Database Administration Questions


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

0 4417
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 4414
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

24 4406
Q:

The PHP Syntax is most similar to

A) Visual Basic B) VB Script
C) PERL & C D) Java Script
 
Answer & Explanation Answer: C) PERL & C

Explanation:

PHP is similar to the C style syntax in terms of keywords and language syntax.

 

If conditions, for and while loops, and function returns are similar in syntax to languages such as C, C++, C#, Java and Perl.

Report Error

View Answer Report Error Discuss

1 4384
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

0 4374
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 4329
Q:

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls

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

Explanation:

Because a table can have only one primary key

Report Error

View Answer Workspace Report Error Discuss

1 4319
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 4308