搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多项选择题】

In a Database Replay workload capture， what client request information is gathered？（）

A、A. SQL text

B、B. Shared server requests （Oracle MTS）

C、C. Bind variable values

D、D. Information about transactions

E、E. Remote DESCRIBE and COMMIT operations

查看正确答案
更多“In a Database Replay workload capture， what client request information is gathered？（）”相关的问题
第1题
[单选题] You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

A、DB_CREATE_FILE_DEST   B、DB_CREATE_ONLINE_LOG_1   C、DB_CREATE_ONLINE_LOG_2  D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed  

点击查看答案
第2题
[单选题] You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）

A、A trigger in each form.   B、A subprogram in each form.   C、A stored subprogram in the database.   D、A subprogram in a library that is attached to each form.  

点击查看答案
第3题
[多选题] You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）

A、 Open the database in read-only mode.  B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.  C、 Enable the block change tracking feature.  D、 Execute the ALTER DATABASE FLASHBACK ON statement.  

点击查看答案
第4题
[单选题] In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） 

A、recovery catalog  B、Oracle Enterprise Manager Repository  C、Automatic Workload Repository （AWR）  D、Oracle 10g Enterprise Manager Grid Control  E、Automatic Database Diagnostic Monitor （ADDM）  

点击查看答案
第5题
[单选题] In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）

A、 Recovery catalog  B、 Oracle Enterprise Manager Repository  C、 Automatic Workload Repository （AWR）  D、 Oracle 10g Enterprise Manager Grid Control  E、 Automatic Database Diagnostic Monitor （ADDM）  

点击查看答案
第6题
[单选题] 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  

点击查看答案
第7题
[单选题] shirin plans to change the form and views of a production database. she will make the changes locally and then update the application’s design template with the changes. which one of the following server tasks does the administrator run in order for the changes to take effect?（）

A、 design   B、 updall   C、 replica   D、 fixup  

点击查看答案
第8题
[单选题] You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

A、MERGE  B、SELECT …CROSS JOIN  C、INSERT ALL …SELECT  D、CREATE VIEW …CONSTRAINT  

点击查看答案
第9题
[简答题] 阅读下面的程序： 语句“ADD3 DAT0，DAT1，DAT2，DAT3”是一条什么类型的语句？作用是什么？

点击查看答案
第10题
[单选题] You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

A、Create a single storage group. Create one database for all users  B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database  C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database  D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服