Which SQL command is used to create a new table? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
A Primary Key in RDBMS must be:
Correct Answer: Option D
Explanation:
A primary key uniquely identifies each record and cannot contain null values.
A primary key uniquely identifies each record and cannot contain null values.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what?
Correct Answer: Option B
Explanation:
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which database structure is created to drastically speed up the retrieval of rows from a table at the expense of slower data updates?
Correct Answer: Option C
Explanation:
An Index is a performance optimization structure created on table columns to search and locate matching rows quickly without performing a full table scan.
An Index is a performance optimization structure created on table columns to search and locate matching rows quickly without performing a full table scan.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!