Which of the following is a valid SQL data type for a date and time? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What is the purpose of the SQL 'ORDER BY' clause?
Correct Answer: Option D
Explanation:
ORDER BY sorts the query results in ascending or descending order based on specified columns.
ORDER BY sorts the query results in ascending or descending order based on specified columns.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is the purpose of the SQL 'CONSTRAINT' keyword?
Correct Answer: Option D
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)
Question #3
Report Error
What does a database constraint called a 'CHECK' constraint do?
Correct Answer: Option B
Explanation:
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!