(A) Hold down the Shift key and click the first and third fields. Click the Key icon on the toolbar.
(B) Hold down the Ctrl key and click the first and third fields. Click the Key icon on the toolbar
(C) Hold down the Shift key and click the first and third fields. Select Primary Key under the Table
(D) Hold down the Ctrl key and click the first and third fields. Select Primary Key under the Table
Tag: DBMS Mcq
You have created a table in Access, but not yet designated a PK. What happens if you save the table now?
(A) The save fails because no PK is defined
(B) The save works as usual
(C) Access warns you that no primary key is defined, and forces you to define a PK before saving
(D) Access warns you that no primary key is defined, but lets you save the table if you want to
Which of the following is an advantage of having a precisely written set of current operations?
(A) It clarifies the assignment of data types
(B) It highlights the best possible way to perform each task
(C) It forces careful assessment of the procedures
(D) It makes the creation of the data dictionary much easier
After creating the initial ERD segments, the next step is to?
(A) define the major transaction modules
(B) perform the appropriate normalization checks based on the data dictionary contents
(C) create a basic data dictionary for all the components found in each ERD segment
(D) define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
In a POS system, what do the major transaction modules define?
(A) Inventory management, shipping, invoice calculations, and product returns
(B) Sales, inventory management, shipping, back ordering, and product returns
(C) Sales, invoice calculations, back ordering, and product returns
(D) Inventory management, shipping, invoice calculations, back ordering, and product returns
Removing the __ is part of the database design process.
(A) feiorgn keys
(B) primary key dependencies
(C) recursive relationships
(D) partial and transitive dependencies
Data redundancies produce unusual and undesirable data management problems caused by __.
(A) transitive requirements
(B) dependencies
(C) normalization
(D) data anomalies
The database data storage standard requires that, with some exceptions, data must occur in only one place at one time. What are the exceptions?
(A) Foreign key and replicated data requirements
(B) Transitive dependencies and foreign keys
(C) Replicated data and primary keys
(D) Transitive dependencies and primary keys