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

30.Which three are types of segments in an Oracle Database? 

A.clusters

B.sequences 

C.stored procedures 

D.views

E.undo

F.tables

答案：AEF

31.Which two statements are true about the SET VERIPY ON command? 

A.It displays values for variables prefixed with &&

B.It displays values for variables created by the DEFINE command 

C.It can be used in SQL Developer and SQL*Plus

D.It can be used only in SQL*Plus

E.It displays values for variables used only in the WHERE clause of a query

答案：BC

32.Which are two of the account management capabilities that can be configured using Oracle profiles?

A.the number of days for which an account may be logged in to one or more sessions before it is locked

B.the number of days for which an account may be inactive before it is locked

C.the maximum number of sessions permitted for a user before the password must be changed D.the ability to prevent a password from ever being reused

E.the maximum amount of cpu time allowed for a users sessions before their account is locked

答案：BD

33.Which three statements are true regarding single row subqueries?

A.They must be placed on the left side of the comparison operator or condition 

B.They must return a row to prevent errors in the SQL statement

C.They can be used in the HAVING clause.

D.A SQL statement may have multiple single row subquery blocks 

E.They can be used in the WHERE clause

F.They must be placed on the right side of the comparison operator or condition

答案：CDE

34.You execute this command:

During the export operation, you detach from the job by using crtl+c and then execute this command

Export> STOP JOB =immediate

Are you sure you wish to stop the job ( [yes] /no): yes 

Which two statements are true about the job?

A.You can reattach to it and monitor it 

B.You can reattach to it but not monitor it 

C.It terminates

D.It continues to run in the backaround 

E.It is paused and can be resumed

答案： AE

35.Which three statements are true about the Automatic Diagnostic Repository (ADR)? 

A.It is a file-based repository held outside any database

B.The ADR base is specified in the DIAGNOSTIC DEST database paramete 

C.It is only used for Oracle Database diagnostic information

D.It is held inside an Oracle database schema

E.It can be used for problem diagnosis of a database when that database's instance is down

答案： ABE

C不對，資料庫、Oracle自動儲存管理（Oracle ASM）、偵聽器、Oracle Clusterware和其他Oracle產品或元件將所有診斷資料儲存在ADR中