WorksheetsDBMS
Total questions: 20
Worksheet time: 10mins
What does DBMS stand for?
Database Management System
Data Binary Management System
Dynamic Business Management System
Digital Backup Management System
Which of the following is not a type of DBMS model?
Hierarchical
Relational
Sequential
Object-oriented
What is the primary key in a relational database?
A key that uniquely identifies each record in a table
A key that is used for encryption
A key that is used for indexing purposes
A key that is a combination of other keys
Which of the following is not a valid data type in MySQL?
VARCHAR
BOOLEAN
TINYINT
DECIMAL
What does SQL stand for?
Structured Query Language
Sequential Query Language
Structured Question Language
Systematic Query Language
Which of the following is not a SQL command?
SELECT
INSERT
MOVE
UPDATE
Which normal form ensures that there are no repeating groups of data?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Fourth Normal Form (4NF)
In a relational database, what is a foreign key?
A key used for opening encrypted data
A key that uniquely identifies each record in a table
A key that links two tables together
A key that is used for indexing purposes
Which SQL clause is used to filter rows from a result set?
WHERE
SELECT
FROM
GROUP BY
What does ACID stand for in database transactions?
Authorization, Consistency, Integrity, Durability
Aggregation, Consistency, Isolation, Durability
Access, Control, Isolation, Durability
Atomicity, Consistency, Isolation, Durability
Which of the following is an example of a DDL (Data Definition Language) statement?
SELECT
INSERT
CREATE
UPDATE
Which type of join returns all rows when there is a match in one of the tables?
Inner join
Left join
Right join
Full outer join
Which SQL function is used to return the current date and time?
GETDATE( )
NOW( )
CURRENT_TIMESTAMP ( )
SYSDATE( )
What is the purpose of normalization in database design?
To speed up database performance
To eliminate redundancy and dependency
To make databases smaller in size
To encrypt sensitive data
Which of the following is not a property of a relation in the relational model?
Each cell contains exactly one atomic (indivisible) value
Values in a column must be of the same data type
Rows in a table have no defined order
Each row in a table is unique
In which normal form is a relation if it is in Second Normal Form (2NF) and every non-prime attribute is fully functionally dependent on the primary key?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF
Which SQL command is used to add a new column to an existing table?
ALTER TABLE
UPDATE TABLE
MODIFY TABLE
ADD COLUMN
Which of the following is not a type of SQL constraint?
UNIQUE
DEFAULT
EXCLUSIVE
FOREIGN KEY
In the context of database transactions, what does the term "isolation level" refer to?
The level of security encryption applied to the database
The degree to which transactions are isolated from each other
The level of database indexing applied to improve query performance
The level of redundancy introduced into the database schema
What is the purpose of the DML (Data Manipulation Language) command "MERGE" in SQL?
To combine multiple columns into a single column
To insert new rows into a table
To update existing rows or insert new rows if they do not exist
To delete rows from a table based on specified conditions
