CompTIA ITF+ Domain 5: Database Fundamentals Welcome to your CompTIA ITF+ Domain 5: Database Fundamentals 1. CompTIA ITF+: Database Fundamentals In SQL, which command is used to remove rows from a table without deleting the table itself? A. DROP B. DELETE C. REMOVE D. TRUNCATE None 2. CompTIA ITF+: Database Fundamentals Which type of database relationship involves a scenario where a record in one table can relate to many records in another table? A. One-to-One B. One-to-Many C. Many-to-Many D. Self-Referencing None 3. CompTIA ITF+: Database Fundamentals What is the purpose of a 'primary key' in a relational database? A. To speed up the performance of queries B. To establish a unique identifier for each record in a table C. To create a secure encryption for data D. To link two tables together None 4. CompTIA ITF+: Database Fundamentals In a database, what does 'normalization' primarily aim to achieve? A. Reducing data redundancy B. Increasing data security C. Enhancing data processing speed D. Simplifying user access None 5. CompTIA ITF+: Database Fundamentals Which SQL clause is used to specify the condition that must be met for records to be selected? A. SELECT B. FROM C. WHERE D. JOIN None 6. CompTIA ITF+: Database Fundamentals What is the function of an 'index' in a database? A. To link tables together B. To provide a unique identifier for each row C. To improve the speed of data retrieval D. To restrict the data type of a column None 7. CompTIA ITF+: Database Fundamentals In relational databases, what is the purpose of a foreign key? A. To uniquely identify each row in a table B. To link two tables together C. To enhance the security of the database D. To store encrypted data None 8. CompTIA ITF+: Database Fundamentals Which SQL statement is used to make changes to existing records in a database table? A. ALTER B. UPDATE C. MODIFY D. CHANGE None 9. CompTIA ITF+: Database Fundamentals In database terminology, what is a 'tuple'? A. A column in a table B. A set of tables C. A row in a table D. A type of database relationship None 10. CompTIA ITF+: Database Fundamentals What does an 'aggregate function' do in SQL? A. Connects two or more tables B. Performs a calculation on a set of values C. Changes the structure of the database D. Creates a new table None 11. CompTIA ITF+: Database Fundamentals In a relational database, what is the term for a field that uniquely identifies each record in a table? A. Foreign Key B. Primary Key C. Unique Identifier D. Index Key None 12. CompTIA ITF+: Database Fundamentals Which SQL statement is used to remove a table schema and its data from the database? A. DELETE B. REMOVE C. DROP D. TRUNCATE None 13. CompTIA ITF+: Database Fundamentals In SQL, what is the purpose of the GROUP BY clause? A. To sort the result set in ascending or descending order B. To filter records based on a condition C. To group rows that have the same values in specified columns D. To join tables based on a related column None 14. CompTIA ITF+: Database Fundamentals What does the SQL HAVING clause do? A. Filters rows before grouping B. Filters rows after grouping C. Specifies the columns to be returned D. Specifies the order of the result set None 15. CompTIA ITF+: Database Fundamentals In a database, what is the purpose of a transaction log? A. To track changes to the database schema B. To store user queries C. To record all transactions to ensure data integrity D. To index the database tables for faster searches None 16. CompTIA ITF+: Database Fundamentals Which data integrity constraint ensures that a column in a relational database table cannot have a NULL value? A. Primary Key B. Unique Key C. Not Null D. Foreign Key None 17. CompTIA ITF+: Database Fundamentals What does the term 'ACID' in database systems refer to? A. A type of database model B. A database security protocol C. Properties of database transactions D. A method for indexing databases None 18. CompTIA ITF+: Database Fundamentals In the context of databases, what is 'data warehousing'? A. Storing current transactional data B. Backing up database files C. Storing and managing historical or analytical data D. Encrypting sensitive database information None 19. CompTIA ITF+: Database Fundamentals In SQL, what is the function of a 'subquery'? A. To update records in a table B. To execute a secondary query within a primary query C. To delete specific records D. To link two tables together None 20. CompTIA ITF+: Database Fundamentals Which term describes the process of converting a database design into an actual database structure? A. Normalization B. Implementation C. Conceptualization D. Design None 1 out of 20 Time is Up! Time's up
