- Study guides, Class notes & Summaries

Looking for the best study guides, study notes and summaries about ? On this page you'll find 11 study documents about .

All 11 results

Sort by:

Exam (elaborations)

Sql Server 7 – Dts, Top Exam Questions and answers, rated A+. latest update.
-

-

-

2

September 2023

2023/2024

A+
Sql Server 7 – Dts, Top Exam Questions and answers, rated A+. latest update. 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 DTS Task ––> send mail--send email to a pre–defined mail account DTS Task ––> execute process task--executes a dos based process DTS Transform property: activeX scripting--you ...
PassPoint02
$7.99 More Info

Exam (elaborations)

Sql Server 7 – Profiler, Questions and answers, 100% accurate, VERIFIED.
-

-

-

5

September 2023

2023/2024

A+
Sql Server 7 – Profiler, Questions and 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–configurable what are some profiler events that are relavent for security monitoring?--1. misc: login failed 2. misc: service control 3. objects: object:deleted 4. sql operators: delete what ...
PassPoint02
$8.99 More Info

Exam (elaborations)

Sql Server 7 – Locking, Questions and answers, 100% Accurare
-

-

-

2

September 2023

2023/2024

A+
Sql Server 7 – Locking, Questions and answers, 100% Accurare 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--needed for data modification update locks--intermediary lock between schared and exclusive. Indicating that a resource wants to obtain an exclusive lock SELECT: holdlocks--shared locks held for duration ...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 – Misc, Top Exam Questions and answers, Graded A+
-

-

-

5

September 2023

2023/2024

A+
Sql Server 7 – Misc, Top Exam Questions and answers, Graded 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 table is not included in the publication you cannot add new rows or update the fk column. you can however still change other columns. error 1205 deadlock situation security level = 13 what is the general unic...
PassPoint02
$8.99 More Info

Exam (elaborations)

Sql Server 7 – Security, Questions and answers, rated A+
-

-

-

3

September 2023

2023/2024

A+
Sql Server 7 – Security, Questions and answers, 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 [user]. fixed database role: public--default permissions–– all users are members of the public role. fixed database role: db_denydatawriter--memebers of this role cannot make any data modifications. fixed...
PassPoint02
$8.99 More Info

Exam (elaborations)

Sql Server 7 - Misc 3, Questions and answers. 100% Accurate. Rated A+
-

-

-

4

September 2023

2023/2024

A+
Sql Server 7 - Misc 3, Questions and 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 exist on the new server 5. missing nt groups 7 upgrading requirements--1. sp4 2. ie4.01 sp1 3. 32 megs of ram 4. 180 megs of hd space 5. sql server 6.5 sp3 6. sql 6 sp3 7 named pipes ...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 - Misc 3 Questions & answers, 100% Accurate. Rated A+
-

-

-

4

September 2023

2023/2024

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 exist on the new server 5. missing nt groups 7 upgrading requirements--1. sp4 2. ie4.01 sp1 3. 32 megs of ram 4. 180 megs of hd space 5. sql server 6.5 sp3 6. sql 6 sp3 7 named pipes wha...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 - Misc 2 – Locking. Questions & answers, 100% Accurate. Rated A+
-

-

-

5

September 2023

2023/2024

A+
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 of concurrency because multiple users can edit data at the same time 2. results in higher concurency than other locking systems. 3. requires timestamps object_id function--gets the database id of ...
PassPoint02
$8.99 More Info

Exam (elaborations)

Sql Server 7 – Locking. Questions & answers, 100% Accurate. Rated A+
-

-

-

2

September 2023

2023/2024

A+
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--needed for data modification update locks--intermediary lock between schared and exclusive. Indicating that a resource wants to obtain an exclusive lock SELECT: holdlocks--shared locks held for...
PassPoint02
$6.99 More Info

Exam (elaborations)

Sql Server 7 – Security, Exam Questions & Answers, 100% Accurate. VERIFIED.
-

-

-

3

September 2023

2023/2024

A+
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 [user]. fixed database role: public--default permissions–– all users are members of the public role. fixed database role: db_denydatawriter--memebers of this role cannot make any data modifi...
PassPoint02
$8.49 More Info