Consider the table structure shown by this output:
Mysql> desc city:

5 rows in set (0.00 sec)
You execute this statement:
SELECT -,-, city. * FROM city LIMIT 1
What is returned?

• A. One row with 10 columns
• B. An error message
• C. One row with 15 columns
• D. One row with 5 columns

Examine this table that contains over two million rows of data:
CREATE TABLE 'news_feed' (
.id'bigint (20) NOT NULL AUTO _INCREMENT,
.news _sources_id'varchar (11) NOT NULL,
.dataline' datetime NOT NULL,
.headline' varchar (256) NOT NULL,
.story' text NOT NULL,.tag varchar (32768) DEFAULT NULL,
PRIMARY KEY ('id')
KEY 'dateline' ( 'dateline')
)
Examine this query that returns 332 rows of date:
SELECT *
FROM news_feed
WHERE DATE(dateline)= '2013-01-01'
Which change would show the greatest improvement in the response time of the query?

• A. Use the LIKE operator:
  SELECT . . .WHERE dateline LIKE '2013-10-01&'
• B. USE the DATEDIFF function:
  SELECT . . . WHERE DATEDIFF (dateline, '2013-01-01') = 0
• C. Use a date range comparison:
  SELECT . . . WHERE dateline >= '2013-01' and dateline < '2013-01-02'
• D. Use numeric equivalents for comparing the two dates:
  SELECT. . .WHERE MOD(UNIX_TIMESTAMP (dateline), 86400 =UNIX_TIMESTAMP ('2013-01-01')

You want to query the VARCHAR column ' code' values that match:
Start with "p"
End with "_"
Contain more than 3 characters
Assume that sql_mode is blank.
Which two queries select only those rows?

• A. SELECT code FROM operations WHERE code LIKE "p_%_%;_"ESCAPE "/";
• B. SELECT code FROM operations WHERE code LIKE "p%_\_";
• C. SELECT code FROM operations WHERE code LIKE " '%'%_' "ESCAPE " ' '';
• D. SELECT code FROM operations WHERE code LIKE "p%%_";
• E. SELECT code FROM operations WHERE code LIKE "p_\%\_";

You have two tables:
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
The tables have the data:
Department

You execute the statement:
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
What data is in the employee table after the statement?

• A. Option C
• B. Option D
• C. Option A
• D. Option B

Consider the content of the class and student tables:
Class

Which three queries produce the same result?

• A. SELECT *
  FROM JOIN student
  On class .class_id=student.class_id
  WHERE NOT ISNULL (student.class_id)
• B. SELECT *
  FROM class
  INNER JOIN student
  WHERE NOT ISNULL (student.class_id)
• C. SELECT *
  FROM student
  RIGHT JOIN class
  ON class.class_id=student.class_id
• D. SELECT *
  FROM JOIN student
  LEFT JOIN student
  ON class. Class.class_id=student.class_id
• E. SELECT *
  FROM class
  INNER JOIN student
  ON class.class_id=student.class_id