单选题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()AThe table created by SKD is not accessible and SKD cannot create new tables.BThe tables created by SKD and HR remain, but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

单选题
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.


参考解析

解析: 暂无解析

相关考题:

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

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.

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

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

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

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.

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

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

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 timesC、 four timesD、 six times

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.

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.

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.

多选题An administrator determines that performance has degraded for a WebSphere Commerce database.  Which of the following steps should be performed to correct this problem?()ACleanup obsolete dataBClear the WebSphere Commerce cacheCEnable WebSphere Commerce AcceleratorDReindex the database tablesERun Performance Monitor to monitor SQL statements

单选题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?()AStart the instance and open the database, instance recovery automatically recovers control files BCreate a file based on the contents of the trace file and save it to the control file locations and start the database CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

单选题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.()A2,1,4,3,5,6B1,4,3,2,6,5C1,4,2,6,3,5D3,2,1,4,5,6

单选题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. ()A2,1,4,3,5,6B1,4,3,2,6,5C1,4,2,6,3,5D3,2,1,4,5,6

单选题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()AThe table created by SKD isnot accessibleand SKD cannot create new tables.BThe tables created by SKD and HR remain, but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

单选题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()AThe database instance is running with manual PGA management.BThe database instance is running with manual shared memory management.CThe database instance has the MEMORY_TARGET value set to a nonzero value.DAll sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed

单选题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()A7,1,5,2,3,6,4B1,2,3,7,5,6,4C7,1,4,5,2,3,6D1,7,5,4,2,3,6

单选题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?()AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

单选题Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()AShut down the database.BSet the appropriate parameters in init.ora file.CStart the database in NOMOUNT state.DIssue the ALTER DATABASE ARCHIVELOG command.EOpen the database.FTake a full closed backup.

单选题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, 5B 4, 3, 1, 2, 5C 2, 4, 3, 5, 1D 4, 2, 5, 3, 1

单选题Which statement is true about Oracle Net Listener?()AIt acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.BA single listener can service only one database instance and multiple remote client connections.CService registration with the listener is performed by the process monitor (PMON) process of each database instance.DThe listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

多选题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?()AThe 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.BAll the user-defined tablespaces must be in read-only mode on the source database.CThe export dump file must be created before starting the import on the target database.DThe source and target database must be running on the same platform with the same endianness.EThe path of data files on the target database must be the same as that on the source database.FThe impdp operation must be performed by the same user that performed the expdp operation.

单选题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.A1,2,3,4B3,2,4,1C4,2,1,3D4,3,2,1

单选题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 timesC four timesD six times

单选题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, 5B 4, 3, 1, 2, 5C 2, 4, 3, 5, 1D 4, 2, 5, 3, 1