What is the difference between a database and a data warehouse? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
The actual collection of data tuples stored in a table at any specific point in time is called a what?
Correct Answer: Option C
Explanation:
A Relation Instance is the specific collection of data rows (tuples) present in a table at a given moment. It changes frequently as data is modified.
A Relation Instance is the specific collection of data rows (tuples) present in a table at a given moment. It changes frequently as data is modified.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a valid SQL command to delete a database?
Correct Answer: Option C
Explanation:
DROP DATABASE is the SQL command to delete an entire database.
DROP DATABASE is the SQL command to delete an entire database.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
To be in Second Normal Form (2NF), a relation must already satisfy First Normal Form (1NF) and must completely eliminate what type of dependency?
Correct Answer: Option A
Explanation:
Second Normal Form (2NF) requires that the table is in 1NF and that no non-prime attribute is partially dependent on any candidate key (meaning no partial dependency exists).
Second Normal Form (2NF) requires that the table is in 1NF and that no non-prime attribute is partially dependent on any candidate key (meaning no partial dependency exists).
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!