View the Exhibit and examine the privileges granted to the SL_REP user.
The EMP table is owned by the SCOTT 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.
您可能感兴趣的试卷
你可能感兴趣的试题
Observe the information in the columns:
1: The SGA a. Text and parsed forms of all SQL statements
2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved
3: User-session data c. Security and resource usage information
4:The stack space d. Local variables for the process
Which option has the correct match between the memory areas and their contents()
A.1-c,2-b,3-d,4-a
B.1-c,2-b,3-c,4-a
C.1-a,2-b,3-c,4-d
D.1-a,2-b,3-d,4-c
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
Note the following points describing various utilities in Oracle Database 11g:
1:It enables the high-speed transfer of data from one database to another.
2:It provides a complete solution for the backup, restoration, and recovery needs of the entire database.
3:It enables the loading of data from an external file into an Oracle database.
4:It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup()
A.1
B.2
C.3
D.4
E.1,2,and 4
F.1,2,3,and 4
The database instance is currently using SPFILE. View the Exhibit and examine the error that youreceived while running the DB Structure Integrity check.
Given below are the steps to recover from the error in random order:
1: Shut down the instance, if not already done.
2: Copy one of the remaining control files to a new location.
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4: Start up the database instance to the NOMOUNT stage.
5: Recover the database to the point of failure of the control file.
6: Open the database.
Identify the correct sequence of steps()
A.1,2,4,3,5,6
B.2,4,3,5,6;1 not required
C.4,5,6,2,3;1 not required
D.5,2,3,4;1 and 6 not required
A.You can perform online whole database backups.
B.You can performofflinewhole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.
View the Exhibit and examine the attributes of an undo tablespace.
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error:
ORA-01555: snapshot too old
What could be the reason for this error()
A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace
最新试题
Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()
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()
Which statements are correct about temporary tables()
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
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()
Which statements are true regarding listeners()
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
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()