DBMS

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