网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
()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 observed
B.that how you have observed
C.how that you have observed
D.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?（）A
The Automatic Memory Manager (AMM)B
The SQL Tuning AdvisorC
The Segment AdvisorD
The 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（）A
Enable debug logging.B
Enable automatic testing for simple queries.C
Enable automatic testing for recursrve 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
考题
单选题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.
考题
单选题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？（）A
Monitor thealert.logfileB
Enable server-side SQL tracing for user sessionsC
Enable fine-grained auditing for the customer tableD
Enable Fine-Grained Access Control （FGAC） for the customer tableE
Write 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？（）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 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.C
Enable automatic testing for recursive queries.D
Configure event logging to log errors and warnings.
热门标签
最新试卷