网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?()
A

Coalesce the application tables at a regular interval.

B

Export and Import the application tables a regular interval.

C

Drop and recreate the application tables at a regular interval.

D

Move the application tables to a tablespace with less space usage.

E

Distribute the application tables across multiple tablespaces depending on usage.

F

Move the application tables to automatic segment space management tablespace.


参考答案

参考解析
解析: 暂无解析
更多 “单选题As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?()A Coalesce the application tables at a regular interval.B Export and Import the application tables a regular interval.C Drop and recreate the application tables at a regular interval.D Move the application tables to a tablespace with less space usage.E Distribute the application tables across multiple tablespaces depending on usage.F Move the application tables to automatic segment space management tablespace.” 相关考题
考题 You are an administrator of a switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in your network. However, you need to share the VLAN information across numerous switches throughout your network. Which of the following would allow you accomplish this?()A、STPB、GVRPC、SNMPD、VTPE、DHCP

考题 You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository (AWR)E、Automatic Database Diagnostic Monitor (ADDM)

考题 You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

考题 In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index­organized table (IOT)

考题 You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()A、It degrades the run time and compiler performance.B、It provides better run time and compiler performance.C、It provides better optimization of the statement during parse time.D、It forces the rule based optimizer to be used for statement optimization.E、It provides better run time performance but slightly degraded compiler performance. F、It provides better run time performance but slightly degraded run time performance.

考题 As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?()A、Coalesce the application tables at a regular interval.B、Export and Import the application tables a regular interval.C、Drop and recreate the application tables at a regular interval.D、Move the application tables to a tablespace with less space usage.E、Distribute the application tables across multiple tablespaces depending on usage.F、Move the application tables to automatic segment space management tablespace.

考题 You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA).  You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()A、Control fileB、Password fileC、Parameter fileD、Online redo log fileE、Listener controller fileF、Server parameter file

考题 You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to, in order to determine the appropriate indexes?() A、Memory AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository (AWR)E、Automatic Database Diagnostic Monitor (ADDM)

考题 In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query?()A、hash clustersB、index clustersC、partitioned tablesD、index­organized table (IOT)

考题 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. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform?()A、In a SQL Trace log file, you should look for queries with low duration values and high read and write values.B、In a query execution plan, you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file, you should look for queries with high duration values and low read and write values.D、In a query execution plan, you should look for queries with a large number of table scans.

考题 单选题In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A heap tableB object tableC external tableD clustered tableE global temporary tableF index-organized table (IOT)

考题 单选题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. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform?()A In a SQL Trace log file, you should look for queries with low duration values and high read and write values.B In a query execution plan, you should look for queries with missing or out-of-date statistics.C In a SQL Trace log file, you should look for queries with high duration values and low read and write values.D In a query execution plan, you should look for queries with a large number of table scans.

考题 单选题You work as a database administrator for Supportcenter.cn. You are using three database, SupportCenter DB01, SupportCenter DB02, and SupportCenter DB03, on different host machines in your development environment. The database server configuration, such as IP address and listener port number, change frequently due to development requirements, and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()A Host namingB Local namingC Easy ConnectD External namingE directory naming

考题 单选题You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to, in order to determine the appropriate indexes?()A Memory AdvisorsB Segment AdvisorsC SQL Tuning and Access AdvisorsD Automated Workload Repository (AWR)E Automatic Database Diagnostic Monitor (ADDM)

考题 单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A Database ControlB Management ServerC Management RepositoryD Application Server ControlE Oracle Management Agent

考题 单选题In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query?()A hash clustersB index clustersC partitioned tablesD index­organized table (IOT)

考题 单选题You are an administrator of a switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in your network. However, you need to share the VLAN information across numerous switches throughout your network. Which of the following would allow you accomplish this?()A STPB GVRPC SNMPD VTPE DHCP

考题 单选题In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?()A  Heap tableB  Object tableC  External tableD  Clustered tableE  Global temporary tableF  Index-organized table (IOT)

考题 单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to, in order to determine the appropriate indexes?()A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository (AWR)E Automatic Database Diagnostic Monitor (ADDM)

考题 单选题You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()A It degrades the run time and compiler performance.B It provides better run time and compiler performance.C It provides better optimization of the statement during parse time.D It forces the rule based optimizer to be used for statement optimization.E It provides better run time performance but slightly degraded compiler performance. F It provides better run time performance but slightly degraded run time performance.

考题 单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A use the external table populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use the direct path data load of Oracle export and import utility

考题 单选题You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA).  You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()A Control fileB Password fileC Parameter fileD Online redo log fileE Listener controller fileF Server parameter file

考题 单选题From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries.  You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message.  Which method would you follow to achieve this?()A set the CPU time per call in the users profileB set the CPU time per session in the users profilesC set the CPU levels for the users’ group using Resource ManagerD set the TIMED_STATISTICS parameter to TRUE in the parameter file

考题 单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A Hot backupB Online backupC consistent backupD incremental backupE inconsistent backup

考题 单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to, in order to determine the appropriate indexes?()A  Memory AdvisorB  Segment AdvisorC  SQL Access AdvisorD  Automatic Workload Repository (AWR)E  Automatic Database Diagnostic Monitor (ADDM)

考题 单选题In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance?()A heap tableB object tableC external tableD clustered tableE global temporary tableF index­organized table (IOT)