Database Administration Questions


Q:

5 + 2 x 10 =

A) 70 B) 20
C) 25 D) 52
 
Answer & Explanation Answer: C) 25

Explanation:

According to BODMAS rule,

After multiplication only, addition is done.

Hence,

5 + 2 x 10 = 5 + 20 = 25.

Report Error

View Answer Report Error Discuss

4 3023
Q:

We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced

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

Explanation:

Can’t delete a row from primary table if there are related rows in secondary table.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 3023
Q:

What is the difference between oracle,sql and sql server?

Answer

  • Oracle is based on RDBMS.

  • SQL is Structured Query Language.

  • SQL Server is another tool for RDBMS provided by MicroSoft


 

Report Error

View answer Workspace Report Error Discuss

2 3015
Q:

Why are manhole covers round?

Answer

A number of possible explanations for why manhole covers are round include :


 


1. A round manhole cover cannot fall through its circular opening, whereas a square, rectangular, or oval manhole cover could fall in if it were inserted diagonally in the hole.


2. Circular covers don’t need to be rotated or precisely aligned when placing them on the opening.


3. A round manhole cover is easily moved and rolled.


4. Human beings have a roughly circular cross-section.


5. Round tubes are the strongest shape against the compression of the earth around them, so the cover of the tube would naturally be round as well.


6. It’s easier to dig a circular hole.

Report Error

View answer Workspace Report Error Discuss

2 3010
Q:

What are different types of DBMS?

Answer

1. DBMS


2. RDBMS (Relational)


3. ORDBMS (Object Relational)


4. DDBMS (Distributed)


5. FDBMS (Federated)


6. HDDBMS (Homogeneous)


7. HDBMS (Hierarchical)


8. NDBMS (Networked)

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 3005
Q:

Cloud computing is not suited for situations

A) where complex legacy systems have to be ported B) characterized by limited-time tasks
C) involving offloading of expensive computing tasks D) with no existing regulatory compliance issues
 
Answer & Explanation Answer: A) where complex legacy systems have to be ported

Explanation:

Cloud computing is not suited for situations where complex legacy systems have to be ported.

Report Error

View Answer Report Error Discuss

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

4 3001
Q:

Physical data models describe the details of how data is stored in the computers

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

Explanation:

They describe the details of how data is stored in the computers

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2999
Q:

What gets bigger the more you take away?

Answer

A Hole gets bigger and bigger as you take more away from it.

Report Error

View answer Workspace Report Error Discuss

6 2961