The time when the last flashback operation in your database was performed.
The time when the first flashback operation in your database was performed.
A list of flashback operations performed in your database using SCN and time.
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
第1题:
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()
第2题:
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?()
第3题:
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?()
第4题:
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()
第5题:
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
第6题:
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least. Which action should be performed to finish the task?()
第7题:
renaming the control files
dropping a user in your database
enabling or disabling redo log archiving
dropping a tablespace in your database
re-creating the control files, after you lost all the control files in your database
第8题:
You must use automatic undo management in the database.
You must configure OMF in your database.
You must configure ASM for storing the datafiles.
You must multiplex the online redo log file.
第9题:
The time when the last flashback operation in your database was performed.
The time when the first flashback operation in your database was performed.
A list of flashback operations performed in your database using SCN and time.
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
第10题:
The table is moved to the SYSAUX tablespace.
The table is moved to the SYSTEM tablespace.
The table is removed from the database permanently.
The table is renamed and remains in the TBSFD tablespace.
第11题:
It would return information regarding only the last committed transaction.
It would return only the active transactions in all the undo segments in the database.
It would return only the committed transactions in all the undo segments in the database.
It would return both active and committed transactions in all the undo segments in the database.
It would return information regarding the transactions that began and were committed in the last 30 minutes.
第12题:
DBA_PENDING_TRANSACTIONS
DBA_AUDIT_STATEMENT
V$FLASHBACK_DATABASE_STATS
FLASHBACK_TRANSACTION_QUERY
第13题:
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? SELECT * FROM HR; ()
第14题:
You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第15题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第16题:
At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()
第17题:
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()
第18题:
The statement will be executed successfully, and a new time zone will be set for the database.
The statement will be executed successfully, but a new time zone will not be set for the database.
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
The 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.
第19题:
USER_DUMP_DEST
CORE_DUMP_DEST
TRACE_DUMP_DEST
BACKUP_DUMP_DEST
BACKGROUND_DUMP_DEST
第20题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第21题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第22题:
The statement will fail.
The statement will be executed successfully, and the new time zone will be set for the database.
The statement will be executed successfully, but the new time zone will be set for the current session.
The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
第23题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第24题:
Query the V$FLASHBACK_DATABASE_LOG view.
Query the V$FLASHBACK_DATABASE_STAT view.
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
Query the V$RECOVERY_FILE_DEST view.