Database Questions

Q:

 Which of the following improves a query's processing time?

A) Write complex queries. B) Combine a table with itself.
C) Query one query within another. D) Use compatible data types.
 
Answer & Explanation Answer: D) Use compatible data types.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3336
Q:

 Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

A) Nonrepeatable read B) Phantom read
C) Dirty read D) Consistent read
 
Answer & Explanation Answer: A) Nonrepeatable read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3308
Q:

 Which of the following is an advantage of partitioning?

A) Complexity B) Inconsistent access speed
C) Extra space D) Security
 
Answer & Explanation Answer: D) Security

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3260
Q:

Representation level data models provide the concepts that are close to the way many users perceive data

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

Explanation:

High level data models provide the concepts that are close to the way many users perceive data

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 3241
Q:

The time complexity of sequential search is

A) O(n) B) O(2n)
C) O(n^2) D) None
 
Answer & Explanation Answer: A) O(n)

Explanation:

The time complexity of sequential search is O(n)

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3240
Q:

The relationship where both the participating entities belong to same entity type is called

A) Participation B) Recursive
C) Standard D) Normal
 
Answer & Explanation Answer: B) Recursive

Explanation:

The relationship where both the participating entities belong to same entity type is called Recursive relationship

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3224
Q:

What is schema?

Answer

The description of a data base is called the database schema , which is specified during database design and is not expected to change frequently . A displayed schema is called schema diagram .We call each object in the schema as schema construct.

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 3171
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 3145