1z1-882 試験問題を無料オンラインアクセス

Using the query:
SELECT Code FROM country WHERE Name = 'united states'
Which statement executed in the mysql client would create a prepared statement?

• A.PREPARE STATEMENT countrycode As 'SELECT code FROM country WHERE Name =?.;
• B.PREPARE countrycode FROM 'SELECT code FROM country WHERE Name =?.;
• C.PREPARE STATEMENT countrycode FROM 'SELECT code FROM counyry WHERE Name =?.;
• D.PREPARE countrycode As 'SELECT code FROM country WHERE Name =?.;

Given the data from table t1:

This DELETE command is executed:
DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;
Which set of rows will be deleted by the command?

• A.(2,8) and (10,8)
• B.(7,1) and (1,4)
• C.(7,1) and (10,8)
• D.(2,8) and (1,4)

A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000.
You execute this query:
SELECT col1 FROM t1 WHERE col1< 100
UNION
SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200
UNION ALL
SELECT col1 FROM t1 WHERE col 1 >=900
What is the output?

• A.A list of all values, including duplicates, in the ranges of 1-200 and 900-1000
• B.An error, because mixing UNION and UNION ALL in the same query is not permitted
• C.A list of all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000
• D.A list of unique values within the range of 1-200 and a list of all values, including duplicates, on the table within the
  range of 900-1000
• E.A list of unique values within the ranges of 1-200 and 900-1000

Inspect the query:
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';

How can this query be optimized?

• A.The query cannot be optimized as count () must read all rows.
• B.The query needs an index that includes the title column.
• C.The query cannot be optimized as an index is already used.
• D.The query need an index on the emp-no column.

What is true about the contents of the INFORMATION_SCHEMATA table?

• A.It contains information such as name, character set, and collation for all the databases on the server.
• B.It contains information about the table structure for all databases.
• C.It contains information including tables, trigger, stored routines, and views for all databases
• D.It contains information about all the tables, triggers, and views for all databases.