Which of the following is a valid SQL data type for storing decimal numbers with exact precision? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which of the following is NOT an advantage of DBMS over traditional file systems?
Correct Answer: Option D
Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a true statement about indexes?
Correct Answer: Option B
Explanation:
Indexes speed up data retrieval but require additional maintenance during data modifications, which can slow down DML operations.
Indexes speed up data retrieval but require additional maintenance during data modifications, which can slow down DML operations.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the purpose of the SQL 'CONSTRAINT' keyword?
Correct Answer: Option C
Explanation:
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!