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

（A）It consists of a single row and single column of VARCHAR2 data type.

（B）It can be accessed only by the SYS user.

（C）It can display multiple rows and columns.

（D）It can be used to display only constants or pseudo columns.

（E）It can display multiple rows but only a single column.

（F）It can be accessed by any user who has the SELECT privilege in any schema

（A）DELETE

（B）ALTER

（C）INDEX

（D）SELECT

（E）INSERT

（F）REFERENCES

（G）UPDATE

（A）The subquery is executed for every row in the EMPLOYEES table.

（B）The subquery is not a correlated subquery.

（C）The DELETE statement executes successfully even if the subquery selects multiple rows.

（D）The subquery is executed before the DELETE statement is executed.

（E）All existing rows in the EMPLOYEE table are deleted.

（A）The HR. EMPLOYEES table may be moved to the recycle bin.

（B）Views referencing HR, EMPLOYEES are dropped.

（C）Sequences used to populate columns in the HR. EMPLOYEES table are dropped.

（D）ALL constraints defined on HR, EMPLOYEES are dropped.

（E）Synonyms for HR EMPLOYEES are dropped.

（F）All indexes defined on HR, EMPLOYEES are dropped.

（A）WITH GRANT OPTION can be used when granting an object privilege to both users and roles

（B）Adding a foreign key constraint pointing to a table in another schema requires the REFERENCEs object privilege

（C）Adding a primary key constraint to an existing table in another schema requires a system privilege

（D）Revoking a system privilege that was granted with the WITH ADMIN OPTION has a cascading effect.

（E）WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

（F）Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect

（A）Rename a table

（B）Drop pseudo columns from a table.

（C）Enable or disable constraints on a table.

（D）Restrict all DML statements on a table.

（E）Lock a set of rows in a table CE Rename a table.

（F）Drop all columns simultaneously from a table.

（A）COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

（B）COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

（C）COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column

（D）A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

（E）It can only be used for NUMBER data types.

（A）Create roles.

（B）Execute a procedure or function in another schema.

（C）Create FOREIGN KEY constraints that reference tables in other schemas.

（D）Delete rows from tables in any schema except sys.

（E）Set default and temporary tablespaces for a user.

（A）SELECT MAX (salary)
FROM employees
GROUP BY department_id;

（B）SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

（C）SELECT MAX (salary)
FROM employees;

（D）SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

（E）SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

（A）When you terminate your session, the row will be deleted.

（B）To drop the table in this session, you must first truncate it.

（C）You can add a column to the table in this session.

（D）Other sessions can view the committed row.

（E）You can add a foreign key to the table.

（A）An index can be created as part of a CREATE TABLE statement.

（B）If a query filters on an indexed column then it will always be used during execution of the query

（C）A UNIQUE and non-unique index can be created on the same table column

（D）An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

（E）A descending index is a type of function-based index

（F）A DROP INDEX statement always prevents updates to the table during the drop operation

（A）The DEPARTMENT_ID column is set to null for all tows in the table

（B）The DEPARTMENT_ID column can be recovered from the recycle bin

（C）A query can display data from the DEPARTMENT_ID column.

（D）The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.

（E）No updates can be made to the data in the DEPARTMENT_ID column.

（F）A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.

（A）It processes NULLS in the selected columns.

（B）It ignores NULLS.

（C）INTERSECT is of lower precedence than UNION or UNION ALL.

（D）Multiple INTERSECT operators are not possible in the same SQL statement.