Which type of database model organizes data in a tree-like structure? 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 difference between DELETE and TRUNCATE commands?
Correct Answer: Option B
Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which normal form eliminates transitive dependencies?
Correct Answer: Option B
Explanation:
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which SQL command is used to add new rows of data into an existing table?
Correct Answer: Option C
Explanation:
The INSERT command is a Data Manipulation Language (DML) statement used to add new records/rows to a table.
The INSERT command is a Data Manipulation Language (DML) statement used to add new records/rows to a table.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!