网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You want a record of all queries that are not using indexes. How would you achieve this?（）
A
By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B
By enabling the Error Log because not using indexes is an error
C
By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D
By enabling the Error Log and using the – log-queries-not-using-indexes option
参考答案
参考解析
解析：
暂无解析
更多 “单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB By enabling the Error Log because not using indexes is an errorC By enabling the Slow Query Log and using the – log-queries-not-using-indexes optionD By enabling the Error Log and using the – log-queries-not-using-indexes option” 相关考题
考题
In which case would you use a FULL OUTER JOIN? ()
A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.
考题
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index.Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.Which three methods could transparently help to achieve this result?（）A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnE. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
考题
You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect－traffic all command?()
A. When you want all unauthenticated traffic to be redirectedB. When you want all clear text traffic to be redirected.C. When you want all authenticated traffic to be redirected.D. When you want all encrypted traffic to be redirected.
考题
You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A、by using the ANALYZE utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package
考题
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.
考题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）A、 ZeroB、 One or moreC、 NONED、 DEFAULT
考题
You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）A、by using triggersB、by using external tablesC、by using anonymous PL/SQL blocksD、by auditing all DML operations on the table
考题
In which scenario will you create a sorted hash cluster？ （）A、 if the application uses queries joining tables only occasionallyB、 if the full table scan is executed often on only one table of the clustered tablesC、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD、 when you want the data to be returned automatically in the chronological order
考题
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）A、disabling the indexB、making the index invisibleC、making the index unusableD、using the MONITORING USAGE clause for the index
考题
You want users to log on to Active Directory by using a new User Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）A、DsmodB、NetdomC、RedirusrD、Active Directory Domains and Trusts
考题
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 are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect-traffic all command?（）A
When you want all unauthenticated traffic to be redirectedB
When you want all clear text traffic to be redirected.C
When you want all authenticated traffic to be redirected.D
When you want all encrypted traffic to be redirected.
考题
单选题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 want users to log on to Active Directory by using a new Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）A
DsmodB
NetdomC
RedirusrD
Active Directory Domains and Trusts
考题
单选题You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）A
by using triggersB
by using external tablesC
by using anonymous PL/SQL blocksD
by auditing all DML operations on the table
考题
多选题You are a network administrator for ExamSheet.net’s Windows 2000 network. Your computer has Windows 2000 Professional installed. Your office has a power utage while you are running the Windows 2000 disk defragmenter. When you restart your computer， you receive the following error message： "Bad or missing operating system". You want your computer to start properly. You want to do this with least amount of administrative effort. What should you do？（）AReinstall the operating systemBStart the computer by using the Windows 2000 Professional CD-ROM.CUse the Recovery Console to repair the Master Boot Record.DUse the Emergency Repair Disk to repair the Master Boot Record.
考题
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A
By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB
By enabling the Error Log because not using indexes is an errorC
By enabling the Slow Query Log and using the – log-queries-not-using-indexes optionD
By enabling the Error Log and using the – log-queries-not-using-indexes option
考题
单选题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.
考题
单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQLCREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task？（）A
disabling the indexB
making the index invisibleC
making the index unusableD
using the MONITORING USAGE clause for the index
考题
单选题Your network contains an Active Directory forest.The forest contains three domain trees.Each domain tree contains multiple domains.You have an Active Directory-integrated DNS zone.You install a Web server named Web1. All of the users in the company will use Web1.You need to ensure that the users can access Web1 by using the URL http://web1. You want to achieve this goal by using the minimum amount of administrative effort.What should you do？（）A
Configure a GlobalNames zone and add a Host (A) resource record for Web1.B
Create an Alias (CNAME) resource record for Web1 in the forest root domain zone.C
Create a reverse lookup zone and add an Alias (CNAME) resource record for Web1.D
Create a Host Information (HINFO) resource record for Web1 in the forest root domain zone.
考题
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）A
ZeroB
One or moreC
NONED
DEFAULT
考题
单选题In which scenario will you create a sorted hash cluster？ （）A
if the application uses queries joining tables only occasionallyB
if the full table scan is executed often on only one table of the clustered tablesC
if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD
when you want the data to be returned automatically in the chronological order
考题
单选题You are the network administrator for Company. You have been assigned the task to create and deploy a standard Windows 2000 Professional image to all 2,500 client computers that today are installed with Windows 98. You log on to a client computer called Company by using a local administrative account called SetupUser and install three Windows 2000 professional compatible software packages on Company. You create an image using third party software. You deploy the image to a test client computer and join the client computer to a domain. You want to create shortcuts on all users' desktops for the software packages you installed. You also want users to have the option to delete the icons. Which profile must you edit?（）A
The SetupUser profileB
The Default User profileC
The Administrator profileD
The System profileE
The All Users profile
考题
单选题You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A
by using the ANALYZE utilityB
by using the DBVERIFY utilityC
by using the DB_BLOCK_CHECKING parameterD
by using the DBMS_REPAIR package
考题
单选题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.
考题
单选题Your network consists of a single Active Directory domain named contoso.com. All servers run Windows Server 2003 Service Pack 2 (SP2). You deploy a Web server named Server1. Users access the server by using the URL http://server1.contoso.com. You need to create a new resource record that will allow users to access the server by using the URL http://www.contoso.com. The solution must prevent the need to modify the new record if the IP address of Server1 changes. Which type of resource record should you configure?（）A
alias（CNAME）B
host （A）C
mail exchanger （MX）D
pointer（PTR）
考题
单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）A
disabling the indexB
making the index invisibleC
making the index unusableD
using the MONITORING USAGE clause for the index
热门标签
最新试卷
