DBMS Quiz

What is the main purpose of a DBMS?

• Manage software updates

• Store and retrieve data efficiently

• Design websites

• Compile programming code

A DBMS is made up of:

• Only tables

• Data and programming languages

• Interrelated data and programs to access the data

• Only user interfaces

Which of the following provides data independence?

• File System

• Operating System

• DBMS

• Compiler

In file systems, data redundancy is:

• Eliminated

• Reduced

• Managed automatically

• High

How many levels of data abstraction are there in DBMS?

• 2

• 5

• 3

• 4

Logical data independence allows changes in:

• Physical schema without changing conceptual schema

• Conceptual schema without changing external schema

• External schema without changing internal schema

• Database queries without changes

In which DBMS architecture does the client interact directly with the database?

• 2-Tier

• 3-Tier

• 1-Tier

• Web Tier

Which tier handles user interface and application logic in a 3-tier architecture?

• Database server

• Application server

• Network layer

• End-user terminal

Which SQL command is used to create a table?

• INSERT

• SELECT

• CREATE

• ALTER

What does the VARCHAR data type store?

• Numeric values

• Fixed-length characters

• Variable-length characters

• Dates