Oracle 1Z0-051 問題集

質問 1：
You created an ORDERS table with the following description:
Exhibit:

You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column.
Which statement is true in this scenario?
A. The primary key constraint can be created only a the time of table creation
B. You cannot add a primary key constraint if data exists in the column
C. You cannot have two constraints on one column
D. You can add the primary key constraint even if data exists, provided that there are no duplicate values
正解：D

質問 2：
View the Exhibit for the structure of the STUDENT and FACULTY tables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine the following two SQL statements:

Which statement is true regarding the outcome?
A. Both statements 1 and 2 execute successfully and give the same required result.
B. Only statement 1 executes successfully and gives the required result.
C. Only statement 2 executes successfully and gives the required result.
D. Both statements 1 and 2 execute successfully and give different results.
正解：A

質問 3：
Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)
A. It allows the MANAGER to pass the specified privileges on to other users.
B. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
C. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
D. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F. MANAGER must be a role.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You need to produce a report where each customer's credit limit has been incremented by $1000.
In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit.
The column headings should have only the first letter of each word in uppercase .
Which statement would accomplish this requirement?
A. SELECT cust_last_name Name, cust_credit_limit + 1000
"New Credit Limit"
FROM customers;
B. SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000 INITCAP("NEW
CREDIT LIMIT")
FROM customers;
C. SELECT cust_last_name AS Name, cust_credit_limit + 1000
AS New Credit Limit
FROM customers;
D. SELECT cust_last_name AS "Name", cust_credit_limit + 1000
AS "New Credit Limit"
FROM customers;
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which object privileges can be granted on a view?
A. DELETE, INSERT, SELECT, UPDATE
B. DELETE, INSERT,SELECT
C. none
D. ALTER, DELETE, INSERT, SELECT
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables:

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table. Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following the CREATE TABLE command: Exhibit:

Which statement is true regarding the above command?
A. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table
B. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table
C. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match
D. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine the structure of the PROMOS table:

You want to display the list of promo names with the message 'Same Day' for promos that started and ended on the same day.
Which query gives the correct output?
A. SELECT promo_name, DECODE((NULLIF(promo_start_date, promo_end_date)),
NULL,'Same day') FROM promos;
B. SELECT promo_name, NVL2(TO_CHAR(TRUNC(promo_end_date-promo_start_date)),
NULL,'Same Day')
FROM promos;
C. SELECT promo_name, NVL(NULLIF(promo_start_date, promo_end_date), 'Same Day')
FROM promos;
D. SELECT promo_name, NVL(TRUNC(promo_end_date - promo_start_date), 'Same
Day') FROM promos;
正解：A
解説: (Topexam メンバーにのみ表示されます)