单项选择题
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
