1.
A __________ contains all the information about the data analysis including entities, attributes, and tables.
2.
Which of the following is a logical entity that acts as a table but is not one?
3.
Identify whether the given statement is true or false.
"A CHAR column can be converted to a VARCHAR2 column and vice-versa even if the column contains non- NULL values, provided its size does not change."
4.
Which of the following statements is used to search data when the users do not have the exact or complete text for a column?
5.
Identify whether the given statement is true or false.
"In an INSERT statement, if columns are not specified in the INTO clause, the values in the VALUES clause must be in the order in which the columns have been defined in the table."
6.
Identify whether the given statement is true or false.
"Column aliases can be used in a WHERE clause."
7.
Which of the following special characters is used to query all the columns from a table without listing each column by name?
8.
Identify whether the given statement is true or false. "The number and datatypes of values specified in the
VALUES clause of an INSERT statement must match the number and datatypes of corresponding columns specified in the INTO clause."
9.
Which of the following statements is used to add more than one record to a table?
10.
Which of the following SQL statements can be used to repair only the index tree in a MYSQL database?