1Z0-006 Fundamental Database Concepts 2 — Questions and Answers
Question 1: Which type of relationship exists when one record in Table A can relate to many records in Table B, and one record in Table B can relate to many records in Table A?
- One-to-One
- One-to-Many
- Many-to-Many (Correct answer)
- Self-Referencing
Correct answer: Many-to-Many
A many-to-many relationship means each row on either side can relate to multiple rows on the other side, typically resolved with a junction (bridge) table.
Question 2: In the context of database transactions, what does the 'I' in ACID stand for?
- Integration
- Isolation (Correct answer)
- Indexing
- Integrity
Correct answer: Isolation
Isolation ensures that concurrent transactions execute as if they were run sequentially, preventing interference between them.
Question 3: Which SQL command is used to permanently save changes made during a transaction?
- SAVE
- COMMIT (Correct answer)
- ROLLBACK
- PERSIST
Correct answer: COMMIT
COMMIT permanently saves all changes made during the current transaction to the database.
Question 4: What is a surrogate key?
- A natural key derived from business data
- A key that references another table
- A system-generated artificial key with no business meaning (Correct answer)
- A composite key made of multiple columns
Correct answer: A system-generated artificial key with no business meaning
A surrogate key is an artificially generated identifier (often a sequence number) with no inherent business meaning, used purely to uniquely identify rows.
Question 5: Which normal form eliminates transitive dependencies among non-key attributes?
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF) (Correct answer)
- Boyce-Codd Normal Form (BCNF)
Correct answer: Third Normal Form (3NF)
Third Normal Form (3NF) requires that no non-key attribute is transitively dependent on the primary key through another non-key attribute.
Question 6: What is the purpose of a database view?
- To store data permanently on disk
- To provide a virtual table based on a query result (Correct answer)
- To enforce referential integrity constraints
- To speed up data retrieval by pre-sorting data
Correct answer: To provide a virtual table based on a query result
A view is a virtual table whose contents are defined by a stored query, presenting data from one or more base tables without storing data itself.
Question 7: In relational database terminology, what is a 'tuple'?
- A column in a table
- A row in a table (Correct answer)
- An index on a table
- A constraint on a table
Correct answer: A row in a table
In relational theory, a tuple corresponds to a single row in a relational table, representing one record of data.
1Z0-006 Fundamental Database Concepts 2
Which type of relationship exists when one record in Table A can relate to many records in Table B, and one record in Table B can relate to many records in Table A?