You executed the following command to back up your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?()
In which scenario will you create a hash cluster?()A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator (=) to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables
点击查看答案
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number (SCN) to which you can flash back your database
Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement: SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’; What will be the result of issuing the above statement?()AThe statement will be executed successfully, and a new time zone will be set for the database.BThe statement will be executed successfully, but a new time zone will not be set for the database.CThe statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.DThe statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A renaming the control filesB dropping a user in your databaseC enabling or disabling redo log archivingD dropping a tablespace in your databaseE re-creating the control files, after you lost all the control files in your database
单选题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?()AEnable WPF tracing in the registry.Restart the application.BEnable tracing by modifying local Group Policy.Restart the application.COpen the XML configuration file for your application on the user's computer.Set tracing to a verbose level.Restart the application.DOpen the XML configuration file for your application on the user's computer.Add a trace listener.Restart the application.
单选题You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()Aback up the control file to traceBbring database to the MOUNT stateCopen a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseDset the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog