Unit 3 IT Class X DBMS

Which of the following best defines a Database Management System (DBMS)?

• Software for managing spreadsheets

• Tool for organizing files on a computer

• Application for managing structured data

• Platform for creating websites

What is the purpose of a foreign key in a database table?

• Unique identifier for each record

• Link to another table's primary key

• Encrypting sensitive data

• Sorting data in ascending order

What does SQL stand for in the context of databases?

• Structured Query Language

• System Query Logic

• Software Query Line

• Structured Query Logic

What is the function of a SELECT command in SQL?

• Insert data into a table

• Update existing records

• Retrieve data from a database

• Delete specific rows from a table

What is the main advantage of using a Database Management System (DBMS)?

• Easy to use for beginners

• Improved data security

• Limited storage capacity

• Slow data access speed

Which command is used to create a new table in a database using SQL?

• INSERT

• SELECT

• CREATE TABLE

• UPDATE

In a relational database, what is a tuple?

• A column of a table

• A row of a table

• A combination of columns

• A combination of rows

What is the primary key in a relational database?

• A key used for authentication

• A key that uniquely identifies a row in a table

• A key that uniquely identifies a column in a table

• A key that is used for encryption

Which language is used to query databases in a relational DBMS?

• SQL

• C++

• Python

• Java

What is the primary purpose of a DBMS?

• Managing hardware components

• Storing and organizing data

• Running software applications

• Designing user interfaces