多选题Which of these recommendations should be followed before capturing a workload？（）AMake sure your replay database has the same structure as the capture database， except without data.BMake sure the replay and capture databases are similar in data content.CPerform a clean shutdown and restart of the capture database before beginning a workload capture.DStart the capture database in UNRESTRICTED mode， then start the capture.EDefine inclusion and exclusion filters.
多选题
Which of these recommendations should be followed before capturing a workload？（）
A
Make sure your replay database has the same structure as the capture database， except without data.
B
Make sure the replay and capture databases are similar in data content.
C
Perform a clean shutdown and restart of the capture database before beginning a workload capture.
D
Start the capture database in UNRESTRICTED mode， then start the capture.
E
Define inclusion and exclusion filters.
参考解析
解析：
暂无解析
相关考题：
Which two client requests are captured during database replay Capture?() A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations
Which client requests to the database can be captured as a part of the workload capture?() A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external files
WhichofthefollowingrepresentsthecorrectsequenceofeventsforDatabaseReplay?() A.Capture，analyze，preprocess，replayB.Capture，preprocess，analyze，replayC.Capture，preprocess，replay，analyzeD.Analyze，capture，preprocess，replayE.Noneoftheabove
Which two client requests are captured during database replay Capture?() (Choose two) A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations
Which of the following represents the correct sequence of events for Database Replay？（）A、 Capture，analyze，preprocess，replayB、 Capture，preprocess，analyze，replayC、 Capture，preprocess，replay，analyzeD、 Analyze，capture，preprocess，replayE、 None of the above
Which client requests to the database can be captured as a part of the workload capture？（） A、 flashback queryB、 distributed transactionsC、 logging in and logging out of sessionsD、 all DDL statements having bind variablesE、 direct path load of data from external files
In a Database Replay workload capture， what client request information is gathered？（）A、 SQL textB、 Shared server requests （Oracle MTS）C、 Bind variable valuesD、 Information about transactionsE、 Remote DESCRIBE and COMMIT operations
Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload
Performance divergence indicated in the Workload Replay report is most likely due to what？（） A、 DML and SQL statement results that do not match between the capture and replay systemsB、 When errors that occur in the capture system dont occur in the replay systemC、 Top SQL statementsD、 Infrastructure or system-configuration differencesE、 Time-of-day differences between capture and replay systems
Which two client requests are captured during database replay Capture？（）A、 Flashback queriesB、 Shared server requestsC、 Login and logoff activities of sessionsD、 Direct path load of data from external files by using utilities such as SQL *loaderE、 Data definition language （DDL） and data manipulation language （DML） operations
Which two client requests are captured during database replay Capture?（） (Choose two)A、Flashback queriesB、Shared server requestsC、Login and logoff activities of sessionsD、Direct path load of data from external files by using utilities such as SQL *loaderE、Data definition language (DDL) and data manipulation language (DML) operations
Which two statements about workload capture and replay operations are true?（）A、The clients must be created manually on the test machines to perform more realistic testing.B、Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C、Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D、The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
Which of these recommendations should be followed before capturing a workload？（）A、 Make sure your replay database has the same structure as the capture database， except without data.B、 Make sure the replay and capture databases are similar in data content.C、 Perform a clean shutdown and restart of the capture database before beginning a workload capture.D、 Start the capture database in UNRESTRICTED mode， then start the capture.E、 Define inclusion and exclusion filters.
A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases， a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do？（）A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.B、Back up the current transaction log. Restore the database to the point just before the data loss.C、Restore the database from the existing backup files to a time just before the data loss.D、Restore the database to the point of the last full backup.
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 the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）A、To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.B、To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.C、To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.D、To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
多选题Which two client requests are captured during database replay Capture？（）AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language （DDL） and data manipulation language （DML） operations
多选题Which two statements about workload capture and replay operations are true？（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
多选题Which two prerequisites are needed for performing workload capture and replay？（）AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload
多选题You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）AEnsure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.BEnsure that the stored procedure and the tables are owned by the same database user.CEnsure that the stored procedure and the tables use the same database schema.DConfigure the multiuser database option on both databases.EConfigure the cross-database ownership chaining option on both databases.
单选题Which of the following represents the correct sequence of events for Database Replay？（）A Capture，analyze，preprocess，replayB Capture，preprocess，analyze，replayC Capture，preprocess，replay，analyzeD Analyze，capture，preprocess，replayE None of the above
多选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A corporate backup and recovery strategy that has to be validated is designed. You are required to make sure that any single database can be restored successfully from a severe failure, and during the restoration, a backup data center should not be required in a different location. Which three actions should be contained by your solution?（）AAll SQL Server instances should be installed on a failover cluster.BOne list of all Windows logins and passwords should be sustained.CAll backup media offsite should be stored.DSQL login accounts and credentials should be scripted.EThe administrative processes and application access requirements should be documented.
多选题In a Database Replay workload capture， what client request information is gathered？（）ASQL textBShared server requests （Oracle MTS）CBind variable valuesDInformation about transactionsERemote DESCRIBE and COMMIT operations
多选题Which client requests to the database can be captured as a part of the workload capture?（）Aflashback queryBdistributed transactionsClogging in and logging out of sessionsDall DDL statements having bind variablesEdirect path load of data from external files
多选题Which of these recommendations should be followed before capturing a workload？（）AMake sure your replay database has the same structure as the capture database， except without data.BMake sure the replay and capture databases are similar in data content.CPerform a clean shutdown and restart of the capture database before beginning a workload capture.DStart the capture database in UNRESTRICTED mode， then start the capture.EDefine inclusion and exclusion filters.
单选题Performance divergence indicated in the Workload Replay report is most likely due to what？（）A DML and SQL statement results that do not match between the capture and replay systemsB When errors that occur in the capture system dont occur in the replay systemC Top SQL statementsD Infrastructure or system-configuration differencesE Time-of-day differences between capture and replay systems
单选题Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload： 1） Preprocess the captured workload. 2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients. 4） Restore the test database to the point when the capture started. 5） Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）A 1，4，5，3 （2 is not required.）B 1，4，3，5 （2 is not required.）C 1，2，4，5 （3 is not required.）D 2，1，5，3，4 E 1，2，4，5，3
多选题Which two client requests are captured during database replay Capture?（） (Choose two)AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations