1z0-071 無料問題集「Oracle Database SQL」

（A）The foreign key constraint will be enabled and IMMEDIATE.

（B）The primary key constraint will be enabled and IMMEDIATE.

（C）The primary key constraint will be enabled and DEFERRED.

（D）The foreign key constraint will be enabled and DEFERRED.

（E）The foreign key constraint will be disabled.

（A）A SAVEPOINT does not issue a COMMIT

（B）Rolling back to a SAVEPOINT can undo a TRUNCATE statement.

（C）Rolling back to a SAVEPOINT can undo a DELETE statement

（D）Only one SAVEPOINT may be issued in a transaction.

（E）Rolling back to a SAVEPOINT can undo a CREATE INDEX statement.

（A）It will return rows from both SELECT statements after eliminating duplicate rows.

（B）It will return rows from both SELECT statements including duplicate rows.

（C）It will return rows that are not common to both SELECT statements.

（D）It will return rows common to both SELECT statements.

（A）Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.

（B）Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

（C）Display the total number of products supplied by supplier 102 which have a product status of obsolete.

（D）Display the minimum PROD_LIST_PRICE for each product status.

（E）Display suppliers whose PROD_LIST_PRICE is less than 1000.

（A）The data type of each column retuned by the second query must exactly match the data type of the corresponding column returned by the first query

（B）The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query

（C）The number, but not names, of columns must be identical for all SELECT statements in the query

（D）The names and number of columns must be identical for all SELECT statements in the query.

（E）The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query

（A）The argument can be a column name, variable, literal or an expression.

（B）They can accept only one argument.

（C）They can be nested to any level.

（D）The date type returned can be different from the data type of the argument.

（E）They return a single result row per table.

（F）They can be used only in the where clause of a select statement.

（A）SELECT"
FROM employees e1
WHERE salary >!
SELECT AVG (salary)
FROM employees e2
WHERE e1. Department _id = e2, department_ id

（B）SELECT "
FROM employees
WHERE salary > ANY
SELECT AVG (salary)
EROM employees
GROUP BY department_ id);

（C）SELECT
FROM employees
WHERE salary > AVG (salary) OVER (PARTITION BY department _ id);

（D）SELECT"
FROM employees
WHERE salary >
( SELECT AVG
(salary) FROM
employees

（E）SELECT.
FROM
SELECT e.", AVG (salary) OVER (PARTITION BY department id) avg_ sal
FROM employees e
WHERE salary > avg_ sal;

（A）Store the query in a script and pass the substitution value to the script when executing it.

（B）Execute the SET VERIFY ON command before executing the query.

（C）Use the DEFINE command before executing the query

（D）Replace 's1' with &1'in the query:

（E）Execute the SET VERIFY OFF command before executing the query.

（F）Use the UNDEFINE command before executing the query.

（A）GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;

（B）GRANT CREATE SEQUENCE TO manager, emp;

（C）GRANT CREATE TABLE, SELECT ON hr. employees TO manager;

（D）GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION:

（E）GRANT CREATE TABLE, emp TO manager;

（A）SELECT * FROM customers WHERE customer id = '0001';

（B）SELECT * FROM customers WHERE insert date ='01-JAN-19'

（C）SELECT * FROM customers WHERE customer_ id = 0001 ;

（D）SELECT * FROM customers WHERE TO_ CHAR (customer_ id) ='0001';

（E）SELECT * FROM customers WHERE insert_ date = DATE '2019-01-01';

（A）& can prefix a substitution variable name only in queries. DML

（B）An & prefix to an undefined substitution variable, which is referenced twice in the same query, will prompt for a value twice .

（C）The && prefix will not prompt for a value even if the substitution variable is not previously defined in the session.

（D）Both & and && can prefix a substitution variable name in queries and DML statements.

（E）An && prefix to an undefined substitution variable, which is referenced multiple times in multiple queries, will prompt for a value once per query.

（A）It executes successfully and the row is inserted with a null PLBLISHER_ID.

（B）It executes successfully only NULL PUBLISHER_ID column name is added to the columns list in the INSERT statement.

（C）It executes successfully only if NULL is explicitly specified in the INSERT statement.

（D）It executes successfully onlyif NULL PUBLISHER ID column name is added to the columns list and NULL is explicitly specified In the INSERT statement.