Which of the following is a way to avoid redundancy in a database? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What value represents missing, unknown, or inapplicable data in a relational database?
Correct Answer: Option C
Explanation:
NULL is a special marker used in SQL to indicate the absence of a value or that the data is missing, unknown, or not applicable.
NULL is a special marker used in SQL to indicate the absence of a value or that the data is missing, unknown, or not applicable.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is the difference between DELETE and TRUNCATE commands?
Correct Answer: Option B
Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is a composite index?
Correct Answer: Option C
Explanation:
A composite index is created on two or more columns, often used to speed up queries that filter on those columns.
A composite index is created on two or more columns, often used to speed up queries that filter on those columns.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!