DBMS_Quiz_1

Which of the following is NOT a component of a DBMS?

• Database Engine

• Query Processor

• Spreadsheet Manager

• Transaction Manager

The three-tier architecture of DBMS consists of which layers?

• User, Network, Database

• External, Conceptual, Internal

• Physical, Logical, Virtual

• Application, Data, Network

What is Data Independence in DBMS?

• The ability to access data from multiple databases

• The ability to store data in multiple locations

• The ability to change the schema at one level without changing the schema at the next higher level

• The ability to perform transactions independently

Which of the following represents the overall design of the database?

• Instance

• Table

• View

• Schema

What is the main purpose of data modeling?

• To visualize database structure before implementation

• To improve network connectivity

• To speed up computations

• To provide cloud storage

In the E-R model, a weak entity is identified by which attribute?

• Primary Key

• Composite Key

• Foreign Key

• Partial Key

What is a foreign key in a relational model?

• A key that uniquely identifies an entity

• A key that refers to the primary key of another table

• A key that is never null

• A key used only in a single table

Which SQL category is used to define the structure of a database?

• DML

• DDL

• DCL

• TCL

Which of the following is a Data Definition Language (DDL) command?

• SELECT

• UPDATE

• CREATE

• INSERT

The SQL command used to delete all records from a table without removing its structure is:

• DELETE

• DROP

• TRUNCATE

• REMOVE