Two customers try to update the same account at nearly the same time. Which database component is responsible for preventing conflicts and helping keep the database consistent?
Category: Uncategorized
A Customers table has CustomerID as its primary key. An Orde…
A Customers table has CustomerID as its primary key. An Orders table stores CustomerID to indicate who placed each order. What is Orders.CustomerID?
A company requires every Employee row to have a Name. Which…
A company requires every Employee row to have a Name. Which constraint should be placed on the Name column?
A business wants data organized into tables with rows and co…
A business wants data organized into tables with rows and columns and plans to use SQL for querying. Which model is the best fit?
Two sets contain {a, b, c} and {c, b, a}. How should they be…
Two sets contain {a, b, c} and {c, b, a}. How should they be treated according to the slides?
An employee has not provided a middle name, and the value is…
An employee has not provided a middle name, and the value is unknown. What should be stored if the column permits missing data?
A developer needs to know what tables, columns, and indexes…
A developer needs to know what tables, columns, and indexes exist before generating a query. Which database component stores this directory information?
A table needs to store product prices such as 19.995 with th…
A table needs to store product prices such as 19.995 with three digits after the decimal and up to ten significant digits. Which data type from the slides is most appropriate?
A server fails after several updates. The DBMS uses a record…
A server fails after several updates. The DBMS uses a record of prior inserts, updates, and deletes to restore the database. Which component is being used?
Who has to be the last one to complete a d/c summary?
Who has to be the last one to complete a d/c summary?