DBA 110 quiz 3
"To search for null values, use the _ clause."
equal to NULL
0 out of 2 points
"To override the order of precedence in an arithmetic expression, you can use
DBA 120 Fall 2016
1. The CREATE USER and CREATE SESSION statement is used to add a user, and the IDENTIFIED BY is the password for the specified user. This type of privilege is a SYSTEM privilege.
2. CREATE TABLE or CREATE ANY TABLE should be granted.
0 out of 4 points
The identifier of the entity becomes the _ of the corresponding
4 out of 4 points
Given the tables
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE_B (Attribute4, Attribute5, At
DBA 110 Quiz 5
"Issue the correct statement (in the mysql command line window) to view the City table
columns and settings, and then indicate the primary key below. "
Show columns from city; name is the primary key.
DBA 110 Quiz 6
MySQL is another language that is added to SQL to organize database.
2 out of 2 points
Which are the three MySQL benefits that add value to the SQL language and database
management in t
DBA 110 Quiz 4
The ALTER statement can be used to:
change the table
change the table structure
change the table data
add rows to the table
delete rows from the table
2 out of 2 points
The _ command defines
DBA 110 Quiz 2
"If you created a pet_info table in this way: 'CREATE TABLE pet_info (pet_name char(20) NOT
NULL, owner char(20) NOT NULL, pet_type varchar(30) NOT NULL, pet_gender enum ('m', 'f')
NULL, pet_bday date, pet_dday date, PRIMARY KEY (pet_name);
Dont forget to Tee you file when you are working on most of your lab work.
mysql> TEE d:\lab03.txt
1. Create a my_opts.txt file under c:\
2. From home, adjust your user=root and password= to your password
4. C:\>mysql -u student -p -e "SELECT
Lab 2 Working with MySQL
Use option file to access MySQL
Use many of features of the mysql client
Learn how to edit and use option file to simplify access to MySQL
Learn to use many of features of the mysql