問題1
Which three view types are not updateable?
Which three view types are not updateable?
正確答案: B,C,D
說明：（僅 NewDumps 成員可見）
問題2
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?
正確答案: B
問題3
You want to compare all columns of table A to columns with matching names in table B.
You want to select the rows where those have the same values on both tables.
Which query accomplishes this?
You want to compare all columns of table A to columns with matching names in table B.
You want to select the rows where those have the same values on both tables.
Which query accomplishes this?
正確答案: A
問題4
Your application is running slow.
Which two features provide information that help to identify problems?
Your application is running slow.
Which two features provide information that help to identify problems?
正確答案: A,D
問題5
Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?
Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?
正確答案: A
問題6
You have a transaction that queries a table at the beginning of the transaction and performs the same query later.
Which two transaction isolation levels guarantee that you get the same results both times?
You have a transaction that queries a table at the beginning of the transaction and performs the same query later.
Which two transaction isolation levels guarantee that you get the same results both times?
正確答案: A,C
說明：（僅 NewDumps 成員可見）
問題7
You attempt to create two new tables:
CREATE TABLE 'warehouse' (
'id' int (11) NOT NULL AUTO_INCREMENT,
'name' varchar (20) NOT NULL,
'phone' varchar (20) NOT NULL,
PRIMARY KEY (' id)
) ENGINE=MyISAM
CREATE TABLE 'warehouseitem' (
'warehouse_id' bigint (11) NOT NULL,
'item_id' int (11) NOT NULL,
'count' int(11) NOT NULL DEFAULT '0',
KEY "warehouse_id' ('warehouse-id) ,
FOREIGN KEY (warehouse_id) REFFERENCES warehouse (id)
) ENGINE= InnoDB
You get this error :
ERROR 1215 ( HYooo): cannot add foreign key constraint
Which two changes are required to permit these statements to execute without any error?
You attempt to create two new tables:
CREATE TABLE 'warehouse' (
'id' int (11) NOT NULL AUTO_INCREMENT,
'name' varchar (20) NOT NULL,
'phone' varchar (20) NOT NULL,
PRIMARY KEY (' id)
) ENGINE=MyISAM
CREATE TABLE 'warehouseitem' (
'warehouse_id' bigint (11) NOT NULL,
'item_id' int (11) NOT NULL,
'count' int(11) NOT NULL DEFAULT '0',
KEY "warehouse_id' ('warehouse-id) ,
FOREIGN KEY (warehouse_id) REFFERENCES warehouse (id)
) ENGINE= InnoDB
You get this error :
ERROR 1215 ( HYooo): cannot add foreign key constraint
Which two changes are required to permit these statements to execute without any error?
正確答案: B,E
問題8
Consider the statement:
CREATE TABLE t1 (a INT) PARTITION BY KEY
/*150611 ALGORITHM = 1*/
What does this statement do?
Consider the statement:
CREATE TABLE t1 (a INT) PARTITION BY KEY
/*150611 ALGORITHM = 1*/
What does this statement do?
正確答案: C
問題9
Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no mysqld
process is running.
Which two may provide diagnostic information to help determine why the MYSQL server stopped?
Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no mysqld
process is running.
Which two may provide diagnostic information to help determine why the MYSQL server stopped?
正確答案: D,E
問題10
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
正確答案: A,C,E