#1
Which of the following is not a type of database management system?
Relational DBMS
NoSQL DBMS
Hierarchical DBMS
Analytical DBMS
#2
Which SQL statement is used to extract data from a database?
#3
What is a primary key?
A key that uniquely identifies each row in a table
A key that is primary to all tables
A main key used for multiple tables
A key that unlocks the primary data
#4
What is the purpose of the SQL 'JOIN' clause?
To concatenate strings
To combine rows from two or more tables, based on a related column between them
To insert a new record into a table
To update data in a database
#5
What does the term 'OLTP' stand for?
Online Transaction Processing
Online Translation Process
Operational Transaction Processing
Operational Translation Procedure
#6
Which of the following is NOT a valid SQL aggregate function?
#7
What does ACID stand for in the context of databases?
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Integration, Durability
Association, Consistency, Isolation, Durability
Atomicity, Connection, Isolation, Durability
#8
Which of the following best describes the concept of 'Data Encapsulation' in DBMS?
Combining data and methods into a single unit
Encrypting data to protect it from unauthorized access
The process of data backup and recovery
Separating data into packets for network transmission
#9
Which of the following is not a characteristic of NoSQL databases?
Fixed schema
Scalability
Flexibility in storing unstructured data
Distributed computing
#10
Which of the following is an example of a Document-Oriented NoSQL database?
#11
In the context of database indexing, what is a 'B-tree'?
A binary tree structure optimized for disk storage
A balanced tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic time
A basic tree structure used for hierarchical data representation
A binary tree that is unbalanced and used for database testing
#12
Which of the following is true about 'Triggers' in a database?
They are special types of stored procedures that are defined to execute automatically in place or after data modifications
They can only be used to validate data during inserts and updates
They are used to speed up the process of retrieving data from the database
They are primarily used for data backup and recovery processes
#13
In a 'Star Schema' design in data warehousing, what is a fact table?
A table that contains the dimensions of the business
A table that holds foreign keys from dimension tables as well as measures and facts
A table that only contains textual information of the business processes
A central table that summarizes all data and is linked to all other tables
#14
What is 'Data Mining'?
The process of designing, writing, testing, debugging, and maintaining the source code of database scripts
The process of protecting and securing a database from illegitimate use and malicious threats and attacks
The process of discovering patterns, correlations, anomalies, and significant relationships in large sets of data
The physical process of storing and retrieving data from a hard disk
#15
What is 'Database Replication'?
The process of duplicating data across multiple databases for backup purposes
The process of copying and distributing data and database objects from one database to another and synchronizing between databases to maintain consistency
A method of data storage using multiple hard drives
The act of splitting a database into smaller chunks to improve performance
#16
Which one of the following is a key feature of 'Column-oriented' DBMS?
Data is stored in rows, making it optimal for writing data quickly.
Data is stored in columns, making it optimal for reading large volumes of data.
Data is stored without any specific structure, allowing for high flexibility.
Data is encrypted automatically, providing built-in security.
#17
What is the main advantage of using 'Stored Procedures' in a database?
They provide a secure method of data replication.
They allow faster data retrieval by storing the SQL code on the client side.
They enhance security by abstracting the SQL queries from the user and reduce database access by encapsulating complex queries.
They automatically create backups of the database at regular intervals.
#18
In the context of database transactions, what does 'Locking' prevent?
Data corruption by ensuring only one transaction can read or write to a piece of data at a time
Unauthorized access to data by encrypting the database contents
Physical damage to the hard drives storing the database
Data from being read or written to the database entirely
#19
Which of the following best describes 'Entity-Relationship (ER) Models'?
A graphical representation of data structures for a database, showing the database's tables, the fields in each table, and the relationships between fields and tables
A framework for specifying the logical structure of a database in a graphical form, to represent entities, their attributes, and relationships
A programming model that defines the methods by which data can be stored, retrieved, and manipulated on a web server
A method for executing large numbers of transactions processed online
#20
In database systems, what is 'Partitioning' used for?
Dividing a database into multiple pieces to make management, performance tuning, and backup and recovery more efficient
Encrypting and securing database parts to protect sensitive data
Creating multiple user interfaces for different types of database users
Replicating database parts for use in distributed systems
#21
What is the primary purpose of 'Normalization' in database design?
To reduce data redundancy and improve data integrity
To increase the speed of database queries
To secure the database by normalizing user access levels
To partition the database into smaller, more manageable pieces
#22
In database normalization, which normal form is concerned with removing transitive dependency?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
#23
What does the term 'Sharding' refer to in database management?
Encrypting database files on disk
Duplicating data across multiple servers
Breaking a database into smaller, faster, more easily managed parts called shards
Creating a backup of a database
#24
Which one of the following best describes 'CAP Theorem' in distributed database systems?
It states that a distributed computer system cannot simultaneously guarantee consistency, availability, and partition tolerance.
It describes the capacity of a database to handle growth in the amount of data and transactions.
It outlines the principles for constructing and administering databases.
It defines the criteria for database security and data encryption.
#25
What is 'Two-phase Commit' protocol in databases?
A backup protocol that ensures data is saved in two different locations for safety
A data replication method that involves two different phases for data consistency
A synchronization protocol for ensuring that all participants in a distributed transaction either commit or roll back changes
A security protocol that requires two forms of identification from the user