Database Administration Questions


Q:

Chennai express left Hyderabad for Chennai at 14 : 30 hours, travelling at a speed of 60 kmph and Charminar Express left Hyderabad for Chennai on the same day at 16 : 30 hours, travelling at a speed of 80 kmph. How far away from Hyderabad will the two trains meet? 

A) 360 kms B) 480 kms
C) 520 kms D) 240 kms
 
Answer & Explanation Answer: B) 480 kms

Explanation:

Now, the distance covered by Chennai express in 2 hrs = 60 x 2 = 120 kms

Let the Charminar Express takes 't' hrs to catch Chennai express

=> 80 x t = 60 x (2 + t)

=> 80 t = 120 + 60t

=> t = 6 hrs

 

Therefore, the distance away from Hyderabad the two trains meet = 80 x 6 = 480 kms.

Report Error

View Answer Report Error Discuss

10 4946
Q:

Which SQL keyword is used to sort the result-set?

A) ORDER B) ORDER BY
C) SORT BY D) SORT
 
Answer & Explanation Answer: B) ORDER BY

Explanation:

SQL keyword ORDER BY is used to sort the result-set.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 4912
Q:

What goes up and down the stairs without moving?

A) Umbrella B) Lift
C) Stairs D) All the above
 
Answer & Explanation Answer: C) Stairs

Explanation:

Those are stairs which goes up and down without moving.

Report Error

View Answer Report Error Discuss

4 4894
Q:

On the occasion of New Year, each student of a class sends greeting cards to the others. If there are 21 students in the class, what is the total number of greeting cards exchanged by the students?

A) 380 B) 420
C) 441 D) 400
 
Answer & Explanation Answer: B) 420

Explanation:

Given total number of students in the class = 21

 

So each student will have 20 greeting cards to be send or receive (21 - 1(himself))

 

Therefore, the total number of greeting cards exchanged by the students = 20 x 21 = 420.

Report Error

View Answer Report Error Discuss

11 4849
Q:

Which planet rotates clockwise?

A) Uranus B) Saturn
C) Venus D) Earth
 
Answer & Explanation Answer: C) Venus

Explanation:

Venus is the only planet that rotates in clockwise where all other planets in the solar system rotates in anti - clockwise direction.

 

which_planet_rotates_clockwise1556602727.jpg image

Report Error

View Answer Report Error Discuss

6 4845
Q:

The command to eliminate a table from a database is

A) REMOVE TABLE CUSTOMER; B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER; D) DROP TABLE CUSTOMER;
 
Answer & Explanation Answer: D) DROP TABLE CUSTOMER;

Explanation:

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...

Report Error

View Answer Report Error Discuss

36 4824
Q:

In which of the following state Bandipur National Park is located?

A) Karnataka B) Andhra Pradesh
C) Himachal Pradesh D) Madhya Pradesh
 
Answer & Explanation Answer: A) Karnataka

Explanation:

Bandipur National Park is located in the state of Karnataka.

Report Error

View Answer Report Error Discuss

Filed Under: Indian Geography
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank PO , Database Administration , IT Trainer

7 4818
Q:

How can you make sure your dependencies are safe ?

Answer

When writing Node.js applications, ending up with hundreds or even thousands of dependencies can easily happen.
For example, if you depend on Express, you depend on 27 other modules directly, and of course on those dependencies' as well, so manually checking all of them is not an option!


The only option is to automate the update / security audit of your dependencies. For that there are free and paid options:


1. npm outdated
2. Trace by RisingStack
3. NSP
4. GreenKeeper
5. Snyk

Report Error

View answer Workspace Report Error Discuss

1 4812