Examine the commands executed to monitor database operations: $ conn sys oracle/oracle@prod as sysdba SQL VAR eid NUMBER SQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’); Which two statements are true?（）A、Database operations will be monitored only when they consume a significant amount of resource.B、Database operations for all sessions will be monitored.C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D、Only DML and DDL statements will be monitored for the session.E、All subsequent statements in the session will be treated as one database operation and will be monitored.
Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）
- A、Database operations will be monitored only when they consume a significant amount of resource.
- B、Database operations for all sessions will be monitored.
- C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
- D、Only DML and DDL statements will be monitored for the session.
- E、All subsequent statements in the session will be treated as one database operation and will be monitored.
相关考题：
You executed the following commands in a database session:What could have caused the recycle bin to clean up?() A. There is demand for space from the new table从B. The undo tablespace does not have sufficient free spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free space
Examine the following commands and their output:SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View 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.
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）A. The pending area is automatically submitted after the plan creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
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 set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?() A. The execution of the script fails because multiple channels cannot coexist.B. The script is executed and both the channels are used for the script execution.C. The new channel, CHI, is Ignored because a channel has been configured already.D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?() A. It collects statistics into the pending area in the data dictionaryB. It creates a virtual hidden column in the CUSTOMERS_OBE tableC. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENTD. It creates a histogram to hold skewed information about the data in the columns
View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?() A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.
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.
Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?() A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B. All DDL commands are logged in the alert log file.C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D. Only DDL commands that resulted in the creation of new segments are logged.E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）A.AB.BC.CD.DE.E
Which of the following commands should Karen, a technician, use to examine and restoreprotected system files?（）A、SFCB、RECOVERC、REPLACED、COPY
Which of the following commands displays the number of system calls per second that are being executed？（）A、 sarB、 pstatC、 iostatD、 filemon
What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ； A、 The entire backup will fail.It will not be usable for recovery.B、 The entire backup will failbut any datafile successfully backed up will be usable for recovery.C、 If this backup fails，subsequent backups will prioritize datafiles not backed up.D、 If this backup fails，an error will be raised and any other commands will not be executed. E、 If this backup fails，no error will be raised and any other commands will be executed.
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in it
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）AThe commands execute successfully.BCommand 6 produces an error because of circular role grant.CCommand 5 produces an error because a role cannot be granted to another role.DCommand 3 produces an error because the MGRROLE role already contains system privileges.EThe table created by HR remains and HR still has the CREATE TABLE system privilege.FThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）AThe shrink operation touches every block in the BOOKING tableBThe high-water mark (HWM) for the BOOKING table is shifted from its original positionCThe progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableDThe data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）AOnly the SET command must be within a RUN block.BAll commands should be executed at the RMAN prompt.CAll three commands must be within a single RUN block.DOnly the RESTORE and RECOVER commands must be within a single RUN block.
多选题Examine the commands executed to monitor database operations: $ conn sys oracle/oracle@prod as sysdba SQL VAR eid NUMBER SQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’); Which two statements are true?（）ADatabase operations will be monitored only when they consume a significant amount of resource.BDatabase operations for all sessions will be monitored.CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.DOnly DML and DDL statements will be monitored for the session.EAll subsequent statements in the session will be treated as one database operation and will be monitored.
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）AThe table is moved to the SYSAUX tablespace.BThe table is moved to the SYSTEM tablespace.CThe table is removed from the database permanently.DThe table is renamed and remains in the TBSFD tablespace.
单选题Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A The shrink operation touches every block in the BOOKING tableB The high-water mark （HWM） for the BOOKING table is shifted from its original positionC The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题Which of the following commands cannot be executed when the database open？（）ARECOVER DATABASEBRECOVER TABLESPACECRECOVER DATAFILEDALTER DATABASE RECOVER DATAFILE
单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert log file.BAll DDL commands are logged in the alert log file.CAll DDL commands are logged in a different log file that contains DDL statements and their execution dates.DOnly DDL commands that resulted in the creation of new segments are logged.EAll DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）ANone of the data definition language (DDL) statements are logged in the trace file.BOnly DDL commands that resulted in errors are logged in the alert log file.CA new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.DOnly DDL commands that resulted in the creation of new database files are logged.
单选题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（）AAll sessions of the HR user onlyBAll sessions of the HR user and the SYS userCThe session of the HR user that executed the commandsDAll the sessions for which the database users have access privilege to the PERSONS table
单选题What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；A The entire backup will fail.It will not be usable for recovery.B The entire backup will failbut any datafile successfully backed up will be usable for recovery.C If this backup fails，subsequent backups will prioritize datafiles not backed up.D If this backup fails，an error will be raised and any other commands will not be executed. E If this backup fails，no error will be raised and any other commands will be executed.