niusouti.com

多选题Which two statements are true about standard database auditing()ADDL statements can be audited.BStatements that refer to stand-alone procedure can be audited.COperations by the users logged on as SYSDBA cannot be audited.DOnly one audit record is ever 

题目
多选题
Which two statements are true about standard database auditing()
A

DDL statements can be audited.

B

Statements that refer to stand-alone procedure can be audited.

C

Operations by the users logged on as SYSDBA cannot be audited.

D

Only one audit record is ever created for a session per audited statement even though it is executedmore than once.


相似考题
更多“多选题Which two statements are true about standard database auditing()ADDL statements can be audited.BStatements that refer to stand-alone procedure can be audited.COperations by the users logged on as SYSDBA cannot be audited.DOnly one audit record is ever ”相关问题
  • 第1题:

    Which two statements are true about the WebLogic Server domains ? ()

    • A、 Application Programmers need to refer to domains in their Oracle Web`logic Server programming Interface
    • B、 domains can be used to separate development, test, and production application, administration and operational responsibility, and organizational or business division 
    • C、 one can share a configured resource or subsystem between domains
    • D、 the concept of multiple domains is supported 

    正确答案:B,D

  • 第2题:

    Which two statements about bigfile tablespaces are true? ()

    • A、The bigfile tablespace have only one data file.
    • B、The segment space management is automatic.
    • C、The extent management is dictionary managed.
    • D、The database can have only one bigfile tablespace.
    • E、The bigfile tablespace can be converted to a smallfile tablespace.

    正确答案:A,B

  • 第3题:

    Which two statements are true about a job chain? ()(Choose two.)

    • A、A job chain can contain a nested chain of jobs.
    • B、The jobs in a job chain cannot have more than one dependency.
    • C、A job of the CHAIN type can be run using event-based or time-based schedules.
    • D、The jobs in a job chain can be executed only by using the events generated by the Scheduler

    正确答案:A,C

  • 第4题:

    You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()

    • A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
    • B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
    • C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
    • D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
    • E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

    正确答案:A

  • 第5题:

    Which two statements are true about standard database auditing()

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案:A,B

  • 第6题:

    多选题
    Which two statements are true about a job chain?()
    A

    A job chain can contain a nested chain of jobs.

    B

    The jobs in a job chain cannot have more than one dependency.

    C

    A job of the CHAIN type can be run using event-based or time-based schedules.

    D

    The jobs in a job chain can be executed only by using the events generated by the Scheduler


    正确答案: D,B
    解析: 暂无解析

  • 第7题:

    多选题
    Which two statements are true about a job chain?()
    A

    A job chain can contain a nested chain of jobs

    B

    The jobs in a job chain cannot have more than one dependency

    C

    A job of the CHAIN type can be run using event-based or time-based schedules

    D

    The jobs in a job chain can be executed only by using the events generated by the Scheduler


    正确答案: A,D
    解析: 暂无解析

  • 第8题:

    多选题
    Which two statements are true about hierarchical architecture? ()(Choose two.)
    A

    You can assign a logical interface to multiple zones.

    B

    You cannot assign a logical interface to multiple zones.

    C

    You can assign a logical interface to multiple routing instances.

    D

    You cannot assign a logical interface to multiple routing instances.


    正确答案: B,C
    解析: 暂无解析

  • 第9题:

    多选题
    Which two statements are true about the RMAN validate database command?()
    A

    It checks the database for intrablock corruptions.

    B

    It can detect corrupt pfiles.

    C

    It can detect corrupt spfiles.

    D

    It checks the database for interblock corruptions.

    E

    It can detect corrupt block change tracking files.


    正确答案: E,C
    解析: 暂无解析

  • 第10题:

    多选题
    Which two statements are true about the roles in the Oracle database?()
    A

    A role can be granted to itself.

    B

    Roles are owned by the SYS user.

    C

    Roles can be granted to other roles.

    D

    A role cannot be assigned external authentication.

    E

    A role can contain both system and object privileges.


    正确答案: E,D
    解析: 暂无解析

  • 第11题:

    多选题
    Which two statements about subqueries are true? ()
    A

    A subquery should retrieve only one row.

    B

    A subquery can retrieve zero or more rows.

    C

    A subquery can be used only in SQL query statements.

    D

    Subqueries CANNOT be nested by more than two levels.

    E

    A subquery CANNOT be used in an SQL query statement that uses group functions.

    F

    When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.


    正确答案: C,D
    解析: 暂无解析

  • 第12题:

    多选题
    Which two statements about bigfile tablespaces are true? ()
    A

    The bigfile tablespace have only one data file.

    B

    The segment space management is automatic.

    C

    The extent management is dictionary managed.

    D

    The database can have only one bigfile tablespace.

    E

    The bigfile tablespace can be converted to a smallfile tablespace.


    正确答案: D,B
    解析: 暂无解析

  • 第13题:

    Which two statements about subqueries are true? ()

    • A、A subquery should retrieve only one row.
    • B、A subquery can retrieve zero or more rows.
    • C、A subquery can be used only in SQL query statements.
    • D、Subqueries CANNOT be nested by more than two levels.
    • E、A subquery CANNOT be used in an SQL query statement that uses group functions.
    • F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

    正确答案:B,F

  • 第14题:

    Which two statements are true about a job chain?()

    • A、A job chain can contain a nested chain of jobs.
    • B、The jobs in a job chain cannot have more than one dependency.
    • C、A job of the CHAIN type can be run using event-based or time-based schedules.
    • D、The jobs in a job chain can be executed only by using the events generated by the Scheduler

    正确答案:A,C

  • 第15题:

    Which two statements are true about simple views?()

    • A、Views can be created as read only.
    • B、Views are data segments like tables.
    • C、Views can be created on the basis of more than one table.
    • D、Data manipulation language (DML) operations cannot be performed on views.

    正确答案:A,C

  • 第16题:

    Which two statements are true about a job chain?()

    • A、 A job chain can contain a nested chain of jobs
    • B、 The jobs in a job chain cannot have more than one dependency
    • C、 A job of the CHAIN type can be run using event-based or time-based schedules
    • D、 The jobs in a job chain can be executed only by using the events generated by the Scheduler

    正确答案:A,C

  • 第17题:

    Which two statements are true about the roles in the Oracle database?()

    • A、A role can be granted to itself.
    • B、Roles are owned by the SYS user.
    • C、Roles can be granted to other roles.
    • D、A role cannot be assigned external authentication.
    • E、A role can contain both system and object privileges.

    正确答案:C,E

  • 第18题:

    多选题
    Which two statements are true about a job chain? ()(Choose two.)
    A

    A job chain can contain a nested chain of jobs.

    B

    The jobs in a job chain cannot have more than one dependency.

    C

    A job of the CHAIN type can be run using event-based or time-based schedules.

    D

    The jobs in a job chain can be executed only by using the events generated by the Scheduler


    正确答案: B,A
    解析: 暂无解析

  • 第19题:

    多选题
    By default, which two statements are true about export routing polices?()
    A

    Export polices can evaluate only active routes

    B

    Export polices can evaluate all routes

    C

    Export polices can be applied to the forwarding table

    D

    Export polices can be applied to interfaces


    正确答案: A,B
    解析: 暂无解析

  • 第20题:

    多选题
    By default, which two statements are true about export routing policies?()
    A

    Export policies can evaluate only active routes

    B

    Export policies can evaluate all routes

    C

    Export policies can be applied to the forwarding table

    D

    Export policies can be applied directly to interfaces


    正确答案: B,A
    解析: 暂无解析

  • 第21题:

    多选题
    Which two statements regarding the control file and Recover Manager are true? ()
    A

    The control file can grow in size.

    B

    The control file can store RMAN scripts.

    C

    CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.

    D

    The RMAN catalog can exist solely in the control file of the target database.


    正确答案: D,A
    解析: 暂无解析

  • 第22题:

    多选题
    Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)
    A

    The ADR base keeps all diagnostic information in binary format

    B

    SQL*Plus provides the ADRI script, which can be used to work with ADR

    C

    The ADR can be used for problem diagnosis only when the database is open

    D

    The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

    E

    The ADR can be used for problem diagnosis even when the database instance is down

    F

    The ADR base is shared across multiple instances


    正确答案: D,B
    解析: 暂无解析

  • 第23题:

    多选题
    Which two statements are true about simple views?()
    A

    Views can be created as read only.

    B

    Views are data segments like tables.

    C

    Views can be created on the basis of more than one table.

    D

    Data manipulation language (DML) operations cannot be performed on views.


    正确答案: D,B
    解析: 暂无解析