SQL

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

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

Jamel Travis 10/27/2012 Homework Unit 5 Choosing a database management system requires a great deal of analysis. True When choosing a database management system, you should consider system compatibility and hardware requirements. True Only insert and update statements are part of a database transaction. False Physical design is a column specification that determines what kind of data can be stored in it. True A data type is a column specification that determines what kind of data can be stored in it. True Int, decimal and money are character numeric types. True Char and NChr are variable-length character types. True Varchar and NVarchar are based on the Unicode character types. False NChar and NVchar are based on the Unicode character set. True