Database Management Quiz

Which of the following refer to data?

• An order in an online store

• Exchange rate

• A biography of Alexander Pushkin

• Phone number

• Address

Which of the following statements about DBMSs is INCORRECT?

• DBMSs do not isolate the operations of users working with a DB at the same time.

• A DBMS allows you to control user access to data.

• A DBMS allows you to manipulate data: insert, update, delete, and select.

• A DBMS can be used to protect data from accidents.

In which of the following DB objects is information stored?

• Table

• Constraint

• Data type

Which of the following statements about the primary key is correct?

• The primary key is always restricted by uniqueness.

• The primary key can contain null values.

• Primary key values can contain duplicates.

Which of the following are disadvantages of SQL?

• Complexity

• DBMS-independent

• Requires procedural extensions

• Standardized

• Unpredictable performance of complex queries

What is ANSI SQL?

• An SQL standard that defines the syntax of SQL commands.

• A structured query language for managing data in relational database management systems

• A dialect of SQL that is used in the Microsoft SQL Server RDMS

• An artificial, normalized, standardized implementation of SQL.

Which of the following statements is INCORRECT?

• For OLAP databases, high-level normalization is not important.

• The higher the level of normalization, the more relationships there are, and the more connections there are between them.

• Data warehouses are optimized to ensure high performance when selecting a large amount of data.

• For OLTP databases, it is not important to insert and update data.

Which of the following statements about the TRUNCATE statement is true?

• It removes specific rows from a table.

• The WHERE clause cannot be used.

• It inserts rows in a table.

• It is not MVCC-safe; the effect is visible to other transactions instantly.

• It removes ALL of the rows from a table.

Which of the following is the correct way to insert multiple rows in a single INSERT statement?

• INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4), (value5, value6)

• INSERT INTO table_name (column1, column2) (value1, value2), (value3, value4), (value5, value6)

• INSERT INTO table_name (value1, value2), (value3, value4), (value5, value6) VALUES (column1, column2)

• INSERT INTO table_name VALUES (column1, column2) (value1, value2), (value3, value4), (value5, value6)

Which of the following statements is correct?

• DML and DDL commands are transaction-safe and can be rolled back if necessary.

• Database-wide and tablespace-wide operations (including DCL operators) can be rolled back

• Any non-committed transaction will be automatically committed if the session is interrupted.

• All DML commands except TRUNCATE are MVCC-unsafe.