Oracle 1z0-882 問題集

質問 1：
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

質問 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?
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

質問 3：
You create a new,empty database called 'test'. You want to change the database 's CHARACTER SET to "latin1" and the
database 'sCOLLATION to 'latin_german_ci'.
Which statement is true?
A. Databases do not have CHARACTER SET or COLLATION attributes.
B. You can only do this with two separate commands:
ALTER DATABASE 'test' CHARACTER SET latin1
ALTER DATABASE 'test' COLLATE latin_german1_ci
C. You cannot change the CHARACTER set or COLLATION value on an existing database.
D. You can do this one command:
ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci
正解：D

質問 4：
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 メンバーにのみ表示されます)

質問 5：
You have been tasked to create a database that will store a list of all managers and the employees who report directly
to them. The following is stipulated:
No manage is managing more than three people.
No employee can work for more than one manage.
Which of these designs represents a normalized schema that meets the project requirements?
A. CREATE TABLE 'manager'
'manager' varchar (50) DEFAULT NULL,
'employee2' varchar (50) DEFAULT NULL,
'employee' varchar (50) DEFAULT NULL,
UNIQUE ( 'manager ', 'employee1', 'employee2, 'employee3')
)
B. CREATE TABLE 'message' (
'id' int(11) NOT NULL AUTO_INCREMENT,
'manager' varchar(50) DEFAULT NULL,
PRIMARY KEY ("id')
)
CREATE TABLE 'employees' (
'id int (11) NOT NULL AUTO _INCREMENT,
'employees' varchar(25) DEFAULT NULL,
)
C. CREATE TABLE 'managers' (
"id' int(11) NOT NULL AUTO_INCREMENT,
'manager' varchar (50) DEFAULT NULL ,
PRIMARY KEY ('id')
)
CREATE TABLE "employees' (
'id' int(11) NOT NULL AUTO _INCREMENT,
'manager_id' int(11) DEFAULT NULL,
'employee varchar (25) DEFAULT NULL,
PRIMARY KEY ('id')
)
D. CREATE TABLE 'manager' (
'manager' varchar (50) DEFAULT NULL,
'employee_list'varchar (150) DEFAULT NULL,
)
正解：A

質問 6：
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

質問 7：
A SELECT statement without an ORDER BY clause return some rows.
Which statement is always true about the order of the returned results?
A. The results are not in a set order.
B. The results are in descending order.
C. The results are in the order inserted.
D. The results are in ascending order.
正解：A
解説: (Topexam メンバーにのみ表示されます)