Sql Server 7 EXAMS Bundle

Sql Server 7 – Dts Exam Questions & Answers, 100% Accurate. VERIFIED. What is a DTS package? Task?--a collection of commands that tell DTS what data to collect and how to write it out to a destination. A package can also contain other commands called tasks which are action statements DT...

Sql Server 7 - Profiler Exam Questions & Answers, 100% Accurate. VERIFIED. what are the 12 profiler event categories--1. cursors 2. error and warning 3. locks 4. misc. 5. objects 6. scans 7. sessions 8. sql operators 9. stored procedures 10. transactions 11. tsql events 12. user–c...

Sql Server 7 – Security, Exam Questions & Answers, 100% Accurate. VERIFIED. what are statement permissions?--create statements: CREATE TABLE, CREATE VIEW BACKUP DB, etc. what are object permissions?--select, insert, update, delete, reference, excecute. example: revoke select on authors to ...

Sql Server 7 – Locking. Questions & answers, 100% Accurate. Rated A+ intent lock--a mechinism used by transactions to declare their intent of acquiring a lock schema lock--used to maintain structural integrity of tables – i.e. cant drop an index while it is being used exclusive lock--...

Sql Server 7 - Misc – Locking. Questions & answers, 100% Accurate. Rated A+ MSREPL_COMMANDS--this table lives in the distribution database. contains info about the location of synchronization files–– truncated after successful replication foreign keys in merge replication--when the fk ...

Sql Server 7 - Security – Locking. Questions & answers, 100% Accurate. Rated A+ what are statement permissions?--create statements: CREATE TABLE, CREATE VIEW BACKUP DB, etc. what are object permissions?--select, insert, update, delete, reference, excecute. example: revoke select on aut...

Sql Server 7 - Misc 2 – Locking. Questions & answers, 100% Accurate. Rated A+ third normal form--eliminate dependencies between non–key columns in a table denormalization--breaking from the normal forms to help performance 3 things about optimistic concurrency--1. may result in loss o...

Sql Server 7 - Misc 3 – Locking. Questions & answers, 100% Accurate. Rated A+ when might an object in 6.5 not be upgraded to 7? 5 reasons--1. object has been renamed with sp_rename 2. syscomments text is missing 3. a stored procedure is created within another stored procedure 4. owner of a...

Sql Server 7 - Misc 3 – Locking. Questions & answers, 100% Accurate. Rated A+ when might an object in 6.5 not be upgraded to 7? 5 reasons--1. object has been renamed with sp_rename 2. syscomments text is missing 3. a stored procedure is created within another stored procedure 4. owner of a...

Sql Server 7 - Misc 3 Questions & answers, 100% Accurate. Rated A+ when might an object in 6.5 not be upgraded to 7? 5 reasons--1. object has been renamed with sp_rename 2. syscomments text is missing 3. a stored procedure is created within another stored procedure 4. owner of an object doesnt...

Sql Server 7 - Misc 3 Questions & answers, 100% Accurate. Rated A+ when might an object in 6.5 not be upgraded to 7? 5 reasons--1. object has been renamed with sp_rename 2. syscomments text is missing 3. a stored procedure is created within another stored procedure 4. owner of an object doesn...

Sql Server 7 - Misc 3, Questions & Answers, 100% Answers. Latest update. when might an object in 6.5 not be upgraded to 7? 5 reasons--1. object has been renamed with sp_rename 2. syscomments text is missing 3. a stored procedure is created within another stored procedure 4. owner of an object ...

Sql Server 7 - Misc 2. Question & Answers. Latest updates. Rated A+ third normal form--eliminate dependencies between non–key columns in a table denormalization--breaking from the normal forms to help performance 3 things about optimistic concurrency--1. may result in loss of concurrency ...

Sql Server 7 – Security. Question & Answers. Latest updates. Rated A+ what are statement permissions?--create statements: CREATE TABLE, CREATE VIEW BACKUP DB, etc. what are object permissions?--select, insert, update, delete, reference, excecute. example: revoke select on authors to [use...