Discussion
Home ‣ Certification ‣ Microsoft Certification See What Others Are Saying!
- Question
You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows. You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal. What should you do?
Options- A. Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data.
- B. Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
- C. Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format.
- D. Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data.
- Correct Answer
- Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
ExplanationWe need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier).
Incorrect Answers:
A: We could use a SqlConnection object only if the SQL Server were SQL Server 7.0, 2000 or later.
C: HTTP functionality is not required in this scenario. It would introduce unnecessary overhead.
D: ADODB is a legacy standard and should not be used here
- 1. Which of the following is Not a Function?
Options- A. Incident Management
- B. Technical Management
- C. Service Desk
- D. Application Management Discuss
- 2. The status bar of Word 2010 provides useful information about the current document you are working on. You can customize the status bar to add or remove options to suit your needs. By default, which of these options is NOT present on the status bar?
Options- A. Line Number
- B. Page Number
- C. Word Count
- D. Language Discuss
- 3. A large document contains meeting notes from all meeting that took place between HR and Finance. You need to find all instances of 'derive' or 'dive' or 'dave'. What would be the most efficient way to find these terms using the Find & Replace dialog box?
Options- A. Choose Wildcard option and search for d?ve
- B. Choose Wildcard option and search for d*ve
- C. Choose Wildcard option and search for ?ve
- D. Choose Wildcard option and search for *ve Discuss
- 4. Which hardware platform (or platforms) are supported by Windows 2000?
Options- A. The Intel Pentium/ 166MHZ (and higher) platform
- B. The Compac Alpha platform
- C. The PowerPC platform
- D. The MIPS R4000 platform Discuss
- 5. You decide to change the file system on your Windows 2000 computer. You want to change drive C: from FAT to NTFS. What should you type at the command prompt?
Options- A. FORMAT C: /FS : NTFS
- B. CONVERT C: /FS : NTFS
- C. FORMAT C: /NTFS
- D. CONVERT C: /NTFS Discuss
- 6. You perform a normal backup for your company once a week. In addition, you want to perform a backup of data each day in between normal backups. You want to minimize the amount of time it takes to perform these backups. Which backup type should you use on the days in between normal backups?
Options- A. Normal
- B. Incremental
- C. Differential
- D. Copy Discuss
- 7. You are choosing a Windows 2000 operating system to use on a new computer at your company. This new computer will be a heavily used SQL server in your enterprise network environment. which operating system should you choose?
Options- A. Windows 2000 professional
- B. Windows 2000 Server
- C. Windows 2000 Advanced Server
- D. Windows 2000 Datacenter Server Discuss
- 8. What is the maximum number of triggers, can apply to a single table?
Options- A. 8
- B. 10
- C. 12
- D. 14 Discuss
- 9. Why do you need common fields in a Database? Discuss
- 10. Insert command falls in which sub-language of SQL ?
Options- A. DCL
- B. DQL
- C. DML
- D. DDL Discuss
More questions
Correct Answer: Incident Management
Correct Answer: Line Number
Correct Answer: Choose Wildcard option and search for d*ve
Correct Answer: The Intel Pentium/ 166MHZ (and higher) platform
Explanation:
The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.
Correct Answer: CONVERT C: /FS : NTFS
Explanation:
The convert.exe command is used to change a volume's file system from FAT to NTFS.
Correct Answer: Incremental
Explanation:
In terms of the time it takes to perform backups, the incremental backup will take the least amount of time because it is not a cumulative backup, like the differential backup.
Correct Answer: Windows 2000 Advanced Server
Explanation:
Windows 2000 Advanced Server is optimized for use on servers (such as SQL servers) in an enterprise network environment.
Correct Answer: 12
Explanation:
Maximim number of triggers that can be applied to a single table is 12
Correct Answer: A database that contains multiple tables related through common fields A common field is a field of data that is shared among all forms in a database Without them, it would be difficult and/or time-consuming to create other forms
Correct Answer: DML
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.