View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；
Which statement describes the outcome of the command（）
A.The command executes successfully.
B.The command produces an error because the EMP table is owned by SCOTT.
C.The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
D.The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table
您可能感兴趣的试卷
你可能感兴趣的试题
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can see theeffect of the UPDATE and DELETE commands（）
A.All sessions of the HR user only
B.All sessions of the HR user and the SYS user
C.The session of the HR user that executed the commands
D.All the sessions for which the database users have access privilege to the PERSONS table
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（）
A.Flashback log files
B.Backups that have become obsolete
C.User managed backups of the data files and control files
D.Archived redo log files that have multiple copies in a different archive location and not backed up
In a new installation of Oracle Database 11g， you perform these activities：
1. Organize software and data on different subdirectories to avoid poor performance.
2. Use consistent naming conventions for database files.
3. Separate administrative information pertaining to the database in different directories.
Which optioncorresponds to the type of activities you performed（）
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification.
Whichschema object enables the user to access the information from the remote database（）
A.Cluster
B.Database link
C.Mapping table
D.Materialized view
The database instance has the following parameter setting：
OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.
What would you achieve by the above process（）
A.The database user OPS$SKD will be able to administer the database.
B.The authentication detail for the database user OPS$SKD is recorded in the password file.
C.The local operating system user SKD will be able to access the database instance without specifying theusername and password.
D.The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
A.The DML operations re-create the Bitmap index blocks.
B.The Bitmap index is rebuilt automatically after a DML operation.
C.The smallest amount of a bitmap that can be locked is a bitmap segment.
D.Additional time is taken to remove NULL values from the Bitmap index after a DML operation.
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（）
A.An Automatic Workload Repository snapshot has been taken recently.
B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but notthe threshold alerts related to instance metrics
A.It can span multiple databases.
B.It can consist of multiple data files.
C.It can contain blocks of different sizes.
D.It can contain segments of different sizes.
E.It can contain a part of a nonpartitioned segment
A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.
Which two statements are true in this scenario（）
A.You must shut down the database instance to perform the backups.
B.You must configure the Flash Recovery Area （FRA） for the database.
C.You can perform complete database backups without closing the database.
D.All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
最新试题
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95Which background process is responsible for issuing alerts when the threshold is crossed（）
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（）
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（）
Identify the situations in which you use the alert log file in your database to check the detail.（）
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error（）
Which statements are true regarding the Oracle Data Pump export and import operations（）
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（）
In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
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（）
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）