What is the purpose of the SQL 'JOIN' clause? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which SQL statement is used to delete all rows from a table without logging individual row deletions?
Correct Answer: Option B
Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is metadata?
Correct Answer: Option A
Explanation:
Metadata is data that provides information about other data, such as structure and constraints.
Metadata is data that provides information about other data, such as structure and constraints.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which language is used to define the structure of a database, such as creating tables and constraints?
Correct Answer: Option D
Explanation:
Data Definition Language (DDL) is used to define and modify the database schema, including CREATE, ALTER, and DROP statements.
Data Definition Language (DDL) is used to define and modify the database schema, including CREATE, ALTER, and DROP statements.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!