Database Questions

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 2876
Q:

 A transaction for which all committed changes are permanent is called:

A) atomic. B) consistent.
C) isolated. D) durable.
 
Answer & Explanation Answer: D) durable.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 2873
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 2833
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 2764
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 2725
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 2708
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 2592
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 2507