View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command：
SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION；
Which statement is true about the user SKD afterhe/she is granted this role（）
A.The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.
B.The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C.The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.
D.The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them
您可能感兴趣的试卷
你可能感兴趣的试题
You executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5ignorecase=N
Which statement describes the purpose of the above password file（）
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem groups
You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened：
1. SGA is allocated.
2. Control file is read.
3. Redo log files are opened.4. Instance recovery is started.
5. Background processes are started.
6. Data file headers 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， 5， 7， 2， 3， 6； step 4 is not required
C.7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from =>> http：//www.amaderforum.com
D.1， 2， 3， 5， 6， 4； step 7 is not required
Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What effect would this command have onthe database（）
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order：
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task（）
A.4， 1， 3， 2， 5
B.1， 3， 4， 5， 2
C.1， 3， 2， 5； 4 not required
D.4， 1， 5， 2； 3 not required
E.1， 3， 4， 5； 2 not required
A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces.
What happens to the new DML operations in this scenario（）
A.The DML commands will fail.
B.The undo data generated by the DML is stored in one of the two other undo tablespaces.
C.The undo data generated by the DML will overwrite the extents that contain committed undo data.
D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）
A.CLOB
B.BLOB
C.BFILE
D.LONG RAW
Note the following functionalities of various background processes：
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process（）
A.Archiver Process （ARCn）： 1， 2， 5
B.System Monitor Process （SMON）： 1， 4， 5
C.Process Monitor Process （PMON）： 4， 5， 6
D.Database Writer Process （DBWn）： 1， 3， 4
You are using Enterprise Manager to schedule backups for your database.
Which type of script would begenerated by the backup scheduler（）
A.XML script
B.PL/SQL script
C.Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
D.Recovery Manager （RMAN） script
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting（）
A.Optimizer statistics are collected automatically.
B.Only timed operating system （OS） statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
最新试题
Which statement is true about loading data using the conventional path of SQL*Loader（）
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；Which statements describe the effect of the command（）
Examine the command that is used to create a table：SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users；Which two statements are true about the effect of the above command（）
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（）
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）
Examine the following statement that is used to modify the primary key constraint on the SALES table：SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；Which three statements aretrue regarding the above command（）
You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted（）
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）