-
Why would you execute the report obsolete command？（）
A . To list all backups that were no longer available for restore operations
B . To list all backups that had aged beyond the RMAN retention criteria
C . To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
D . To list all datafiles that are no longer part of the database and thus do not need to be backed up
E . To list all archived redo logs that are no longer needed for any database recovery
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
A . Because row IDs may change during the flashback operation
B . Because the object number changes after the flashback operation
C . Because the rows are retrieved from the recycle bin during the flashback operation
D . Because the table is moved forward and back to a temporary during the flashback opertio
-
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
A . ’SQL ALTER DATABASE OPEN’；
B . SQL ALTER DATABASE ’OPEN’；
C . OPEN DATABASE；
D . DATABASE OPEN
-
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)
A . It produces less accurate results of the comparison analysis.
B . It automatically calls the SQL Tuning Advisor for recommendations.
C . It shortens the time of execution and reduces the impact on system resources.
D . Only the changes in the execution plan, and not performance regression, are detected.
-
You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）
A . The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
B . The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
C . The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
D . The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
-
Your application uses two threads， named threadOne and threadTwo. You need to modify the code to prevent the execution of threadOne until threadTwo completes execution. What should you do？（）
A . Configure threadOne to run at a lower priority.
B . Configure threadTwo to run at a higher priority.
C . Use a WaitCallback delegate to synchronize the threads.
D . Call the Sleep method of threadOne.
E . Call the SpinLock method of threadOne.
-
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： $ rman target / What would be the effect of this command？（）
A . RMAN would use the current operating system location to place the backup.
B . RMAN would use the control file of the target database to maintain the backup.
C . RMAN would use the recovery catalog of the target database to maintain the backup.
D . RMAN would use the control file of the target database to maintain the backup metadata.
E . RMAN would use the recovery catalog of the target database to maintain the backup metadata.
-
When the rc.cluster script is executed， cluster processes are started in what orde？（）
A . topsvcs，clstrmgr，clsmuxpd，grpsvcs，emsvcs，clinfo
B . topsvcs，grpsvcs，emsvcs，clstrmgr，clsmupxpd，clinfo
C . clstrmgr，clsmuxpd，clinfo，topsvcs，grpsvcs，emsvcs
D . clstrmgr，topsvcs，clxmuxpd，clinfo，grpsvcs，emsvc
-
Your Oracle Database 10g is online when you execute the following statement： SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF； What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
A . The database does not record flashback logs for MY_TABLESPACE
B . The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C . All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D . None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
-
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
A . back up the control file to trace
B . bring database to the MOUNT state
C . open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D . set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
-
After executing the "show host" command, which of the information below would you see?（）
A . The IP addresses of workstations allowed gain access to the router via an access list
B . Permanent name-to-address mappings created using the ip host command.
C . Temporary and permanent DNS entries.
D . The names of the routers created using the hostname command.
E . The length of time of users logged into the router, as well as the duratio
-
You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL> ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？ （）
A . The DBWn process writes to the datafile.
B . Changes in the background process are recorded.
C . The log file is updated with the current SCN number.
D . The System Change Number （SCN） is recorded in the control file.
E . The changes to the listener configuration in the listener.ora file are recorded.
-
When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics. Which two statements describe the implications of this？（）
A . It produces less accurate results of the comparison analysis.
B . It automatically calls the SQL Tuning Advisor for recommendations.
C . It shortens the time of execution and reduces the impact on system resources.
D . Only the changes in the execution plan，and not performance regression，are detected.
-
You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted， but only once. Which three are possible mechanisms for performing this initialization code？（）
A . In the init method.
B . In the jspInit method.
C . In the constructor of the JSP’s Java code.
D . In a JSP declaration， which includes an initializer block.
E . In a JSP declaration， which includes a static initializer block.
-
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
A . back up the control file to trace
B . bring database to the MOUNT state
C . open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D . set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
-
Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified？（）
A . only the control file， the current SPFILE， and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file，current SPFILE file，data files，and archived redo log
-
Your application uses two threads， named threadOne and threadTwo.You need to modify the code to prevent the execution of threadOne until threadTwo completes execution. What should you do？（）
A . Configure threadOne to run at a lower priority.
B . Configure threadTwo to run at a higher priority.
C . Use a WaitCallback delegate to synchronize the threads.
D . Call the Sleep method of threadOne.
E . Call the SpinLock method of threadOne.
-
Examine the SQL statements that creates ORDERS table:
https://assets.asklib.com/images/image2/201808011530357709.jpg
For which columns would an index be automatically created when you execute the above SQL statement? （）
A . SER_NO
B . ORDER_ID
C . STATUS
D . PROD_ID
E . ORD_TOTAL
F . Composite index on ORDER_ID and ORDER_DATE
-
Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）
A . Because row IDs may change during the flashback operation
B . Because the object number changes after the flashback operation
C . Because the rows are retrieved from the recycle bin during the flashback operation
D . Because the table is moved forward and back to a temporary during the flashback opertio
-
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.You plan to use a PresentationTraceSources object when the application is executed by users.When the application is executed in a test environment, all debug information is successfully captured.You need to be able to capture debug information when the application is deployed.What should you do？（）
A.Enable WPF tracing in the registry.Restart the application.
B.Enable tracing by modifying local Group Policy.Restart the application.
C.Open the XML configuration file for your application on the user‘s computer.Set tracing to a verbose level.Restart the application.
D.Open the XML configuration file for your application on the user‘s computer.Add a trace listener.Restart the application.
-
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？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' />
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
-
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' />
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
-
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed？（）
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation
