单选题You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A Set DYNAMIC_SAMPLING to level 4B Set the STATISTICS_LEVEL parameter to BASICC Set the INCREMENTAL value to TRUE for the partition tableD Increase the value of STALE

考题 You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.

查看答案

考题 You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?() A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

查看答案

考题 Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?() A.A syntax error will result as you cannot specify more than one partition in the same statementB.All data in p1 and p3 partitions are removed and the table definition is changedC.All data in p1 and p3 partitions are removed, but the table definition remains unchangedD.Only the first partition (p1) will be dropped as only one can be dropped at any time

查看答案

考题 Which is a restriction on a list partitioned table？（）A、You cannot create global range partitioned indexes on the table. B、The optimizer will not execute partition wise joins on the table’s partitions. C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

查看答案

考题 Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? （）A、Modify the NTFS permissions on the Data folder.B、Modify the share permissions on the Data share.C、Add the domain administrator to the local Administrator’s group on Server1.D、Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

查看答案

考题 You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）A、Use the database link.B、Use the SQL*Loader utility.C、Use the Oracle Data Pump utility.D、Create an external table and leave the data in the flat file

查看答案

考题 You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.

查看答案

考题 You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A、 Set DYNAMIC_SAMPLING to level 4B、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the INCREMENTAL value to TRUE for the partition tableD、 Increase the value of STALE_PERCENT for the partition table

查看答案

考题 You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（） A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.

查看答案

考题 Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A、A syntax error will result as you cannot specify more than one partition in the same statementB、All data in p1 and p3 partitions are removed and the table definition is changedC、All data in p1 and p3 partitions are removed, but the table definition remains unchangedD、Only the first partition (p1) will be dropped as only one can be dropped at any time

查看答案

考题 An application uses Windows Azure Table storage. The application uses five tables. One table used by the application is approaching the limit for storage requests per second. You need to recommend an approach for avoiding data access throttling. What should you recommend？（）A、 Use a single partition key for the table.B、 Compress data before storing it in the table.C、 Create additional partition keys for the table.D、 Continually remove unnecessary data from the table.

查看答案

考题 Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? （）A、Modify the NTFS permissions on the Data folder.B、Modify the share permissions on the Data share.C、Add the domain administrator to the local Administrator’s group on Server1.D、Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

查看答案

考题 You are planning to deploy Windows 7 Enterprise to all of your company’s client computers. You have the following requirements： Create two custom partitions on each client computer’s hard disk， one for the operating system and the other for data. Automatically create the partitions during Windows Setup. You need to design an image that meets the requirements. What should you do？（）A、Use Windows PE to create the partitions. Install Windows 7 on the first partition.B、Use Windows System Image Manager （Windows SIM） to specify the partition configuration.C、Use Disk Management to create the two partitions on the hard disk.D、Use SysPrep to create the two partitions during Windows Setup.

查看答案

考题 You are designing a Windows Azure application that will use Windows Azure Table storage. The application will allow teams of users to collaborate on projects. Each user is a member of only one team. You have the following requirements： - Ensure that each user can efficiently query records related to his or her team’s projects. - Minimize data access latency. You need to recommend an approach for partitioning table storage entities. What should you recommend？（）A、 Partition by user.B、 Partition by team.C、 Partition by project.D、 Partition by the current date.

查看答案

考题 You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）A、Specify a view based on the archival data table and current data tables.B、Specify that the data must be queried by using a stored procedure.C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

查看答案

考题 Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）A、Implement horizontal partitioning.B、Implement vertical partitioning.C、Implement a raw partition.D、Implement distributed partitioning.

查看答案

考题单选题You are planning to deploy Windows 7 Enterprise to all of your company’s client computers. You have the following requirements： Create two custom partitions on each client computer’s hard disk， one for the operating system and the other for data. Automatically create the partitions during Windows Setup. You need to design an image that meets the requirements. What should you do？（）A Use Windows PE to create the partitions. Install Windows 7 on the first partition.B Use Windows System Image Manager （Windows SIM） to specify the partition configuration.C Use Disk Management to create the two partitions on the hard disk.D Use SysPrep to create the two partitions during Windows Setup.

查看答案

考题单选题You are designing a Windows Azure application that will use Windows Azure Table storage. The application will allow teams of users to collaborate on projects. Each user is a member of only one team. You have the following requirements： - Ensure that each user can efficiently query records related to his or her team’s projects. - Minimize data access latency. You need to recommend an approach for partitioning table storage entities. What should you recommend？（）A Partition by user.B Partition by team.C Partition by project.D Partition by the current date.

查看答案

考题单选题You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）A Specify a view based on the archival data table and current data tables.B Specify that the data must be queried by using a stored procedure.C Specify that both the archival data table and the current data tables must have indexes created on the same columns.D Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

查看答案

考题单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）A Drop the table.B Partition the table.C Truncate the table.D Add a column to the table.E Rename a column in the table.

查看答案

考题单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）A A syntax error will result as you cannot specify more than one partition in the same statementB All data in p1 and p3 partitions are removed and the table definition is changedC All data in p1 and p3 partitions are removed, but the table definition remains unchangedD Only the first partition (p1) will be dropped as only one can be dropped at any time

查看答案

考题单选题You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）A Use the database link.B Use the SQL*Loader utility.C Use the Oracle Data Pump utility.D Create an external table and leave the data in the flat file

查看答案

考题单选题Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? （）A Modify the NTFS permissions on the Data folder.B Modify the share permissions on the Data share.C Add the domain administrator to the local Administrator’s group on Server1.D Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

查看答案

考题单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）A Upgrade the hardware/memory to accommodate the data.B Load the data into your database by using the PARALLEL clause.C Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.D Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

查看答案

考题单选题Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? （）A Modify the NTFS permissions on the Data folder.B Modify the share permissions on the Data share.C Add the domain administrator to the local Administrator’s group on Server1.D Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

查看答案

考题单选题Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）A Implement horizontal partitioning.B Implement vertical partitioning.C Implement a raw partition.D Implement distributed partitioning.

查看答案

考题单选题An application uses Windows Azure Table storage. The application uses five tables. One table used by the application is approaching the limit for storage requests per second. You need to recommend an approach for avoiding data access throttling. What should you recommend？（）A Use a single partition key for the table.B Compress data before storing it in the table.C Create additional partition keys for the table.D Continually remove unnecessary data from the table.

查看答案

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

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