AP Notes, Outlines, Study Guides, Vocabulary, Practice Exams and more!

Microsoft SQL Server

PT 2520 Unit 10

Subject: 
Algebra
Rating: 
0
No votes yet
Tags: 
Database management systems
Computing
Data management
Relational database management systems
Software engineering
Subroutines
SQL
Stored procedure
SAS
Database
Microsoft SQL Server
Java stored procedure
Technology

PT2520 Unit 9 Clarence Gross 3/2/13 Threat analysis is about identifying all the ways the database can be harmed. True Accidental threats are as great a danger to a database as intentional ones. True A policy is a set of step by step instructions for accomplishing a task. False A procedure is a set of rules for how to do things. False A disaster recovery plan is a plan for how to recover data and availability after any of various disasters. True A stored procedure is one or more SQL statements grouped to be executed together. True Stored procedures can be used to enforce business rules and make transactions such as updates safer. True The syntax for stored procedures is the same in any database management system. False

PT 2520 Unit 8

Subject: 
Algebra
Rating: 
0
No votes yet
Tags: 
Relational database management systems
Computing
Data management
Filesystem permissions
Data
SQL
Role-based access control
Microsoft SQL Server
Technology

Jamel Travis 11/10/2012 Homework 8 Authorization is the process of assigning permissions to users. True Authentication is the process of assigning permissions to users. False In SQL Server, a login provides database level permissions. False In SQL Server, the USER is mapped to a login and assigned database permissions. True Permission is an action granted to a database user. True A role is a collection of related permissions True A role consists of ownership of database objects. False A schema consists of ownership of a database objects. True Permission to SELECT allows a user to view data. True Permission to UPDATE allows a user to add records to the database. True
Subscribe to RSS - Microsoft SQL Server

Need Help?

We hope your visit has been a productive one. If you're having any problems, or would like to give some feedback, we'd love to hear from you.

For general help, questions, and suggestions, try our dedicated support forums.

If you need to contact the Course-Notes.Org web experience team, please use our contact form.

Need Notes?

While we strive to provide the most comprehensive notes for as many high school textbooks as possible, there are certainly going to be some that we miss. Drop us a note and let us know which textbooks you need. Be sure to include which edition of the textbook you are using! If we see enough demand, we'll do whatever we can to get those notes up on the site for you!