DCL commands in SQL include: MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
Correct Answer: Option C
Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which normal form requires that all attributes in a table contain only atomic, indivisible values, and prohibits multi-valued attributes?
Correct Answer: Option A
Explanation:
A relation is in First Normal Form (1NF) if and only if the domain of every attribute contains only atomic (indivisible) values, and no repeating groups exist.
A relation is in First Normal Form (1NF) if and only if the domain of every attribute contains only atomic (indivisible) values, and no repeating groups exist.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is a data mart?
Correct Answer: Option B
Explanation:
A data mart is a specialized data warehouse for a specific department, team, or subject area.
A data mart is a specialized data warehouse for a specific department, team, or subject area.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!