Which of the following is not a type of database model? 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 command deletes all rows from a table without deleting the structural schema, cannot be rolled back easily in some systems, and does not fire delete triggers?
Correct Answer: Option D
Explanation:
TRUNCATE is a DDL command that quickly removes all records from a table by deallocating the data pages, bypassing row-level logging and triggers while leaving the table structure intact.
TRUNCATE is a DDL command that quickly removes all records from a table by deallocating the data pages, bypassing row-level logging and triggers while leaving the table structure intact.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a valid SQL statement to add a new column to a table?
Correct Answer: Option B
Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
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)
No comments yet. Be the first to start the discussion!