What is a database?
A. A collection of files
B. A collection of tables
C. A collection of records
D. A collection of data organized for rapid search and retrieval
Answer: D
Which of the following is not a type of database model?
A. Hierarchical
B. Relational
C. Object-oriented
D. Sequential
Answer: D
What does DBMS stand for?
A. Database Management System
B. Data Backup and Management System
C. Digital Business Management System
D. Data Buffer Management System
Answer: A
Which component of DBMS ensures the security of the database?
A. Query Processor
B. Database Administrator (DBA)
C. Transaction Manager
D. Backup and Recovery Manager
Answer: B
What is the primary purpose of a database schema?
A. To define the structure of the database
B. To manage user permissions
C. To optimize query performance
D. To create database backups
Answer: A
In a relational database, what is a tuple?
A. A row in a table
B. A column in a table
C. A database index
D. A database query
Answer: A
Which of the following SQL commands is used to retrieve data from a database?
A. UPDATE
B. SELECT
C. DELETE
D. INSERT
Answer: B
What is the purpose of a primary key in a relational database table?
A. To ensure data integrity
B. To store large amounts of data
C. To join multiple tables
D. To create backups
Answer: A
Which database model organizes data in a tree-like structure?
A. Relational model
B. Hierarchical model
C. Object-oriented model
D. Network model
Answer: B
What is ACID in the context of database transactions?
A. A database security feature
B. A database query language
C. A set of properties that ensure reliable transactions
D. A type of database backup
Answer: C
Which SQL command is used to add new rows to a table?
A. ADD
B. CREATE
C. INSERT
D. UPDATE
Answer: C
What is the purpose of the COMMIT statement in database transactions?
A. To begin a transaction
B. To end a transaction and save changes permanently
C. To roll back a transaction
D. To query the database
Answer: B
What is normalization in database design?
A. Organizing data into tables and columns
B. Removing duplicate data
C. Reducing data redundancy and dependency
D. Creating database backups
Answer: C
Which SQL command is used to delete data from a table?
A. REMOVE
B. DELETE
C. ERASE
D. TRUNCATE
Answer: B
In database terminology, what does CRUD stand for?
A. Create, Retrieve, Update, Delete
B. Compute, Report, Utilize, Design
C. Choose, Remove, Update, Debug
D. Correct, Refactor, Use, Document
Answer: A
What does the term “foreign key” represent in a relational database?
A. A primary key from another table used to establish a link
B. A unique identifier for each row in a table
C. A constraint that ensures data uniqueness
D. A data type used for storing text values
Answer: A
Which SQL command is used to modify existing data in a table?
A. ALTER
B. MODIFY
C. UPDATE
D. CHANGE
Answer: C
What is a database index used for?
A. To store large objects such as images
B. To ensure data integrity
C. To speed up data retrieval
D. To create relationships between tables
Answer: C
In database terminology, what does the term “transaction” refer to?
A. A set of operations that must all succeed or all fail together
B. A type of database table
C. A database administrator’s role
D. A data modeling technique
Answer: A
Which database model allows for complex data types and relationships?
A. Relational model
B. Hierarchical model
C. Object-oriented model
D. Network model
Answer: C
What is the purpose of the SQL SELECT statement?
A. To delete data from a table
B. To insert new data into a table
C. To update existing data in a table
D. To retrieve data from a database
Answer: D
Which SQL command is used to create a new database?
A. CREATE DATABASE
B. ADD DATABASE
C. DEFINE DATABASE
D. MAKE DATABASE
Answer: A
What is data integrity in the context of databases?
A. Ensuring data is up-to-date
B. Ensuring data is stored efficiently
C. Ensuring data is accurate and consistent
D. Ensuring data is secure
Answer: C
Which SQL command is used to remove a table from a database?
A. REMOVE TABLE
B. DELETE TABLE
C. DROP TABLE
D. ERASE TABLE
Answer: C
In database design, what does the term “normalization” refer to?
A. Optimizing query performance
B. Reducing data redundancy
C. Creating primary keys
D. Adding indexes to tables
Answer: B
What does the SQL command “SELECT COUNT(*) FROM Customers;” do?
A. Counts the total number of customers in the Customers table
B. Selects the first customer from the Customers table
C. Counts the number of unique customers in the Customers table
D. Counts the number of customers from a specific city
Answer: A
Which SQL command is used to add a new column to an existing table?
A. ADD COLUMN
B. INSERT COLUMN
C. CREATE COLUMN
D. ALTER COLUMN
Answer: A
What does the term “data warehouse” refer to in database management?
A. A collection of operational data used for day-to-day operations
B. A large store of historical data used for analysis and reporting
C. A cloud-based database service
D. A database management system
Answer: B
Which SQL command is used to define a constraint on a table?
A. SET CONSTRAINT
B. DEFINE CONSTRAINT
C. ADD CONSTRAINT
D. CREATE CONSTRAINT
Answer: C
In a relational database, what is a view?
A. A virtual table based on the result set of a SELECT query
B. A table used for temporary data storage
C. A table without any data
D. A table with duplicate data
Answer: A
Which SQL command is used to change the structure of an existing table?
A. MODIFY TABLE
B. ALTER TABLE
C. CHANGE TABLE
D. UPDATE TABLE
Answer: B
What is the purpose of a database index?
A. To store large objects such as images
B. To speed up data retrieval
C. To ensure data uniqueness
D. To create relationships between tables
Answer: B
Which SQL command is used to limit the number of rows returned in a query result?
A. RESTRICT
B. LIMIT
C. TOP
D. SAMPLE
Answer: B
What is the role of a Database Administrator (DBA)?
A. Writing SQL queries
B. Designing database tables
C. Managing and maintaining databases
D. Developing database applications
Answer: C
Which SQL command is used to add a primary key to a table?
A. SET PRIMARY KEY
B. ADD PRIMARY KEY
C. CREATE PRIMARY KEY
D. DEFINE PRIMARY KEY
Answer: B
In database terminology, what does the term “OLTP” stand for?
A. Online Transaction Processing
B. Offline Transaction Processing
C. Online Table Processing
D. Operational Table Processing
Answer: A
Which SQL command is used to change the data type of a column in an existing table?
A. MODIFY COLUMN
B. ALTER COLUMN
C. CHANGE COLUMN
D. UPDATE COLUMN
Answer: B
What is the purpose of the SQL WHERE clause?
A. To group rows that have the same values into summary rows
B. To filter rows based on a specified condition
C. To order rows in ascending or descending order
D. To join rows from two or more tables based on a related column
Answer: B
Which SQL command is used to remove a specific row from a table?
A. DELETE
B. ERASE
C. REMOVE
D. DROP
Answer: A
In database management, what is a stored procedure?
A. A sequence of SQL statements stored in the database
B. A backup of the entire database
C. A query used to retrieve data
D. A data type used for storing binary data
Answer: A
What does the term “data redundancy” refer to in database design?
A. Storing data in multiple locations
B. Having too much data in a database
C. Storing duplicate data unnecessarily
D. Not having enough data in a database
Answer: C
Which SQL command is used to create a temporary table?
A. CREATE TEMPORARY TABLE
B. ADD TEMPORARY TABLE
C. DEFINE TEMPORARY TABLE
D. INSERT TEMPORARY TABLE
Answer: A
In database terminology, what does the term “data dictionary” refer to?
A. A collection of database tables
B. A list of database users
C. Metadata about the data in a database
D. A backup of the entire database
Answer: C
Which SQL command is used to add a foreign key constraint to a table?
A. ADD CONSTRAINT
B. ADD FOREIGN KEY
C. DEFINE FOREIGN KEY
D. INSERT FOREIGN KEY
Answer: B
In database management, what does the term “backup” refer to?
A. A duplicate copy of the database used for disaster recovery
B. The primary copy of the database
C. The process of deleting old data
D. The process of optimizing database performance
Answer: A
Which SQL command is used to retrieve only unique records from a query result?
A. UNIQUE
B. DISTINCT
C. UNIQUE
D. DISTINCT
Answer: D
What does the term “data normalization” refer to in database design?
A. Reducing data redundancy and dependency
B. Increasing data redundancy and dependency
C. Organizing data into tables and columns
D. Creating database backups
Answer: A
Which SQL command is used to retrieve a subset of columns from a table?
A. GET
B. FETCH
C. SELECT
D. EXTRACT
Answer: C
What is the purpose of the SQL ORDER BY clause?
A. To filter rows based on a specified condition
B. To group rows that have the same values into summary rows
C. To order rows in ascending or descending order
D. To join rows from two or more tables based on a related column
Answer: C
In database terminology, what does the term “data warehouse” refer to?
A. A collection of operational data used for day-to-day operations
B. A large store of historical data used for analysis and reporting
C. A cloud-based database service
D. A database management system
Answer: B