to avoid round trips to the server by enabling caching of query results in client memory
to improve performance by storing a copy of the data from the private SQL area of the PGA
to enhance the query performance by creating a cache in the client memory for sorting operations
to avoid the storing of query plans and results in the server by creating a cache in the client memory
第1题:
A.A
B.B
C.C
D.D
第2题:
第3题:
A、Had they executed
B、If they have executed
C、If they would execute
D、Have they executed
第4题:
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?()
第5题:
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?()
第6题:
第7题:
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.
To: Miss Kate Bush
From: your name, Personnel Manager
Subject: IT Department job interview
Date: April 18, 2013
I have received over 100 applications for the three new positions in the IT Department and have put together a short list of 10 candidates. I will shortly write to the candidates inviting them for interview. Please let me know when and where you would like the interview to take place so that I can inform the candidates when I write to them.
略
第8题:
A. There is demand for space from the new table从
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space
第9题:
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?()
第10题:
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()