Oracle 1z0-882 問題集

質問 1：
You started a MySQL command -line session with sq1_ mode (empty), and created the person table with the
structure:
Mysql> DESC person;

You issue:
INSERT INTO person VALUES ('casper', 'undefined')
What is the effect?
正解：

質問 2：
As a developer, you inherit this table as part of a project:
CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED
)
What change should you make to ensure that examinee_id is an integer value throughout the table?
A. The examinee_id column should be designated as PRIMARY KEY.
B. A NOT NULL qualifier should be added to examinee_id.
C. A NOT NULL qualifier should be moved from exam-id to examinee-id.
D. The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).
正解：B

質問 3：
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?
A. All rows from both tables exist in employeesMAIN.
B. A unique list of employees exist in employeesMAIN.
C. An error is produced because you cannot create a TEMPORARY TABLE with a UNION.
D. The employees common to both tables exist in employees MAIN.
正解：A

質問 4：
You want to load data directly from a file into MYSQL by using the SOURCE command.
Which types of data can the file contains to perform this?
A. SQL commands
B. MyISAM or InnoDB data files
C. Comma-delimited data
D. Tab-delimited data
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You have access to a MySQL 5.6 database with the SELECT ,INSERT, and DELETE privileges on all tables in the mydb
database.
The mydb database.
The mydb t1 table has five rows of data.
You use the statement below to remove all rows in the t1 table:
Mysql> TRUNCATE TABLE mysql.t1;
What is the result?
A. The command fails owing to permissions error.
B. The command succeeds and five rows are affected.
C. The command fails owing to syntax error.
D. The command succeeds and o rows are affected.
正解：A

質問 6：
When working with stored routines, these details are available:
The affected -rows count
The number of conditions that occurred
The condition information, such as the error code and message
Where can you find these default?
A. In the Handler area, defined in the DECLARE handler_action HANDLER block in a stored routine
B. In the Diagnostics area, part, of which can be stored in user-defined or routine variables
C. In the Signal area, which is set with the help of the SIGNAL statement in a stored routine
D. In the Error area, which can be accessed with the help of the SHOW ERRORS statement
正解：B

質問 7：
What are two ways in which normalizing your tables helps improve performance In MySQL?
A. Fewer nullable column improve index usage.
B. Smaller table sizes and row lengths improve sorting operations.
C. Normalizing Improves the performance of innodb_file_per _table.
D. Separate tables allow indexing more columns.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)