Scribd
Upload
31 views3 pages

7-3-24 dbms set

Uploaded by

alokkdixit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
31 views3 pages

7-3-24 dbms set

Uploaded by

alokkdixit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

1. What is the primary function of a database management system (DBMS)?

a) Manage hardware resources


b) Store and retrieve data
c) Execute user interfaces
d) Control network traffic
Answer: b) Store and retrieve data
2. Which of the following is not a type of database model?
a) Hierarchical
b) Relational
c) NoSQL
d) Linear
Answer: d) Linear
3. What is ACID in database transactions?
a) Atomicity, Consistency, Isolation, Durability
b) Accuracy, Consistency, Isolation, Durability
c) Atomicity, Compatibility, Isolation, Durability
d) Atomicity, Consistency, Integrity, Durability
Answer: a) Atomicity, Consistency, Isolation, Durability
4. Which database language is used to manipulate data in a relational database?
a) SQL
b) HTML
c) CSS
d) XML
Answer: a) SQL
5. In a relational database, what is a primary key?
a) A key used for primary authentication
b) A unique identifier for each row in a table
c) A key used for encryption purposes
d) A key used for indexing purposes
Answer: b) A unique identifier for each row in a table
6. Which normal form ensures that there are no repeating groups within a table?
a) First Normal Form (1NF)
b) Second Normal Form (2NF)
c) Third Normal Form (3NF)
d) Boyce-Codd Normal Form (BCNF)
Answer: a) First Normal Form (1NF)
7. Which database model organizes data into a tree-like structure?
a) Relational
b) Hierarchical
c) Network
d) NoSQL
Answer: b) Hierarchical
8. What is a foreign key in a relational database?
a) A key used to access a remote database
b) A key that uniquely identifies each row in a table
c) A key that links two tables together
d) A key that is encrypted for security purposes
Answer: c) A key that links two tables together
9. What is the purpose of a database index?
a) To speed up data retrieval
b) To encrypt sensitive data
c) To enforce data integrity constraints
d) To generate reports
Answer: a) To speed up data retrieval
10. Which database model allows for flexible and schema-less data storage?
a) Relational
b) Hierarchical
c) NoSQL
d) Object-Oriented
Answer: c) NoSQL
11. What does CRUD stand for in database operations?
a) Create, Retrieve, Update, Delete
b) Collect, Retrieve, Update, Delete
c) Connect, Retrieve, Use, Delete
d) Create, Replace, Update, Drop
Answer: a) Create, Retrieve, Update, Delete
12. Which of the following is not a component of a database schema?
a) Tables
b) Views
c) Queries
d) Constraints
Answer: c) Queries
13. What does DDL stand for in database management?
a) Data Definition Language
b) Data Distribution Layer
c) Data Design Language
d) Data Description Language
Answer: a) Data Definition Language
14. Which type of join returns all rows from both tables, joining records when the condition is met?
a) INNER JOIN
b) LEFT JOIN
c) RIGHT JOIN
d) FULL OUTER JOIN
Answer: d) FULL OUTER JOIN
15. Which SQL keyword is used to retrieve data from a database?
a) FETCH
b) RETRIEVE
c) SELECT
d) GET
Answer: c) SELECT
16. What is a view in a database?
a) A virtual table based on the result of a SELECT query
b) A physical table stored in memory
c) A table used for temporary storage
d) A table used for backup purposes
Answer: a) A virtual table based on the result of a SELECT query
17. Which database model stores data in key-value pairs?
a) Hierarchical
b) Relational
c) NoSQL
d) Object-Oriented
Answer: c) NoSQL
18. In SQL, which function is used to return the number of rows that matches a specified condition?
a) TOTAL()
b) COUNT()
c) SUM()
d) AVG()
Answer: b) COUNT()
19. Which database constraint ensures that all values in a column are unique?
a) PRIMARY KEY
b) FOREIGN KEY
c) UNIQUE
d) CHECK
Answer: c) UNIQUE
20. What does the term "Normalization" refer to in the context of databases?
a) A process of reducing data redundancy and dependency
b) A process of increasing data redundancy for faster retrieval
c) A process of encrypting sensitive data
d) A process of compressing database files
Answer: a) A process of reducing data redundancy and dependency

You might also like