Discussion
Home ‣ Database ‣ SQL Server 2000 Comments
- Question
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. PESSIMISTIC
- Correct Answer
- OPTIMISTIC
- 1. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Options- A. Differential recovery
- B. Full recovery
- C. Simple recovery
- D. Bulk-logged recovery Discuss
- 2. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. READCOMMITTED Discuss
- 3. SQL Server program code that is executed after an SQL command has been processed is called a(n):
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
- 4. An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
Options- A. COBOL.
- B. VB.NET.
- C. TRANSACT SQL.
- D. Visual Basic. Discuss
- 5. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
- 6. HTML is an application of a more robust document markup language called:
Options- A. XHTML.
- B. XML.
- C. SGML.
- D. None of the above is correct. Discuss
- 7. XML Schemas consist of:
Options- A. properties and methods.
- B. elements and attributes.
- C. structure and data.
- D. tables and relationships. Discuss
- 8. XML is:
Options- A. a subset of SGML only.
- B. a hybrid of document processing and database processing only.
- C. a standardized yet customizable way to describe the content of documents only.
- D. XML is all of the above. Discuss
- 9. If an XML document does not have a DTD, then by definition it is:
Options- A. not-type-valid.
- B. type-valid.
- C. an HTML document.
- D. None of the above is correct. Discuss
- 10. What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?
Options- A. SOAP
- B. SGML
- C. SQL
- D. ADO Discuss
SQL Server 2000 problems
Search Results
Correct Answer: Bulk-logged recovery
Correct Answer: READCOMMITTED
Correct Answer: AFTER trigger.
Correct Answer: TRANSACT SQL.
Correct Answer: INSTEAD OF trigger.
Correct Answer: SGML.
Correct Answer: elements and attributes.
Correct Answer: XML is all of the above.
Correct Answer: not-type-valid.
Correct Answer: SOAP
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.