Home
Mcqs
Quizes
Q&A
Past Paper
blog
Spaces
Join Now
Sign in
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
DDL is used to:
A. Represent the database structure.
B. Define and manage the structure of a database.
C. Deals with manipulation of data stored in the database.
D. None of these.
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
Boyce Codd Normal Form:
A. Addresses certain type of multivalued dependencies.
B. Makes sure that data in each column is atomic.
C. Makes sure that every determinant is a candidate key.
D. None of these.
Tamoban Javnoi
COMPUTER SCIENCE & IT
-
Database Management Systems
A child entity in ER diagrams is:
A. The entity on the one side of a one to many relationship.
B. Entity that inherits attributes and relations from another entity.
C. A row of a table.
D. None of these.
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
Information Systems Auditing Process
Governance and Management of Information Technology
Information Systems Acquisition Development & Implementation
Information Systems Operations and Business Resilience
Protection of Information Assets
Programming
Cybersecurity
Software Engineering