Oracle 1z0-071 問題集

質問 1：
Which two are true about constraints?
A. All constraints can be defined at the table or column level.
B. Constraints are enforced only during INSERT operations.
C. A column with a UNIQUE constraint can contain a NULL value.
D. A column with a foreign key constraint can never contain a null value.
E. A constraint can be disabled even if the constrained column contains data.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true about the data dictionary?
A. The data dictionary is accessible when the database is closed.
B. Views with the prefix all_, dba_ and useb_ are not all available for every type of metadata.
C. Views with the prefix dba_ display only metadata for objects in the SYS schema.
D. The data dictionary does not store metadata in tables.
E. Views with the prefix all_ display metadata for objects to which the current user has access.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You want to return the current date and time from the user session, with a data type of TIMESTAMP WITH TIME ZONE.
Which function will do this?
A. CURRENT DATE
B. LOCALTIMESTAMP
C. CURRENT_ TIMESTAMP
D. SYSDATE
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two are true about scalar subquery expressions?
A. You cannot correlate them with a table in the parent statement
B. .You must enclose them in parentheses.
C. They can return two columns.
D. You can use them as a default value for a column.
E. They can return at most one row.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine this SQL statement:

Which two are true?
A. The subquery is executed for every updated row in the ORDERS table.
B. All existing rows in the ORDERS table are updated.
C. The subquery is not a correlated subquery.
D. The subquery is executed before the UPDATE statement is executed.
E. The UPDATE statement executes successfully even if the subquery selects multiple rows.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Examine the description of the EMPLOYEES table:

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTM ENT_ID?
A. UPDATE employees e1
SET salary=
(SELECT e1.salary + MIN(e2.salary)
FROM employees e2
WHERE e1. department_ id = e2.department_id);
B. UPDATE employees e1
SET salary = salary+(SELECT MIN (salary)
FROM employees e2) ;
C. UPDATE employees e1
SET salary =(SELECT e2. salary + MIN(e2.salary)
FROM employees e2
WHERE e1.department_ id = e2. department_id GROUP BY e2. department_id) ;
D. UPDATE employees e1
SET salary = salary +
(SELECT MIN(e1. salary)
FROM employees e2
WHERE e1.department_id = e2 .department_id);
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine these requirements:
1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
2. Sort the titles by date of purchase, starting with the most recently purchased book.
Which two queries can be used?
A. SELECT book_title FROM books WHERE (price NOT BETWEEN 500 AND 1000) AND (purchase_date< '17-JAN-2007') ORDER BY purchase_date DESC;
B. SELECT book_title FROM books WHERE (price< 500 OR >1000) AND (purchase date< '17-JAN-2007') ORDER BY purchase date DESC;
C. SELECT book_title FROM books WHERE (price BETWEEN 500 AND 1000) AND (purchase_date<'17-JAN-2007') ORDER BY purchase_date;
D. SELECT book_title FROM books WHERE (price IN (500, 1000)) AND (purchase date < '17-JAN-2007') ORDER BY purchase_date ASC;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 8：
The CUSTOMERS table has a CUST_CREDT_LIMIT column of data type number.
Which two queries execute successfully?
A. SELECT TO_CHAR(NVL(cust_credit_limit * .15,'Not Available')) FROM customers;
B. SELECT NVL2(cust_credit_limit * .15,'Not Available') FROM customers;
C. SELECT NVL(cust_credit_limit * .15,'Not Available') FROM customers;
D. SLECT NVL(TO_CHAR(cust_credit_limit * .15),'Not available') from customers;
E. True - This query uses NVL2 correctly by checking if cust_credit_limit is not NULL, then applying TO_CHAR to compute 15% of it and converting it to string, or returning 'NOT Available' if it is NULL. The syntax and function usage are correct.
F. SELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),'NOT Available') FROM customers;
正解：A,F
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Which three statements are true about multiple row subqueries?
A. They cannot contain subquery.
B. They can contain GROUP BY clauses.
C. They can return multiple columns.
D. They can contain HAVING clauses.
E. Two or more values are always returned from the subquery.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)