Oracle Oracle Certifications 1Z0-082 Questions & Answers

• Question 11:

  Which three statements are true about Resumable Space Allocation in Oracle databases? (Choose three.)

  A. A user's session may be suspended and resumed multiple times.

  B. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

  C. All sessions must have the same timeout value when waiting for resumable space allocations.

  D. Resumable space allocation is only possible with locally managed tablespaces.

  E. A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.

  F. Resumable space allocation may be enabled for some sessions and not others.

  Correct Answer: AEF

• Question 12:

  Examine the description of the PRODUCT_INFORMATION table:

  

  Which query retrieves the number of products with a null list price?

  A. SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;

  B. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

  C. SELECT COUNT(DISTINCT list price) FROM product_information WHERE list_price IS NULL;

  D. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;

  Correct Answer: B

• Question 13:

  Which two statements are true about a self join? (Choose two.)

  A. It can be an inner join.

  B. It can be a left outer join.

  C. It must be an equijoin.

  D. The join key column must have an index.

  E. It must be a full outer join.

  Correct Answer: AB

• Question 14:

  Which two are benefits of external tables? (Choose two.)

  A. They support DELETES which transparently deletes records in the file system as if they were table rows.

  B. They can be queried, transformed, and joined with other tables without having to load the data first.

  C. They support UPDATES which transparently updates records in the file system as if they were table rows.

  D. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.

  E. They can be queried while the database is in the MOUNT state like dynamic performance views.

  Correct Answer: BD

• Question 15:

  You want to apply the principle of Least Privilege in all your live databases.

  One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.

  Which two are types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose two.)

  A. analysis of privileges that a user has on other schema's objects

  B. analysis of privileges that a user has on their own schema objects

  C. analysis of all privileges used by the sys user.

  D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

  E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

  Correct Answer: DE

• Question 16:

  Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

  A. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

  B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

  C. Delete statements can always be done on a table through a view.

  D. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

  E. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

  F. Insert statements can always be done on a table through a view.

  Correct Answer: BDE

• Question 17:

  Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)

  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 descending index is a type of function-based index.

  D. A DROP INDEX statement always prevents updates to the table during the drop operation.

  E. A UNIQUE and non-unique index can be created on the same table column.

  F. An INVINSIBLE INDEX is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

  Correct Answer: ACE

• Question 18:

  Which three actions are ways to apply the principle of least privilege? (Choose three.)

  A. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true

  B. setting the REMOTE_OS_AUTHENT parameter to true

  C. revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the SYSTEM user

  D. enabling Unified Auditing

  E. using Access Control Lists (ACLs)

  F. revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the public user

  Correct Answer: DEF

• Question 19:

  Examine the description of the PRODUCTS table:

  

  Which query is valid?

  A. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;

  B. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;

  C. SELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;

  D. SELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;

  Correct Answer: B

• Question 20:

  Which two Oracle database space management features require the use of locally managed tablespaces? (Choose two.)

  A. Automatic data file extension (AUTOEXTEND)

  B. Server-generated tablespace space alerts

  C. Online segment shrink

  D. Free space management with bitmaps

  E. Oracle Managed Files (OMF)

  Correct Answer: CD