Q. In an ER model, what does an entity represent?
-
A.
A relationship
-
B.
A table
-
C.
A column
-
D.
A constraint
Solution
In an Entity-Relationship (ER) model, an entity represents a table in the database.
Correct Answer:
B
— A table
Learn More →
Q. What does concurrency control in a DBMS ensure?
-
A.
Data redundancy
-
B.
Data integrity during simultaneous access
-
C.
Faster data retrieval
-
D.
Data backup
Solution
Concurrency control ensures data integrity when multiple users access the database simultaneously.
Correct Answer:
B
— Data integrity during simultaneous access
Learn More →
Q. What is normalization in database design?
-
A.
The process of organizing data to reduce redundancy
-
B.
The process of creating a database
-
C.
The process of indexing data
-
D.
The process of backing up data
Solution
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Correct Answer:
A
— The process of organizing data to reduce redundancy
Learn More →
Q. What is the purpose of a primary key in a database table?
-
A.
To uniquely identify each record
-
B.
To link tables together
-
C.
To enforce data types
-
D.
To store large amounts of data
Solution
A primary key is used to uniquely identify each record in a database table.
Correct Answer:
A
— To uniquely identify each record
Learn More →
Q. What is the purpose of a primary key in a database?
-
A.
To uniquely identify a record
-
B.
To link two tables
-
C.
To enforce data integrity
-
D.
To speed up queries
Solution
A primary key is used to uniquely identify each record in a database table.
Correct Answer:
A
— To uniquely identify a record
Learn More →
Q. Which of the following is a type of SQL join?
-
A.
INNER JOIN
-
B.
OUTER JOIN
-
C.
CROSS JOIN
-
D.
All of the above
Solution
INNER JOIN, OUTER JOIN, and CROSS JOIN are all types of SQL joins used to combine rows from two or more tables.
Correct Answer:
D
— All of the above
Learn More →
Q. Which of the following is NOT a component of a DBMS architecture?
-
A.
Database engine
-
B.
User interface
-
C.
Data warehouse
-
D.
Database schema
Solution
A data warehouse is not a component of a DBMS architecture; it is a separate system used for reporting and data analysis.
Correct Answer:
C
— Data warehouse
Learn More →
Q. Which of the following is NOT a component of DBMS architecture?
-
A.
Database Engine
-
B.
User Interface
-
C.
Data Warehouse
-
D.
Database Schema
Solution
A Data Warehouse is not a component of DBMS architecture; it is a separate system used for reporting and data analysis.
Correct Answer:
C
— Data Warehouse
Learn More →
Q. Which SQL command is used to update existing records in a table?
-
A.
MODIFY
-
B.
UPDATE
-
C.
CHANGE
-
D.
SET
Solution
The UPDATE command is used to modify existing records in a table in SQL.
Correct Answer:
B
— UPDATE
Learn More →
Q. Which SQL statement is used to retrieve data from a database?
-
A.
GET
-
B.
SELECT
-
C.
FETCH
-
D.
RETRIEVE
Solution
The SELECT statement is used to retrieve data from a database in SQL.
Correct Answer:
B
— SELECT
Learn More →
Showing 1 to 10 of 10 (1 Pages)
