Oracle 19c OCP 1Z0-082认证考试题库（30-35）

30.Which three are types of segments in an Oracle Database? A.clustersB.sequences C.stored procedures D.viewsE.undoF.tables答案：AEF31.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*PlusD.It can be used only in SQL*PlusE.It displays values for variables used only in the WHERE clause of a query答案：BC32.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 lockedB.the number of days for which an account may be inactive before it is lockedC.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 reusedE.the maximum amount of cpu time allowed for a users sessions before their account is locked答案：BD33.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 statementC.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 clauseF.They must be placed on the right side of the comparison operator or condition答案：CDE34.You execute this command:During the export operation, you detach from the job by using crtl+c and then execute this commandExport> STOP JOB =immediateAre 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 terminatesD.It continues to run in the backaround E.It is paused and can be resumed答案： AE35.Which three statements are true about the Automatic Diagnostic Repository (ADR)? A.It is a file-based repository held outside any databaseB.The ADR base is specified in the DIAGNOSTIC DEST database paramete C.It is only used for Oracle Database diagnostic informationD.It is held inside an Oracle database schemaE.It can be used for problem diagnosis of a database when that database's instance is down答案： ABEC不对，数据库、Oracle自动存储管理（Oracle ASM）、侦听器、Oracle Clusterware和其他Oracle产品或组件将所有诊断数据存储在ADR中