1.
Which of the following SQL statements can be used on a view that is created with the WITH READ ONLY option?
2.
Which of the following is a Data Definition Language (DDL) statement?
3.
Which of the following options is used to prevent the inadvertent loss of a permanent table?
4.
For which of the following data types must a column be indexed if the AUTO_INCREMENT attribute is specified?
5.
Which of the following statements can be used to select a database to make it the default database for a given connection to a server?
6.
Which of the following constraints of an existing table is automatically copied to the new table that is created by using the existing table?
7.
Identify whether the given statement is true or false.
"The NUMBER datatype is used to store both fixed-point and floating-point numbers."
8.
Which of the following data types is a binary-string type?
9.
Identify whether the given statement is true or false.
"Database applications provide certain integrity constraints that must hold for the data."
10.
Which of the following options is an approximate-value data type?