Discussion
Home ‣ Certification ‣ Microsoft Certification Comments
- Question
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
- Correct Answer
- Windows 2000 Advanced Server
ExplanationWindows 2000 Advanced Server is optimized for use on servers (such as SQL servers) in an enterprise network environment.
- 1. You use two sites on your Windows 2000 network. You decide you want to manually specify a particular domain controller in each site that will be used for intersite replication. What should you do?
Options- A. Create a site link to connect the two domain controllers
- B. Designate the desired domain controller in each site as a bridge-head server
- C. Configure the desired domain controller in each site to be a global catalog server
- D. Create a new connection object for the desired domain controller in each site Discuss
- 2. What is the default optimization setting for the Server service on Windows 2000 Server computers?
Options- A. Minimize memory used
- B. Balance
- C. Maximize data throughput for file sharing
- D. Maximize data throughput for network applications Discuss
- 3. You would like to use the command line to end an application that a Terminal Services client is running. What command can you use?
Options- A. Tscon
- B. Tsprof
- C. Tsend
- D. Tskill Discuss
- 4. When you run Sysprep on a Windows 2000 computer, what happens to the user-specific information on the computer?
Options- A. It is preserved in usset.inf
- B. It is saved and automatically reinstalled
- C. It is removed
- D. It is not altered Discuss
- 5. You are preparing to install Certificate Services for the first time on your Windows 2000 network. You plan to install Certificate Services on a Windows 2000 Server computer that is a member of the domain. You want the certification authority (CA) to be able to use Active Directory. Which CA type should you select when you install Certificate Services?
Options- A. Enterprise root CA
- B. Enterprise subordinate CA
- C. Stand-alone root CA
- D. Stand-alone subordinate CA Discuss
- 6. What is Primary Key in DBMS? Discuss
- 7. Which dml command is used in conjunction with @@identity?
Options- A. INSERT and UPDATE
- B. UPDATE and DELETE
- C. SCOPE_IDENTITY and IDENT_CURRENT
- D. Commit and rollback 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. Difference between Candidate key and Primary key? Discuss
- 10. Why do you need common fields in a Database? Discuss
Microsoft Certification problems
Search Results
Correct Answer: Designate the desired domain controller in each site as a bridge-head server
Explanation:
The server that is designated as the bridgehead server is used for intersite replication.
Correct Answer: Maximize data throughput for file sharing
Explanation:
The Maximize data throughput for file sharing setting is the default setting , and is appropriate for Windows 2000 Server computers that are functioning primarily as file servers. The Maximize data throughput for network applicatons setting is the preffered setting for domain controllers.
Correct Answer: Tskill
Explanation:
Tskill ends a process. Since you want to stop an application, this is the command you would use.
Correct Answer: It is removed
Explanation:
The user-specific settings are removed by Sysprep.
Correct Answer: Enterprise root CA
Explanation:
Select Enterprise root CA if you're installing the first certificate server in the forest. This type of CA requires the use of Active Directory.
Correct Answer: A primary key is a special relational database table column or combination of columns designated to uniquely identify all table records That is, A primary key is a column or set of columns in a table that uniquely identifies tuples (rows) in that table A primary key, also called a Primary Keyword Main Features Primary key are :: It must contain a unique value for each row of data It cannot contain null values
Correct Answer: SCOPE_IDENTITY and IDENT_CURRENT
Explanation:
Using automatically incrementing IDENTITY columns is very popular with database developers. You don?t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.
You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.
Correct Answer: 12
Explanation:
Maximim number of triggers that can be applied to a single table is 12
Correct Answer: Candidate Key ? A Candidate Key can be any column or a combination of columns that can qualify as unique key in database There can be multiple Candidate Keys in one table Each Candidate Key can qualify as Primary Key Primary Key ? A Primary Key is a column or a combination of columns that uniquely identify a record Only one Candidate Key can be Primary Key One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain
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
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.