Sawaal

Database Administration Questions

Popular Latest Rated
Q:

What operator tests column for the absence of data?

A) NOT operator B) IS NULL operator
C) EXISTS operator D) All of the above
 
Answer & Explanation Answer: B) IS NULL operator

Explanation:

SELECT "column_name"


FROM "table_name"


WHERE "column_name" IS NULL.

Report Error

View Answer Report Error Discuss

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

1 4449
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 4432
Q:

Breaking of relationships is allowed once referential integrity on a database is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Breaking of relationships is prevented once referential integrity on a database is enforced

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

0 4427
Q:

IF YOU HAVE ME, YOU WANT TO SHARE ME. IF YOU SHARE ME, YOU HAVEN'T GOT ME. WHAT AM I?

Answer

A Secret is what you want to share if you have with you. And if you share that secret with anyone, then secret will not be with you only.

Report Error

View answer Workspace Report Error Discuss

Subject: Word Puzzles Exam Prep: GRE , GATE , CAT , Bank Exams , AIEEE
Job Role: IT Trainer , Database Administration , Bank PO , Analyst

24 4409
Q:

Which layer 4 protocol is used for a Telnet connection?

A) UDP B) IP
C) TCP D) TCP/IP
 
Answer & Explanation Answer: C) TCP

Explanation:

Telnet uses TCP at layer 4. It uses IP at layer 3. We know that Telnet uses TCP/IP protocol, but in the question, it is asked specifically at layer 4 what is used in Telnet. So it is TCP at layer4 and IP at layer 3.

Report Error

View Answer Report Error Discuss

Filed Under: Networking
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Network Engineer

0 4382
Q:

Shamma lends Rs.40,000 to two of her friends. She gives Rs.24,000 to the first at 8% p.a. simple interest. Shamma wants to make a profit of 10% on the whole. The simple interest rate at which she should lend the remaining sum of money to the second friend is:

A) 13% B) 8.5%
C) 9.5% D) 11.25%
 
Answer & Explanation Answer: A) 13%

Explanation:

The ratio of money she lended is

24000 : 16000 = 3 : 2

Let the rate of interest be R%

 

8%                   R%
     

           10

 

3          :           2

 

R = 13%.

Report Error

View Answer Report Error Discuss

Filed Under: Profit and Loss
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

10 4367
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 4346
Q:

Everyone has it and no one can lose it. What is it?

A) Face B) Teeth
C) Hair D) Shadow
 
Answer & Explanation Answer: D) Shadow

Explanation:
Report Error

View Answer Report Error Discuss

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

3 4338