单选题You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）Ato avoid round trips to the server by enabling caching of query results in client memoryBto improve performance by storing a copy of the data from the private SQL area of the PGACto enhance the query performance by creating a cache in the client memory for sorting operationsDto avoid the storing of query plans and results in the server by creating a cache in the client memory
单选题
You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）
A
to avoid round trips to the server by enabling caching of query results in client memory
B
to improve performance by storing a copy of the data from the private SQL area of the PGA
C
to enhance the query performance by creating a cache in the client memory for sorting operations
D
to avoid the storing of query plans and results in the server by creating a cache in the client memory
参考解析
解析：
暂无解析
相关考题：
()orders to our satisfaction, we would have regarded them as promising customers. A、Had they executedB、If they have executedC、If they would executeD、Have they executed
You executed the following commands in a database session:What could have caused the recycle bin to clean up?() A. There is demand for space from the new table从B. The undo tablespace does not have sufficient free spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free space
You have a computer that runs Windows Vista.You need to ensure that all local administrators can install applications without being prompted for approval.What should you do?() A.AB.BC.CD.D
His presentation will show you ____ can be used in other contexts. A. that you have observed B. that how you have observed C. how that you have observed D. how what you have observed
Prof.Lee’s book will show you（ ）can be used in other contexts.A.that you have observedB.that how you have observedC.how that you have observedD.how what you have observed
Write a memo in about 50 words. You are the Personnel Manager of a company, and have been approached by your IT Department to recruit three new members of staff. Write a memo to Miss Kate Bush, the Manager of the IT Department, ·informing her you have received over 100 applications and have selected 10 candidates for interview, ·telling her you will write to the candidates inviting them for interview, and ·asking her to tell you the time and the place of the interview.
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor
You have a domain controller that runs Windows Server 2008 and is configured as a DNS server. You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）A、Data blocks have to be written more frequently by DBWR. B、Redo blocks have to be written more frequently by LGWR. C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、 A primary key must have been created.B、 A mapping table must have been created.C、 An overflow tablespace must have been specified.D、 The PCTTHRESHOLD option must have been specified.
You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）A、to avoid round trips to the server by enabling caching of query results in client memoryB、to improve performance by storing a copy of the data from the private SQL area of the PGAC、to enhance the query performance by creating a cache in the client memory for sorting operationsD、to avoid the storing of query plans and results in the server by creating a cache in the client memory
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS server. You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）A、Enable debug logging.B、Enable automatic testing for simple queries. The safer ， easier way to help you pass any IT exams. 9 / 90C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）A The Automatic Memory Manager （AMM）B The SQL Tuning AdvisorC The Segment AdvisorD The SQL Access Advisor
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）AThe Automatic Memory Manager (AMM)BThe SQL Tuning AdvisorCThe Segment AdvisorDThe SQL Access Advisor SQL
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower
问答题Write a memo in about 50 words. You are the Personnel Manager of a company, and have been approached by your IT Department to recruit three new members of staff. Write a memo to Miss Kate Bush, the Manager of the IT Department, ·informing her you have received over 100 applications and have selected 10 candidates for interview, ·telling her you will write to the candidates inviting them for interview, and ·asking her to tell you the time and the place of the interview.
单选题You have a domain controller that runs Windows Server 2008 and is configured as a DNS server You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）AEnable debug logging.BEnable automatic testing for simple queries.CEnable automatic testing for recursrve queries.DConfigure event logging to log errors and warnings.
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）AThe Automatic Memory Manager (AMM)BThe SQL Tuning AdvisorCThe Segment AdvisorDThe SQL Access Advisor
单选题While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.
单选题While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A A primary key must have been created.B A mapping table must have been created.C An overflow tablespace must have been specified.D The PCTTHRESHOLD option must have been specified.
单选题You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）AMonitor thealert.logfileBEnable server-side SQL tracing for user sessionsCEnable fine-grained auditing for the customer tableDEnable Fine-Grained Access Control （FGAC） for the customer tableEWrite a database trigger on the customer table on the SELECT event
单选题For 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 profile.B Set the CPU time per session in the users profile.C Set the CPU levels for the user’s group using Resource Manager.D Set the TIMED_STATISTICS parameter to TRUE in the 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？（）Aset the CPU time per call in the users profileBset the CPU time per session in the users profilesCset the CPU levels for the users’ group using Resource ManagerDset the TIMED_STATISTICS parameter to TRUE in the parameter file
单选题You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS server. You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）AEnable debug logging.BEnable automatic testing for simple queries.CEnable automatic testing for recursive queries.DConfigure event logging to log errors and warnings.