Home
Mcqs
Quizes
Q&A
Past Paper
blog
Spaces
Join Now
Sign in
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
Which type of database index is typically used to improve the speed of queries that involve range searches?
A. Hash index.
B. B-tree index.
C. Bitmap index.
D. Full-text index.
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
How to ensure ACID properties are maintained in a transaction?
A. By using appropriate indexing.
B. By defining primary keys and foreign keys.
C. By using database transaction management features.
D. By normalizing the database.
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
Where would you typically find the definition of a database schema?
A. In the application code.
B. In the database management system metadata.
C. In the user interface.
D. In the transaction logs.
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
When is a database said to be in the Third Normal Form (3NF)?
A. When it is free of multivalued dependencies.
B. When it has no partial dependency.
C. When it has no transitive dependency.
D. When it has a single candidate key.
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
What is the primary purpose of normalization in database design?
A. To improve query performance.
B. To reduce data redundancy.
C. To increase data integrity.
D. To simplify database schemas.
COMPUTER SCIENCE & IT
Web Design & Development
Database Management Systems
Computer Networks & Security
Operating Systems
Data Structures & Algorithms