SQL review quiz

Which of the following is an example of a DBMS?

• Access

• Mysql

• SQL

• All the above

What does DDL stand for?

• Data Definition Language

• Data Derived Language

• Data dictionary License

• All of the above

Which of the following commands is NOT a DML command?

• Select

• Alter

• Delete

• Update

What is a primary key?

• A unique key used to link two table in a relationship

• One of the keys in a database table

• A key used to uniquely identifying records in a database

• All of the above

Which of the following is a rule for 2NF?

• All non-key fields depend on all components of primary key

• No non-key field depends upon another

• There are no repeating or duplicate fields

• Each record is unique

Used in situations where no one individual field qualifies to be a primary key by its own. It refers to a combination of two or more fields in table that together make the primary key for the table.

• Referential Integrity

• Primary key

• Compound key

• Foreign key

a relational database concept, which states that table relationships must always be accurate and consistent

• Entity reletional diagram

• referential integrity

• redundancy

• foreign key

a thing, person, place, unit, object or any item about which the data should be captured and stored in the form of properties.

• Field

• Record

• Entity

• database