You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（

题目

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

  • A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
  • B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
  • C、Data is never redacted for the EMP_V.SAL column.
  • D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
  • E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
相似考题

1.A piece of ( ) music will make you happy.A、pleasedB、merryC、gladD、fond

2.You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.

3.View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()A. 4B. 8C. 7D. 0

4.— ______— Oh, it's a piece of cake、I love writing.A、Do you like the writing classB、How do you feel about your writing classC、have another piece of cakeD、Could you help me

更多“You execute the following piece ”相关问题

  • 第1题：

    To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）

    A. A template needs to be associated with the task.

    B.A workload needs to be associated with the task.

    C. The partial or complete workload scope needs to be associated with the task.

    D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.


    参考答案：B

  • 第2题：

    You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）

    A. one-way

    B. two-way

    C. three-way

    D. No handshakes required during authentication

    E. None of the above


    参考答案：C

  • 第3题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第4题：

    You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

    • A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
    • B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
    • C、 The command will execute successfully and resumable space will be allocated at the session level.
    • D、 The command will execute successfully and resumable space will be allocated at the instance level.

    正确答案:B

  • 第5题：

    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

    • A、 OPEN
    • B、 MOUNT
    • C、 NORMAL
    • D、 NOMOUNT

    正确答案:B

  • 第6题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第7题：

    单选题
    Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）
    A

    Start the server with the – innodb_recover_options option set to FORCE

    B

    Start the server with the – innodb_force_recovery option set to a non-zero value

    C

    Start the server as usual, and then execute the REPAIR TABLE command

    D

    Start the server as usual, and then execute the CHECK TABLE command


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）
    A

    The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.

    B

     The command will not execute successfully because resumable space allocation is enabled at the session level.

    C

     The command will execute successfully and resumable space will be allocated at the session level.

    D

     The command will execute successfully and resumable space will be allocated at the instance level.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available， what would the status of this backup piece be in the RMAN repository？（）
    A

    EXPIRED

    B

    AVAILABLE

    C

    UNAVAILABLE

    D

    ACCESSIBLE


    正确答案： B
    解析： 暂无解析

  • 第10题：

    多选题
    The EMP table exists in your schema. You want to execute the following query：   SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE）   WHERE ename = ’ALLEN’；   What are the minimum requirements for the statement to execute successfully？（）
    A

    ARCHIVELOG mode must be enabled

    B

    Row Movement must be enabled for the table

    C

    FLASHBACK must be set to ON for the database

    D

    The UNDO_MANAGEMENT parameter must be set to AUTO

    E

    The UNDO_RETENTION parameter must be set appropriately


    正确答案： E,B
    解析： 暂无解析

  • 第11题：

    单选题
    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）
    A

    Data files that belong to only the root container

    B

    Data files that belong to the root container and all the pluggable databases (PDBs)

    C

    Data files that belong to only the root container and PDB$SEED

    D

    Data files that belong to the root container and all the PDBs excluding PDB$SEED


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第13题：

    is NOT a concept of White Box Testing.

    A．You should execute all logical decisions on their tree and false sides.

    B．You should execute all independent paths within a module at least once.

    C．You should execute all loops at their boundary conditions.

    D．You should execute all interfaces at their boundary conditions.


    正确答案：D

  • 第14题：

    This piece of （） is long enough for you to make a shirt.

    Acloth

    Bclothes

    Cclothing

    Dsuit


    A
    略

  • 第15题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第16题：

    You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）

    • A、 Create another password file and then re-execute the GRANT statement.
    • B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
    • C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
    • D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

    正确答案:B

  • 第17题：

    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）

    • A、 The statement will not execute successfully.
    • B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days
    • C、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.
    • D、 Backups will be deleted from the media after 400 days.

    正确答案:A

  • 第18题：

    单选题
    You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }
    A

     NOMOUNT

    B

     MOUNT

    C

     OPEN

    D

     RESTRICTED


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）
    A

     The statement will not execute successfully.

    B

     The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days

    C

     The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.

    D

     Backups will be deleted from the media after 400 days.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）
    A

     OPEN

    B

     MOUNT

    C

     NORMAL

    D

     NOMOUNT


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）
    A

    Only 1

    B

    Only 2

    C

    Only 3

    D

    3 and 1

    E

    1 and 2


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（　）;You need to execute a method named Do Work（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）
    A

    while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

    B

    while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

    C

    while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

    D

    while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）
    A

    Re-install the audit plugin

    B

    Execute the command FLUSH LOGS

    C

    Execute the command SET GLOBAL audit_log_fiush= ON

    D

    Move or rename the existing audit.log file


    正确答案： A
    解析： 暂无解析

  • 第24题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


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

相关内容