Databases Quiz Quiz Databases Medium-level quiz 6 Pradip Devkar October 15, 2024 A medium-level quiz typically includes questions that challenge learners with moderate difficulty. It requires a good understanding of the core concepts but doesn’t dive too deep into advanced topics, Databases Medium-level quiz 6 A medium-level quiz typically includes questions that challenge learners with moderate difficulty. It requires a good understanding of the core concepts but doesn't dive too deep into advanced topics. 1 / 10 Which of the following is not a type of database management system (DBMS)? Hierarchical DBMS Network DBMS Relational DBMS Linear DBMS 2 / 10 What is the main purpose of a database index? To ensure data integrity To increase data retrieval speed To compress data To normalize data 3 / 10 In SQL, which of the following is used to delete all the rows from a table without deleting the table structure? DROP DELETE TRUNCATE REMOVE 4 / 10 What does ACID stand for in the context of databases? Automatic, Consistent, Index, Durable Atomicity, Consistency, Isolation, Durability Accuracy, Communication, Integrity, Data 5 / 10 Which of the following SQL statements is used to retrieve data from a database? INSERT UPDATE DELETE SELECT 6 / 10 What is a foreign key? A unique identifier for a record A key used to lock the database A field in one table that refers to the primary key in another table A key that is shared between tables 7 / 10 In SQL, which command is used to add a new row to a table? ADD INSERT INTO ALTER MODIFY 8 / 10 Which SQL function is used to count the number of rows in a table? COUNT() SUM() AVERAGE() TOTAL() 9 / 10 In a relational database, what is a "view"? A physical table A virtual table based on the result of a query A form of user interface for tables A method to back up data 10 / 10 What is the difference between "DELETE" and "TRUNCATE" in SQL? DELETE removes only structure, while TRUNCATE removes data. DELETE removes all rows one by one and allows rollback, TRUNCATE removes all rows and cannot be rolled back. TRUNCATE is slower than DELETE. DELETE removes indexes; TRUNCATE doesn't. Your score isThe average score is 80% 0% Restart quiz Share this… Whatsapp Linkedin Facebook Twitter Gmail Related Tags: #Databases Quiz, #Quiz Continue Reading Previous Databases Medium-Level Quiz 5Next Databases Advanced Quiz 7 More Stories Natural Language Processing Quiz Quiz NLP Medium Quiz 5 Pradip Devkar November 7, 2024 Natural Language Processing Quiz Quiz NLP Medium Quiz 4 Pradip Devkar November 7, 2024 Deep Learning Quiz Quiz Deep Learning Expert Quiz 10 Pradip Devkar November 6, 2024 Leave a Reply Cancel replyYou must be logged in to post a comment.
