CIW Database Design Specialist Practice Test

These questions are part of the practice quiz. Start practicing

• What must a foreign key be related to in a relational database?
• What is a situation called where unnecessary duplication of data occurs in a database, causing issues?
• Which concept is primarily associated with visualizing the data structure of a database through relationships?
• In database terminology, what does the term "entity" refer to?
• What is the name of the descriptive language used to create and define entities and relationships in a database?
• What is the difference between a candidate key and a primary key?
• Which type of key is unique for each record in a table?
• What is the main purpose of a foreign key?
• What does the "HAVING" clause accomplish in SQL?
• Which of the following entities represents a real-world object or concept in a database?
• Which type of key consists of multiple attributes that uniquely identify a record in a table?
• What kind of data does a NoSQL database typically manage?
• In what scenario would a database migration commonly occur?
• In database terminology, what describes the number of unique entries in a set of rows?
• What does referential integrity in databases ensure?
• What is the process of organizing and refining relations within a relational database called?
• What is a trigger in a database?
• What does data abstraction provide in the context of database design?
• Why is archiving old data important in databases?
• What is the significance of normalization in database design?
• Which of the following describes the primary use of the E-R model?
• Which of the following best describes a collection of formally described tables?
• What is a view in a database?
• What is the primary distinction between a database and a data warehouse?
• What method is used to manage concurrent access to data, where one transaction is denied access until another is complete?
• What is the focus of a data warehouse compared to a data lake?
• In database terminology, what describes the unique identifier of a record in a table?
• Which of the following is NOT a characteristic of a weak entity?
• What is the role of a foreign key in a database?
• What is meant by cascading referential integrity?
• What does a primary key in a database ensure?
• What type of entity has data that is meaningful on its own without needing to reference another entity?
• Which of the following terms describes the ability to access data in a timely manner?
• What does denormalization entail in database management?
• What process involves creating new relations from existing relations based on functional dependencies?
• Who is responsible for directing and performing all activities related to maintaining a database environment?
• Which SQL statement is utilized to retrieve data from a database?
• What is the role of indexing in a database?
• What is the primary difference between a data lake and a data warehouse?
• What is uniquely identifiable element about which data is stored in a database?
• In functional dependencies, if B is dependent on A, and C is dependent on B, what is the relationship called?
• What does the E-R model represent in database design?
• What does the schema of a database represent?
• What purpose does an index serve in a database?
• How is the number of rows in a relation referred to?
• Which of the following best describes structured data?
• What does the rollback operation do in a database transaction?
• In white-box testing, what is primarily being tested?
• Which of the following best defines unstructured data?
• What term refers to the special properties or constraints a relation must have to achieve certain goals like minimizing data redundancy?
• Which of the following best describes normalization in database design?
• What defines a relationship between two attributes indicating that for each unique attribute A, there is only one value of attribute B?
• In database design, what principle relates to maintaining data integrity through controlled access?
• What language is used to control access to data in a database?
• A unique identifier for each record in a database table is known as?
• What term describes an entity that must reference another entity for its data to be meaningful?
• In database systems, what is a transaction?
• Which term refers to an attribute or group of attributes on which another attribute is functionally dependent?
• Which property does a relation need to possess to achieve desired goals like minimizing data redundancy?
• Which component of a database describes the data contained within it?
• What is the main purpose of a database management system (DBMS)?
• What is the role of a data dictionary in a database?
• Which relational constraint states that no part of a primary key may be null?
• In a database context, what is NOT a characteristic of a weak entity?
• What is a row also referred to as in a relational database?
• What relationship type is characterized by an entity referencing itself?
• What type of software supports the creation and management of databases?
• What is a formal method of describing data and data relationships called?
• What is a data model?
• What term is used for tables created temporarily as a result of data manipulation operations?
• What SQL command is used to insert new records into a table?
• What is the definition of database migration?
• Which of the following best describes entity integrity?
• Which of the following is an attribute that characterizes the structure of a database relation?
• What type of relationship exists when an entity is involved with itself?
• What is the primary function of a database?
• What does the SQL "ORDER BY" clause achieve?
• Which of the following describes the primary purpose of a transaction in a database?
• What do you call a primary or foreign key that is made up of multiple attributes?
• What defines third normal form (3NF) in database normalization?
• What does the term "atomic value" in database design refer to?
• What do we call the issue that arises when redundant data may not be updated properly?
• What is the primary purpose of data mining?
• What is the purpose of a query language in a nonprocedural DML?
• What is the process of organizing data to eliminate redundancy called?
• What term describes a client that minimizes local processing and relies heavily on server resources?
• Which entity is created as a result of decomposing a relation while resolving a many-to-many relationship?
• What does the term "data integrity" mean?
• What is referential integrity in the context of a relational database?
• What type of data does a data lake primarily handle?
• Which term refers to the relations that are actually defined within a database?
• What is a unique identifier assigned to a transaction by a database management system?
• In database design, what is the purpose of data normalization?
• What is a composite key in database design?
• What is the role of a query optimizer in database management?
• What is a primary goal of database migration?
• What is the term for a situation where two or more transactions are waiting for another transaction to release a lock on a data item?
• Which SQL statement is used to update existing records in a table?
• In SQL, what is the purpose of the "HAVING" clause?
• What is a relationship in database terminology?
• What anomaly occurs when wanted data is deleted from a relation?
• What does normalization in databases aim to achieve?
• What is the main advantage of using indexes in a database?
• Which database term refers to the formal structure that defines how data is organized and accessed?
• What type of database contains records that have no structured interrelationship?
• What term describes an attribute's value that cannot be divided into multiple pieces of information?
• Which of the following is NOT a characteristic of a relational database?
• Which of the following refers to the management of simultaneous transactions to prevent conflicts?
• What does the acronym ACID stand for in the context of database management?
• How does schema-on-read differ from schema-on-write?
• What is a relational database?
• What is the method called that tests an application without internal knowledge of the code?
• Which of the following is the primary goal of white-box testing?
• What defines a data warehouse?
• Which SQL command would you use to update existing data in a database?
• What is defined as a single event or sequence of actions treated as a unit in database operations?
• What does a logical data model represent?
• What does a Database Management System (DBMS) allow users to do?
• What is the implication of a strong entity in a database system?
• What are database constraints used for?
• What are the three main types of database relationships?
• What is referred to as the primary key that is referenced by a foreign key?
• What is the final step in the successful completion of a database transaction?
• Which of the following describes a candidate key?
• Which process does a DBMS use to assess transaction outcomes against serial execution?
• What does a requirements document specify?
• What does the "GROUP BY" clause do in SQL?
• What is usually included in the identification process of a weak entity?
• What role does a foreign key play in a relational database?
• What is the primary use of a database trigger?
• Which of the following describes a determinant in the context of database design?
• What model underpins most relational databases?
• Which of the following describes the changing of relations in a database to reduce redundancy?
• What is a common characteristic of a weak entity in database design?
• Which type of testing focuses on the structural aspects of the source code?
• What is the term for a set of tables created via DDL operations that contains metadata about a database?
• What are the allowable values for an attribute in a database called?
• What is a surrogate key used for in database design?
• What is a common benefit of using a data warehouse?
• What language is primarily used to create and manage corporate databases?
• What is the process of rejoining relations that were decomposed during normalization?
• What kind of key is a column or concatenated columns that are identical to the primary key of a relation in the same database?
• What is the primary function of a Data Dictionary in a database?
• What is a potential drawback of a data lake?
• What is fundamental to the concept of a data model?
• What is the name given to a data operation that creates virtual tables when called by a user?
• What is a client that performs the bulk of the data-processing operations known as?
• What are the primary components of a relational database?
• Which language provides the necessary interface for performing data operations within a database?
• What is a dynamic relationship in a database?
• Which control mechanism prevents simultaneous transactions from conflicting in a database?
• What database value represents "unknown"?
• What is meant by the term "data governance"?
• What is the key difference between static SQL and dynamic SQL?
• What type of analysis is typically performed using a data warehouse?
• What defines a set of restrictions on the values allowed for the attributes of relations?
• Which term describes a collection of data that is organized for efficient management and access?
• Which type of join fetches all records from the left table along with matched records from the right table?
• How is the number of attributes in a relation defined?
• In a functional dependency, if B is dependent on A and removing an attribute from A still maintains the dependency, what is this condition called?
• What is the purpose of entity-relationship (ER) modeling?
• What term describes a situation where data may not be entered into a relation due to the absence of a complete primary key?
• What is the main purpose of data redundancy?
• What term is used to refer to the main key that is referenced within a foreign key relationship?
• What typically distinguishes a weak entity from a strong entity in a database?
• What type of testing would be most effective in finding logical errors in an application's coding?
• Which of the following best describes a database?
• What is the correct definition of a tuple in database terminology?
• What is a schema in database design?
• In database design, what is the main goal of using an index?
• What is SQL injection?
• What is a property of a relation in a database called?
• What describes the role of a system catalog in a database?
• Which testing method is used to verify that a software application meets the specified requirements?
• What is the primary advantage of white-box testing over black-box testing?
• In relational databases, what is the main function of primary keys?
• What occurs when data is not entered into a relation as a result of an incomplete primary key?
• What is the primary focus of domain constraints in a database?
• What is a unique identifier within a row of a database called?
• What defines a primary key in a database table?
• What is a stored procedure?
• In a relational database, what is a relation?
• Which of the following statements best describes the term "foreign key"?