- Study guides, Class notes & Summaries

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

All 12 results

Sort by:

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.99 More Info

Exam (elaborations)

Sql Server 7 - Misc 2. Exam Questions and answers, 100% Accurate, rated A+
-

-

-

5

September 2023

2023/2024

A+
Sql Server 7 - Misc 2. Exam Questions and 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 a table...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 – Locking, Questions & Answers, 100% Accurate. Latest update.
-

-

-

2

September 2023

2023/2024

A+
Sql Server 7 – Locking, Questions & Answers, 100% Accurate. Latest update. 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...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 – Misc, Questions & Answers. Rated A+. LATEST UPDATE.
-

-

-

5

September 2023

2023/2024

A+
Sql Server 7 – Misc, Questions & Answers. Rated A+. LATEST UPDATE. 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 gener...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 – Security. Question & Answers. Latest updates. Rated A+
-

-

-

3

September 2023

2023/2024

A+
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 [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 modificati...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 - Misc 2. Question & Answers. Latest updates. Rated A+
-

-

-

5

September 2023

2023/2024

A+
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 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 a table or obj...
PassPoint02
$8.49 More Info

Exam (elaborations)

Sql Server 7 - Misc 3, Questions & Answers, 100% Answers. Latest update.
-

-

-

4

September 2023

2023/2024

A+
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 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 wh...
PassPoint02
$8.49 More Info

Exam (elaborations)

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

-

-

2

September 2023

2023/2024

A+
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 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 can...
PassPoint02
$8.49 More Info