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

（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）SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

（B）SELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

（C）SELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

（D）SELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

（E）SELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

（A）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));

（B）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

（C）WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101','A102');

（D）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

（E）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

（A）When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

（B）Creating an external table creates a dump file that can be used only by an external table in the same database.

（C）Creating an external table creates a directory object.

（D）When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

（E）Creating an external table creates a dump file that can be used by an external table in the same or a different database.

（A）SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)

（B）SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);

（C）SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;

（D）SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

（E）SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

（A）SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

（B）SYSDATE can be queried only from the DUAL table.

（C）CURRENT_DATE returns the current date and time as per the session time zone

（D）CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of functional seconds.

（E）SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

（F）CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

（A）The database guarantees read consistency at select level on user-created tablers.

（B）A user can be the owner of multiple schemas In the same database.

（C）A query can access only tables within the same schema.

（D）Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.

（E）When you execute an UPDATE statement, the database instance locks each updated row.

（A）A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

（B）An UNUSED column's space is remained automatically when the row containing that column is next queried.

（C）A column that is set to NNUSED still counts towards the limit of 1000 columns per table.

（D）An UNUSED column's space is remained automatically when the block containing that column is next queried.

（E）Partition key columns cannot be dropped.

（F）A DROP COLUMN command can be rolled back.

（A）The names of employees earning the maximum salary will appear first in descending order.

（B）The names of employees earning the maximum salary will appear first In ascending order.

（C）All remaining employee names will appear in descending order.

（D）All remaining employee names will appear in ascending order.

（E）The names of employees earning the maximum salary will appear first in an unspecified order.

（F）All remaining employee names will appear in an unspecified order.

（A）SELECT 1 FROM DUAL
UNION
SELECT 2 FROM DUAL
ORDER BY 1, 2;

（B）SELECT 3 FROM DUAL
UNION
SELECT 4 FROM DUAL
ORDER BY 3 ;

（C）SELECT 1, 2 FROM DUAL
UNION
SELECT 3, 4 FROM DUAL
ORDER BY 1, 2;

（D）SELECT 1, 2 FROM DUAL
UNION
SELECT 3, 4 FROM DUAL
ORDER BY 3, 4;

（A）A one-to-one relationship is always a self-referencing relationship

（B）A many-to-many relationship can be implemented only by using foreign keys

（C）A table name can be specified just once when selecting data from a table having a selfreferencing relationship

（D）A one-to-many relationship in one direction is a one-to-one relationship in the other direction

（E）A Relationship can be mandatory for both entities

（A）They must be placed on the right side of the comparison operator or condition.

（B）They can be used in the clause.

（C）They must be placed on the left side of the comparison operator or condition.

（D）They must return a row to prevent errors in the SQL statement.

（E）They can be used in the HAVING clause.

（F）A SQL statement may have multiple single row subquery blocks.