Sawaal

Database Administration Questions

Popular Latest Rated
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

Filed Under: Database
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Project Manager

36 5013
Q:

Logical puzzle

You have 10 coins….arrange them in 4 straight lines such that each line contains 4 coins.

Report Error

View answer Workspace Report Error Discuss

Subject: Logic Puzzles Exam Prep: Bank Exams
Job Role: Bank Clerk , Bank PO , Database Administration

27 5011
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 4992
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

Filed Under: General Science
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

6 4990
Q:

On simple interest an amount becomes Rs. 812 in two years and Rs. 924 in four years. What is the rate of interest on that amount?

A) 7.2% B) 8%
C) 8.5% D) 9.3%
 
Answer & Explanation Answer: B) 8%

Explanation:

We know, 

S.I = PTR/100 where P = principal amount, T = time, R = rate of interest

Here in the given data,

Interest for two years S.I = 924 - 812 = Rs. 112

Now, Principal amount P = 812 - 112 = Rs. 700 

Now,

R = S.I x 100/PT

R = 112 x 100/700 x 2

R = 11200/1400

R = 8%

 

Hence, the rate of interest R = 8%.

Report Error

View Answer Report Error Discuss

Filed Under: Simple Interest
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

7 4950
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

Filed Under: Logic Puzzles
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

4 4930
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

Filed Under: Permutations and Combinations
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Database Administration , Bank PO , Bank Clerk

11 4903
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 4897