Category: Uncategorized

A relation in 2NF must satisfy which of the following?

Which DDL command cannot be used after table creation to directly modify a column’s data type if it contains existing data?

Which command permanently removes both data and structure of a table?

Which statement correctly defines First Normal Form (1NF)?

The difference between schema-on-write and schema-on-read is that:

Which of the following queries correctly finds the number of unique students enrolled in classes?

In transaction processing, the term “atomicity” means that —

During recovery, what is the purpose of the log?

Roberts Corporation reports pretax accounting income of $200,000, but due to a single temporary difference, taxable income is only $150,000. At the beginning of the year, no temporary differences existed. Roberts is subject to a tax rate of 25%. Required: Prepare the journal entry to record Roberts Corporation’s income taxes. Note: If no entry is required for a transaction or event, select “No journal entry required” in the first account field.

Which of the following is a disadvantage of a highly normalized schema?