Question 21
To model a database on a real-world system, you typically represent each real-world entity as a/an ________________.Question 22Which of the following is NOT a MySQL data type?
Question 23
To load data from a text file to a table in a MySQL database, you can use the MySQL LOAD command or ________________.
Question 24
Which MySQL data type is typically used for variable-length strings?
Question 25
When you use MySQL, you can't code one of the following as part of a CREATE TABLE statement. Which one is it?
|
default value for a column
|
|
NOT NULL attribute for a column
|
|
user privileges for the table
|
|
primary key for the table
|
Question 26
Which SQL statement can be used to modify the columns of an existing table?
Question 27
Write an aggregate expression to find the oldest date in the invoiceDate column:
________________.
Question 28
If you assign an alias to one table in a join, you have to
|
qualify every column name in the query
|
|
use that name for the table throughout the query
|
|
assign them to all of the tables in the query
|
|
qualify all of the column names for that table
|
Question 29
If a database allows null values in a column, you can use the ________________ operator in a WHERE clause to retrieve only those rows that have a null value in that column.
Question 30
Which type of operators can be used to create compound conditions in a SQL statement?