Q1
Q1 Which of the following best defines a database?
A collection of programs
A type of software
A collection of data
A type of computer
Q2
Q2 What is the primary function of a Database Management System (DBMS)?
Managing software installation
Data processing
Data storage and retrieval
Computer networking
Q3
Q3 Which of the following is NOT a characteristic of a DBMS?
Data redundancy
Data integrity
Data security
Data independence
Q4
Q4 The process of organizing data into tables and establishing relationships between them is known as:
Data mining
Data modeling
Data warehousing
Database design
Q5
Q5 Which of the following SQL statements is used to insert a new record into a table?
SELECT
UPDATE
INSERT INTO
DELETE
Q6
Q6 In the context of database security, what does the term 'authentication' refer to?
Ensuring data is not corrupted
Verifying user identity
Encrypting data
Backing up data
Q7
Q7 Which of the following is a correct syntax to select all columns from a table named "Customers"?
SELECT * FROM Customers
SELECT Customers
SELECT all FROM Customers
GET * FROM Customers
Q8
Q8 What does the following SQL query do? SELECT COUNT(*) FROM Orders;
Counts the number of orders in the Orders table
Updates the number of orders
Deletes the Orders table
Creates a new Orders table
Q9
Q9 A database query returns unexpected duplicates of some records. What is the most likely reason for this occurrence?
The SELECT statement includes a JOIN without proper conditions
Incorrect use of DISTINCT
The database has been corrupted
A WHERE clause is missing
Q10
Q10 What is the purpose of an Entity-Relationship (ER) diagram?
To document the syntax of SQL
To model physical database storage
To illustrate database relationships
To monitor database performance
Q11
Q11 In an ER diagram, what do entities represent?
Relationships between tables
Physical storage locations
Real-world objects or concepts
Database queries
Q12
Q12 Which of the following best describes an attribute in an ER model?
A link between entities
A primary key
A characteristic or property of an entity
A type of relationship
Q13
Q13 The uniqueness of each row in a database table is ensured by:
The primary key
The foreign key
An index
A trigger
Q14
Q14 A relationship in an ER model that involves more than two entity types is known as:
A binary relationship
A ternary relationship
A primary relationship
An associative relationship
Q15
Q15 Which of the following is NOT a type of integrity constraint in a relational database?
Referential integrity
Semantic integrity
Structural integrity
Domain integrity
Q16
Q16 In a "many-to-many" relationship, which of the following is required to model this relationship in a relational database?
A composite primary key
A junction table
A foreign key constraint
An index
Q17
Q17 An attribute that uniquely identifies each entity in an entity set is called a:
Composite attribute
Derived attribute
Multi-valued attribute
Key attribute
Q18
Q18 Which SQL keyword is used to remove a table from a database?
DROP
DELETE
REMOVE
ALTER
Q19
Q19 To add a column named "Email" of type VARCHAR to an existing table named "Users," which SQL statement is correct?
ALTER TABLE Users ADD COLUMN Email VARCHAR
ALTER TABLE Users ADD Email VARCHAR
UPDATE TABLE Users ADD Email VARCHAR
INSERT INTO Users (Email) VALUES ('VARCHAR')
Q20
Q20 What is the correct SQL statement to create a foreign key in the "Orders" table that references the "Customers" table's primary key?
CREATE FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
ALTER TABLE Orders ADD CONSTRAINT fk_customer FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
ALTER TABLE Orders ADD FOREIGN KEY (CustomerID) REFERENCES Customers
CREATE TABLE Orders ADD FOREIGN KEY CustomerID REFERENCES Customers
Q21
Q21 An ER diagram incorrectly shows two entities directly connected by more than one relationship.
What is this error known as?
Relationship redundancy
Cardinality mismatch
Entity ambiguity
Attribute duplication
Q22
Q22 In an ER diagram, an entity set that does not have sufficient attributes to form a primary key is marked as:
Weak entity
Strong entity
Derived entity
Composite entity
Q23
Q23 Which SQL statement is used to extract data from a database?
INSERT INTO
UPDATE
SELECT
DELETE
Q24
Q24 An index in a database is used to:
Decrease storage space
Increase data redundancy
Speed up data retrieval
Secure the database
Q25
Q25 Which of the following is a benefit of query optimization in databases?
Reduces the need for indexes
Increases the complexity of queries
Improves query performance
Decreases database security
Q26
Q26 In SQL, the JOIN clause is used to:
Combine rows from only two tables based on related columns
Delete matching rows in two tables
Update matching columns in two tables
Combine rows from two or more tables based on related columns
Q27
Q27 The primary purpose of normalizing a database is to:
Reduce the database size
Increase query speed
Reduce data redundancy and improve data integrity
Simplify security management
Q28
Q28 What does the term 'cardinality' refer to in the context of databases?
The uniqueness of data in a column
The number of rows in a table
The number of tables in a database
The relationships between tables
Q29
Q29 Which of the following best describes the concept of "transaction isolation level"?
The ability to execute SQL transactions in parallel
The degree to which transaction changes are visible to other transactions
The speed at which transactions are executed
The security level applied to transactions
Q30
Q30 A query plan in a database system is:
A set of operations used to secure the database
A roadmap for data backup procedures
A detailed plan for executing a query, outlining steps and resource use
A user guide for database maintenance
