Database Management MCQs (Chapterwise Multiple Choice Questions)

Which of the following is NOT the correct syntax to write the REVOKE statement that is used to revoke a privilege on a table named, Employee from user2?

REVOKE DELETE ON Employee FROM user2;

REVOKE DELETE ON TABLE Employee FROM user2;

REVOKE DELETE ON Employee FROM PUBLIC;

REVOKE FROM user2 DELETE ON Employee;

Answer & Explanation

Correct Answer: REVOKE FROM user2 DELETE ON Employee;

Note: This Question is unanswered, help us to find answer for this one

How can a timestamp be implemented in a database?

By a system clock only.

By a thread-safe shared counter only.

Either by system clock. or by thread-safe shared counter. or by both together.

Neither by system clock nor by thread-safe shared counter.

Answer & Explanation

Correct Answer: Either by system clock. or by thread-safe shared counter. or by both together.

Note: This Question is unanswered, help us to find answer for this one

An Object-oriented database stores persistent object(s) that is/are not shared among multiple applications or programs, in a permanent storage.

True

False

Answer & Explanation

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

The field ______ defines the maximum number of characters a field can contain.

Length

Width

Capacity

Size

Answer & Explanation

Correct Answer: Size

Note: This Question is unanswered, help us to find answer for this one

Which of the following statements correctly describes a transitive dependency?

A dependency in which the value of a non-key column is dependent on the value of another non-key column.

A dependency in which a table can be created by joining multiple tables such that it has subsets of the attributes of each table.

A dependency in which a non-key attribute of a table is dependent on the table's primary key.

A dependency in which one attribute value is potentially a "multivalued fact" about another and the attributes are independent of each other.

Answer & Explanation

Correct Answer: A dependency in which the value of a non-key column is dependent on the value of another non-key column.

Note: This Question is unanswered, help us to find answer for this one

A star schema contains both fact and ________ tables.

Dimension

Event.

Natural join

Outer join

Answer & Explanation

Correct Answer: Dimension

Note: This Question is unanswered, help us to find answer for this one

Which of the following access control policies ensures a high degree of protection from malicious attacks?

DAC policies

MAC policies

Both DAc and MAC policies

Answer & Explanation

Correct Answer: MAC policies

Note: This Question is unanswered, help us to find answer for this one

________ tools and techniques process data and do statistical analysis for insight and discovery.

Operational intelligence

Business intelligence

Information accessibility

Information fluidity

Answer & Explanation

Correct Answer: Business intelligence

Note: This Question is unanswered, help us to find answer for this one

Restriction of_ from the basic relational model has been removed in the nested relational model.

1NF

2NF

3NF

5NF

Answer & Explanation

Correct Answer: 1NF

Note: This Question is unanswered, help us to find answer for this one

In the data hierarchy, the smallest element is the _____.

Record

Bit

Byte

Character

File

Answer & Explanation

Correct Answer: Bit

Note: This Question is unanswered, help us to find answer for this one

Database Management Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.