Sample questions and answers

Let’s evaluate some sample questions and answers about relational databases for the DP-900 certification:

1. Which of the following statements is characteristic of a relational database?

1. A row in a table represents a data type.
2. Rows in the same table can contain different columns.
3. A table has columns (attributes) and rows (records).
4. All columns in a table should have the same data type.

2. Which SQL statement is used to create new rows in a table?

1. CREATE ROW
2. CREATE
3. INSERT
4. NEW ROW

3. What is an index?

1. A structure that enables queries to locate rows in a table quickly
2. A virtual table based on the results of a query
3. A pre-defined SQL statement that modifies data
4. A type of primary key column

4. Which statement is an example of DDL?

1. SELECT
2. INSERT
3. DELETE
4. DROP

Answer key

1-C 2-C 3-B 4-D