Oracle 1z0-882 問題集

質問 1：
Assume your connection uses SQL mode ANSI_QUOTES.
Which two statements cause a syntax error?
A. CREATE TABLE 'TABLE' (COLUMN' INTEGER)
B. CREATE TABLE BINARY (PRIMARY SMALLINT)
C. CREATE TABLE "CONDITION" ("DESCRIBE" TEXT)
D. CREATE TABLE FRIENDS (NAME CHAR (10))
E. CREATE TABLE INTERVAL (ELAPSED_TIME TIME)
正解：B,E

質問 2：
A floating- point column defined as FLOAT(7,5)allows___________
A. 7 digits in total, of which 5 are to the left of the decimal point
B. 5 digits to the left of the decimal point and 7 digits to the right
C. 7 digits to the left of the decimal point and 5 digits to the right
D. 7 digits in total, of which 5 are to the right of the decimal point
正解：D

質問 3：
Examine the structure and content of the MemberLocation table:

You want to have the field location returned in all letters (example: BERLIN).
Which query would you use?
A. SELECT UPPER (BINARY location) as location FROM MemberLocation
B. SELECT UPPER (Location) as location FROM MemberLocation
C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Inspect the CREATE TABLE below:
Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;
Query Ok, 0 rows affected, 2 warnings (0.11 sec)
Mysql> SHOW WARNINGS;

Which two is true connecting the meaning of the warnings?
A. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB
B. Global variable skip _innodb was set to ON after the server had started.
C. The InnoDB storage engine was disabled during server startup.
D. MYSQL server was not started with the option default -storage -engine=InnoDB
E. The default storage engine MYISAM was used for the table created.
正解：A,D

質問 5：
Which condition must be true in order that a view is considered updateable?
A. The view must only refer to literal values.
B. The user must have the UPDATE or DELETE privilege for the underlying table.
C. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.
D. There must be a subquery in the WHERE clause that refers to a table in the FROM clause.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 A
B. Option C
C. Option D
D. Option B
正解：B

質問 7：
You have two test tables:
Code_innodb as InnoDB engine
Code_ myisam as MYISAM engine
The tables have the same structure:

The tables have one row of data:

You execute an INSERT statement on both code_myisam tables and receive duplicate key errors:
mysql> INSERT INTO code_innodb VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie,),(4, 'Delta');
ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'
Mysql> INSERT INTO code_myisam VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie'),
(4, 'Delta');
ERROR 1062 (23000); Duplicate entry '3' for key 'PRIMARY'
What is the expected output of the SELECT statements?

A. Option A
B. Option C
C. Option D
D. Option B
正解：A