SQL Server does not support batch processing.
Question 2 Which are valid applications of procedures? Passing parameters. Managing transactions. Reducing network traffic. Modularizing applications.
Managing a cursor. Question 3 What is the maximum stored procedure size? There is no size limit on a stored procedure. Question 4 When is using a cursor is a good idea? Never, because it causes a performance hit. When there is no set-processing method of solving a business problem. When you are defeated in your attempts to write set-processing code.
When you are too lazy to write set-processing code. An event handler. An error handler. A deadlock avoidance mechanism. A programming technique no longer supported in SQL Server 7.
Enforcing referential integrity by defining a default. Complex domain enforcement. Enforcing complex business rules. Enforcing complex defaults. Maintaining duplicate data. Question 2 When is a trigger fired?
Before constant validation. After constraint validation, but before the transaction commits. Question 3 How many triggers can exist on a table? No effective limit. One for each type of data modification statement. Question 4 How long does a trigger persist in a database?
MCSE Readiness Review Exam Designing and Implementing Databases with Microsoft SQL Server 7 [Microsoft Press, Robert Sheldon] on. MCSE Readiness Review -- Exam Designing and Implementing Databases with Microsoft® SQL Server 7. Author: Robert Sheldon. Publication.
Until the table it is created for is dropped. Question 5 What are the inserted and deleted tables? Temporary tables located in the tempdb database. Special views of the transaction log. Separate database tables. Question 6 When can you access the inserted and deleted tables? You cannot access these tables, because they are log tables. Only within the transaction in which they are created.
Only within the trigger that is firing. In the trigger in which it fires and in any nested trigger fired from the trigger. Question 7 What is the structure of the inserted and deleted tables? Set by the server defaults. Identical to each other. Identical to the base table. Question 8 What are the contents of the inserted and deleted tables?
The inserted table contains all rows inserted or updated. The deleted table contains all rows deleted or updated. The inserted table contains only rows inserted. The deleted table contains only rows deleted. After the first commit.
After the final commit. After any checkpoint. When the session terminates. Question 2 When does recovery occur?
Automatically when the server is started. Automatically when the server is stopped. Only during the recover server command. After each rolled back transaction. Question 4 How long does a completed transaction persist in a database? Until it is rolled back. Until it is committed.
Until the locks are released. Until another transaction replaces it.
Row level. Page level. Table level. Database level. Server level.
Question 2 What option is used to direct BCP to redirect the errors to a file? Question 3 What dtswiz parameter can be used to specify what login to use when connecting to a SQL Server? Question 4 Which of the following are true about the following BCP statement? The statement will try to connect to a local server.
The statement will fail, because the database name is missing. Perl B. Visual Basic D. Java E.
Full-text queries require a full-text index.