单选题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？（）A DBA_PENDING_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY
单选题
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？（）
A
DBA_PENDING_TRANSACTIONS
B
DBA_AUDIT_STATEMENT
C
V$FLASHBACK_DATABASE_STATS
D
FLASHBACK_TRANSACTION_QUERY
参考解析
解析：
暂无解析
相关考题：
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?() A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
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？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）A、RMAN onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（） A、 WindowB、 ProgramC、 Job_ClassD、 Window group
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）A、 To recover a dropped table.B、 To recover a dropped schema.C、 To recover data from a truncated table.D、 To view changes made by all the transactions during a given period of time.E、 To view changes made by a single transaction during a given period of time.
You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）A、 The batch operation started by the user， SCOTT， terminates with an error.B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.
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？（）A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（） A、You should implement Differential backup B、You should implement Database snapshotsC、You should implement Primary filegroup backup D、You should implement Transaction log backup
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）A、Decrease the amount of time between transaction log backups.B、Configure the database to use the simple recovery model.C、Configure the RECOVERY INTERVAL option to be a smaller value.D、Run DBCC SHRINKFILE on the transaction log file.
You manage a database named DB1， which is located on a SQL Server 2005 computer. You receive a warning that the drive on which the DB1 log file is located is near capacity.Although the transaction log is backed up every five minutes， you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate. You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do？（）A、Connect to the DB1 database. Execute DBCC OPENTRAN. View the SPID and Starttime rows.B、Connect to the master database. Execute DBCC OPENTRAN. View the SPID andStart time rows.C、In SQL Server Management Studio,open the Activity Monitor. Select the Process Info page and apply the following filter settings, Database=DB1 Open Transactions=YesView the Process ID and Last Batch columns.D、Open a query window. Connect to the master database.Execute the following statement.SELECT TOP 1 spid.last batch FROM sys.sysprocesses WHERE dbid = db id（’DB1’）AND open tran0 ORDER BY last batch
You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: 275 GB for the database data file; 50 GB for the transaction log file. The storage array has six 100-GB disk drives available for the database. The disks are attached to a redundant array of independent disks (RAID) controller that supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to be maximized. The database and transaction log files must be protected in the event of a drive failure. You need to design the storage system. Which storage configuration should you use?（）A、A single RAID 5 volumeB、A single RAID 10 volumeC、A RAID 0 volume and a RAID 5 volumeD、A RAID 1 volume and a RAID 5 volume
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A VERSIONS_STARTSCNB VERSIONS_STARTTIMEC VERSIONS_XIDD VERSIONS_OPERATION
单选题You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）ADecrease the amount of time between transaction log backups.BConfigure the database to use the simple recovery model.CConfigure the RECOVERY INTERVAL option to be a smaller value.DRun DBCC SHRINKFILE on the transaction log file.
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）Apoint-in-time recoveryBexecute the ROLLBACK command with transaction numberCflashback the database to before the transaction was committedDdetermine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
单选题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？（）A You must use automatic undo management in the database.B You must configure OMF in your database.C You must configure ASM for storing the datafiles.D You must multiplex the online redo log file.
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）ARMAN onlyBFlashback Table onlyCFlashback Versions Query onlyDFlashback Database and Flashback Transaction QueryEFlashback Versions Query and Flashback Transaction Query
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）A point-in-time recoveryB execute the ROLLBACK command with transaction numberC flashback the database to before the transaction was committedD determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
单选题You manage a database named DB1， which is located on a SQL Server 2005 computer. You receive a warning that the drive on which the DB1 log file is located is near capacity.Although the transaction log is backed up every five minutes， you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate. You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do？（）AConnect to the DB1 database. Execute DBCC OPENTRAN. View the SPID and Starttime rows.BConnect to the master database. Execute DBCC OPENTRAN. View the SPID andStart time rows.CIn SQL Server Management Studio,open the Activity Monitor. Select the Process Info page and apply the following filter settings, Database=DB1 Open Transactions=YesView the Process ID and Last Batch columns.DOpen a query window. Connect to the master database.Execute the following statement.SELECT TOP 1 spid.last batch FROM sys.sysprocesses WHERE dbid = db id（’DB1’）AND open tran0 ORDER BY last batch
单选题Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）A WindowB ProgramC Job_ClassD Window group
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A RMAN only.B Flashback Table only.C Flashback Version Query only.D Flashback Database and Flashback Transaction Query.E Flashback Version Query and Flashback Transaction Query.
单选题You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: 275 GB for the database data file; 50 GB for the transaction log file. The storage array has six 100-GB disk drives available for the database. The disks are attached to a redundant array of independent disks (RAID) controller that supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to be maximized. The database and transaction log files must be protected in the event of a drive failure. You need to design the storage system. Which storage configuration should you use?（）AA single RAID 5 volumeBA single RAID 10 volumeCA RAID 0 volume and a RAID 5 volumeDA RAID 1 volume and a RAID 5 volume
单选题You need to resolve the double counting of transactions issue in the existing reports. What should you do?（）AApply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.BApply a Conditional Split transformation in the Transaction data in the SSIS package.CDelete the AccountHolder table in the WoodgroveDW database.DApply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.
多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.