Database Questions

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 3047
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 3038
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 3033
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 3021
Q:

 In enterprise data modeling, which is incorrect?

A) You review current systems. B) You implement the new database.
C) You describe the data needed at a very high level of abstraction. D) You plan one or more database development projects.
 
Answer & Explanation Answer: B) You implement the new database.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 2928
Q:

The no of entities participating in a relation is called

A) Relation B) Degree of relationship
C) Recursive relationship D) None of the above
 
Answer & Explanation Answer: B) Degree of relationship

Explanation:

The no of entities participating in relation is called Degree of relationship

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2911
Q:

Which among the following is the disadvantage of circular list?

A) An info field that contains the information stored in the node B) Can’t traverse the list backward
C) A pointer to the node is given we cannot delete the node D) Both 2 and 3
 
Answer & Explanation Answer: D) Both 2 and 3

Explanation:

Both 2 and 3 are clearly the diadvantages of circular list

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2853
Q:

Which among the following is the relationship constraints

A) Cardinality ratio B) Participation constraints
C) Both A and B D) None of the above
 
Answer & Explanation Answer: C) Both A and B

Explanation:

Both of them are relation ship constraints

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 2765