Oracle 19c OCP 1Z0-082認證考試題庫（7-12）

7.Which three statements are true?

A.The second ROLLBACK command restores the row that was inserted 

B.The first ROLLBACK command leaves the inserted row locked

C.The second ROLLBACK command restores the 100 rows that were in the table originally 

D.The second ROLLBACK command rolls back the ROLLBACK TO SAVEPOINT a command E.The first ROLLBACK command leaves the table's 100 original rows locked

F.The first ROLLBACK command restores the 100 rows that were in the table originally

答案：AEF

8.Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

A.the first NUMBER or VARCHAR2 column in the last select of the compound query B.the first NUMBER column in the first select of the compound query

C.the first vARCHAR2 column in the first select of the compound query 

D.the first column in the first select of the compound query

E.the first column in the last selects of the compound query

答案：D

9.Examine the description of the MEMBERs table:

You want to display all cities that contain the string AN. The cities must be returned in ascending order with the last names further sorted in descending order.

Which two clauses must you add to the query? 

A.ORDER BY 1, LAST_NAME DESC

B.ORDER BY1, 2

C.WHERE city IN (‘%AN%’) 

D.WHERE city= ‘%AN%’ 

E.WHERE city LIKE ‘%AN%’

F.ORDER BY last name DESC, city ASC

答案：AE

10.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 that can be done using the DBMS_PRIVILEGE_CAPTURE package?

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 privileges granted indirectly to a role that are then used by a user who has been granted that role

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

E.analysis of all privileges used by the sys user

答案：AC

間接賦予一個role是把一個role賦予另外一個role

參見：

11.Which two statements are true about undo segments and the use of undo by transactions in an Oracle

database instance

A.A single transaction may use multiple undo segments simultaneously. 

B.Undo segments can be stored in the SYSAUX tablespace

C.Undo segments can extend when a transaction fills the last extent of the undo segment

D.Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

E.Undo segments can be stored in the SYSTEM tablespace

答案：DE

12.In the PROMOTIONs table, the PROMO BEGIN DATE column is of data type DATE and the default date format is DD-MON-RR

Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?

A.PROMO_BEGIN_DATE- SYSDATE will return a number 

B.TO_DATE(PROMO_BEGIN_DATE * 5) will return a date

C.TO_NUMBER(PROMO_BEGIN_DATE - 5) will return a number 

D.PROMO_BEGIN_DATE- SYSDATE will return an error 

E.PROMO_BEGIN_DATE- 5 will return a date

答案：AE