单选题Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user. 

题目
单选题
Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
A

The table created by SKD isnot accessibleand SKD cannot create new tables.

B

The tables created by SKD and HR remain， but both cannot create new tables.

C

The table created by HR remains and HR still has the CREATE TABLE system privilege.

D

The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

相似考题

1.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

2.The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:（）A.2，4，5B.2，1，4，3，5C.1，2，3，4，5D.1，2，4，5

3.An administrator determines that performance has degraded for a WebSphere Commerce database.  Which of the following steps should be performed to correct this problem？（）A、Cleanup obsolete dataB、Clear the WebSphere Commerce cacheC、Enable WebSphere Commerce AcceleratorD、Reindex the database tablesE、Run Performance Monitor to monitor SQL statements

4.Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

更多“Examine the following steps performed on a database instance”相关问题

  • 第1题：

    Which of the following step libraries is included in the license for IPCC Express Standard? （）

    • A、ICM steps  
    • B、e-mail steps  
    • C、media steps 
    • D、database steps

    正确答案:C

  • 第2题：

    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第3题：

    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

    • A、 The backup will not be performed at all.
    • B、 three times
    • C、 four times
    • D、 six times

    正确答案:C

  • 第4题：

    Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）

    • A、Shut down the database.
    • B、Set the appropriate parameters in init.ora file.
    • C、Start the database in NOMOUNT state.
    • D、Issue the ALTER DATABASE ARCHIVELOG command.
    • E、Open the database.
    • F、Take a full closed backup.

    正确答案:B

  • 第5题：

    多选题
    An administrator determines that performance has degraded for a WebSphere Commerce database.  Which of the following steps should be performed to correct this problem？（）
    A

    Cleanup obsolete data

    B

    Clear the WebSphere Commerce cache

    C

    Enable WebSphere Commerce Accelerator

    D

    Reindex the database tables

    E

    Run Performance Monitor to monitor SQL statements


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

  • 第6题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


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

  • 第7题：

    单选题
    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
    A

    The database instance is running with manual PGA management.

    B

    The database instance is running with manual shared memory management.

    C

    The database instance has the MEMORY_TARGET value set to a nonzero value.

    D

    All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed


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

  • 第8题：

    单选题
    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）
    A

    When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

    B

    When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

    C

    When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

    D

    When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.


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

  • 第9题：

    单选题
    You want to configure the Flashback Database feature and retain flashback logs for three days.  Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this：   1. Set the retention target：  SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320；  2. Enable Flashback Database：  SQL> ALTER DATABASE FLASHBACK ON；  3. Mount the database：  SQL> STARTUP MOUNT EXCLUSIVE  4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE  5. Open the database：  SQL> ALTER DATABASE OPEN；   Choose the correct sequence.（）
    A

     4， 1， 3， 2， 5

    B

     4， 3， 1， 2， 5

    C

     2， 4， 3， 5， 1

    D

     4， 2， 5， 3， 1


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

  • 第10题：

    多选题
    Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）
    A

    The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

    B

    All the user-defined tablespaces must be in read-only mode on the source database.

    C

    The export dump file must be created before starting the import on the target database.

    D

    The source and target database must be running on the same platform with the same endianness.

    E

    The path of data files on the target database must be the same as that on the source database.

    F

    The impdp operation must be performed by the same user that performed the expdp operation.


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

  • 第11题：

    单选题
    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
    A

    The table created by SKD is not accessible and SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第12题：

    单选题
    You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this: Choose the correct sequence.（）
    A

    4, 1, 3, 2, 5

    B

    4, 3, 1, 2, 5

    C

    2, 4, 3, 5, 1

    D

    4, 2, 5, 3, 1


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

  • 第13题：

    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

    • A、The table created by SKD is not accessible and SKD cannot create new tables.
    • B、The tables created by SKD and HR remain， but both cannot create new tables.
    • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:C

  • 第14题：

    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第15题：

    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

    • A、 The time when the last flashback operation in your database was performed.
    • B、 The time when the first flashback operation in your database was performed.
    • C、 A list of flashback operations performed in your database using SCN and time.
    • D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

    正确答案:D

  • 第16题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?（）  

    • A、A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. 
    • B、A full database backup should be performed once daily 
    • C、A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours 
    • D、Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.

    正确答案:C

  • 第17题：

    单选题
    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）
    A

    Start the instance and open the database, instance recovery automatically recovers control files 

    B

    Create a file based on the contents of the trace file and save it to the control file locations and start the database 

    C

    Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 

    D

    Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 

    E

    Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.


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

  • 第18题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


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

  • 第19题：

    单选题
    You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database：  1：SGA is allocated.  2：Control file is read.  3：Redo log files are read.  4：Instance recovery is started.  5：Background processes are started.  6：Data files are checked for consistency.  7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）
    A

    7，1，5，2，3，6，4

    B

    1，2，3，7，5，6，4

    C

    7，1，4，5，2，3，6

    D

    1，7，5，4，2，3，6


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

  • 第20题：

    单选题
    Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）
    A

    Shut down the database.

    B

    Set the appropriate parameters in init.ora file.

    C

    Start the database in NOMOUNT state.

    D

    Issue the ALTER DATABASE ARCHIVELOG command.

    E

    Open the database.

    F

    Take a full closed backup.


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

  • 第21题：

    单选题
    Which statement is true about Oracle Net Listener?（）
    A

    It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

    B

    A single listener can service only one database instance and multiple remote client connections.

    C

    Service registration with the listener is performed by the process monitor (PMON) process of each database instance.

    D

    The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.


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

  • 第22题：

    单选题
    The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（）  1. Shot down and start up the former primary instance without mounting the instance.  2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL  STANDBY command.  3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command.  4. End read or update activity on the former primary and standby database.
    A

    1，2，3，4

    B

    3，2，4，1

    C

    4，2，1，3

    D

    4，3，2，1


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

  • 第23题：

    单选题
    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）
    A

     The backup will not be performed at all.

    B

     three times

    C

     four times

    D

     six times


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

相关内容