168 Multiple choice questions

1. specify the possible range of values of the set, the operations that can be performed
   on the values, and the way in which the values are stored in memory.
   1. a View
   2. Money
   3. Data Type
   4. Character
2. 1.it binds the schema of referenced ob jects and columns to the schema of the referencing object.
   2. is available to views and UDFs
   1. What does the CASE statement create?
   2. A paramater name must begin with what?
   3. what does a user account provide?
   4. 1. SCHEMABINDING clause, purpose?
      2. when is it available?
3. all files are copied for possible future retrieval.
   1. A security plan identifies what?
   2. Numeric data types (2 types)
   3. In a full backup what happens? FULL BACKUP
   4. in an Incremental Backup, what takes place? INCREMENTAL
4. reverses changes
   1. What does ROLLBACK do?
   2. INTERSECT
   3. A full outer join
   4. what does Access control do?
5. each row of a table is loaded to locate the records needed to generate the results.
   1. timestamp
   2. datetime2
   3. An inner join
   4. In a table scan-
6. as a ROW in a table
   1. What does the word inclusion mean?
   2. Data types are assigned and stored where?
   3. What about an index should you avoid? and why?
   4. how is data about each instance of an entity stored in a relational database?
7. stores A-Z or 0-9-any digit or letter that math functions will not be applied to.
   1. Character
   2. INTERSECT
   3. An INDEX
   4. a Query
8. 1.You need to set a value for a column that stores values of the uniqueidentifier data type.
   2. you need to use the NEWID() function in the VALUES list to generate the value.
   1. The CREATE INDEX statement is a what statement?
   2. Which function do you use to provide the current date?
   3. Which columns do you need to set a value for when issuing an INSERT statement?
      When you do, which function do you need to apply and where?
   4. Which clause is REQUIRED when issuing an UPDATE statement?
9. Non-clustered index
   1. Which function do you use to provide the current date?
   2. The LIKE keyword is used in what?
   3. Which type of index has keywords & pointers to the data, but does not contain the actual data pages or records?
   4. what is one difference between an application role and a database role?
10. Use the GRANT statement to provide access according to
    their role.
    1. If you group users by roles which statement would you use and what would that do?
    2. The ORDER BY clause of a SELECT statement is used to?
    3. What does a WHERE clause in an UPDATE statement do?
    4. to control/change the physical sort order of a table what would you use?
11. deletes all rows from the table, but does not log each row deleted.
    1. The CREATE FUNCTION statement is used when?
    2. the EXCEPT operator
    3. What are TRANSACTIONS?
    4. The TRUNCATE TABLE statement does?
12. return a single value, calculated from values in a column.
    1. UNION
    2. A cross join
    3. Aggregate functions
    4. a self-join
13. is a saved query that creates a virtual table from the result set of the query
    1. a View
    2. Principals
    3. Securables
    4. datetime2
14. Allows whole numbers billion 4 bytes
    1. Boolean
    2. JOIN
    3. int
    4. Functions
15. is a specific set of instructions for extracting/selecting particular data.
    1. A login
    2. Boolean
    3. Money
    4. a Query
16. is an application, such as Microsoft Access, that is object-oriented and drag-and-drop driven.
    1. A cross join
    2. A login
    3. Principals
    4. a Graphical Designer
17. the COMMIT command records the changes to the database. if all statements are correct in a single transaction.
    1. Which clause is required when issuing an UPDATE statement?
    2. What are three (common) types of data integrity? and what do they focus on?
    3. In a VIEW what does the WITH CHECK OPTION clause do?
    4. If all statements are correct within a single transaction what command records it to the database?
18. The physical security plan Should include:
    location of servers with restricted entry access
    1. What does the word inclusion mean?
    2. What about an index should you avoid? and why?
    3. What should be included in the physical security plan? (SG)
    4. What does the ON DELETE NO ACTION option do?
19. (equals) = 1NF + removing subsets of data that apply to multiple rows of a table and place them in separate tables.
    1. A foreign key (SG)
    2. Normalizing 1st form
    3. The Second Normal Form (2NF)----(SG) GENERAL
    4. The INTERSECT query is used:
20. 1. you identify any columns that have the same value for more than a single primary key value and separate those columns into a different table.
    2.You then create foreign key relationships between the tables.
    1. What are characteristics of the Unicode data type?
    2. Normalizing a database to 2nd normal form. What 2 steps do you make?
    3. Normalizing 1st form
    4. to control/change the physical sort order of a table what would you use?
21. DML can be performed using the view, but only against one base table at a time.
    1. The CREATE INDEX statement is a what statement?
    2. The TRUNCATE TABLE statement does?
    3. In a VIEW what does the WITH CHECK OPTION clause do?
    4. in a view can DML statements be used? are there limitations?
22. are a set of two or more statements grouped into a single unit.
    1. What are TRANSACTIONS?
    2. Character
    3. A cross join
    4. Scalar functions
23. money data type stores data with the accuracy of four decimal points. It Requires 8 bytes of storage. The money data type supports values between -922,337,203,685,477.5808 and 922,337,203,685,477.5807.
    1. UNION
    2. A login
    3. Integer
    4. Money
24. provides users with access to the database.
    1. what does a user account provide?
    2. A scalar function
    3. Stored procedures
    4. What do Roles do, regarding security?
25. the @ character
    1. A paramater name must begin with what?
    2. A security plan identifies what?
    3. A primary key (SG)
    4. indexes are used to optimize what?
26. Allows whole numbers 8 bytes
    1. bigint
    2. IDENTITY
    3. int
    4. a View
27. a single entity (Tables are used to store inform ation about unique entities)
    1. how is data about each instance of an entity stored in a relational database?
    2. To m inim ize the am ount o f redundant data that is stored, you should design your tables to include only information about what?
    3. The SELECT INTO statement is used to do what? and what is important when issuing the SELECT INTO statement?
    4. The CREATE FUNCTION statement is used when?
28. A database role is assigned to users.
    1. What is ONE difference between application roles and database roles?
    2. What should be included in the physical security plan? (SG)
    3. The ON DELETE CASCADE option causes, what to happen?
    4. what is one difference between an application role and a database role?
29. SELECT DISTINCT
    1. in a view can DML statements be used? are there limitations?
    2. The command that would ensure that return visitors are only counted once is:
    3. The INSERT INTO statement is used (when?)
    4. The TRUNCATE TABLE statement does?
30. serves as the unique identifier of a specific row and uniquely defines a relationship
    within a database.
    1. A cross join
    2. a Graphical Designer
    3. time
    4. A primary key (SG)
31. INSERT INTO table (columnl, column2) VALUES (val1a, val1b), (val2a, val2b);
    1. What is meant by a data type- variable length
    2. What is the correct syntax for inserting multiple rows at one time?
    3. the INTERSECT operator is used to, what?
    4. Which function do you use to provide the current date?
32. c. creation of primary and foreign keys
    1. 1. Can you use a INTO clause with an UPDATE statement?
       2. When can a VALUES clause be used? (list two ways)
    2. Which strategy is not related to an INTERNAL security plan?
       a. provide backups and operational continuity
       b. delete old and unused user accounts
       c. enforce user accounts to have strong passwords
    3. Which clause is REQUIRED when issuing an UPDATE statement?
    4. Which of the following are not methods to manipulate data?
       a. select, insert, update, and delete
       b. creation of stored procedures and functions
       c. creation of primary and foreign keys
33. Because the TRUNCATE TABLE statement does not log each deletion, it is faster and requires fewer locks than the DELETE statement.
    The TRUNCATE TABLE statement requires fewer resources than the DELETE statement.
    1. The LIKE keyword is used in what?
    2. What does the CASE statement create?
    3. Differences between TRUNCATE and DELETE?
    4. The difference between UNION and JOIN is:
34. 1.an attribute value for an entity instance.
    2.A DML statement is a statement that retrieves, adds, deletes, or modifies a row of data in a table. You would use an UPDATE statement to modify the data in a row.
    1. If you group users by roles which statement would you use and what would that do?
    2. The TRUNCATE TABLE statement does?
    3. What does a WHERE clause in an UPDATE statement do?
    4. 1. You would issue a DML statement to set, what?
       2. DML statements do what?
35. returns only matched rows from the two tables.
    1. Principals
    2. Functions
    3. An inner join
    4. A full outer join
36. the CHECK constraints on the table are not considered,
    1. The CREATE INDEX statement is a what statement?
    2. when a view definition contains a join:
    3. When creating a view, are any constraints not considered? if so, What is one of those constraints?
    4. In a VIEW what does the WITH CHECK OPTION clause do?
37. the query performs a cross join and returns a Cartesian product.
    1. indexes are used to optimize what?
    2. When no join is provided in a query, what happens?
    3. A stored procedure can modify what?
    4. when you assign a DEFAULT value to a column?
38. which users can do what action(s) to data in the database.
    1. A security plan identifies what?
    2. A login is a what?
    3. indexes are used to optimize what?
    4. DELETE FROM (does what?)
39. Takes up more space but allows the use of multiple languages
    1. What are characteristics of the Unicode data type?
    2. A paramater name must begin with what?
    3. what does Access control do?
    4. What does a WHERE clause in an UPDATE statement do?
40. UPDATE RENTALS SET kayak = RENTALS.kayak + EQUIPMENT.kayak FROM RENTALS,
    EQUIPMENT
    1. To update data in one table from another table, the developer should use: (what syntax?) (Rentals,equipment)
    2. The CREATE FUNCTION statement is used when?
    3. The ORDER BY clause of a SELECT statement is used to?
    4. it is important that backup software should work with what?
41. VALUES clause is not valid for the UPDATE statement.
    2. The VALUES clause can be used with an INSERT statement to specify the values that should be inserted.
    1. in an Incremental Backup, what takes place? INCREMENTAL
    2. 1. Can you use a VALUES clause with an UPDATE statement?
       2. When can a VALUES clause be used?
    3. Which clause is required when issuing an UPDATE statement?
    4. a WHERE clause is used to do what, when updating.
       (whats an example?)
42. It is arranged similarly to the index of a book, where the index value points to the actual information.
    1. The LIKE keyword is used in what?
    2. How is a non-clustered index arranged? (SG)
    3. A primary key (SG)
    4. A foreign key (SG)
43. The timestamp data type does not store date and time information.
    1. Securables
    2. Character
    3. timestamp
    4. a View
44. rows related by a FOREIGN KEY constraint to be deleted when the referenced row is deleted.
    1. the INTERSECT operator is used to, what?
    2. DELETE FROM (does what?)
    3. The INTERSECT query is used:
    4. The ON DELETE CASCADE option causes, what to happen?
45. returns only distinct (unique) values.
    1. An INDEX
    2. Subqueries
    3. DISTINCT
    4. Permissions
46. to insert a new row in a table.
    1. The CREATE INDEX statement is a what statement?
    2. The INSERT INTO statement is used (when?)
    3. The INSERT INTO with SELECT statement is used (when?)
    4. the INTERSECT operator is used to, what?
47. server-scoped securable. Server-scoped securables are available across all database instances.
    1. A login is a what?
    2. bigint
    3. a View
    4. A foreign key (SG)
48. AND:displays a record if both the first condition and the second condition are true. OR:displays a record if either the first condition or the second conditions are true.
    Truth Tables:show the relationships of the Boolean logical operators.
    1. A column is used to store data for?
    2. A physical security plan does what?
    3. Boolean logical operators (AND,OR,Truth tables)
    4. Numeric data types (2 types)
49. 1.INTO clause is not valid for the UPDATE statement.
    2. he INTO clause can be used with a SELECT statement to insert the results into a new table.
    & It is also an optional keyword that can be specified in the syntax of an INSERT statement.
    1. 1. What is a structure for storing database indexes?
       2. In that structure, how are the database indexes stored?
    2. 1. Can you use a INTO clause with an UPDATE statement?
       2. When can a VALUES clause be used? (list two ways)
    3. The FROM clause is used in an UPDATE statement, when/used for?
    4. The INSERT INTO with SELECT statement is used (when?)
50. exact and approximate
    1. Data integrity (SG)
    2. The GROUP BY clause
    3. Data Type
    4. Numeric data types (2 types)
51. specifies the rows to update. (also, used to specify criteria)
    1. Data types are assigned and stored where?
    2. Which clause is REQUIRED when issuing an UPDATE statement?
    3. what does Access control do?
    4. What does a WHERE clause in an UPDATE statement do?
52. locked records
    1. The command that returns an alphabetical list is:
    2. in an Incremental Backup, what takes place? INCREMENTAL
    3. the INTERSECT operator is used to, what?
    4. it is important that backup software should work with what?
53. ensures and restricts who can connect and what they can do.
    1. what does Access control do?
    2. the EXCEPT operator
    3. What does the CASE statement create?
    4. Backup is a process of what?
54. by ensuring that each piece of data in the table depends only on the primary key. each attribute must be related to the primary key in order to be in the 3rd form.
    1. How does the third normal form (3NF) take normalization a step further than 2NF?
    2. The Second Normal Form (2NF)----(SG) GENERAL
    3. What does a WHERE clause in an UPDATE statement do?
    4. What does the ON DELETE NO ACTION option do?
55. Application roles are not granted and revoked like database roles.
    1. What is ONE difference between application roles and database roles?
    2. What does the CASE statement create?
    3. primary difference between a function and a stored procedure is
    4. the INTERSECT operator is used to, what?
56. B! has keywords and pointers to the data
    1. 1. What is the value of the case expression?
       2. What is the result if none is true?
    2. How is a non-clustered index arranged? (SG)
    3. 1. What is a structure for storing database indexes?
       2. In that structure, how are the database indexes stored?
    4. Which is a characteristic of a non-clustered index?
       a. contains the actual data pages or records
       b. has keywords and pointers to the data
       c. includes foreign keys
57. grant permissions to the database. Defined roles give all users within a group the same permissions.
    1. UPDATE is used to what?
    2. What does ROLLBACK do?
    3. What do Roles do, regarding security?
    4. What are TRANSACTIONS?
58. UPDATE RENTALS SET value _ added _ tax = .10
    1. You can update data if a condition is true and perform an alternative update if the condition is false with the:____statement
    2. The ORDER BY clause of a SELECT statement is used to?
    3. How can a database of addresses be simplified?
    4. To update all records in a database to reflect an increase in value-added tax from 8 percent to 10 percent the developer should use:
59. 1. used to add rows to a different table.
    2. the table must be empty when you execute the query
    1. The CREATE INDEX statement is a what statement?
    2. The SELECT INTO statement is used to do what? and what is important when issuing the SELECT INTO statement?
    3. What are three (common) types of data integrity? and what do they focus on?
    4. Do you need to set a value for a column that has a DEFAULT constraint when issuing an INSERT statement?
60. C! increased speed of writing records
    1. Which is Not a result of using indexes?
       a. increased speed of data retrieval
       b. increased storage requirements
       c. increased speed of writing records
    2. What is the correct syntax for inserting multiple rows at one time?
    3. Which clause is required when issuing an UPDATE statement?
    4. Which is a characteristic of a non-clustered index?
       a. contains the actual data pages or records
       b. has keywords and pointers to the data
       c. includes foreign keys
61. allows you to perform an aggregate calculation over rows that have a matching value in a column.
    1. The GROUP BY clause
    2. a Query
    3. In a table scan-
    4. A primary key (SG)
62. columns that are frequently used as join conditions, in WHERE clauses, and in GROUP BY clauses as key columns in an index
    1. you can give the query optimizer a more efficient way to locate the rows required to generate the results by selecting certain columns, which kinds of columns?
    2. You define an output parameter by using, which keyword?
    3. Which function do you use to provide the current date?
    4. the INTERSECT operator is used to, what?
63. to return only the rows that appear in both tables, similar to a Boolean AND
    1. The INTERSECT query is used:
    2. INTERSECT
    3. the EXCEPT operator
    4. A predicate subquery:
64. 1. a DDL statement that is used to modify the definition of an existing view.
    2. Adding a WHERE clause to the view's definition will ensure that only the rows that meet the WHERE clause condition are visible through the view.
    1. The ORDER BY clause of a SELECT statement is used to?
    2. in a view can DML statements be used? are there limitations?
    3. The CREATE FUNCTION statement is used when?
    4. 1. The ALTER VIEW statement is?
       2. adding a WHERE clause does what in a view?
65. optimize frequently-used queries by reducing the number of table scans required to locate data.
    1. Backup is a process of what?
    2. What does the word inclusion mean?
    3. A column is used to store data for?
    4. indexes are used to optimize what?
66. DEFAULT is specified for a column to assign a column a specific value if no value is specified when a row is added.
    1. when you assign a DEFAULT value to a column?
    2. What about an index should you avoid? and why?
    3. the INTERSECT operator is used to, what?
    4. what does Access control do?
67. the SET clause
    1. A stored procedure can modify what?
    2. What does a WHERE clause in an UPDATE statement do?
    3. What does the CASE statement create?
    4. Which clause is REQUIRED when issuing an UPDATE statement?
68. are the individuals, groups, and processes granted access to SQL Server
    1. timestamp
    2. DISTINCT
    3. Principals
    4. Securables
69. prevents rows that are referenced through a FOREIGN KEY constraint from being deleted. (Cascade related)
    1. What does the CASE statement create?
    2. What does the word inclusion mean?
    3. What does the ON DELETE NO ACTION option do?
    4. what does a user account provide?
70. are the server, database, and objects a database contains
    1. Principals
    2. Securables
    3. a Query
    4. time
71. addresses the safety of the actual location of the database.
    1. A physical security plan does what?
    2. A column is used to store data for?
    3. A full outer join
    4. A scalar function
72. deletes rows in a table
    1. A login is a what?
    2. DELETE FROM (does what?)
    3. INTERSECT
    4. the EXCEPT operator
73. A login is a server-level object that is used to grant the ability to establish a connection with an instance of SQL Server.
    1. time
    2. A cross join
    3. A login
    4. a self-join
74. performs an operation and returns a single value. (a function can't perform any modification on a permanent table)
    1. A scalar function
    2. a self-join
    3. Scalar functions
    4. A table-valued function
75. The datetimeoffset data type stores the date and time, including an offset from Greenwich Mean Time (GMT).
    1. DISTINCT
    2. timestamp
    3. datetimeoffset
    4. Functions
76. to create a user-defined function. User-defined functions must return a value.
    1. the INTERSECT operator is used to, what?
    2. The TRUNCATE TABLE statement does?
    3. The ORDER BY clause of a SELECT statement is used to?
    4. The CREATE FUNCTION statement is used when?
77. they allow multiple statements to be grouped together to avoid data integrity errors
    1. What does a WHERE clause in an UPDATE statement do?
    2. Transactions are useful when updating/deleting/adding records to a database because:
    3. what is one difference between an application role and a database role?
    4. primary difference between a function and a stored procedure is
78. To users and groups
    1. UPDATE is used to what?
    2. A database role is assigned to who?
    3. What does the word inclusion mean?
    4. Data types are assigned and stored where?
79. 1. a column represents a single entity attribute.
    2. The entity is represented with a table, and its attributes are represented by columns within the table.
    1. it is important that backup software should work with what?
    2. The CREATE INDEX statement is a what statement?
    3. 1. In a well-designed relational database table, a column represents what?
       2. The entity is represented how?
    4. The condition that always results in true is:
80. DDL
    1. The CREATE FUNCTION statement is used when?
    2. The INTERSECT query is used:
    3. The CREATE INDEX statement is a what statement?
    4. the INTERSECT operator is used to, what?
81. The SET clause ( You specify the columns or variables that should be updated and, when a FROM clause is not also used, their values.)
    1. Which clause is required when issuing an UPDATE statement?
    2. The LIKE keyword is used in what?
    3. What does the word inclusion mean?
    4. A database role is assigned to who?
82. NO
    1. Boolean logical operators (AND,OR,Truth tables)
    2. it is important that backup software should work with what?
    3. Replicated services, do? REPLICATED SERVICES
    4. Is Combining informational columns, part of the normalization process?
83. Can assign a certain number to it, if that number is not reached the remaining space is not used.
    1. What does the CASE statement create?
    2. What is meant by a data type- variable length
    3. indexes are used to optimize what?
    4. How is a Clustered index arranged? (SG)
84. only files that have been changed since the last backup are copied.
    1. In a full backup what happens? FULL BACKUP
    2. The CREATE INDEX statement is a what statement?
    3. in an Incremental Backup, what takes place? INCREMENTAL
    4. A stored procedure what type of securable?
85. data type store whole numbers
    1. Integer
    2. An INDEX
    3. int
    4. datetime2
86. data types store any real number
    1. JOIN
    2. DISTINCT
    3. Floating-Point
    4. UNION
87. sets a few basic rules for a database: eliminate duplicative columns from the same table.
    1. The GROUP BY clause
    2. a Graphical Designer
    3. A foreign key (SG)
    4. The First Normal Form (1NF)----(SG). GENERAL
88. 1. entity focuses on the primary key,
    2. referential focuses on the foreign key
    3. domain specifies that values must be declared.
    1. What is the correct syntax for inserting multiple rows at one time?
    2. What are three (common) types of data integrity? and what do they focus on?
    3. The ON DELETE CASCADE option causes, what to happen?
    4. The CREATE FUNCTION statement is used when?
89. a single attribute of an entity.
    1. Backup is a process of what?
    2. what does Access control do?
    3. A database role is assigned to who?
    4. A column is used to store data for?
90. The GROUP BY clause.
    1. to control/change the physical sort order of a table what would you use?
    2. Which clause is specified first? the ORDER BY clause and the GROUP BY clause?
    3. The ON DELETE CASCADE option causes, what to happen?
    4. What are characteristics of the Unicode data type?
91. order the results of a query.
    1. The FROM clause is used in an UPDATE statement, when/used for?
    2. The INSERT INTO with SELECT statement is used (when?)
    3. The INTERSECT query is used:
    4. The ORDER BY clause of a SELECT statement is used to?
92. are precompiled groups of SQL statements saved to the database.
    1. INTERSECT
    2. Stored procedures
    3. Integer
    4. Permissions
93. store numbers with a fixed scale and precision. The precision is the total number of digits, including those to the left of the decimal and to the right of the decimal.
    1. Is Combining informational columns, part of the normalization process?
    2. Both the decimal and numeric data types allow you to?
       What is precision?
    3. The CREATE INDEX statement is a what statement?
    4. Data types are assigned and stored where?
94. to filter which rows will be updated.
    (SET LastUpdateDt = getdate(), CreditLimit = 2500 WHERE CustID = 893)
    1. Which clause is REQUIRED when issuing an UPDATE statement?
    2. The ON DELETE CASCADE option causes, what to happen?
    3. The FROM clause is used in an UPDATE statement, when/used for?
    4. a WHERE clause is used to do what, when updating.
       (whats an example?)
95. returns all rows in the results generated by the query on the left-hand side that are not included in the results generated by the query on the right-hand side.
    1. INTERSECT
    2. timestamp
    3. A cross join
    4. the EXCEPT operator
96. an explicit transaction.
    1. The CREATE FUNCTION statement is used when?
    2. To ensure that either both DELETE statements are successful or both fail, you can use what?
    3. The CREATE INDEX statement is a what statement?
    4. The INSERT INTO with SELECT statement is used (when?)
97. Application roles allow access to database objects, but only through an application. Application roles are not assigned to users. Instead, a single login is
    associated with an application.
    1. What does the word inclusion mean?
    2. What does ROLLBACK do?
    3. A database role is assigned to who?
    4. What do application roles allow access to?
98. are one-word commands that return a single value written in the command set of SQL.
    1. Functions
    2. Permissions
    3. DISTINCT
    4. int
99. is used when a column references another column in the same table.
    1. a View
    2. JOIN
    3. A login
    4. a self-join
100. to return a list of only the rows that are in both of the result sets generated by two other separate queries.
     1. The CREATE FUNCTION statement is used when?
     2. A stored procedure can modify what?
     3. the INTERSECT operator is used to, what?
     4. indexes are used to optimize what?
101. 1.An additional table added When you have a many-to-many relationship.
     2.references the primary key of the table on the one side of the relationship and another column that references the primary key of the table on the other side of the relationship.
     1. What should be included in the physical security plan? (SG)
     2. What do application roles allow access to?
     3. Which function do you use to provide the current date?
     4. What is a junction or intersection table.
        The table contains columns that references what?
102. CASE statement
     1. You can update data if a condition is true and perform an alternative update if the condition is false with the:____statement
     2. What is meant by a data type- variable length
     3. Which clause is REQUIRED when issuing an UPDATE statement?
     4. Which function do you use to provide the current date?
103. returns a Cartesian product (a result in which each combination of rows is represented).
     1. A cross join
     2. UNION
     3. Character
     4. Permissions
104. combines two or more SELECT statements with an AND function.
     1. int
     2. time
     3. INTERSECT
     4. a Query
105. OUTPUT keyword
     1. The LIKE keyword is used in what?
     2. You define an output parameter by using, which keyword?
     3. What do Roles do, regarding security?
     4. The Second Normal Form (2NF)----(SG) GENERAL
106. Storing the zip code only in the primary table and creating a separate table of city, state, and zip.
     1. How can a database of addresses be simplified?
     2. What does the word inclusion mean?
     3. What does the CASE statement create?
     4. Numeric data types (2 types)
107. You would use the CREATE INDEX statement to create a clustered index if you wanted to change the physical sort order of a table. (optimize data retrieval)
     1. The TRUNCATE TABLE statement does?
     2. to control/change the physical sort order of a table what would you use?
     3. What are characteristics of the Unicode data type?
     4. it is important that backup software should work with what?
108. A! provide backups and operational continuity.
     ---it is not related to the INTERNAL security plan.
     1. what does a user account provide?
     2. Normalizing a database to 2nd normal form. What 2 steps do you make?
     3. Which strategy is not related to an INTERNAL security plan?
        a. provide backups and operational continuity
        b. delete old and unused user accounts
        c. enforce user accounts to have strong passwords
     4. Which clause is specified first? the ORDER BY clause and the GROUP BY clause?
109. The smallmoney data type supports values between -214,748.3648 and 214,748.3647. All values are stored with accuracy to four decimal points. The smallmoney data type requires 4 bytes of storage capacity.
     1. What do application roles allow access to?
     2. The condition that always results in true is:
     3. it is important that backup software should work with what?
     4. smallmoney (supports, stored to what decimal point, requires how much storage)
110. is the result of structuring (organizing) information to avoid redundancy and inconsistency and to promote efficient maintenance, storage, and updating.
     1. Normal Form (Study guide answer). What does it try to avoid? What does it promote?
     2. What does the ON DELETE NO ACTION option do?
     3. The CREATE INDEX statement is a what statement?
     4. In a VIEW what does the WITH CHECK OPTION clause do?
111. is used to query data from two or more tables.
     1. A login
     2. DISTINCT
     3. Money
     4. JOIN
112. It is arranged in a special order to make retrieval of information faster with direct access to the information.
     1. A database role is assigned to who?
     2. User-defined functions
     3. How is a Clustered index arranged? (SG)
     4. A foreign key (SG)
113. are compact segments of user-written SQL code that can accept parameters and return either a value or a table.
     1. Scalar functions
     2. A table-valued function
     3. Permissions
     4. User-defined functions
114. selects data and returns the results as a table.
     1. User-defined functions
     2. Functions
     3. A table-valued function
     4. Aggregate functions
115. stores 1 or 0, true or false
     1. Boolean
     2. int
     3. An INDEX
     4. Principals
116. when all statements in a transaction have successfully completed, issuing a commit statement
     1. A programmer can enforce data integrity rules when making changes to the records in a database by:
     2. primary difference between a function and a stored procedure is
     3. A stored procedure what type of securable?
     4. You define an output parameter by using, which keyword?
117. return a single value, based on the input value of a single field.
     1. Scalar functions
     2. What are TRANSACTIONS?
     3. a Query
     4. Subqueries
118. creates when-then-else functionality.
     Give an example using the WHEN and THEN?
     (WHEN this condition is met THEN do this.)
     1. What does the CASE statement create?
     2. The INSERT INTO statement is used (when?)
     3. The LIKE keyword is used in what?
     4. A paramater name must begin with what?
119. use the INSERT INTO with a SELECT...FROM clause
     1. The CREATE INDEX statement is a what statement?
     2. A stored procedure what type of securable?
     3. The ON DELETE CASCADE option causes, what to happen?
     4. To set up the INSERT to allow the programmer to copy rows from other tables:
120. you do not need to set a value for a column that has a DEFAULT constraint. If the value is not specified, the value determined by the DEFAULT constraint is used.
     1. in an Incremental Backup, what takes place? INCREMENTAL
     2. The ORDER BY clause of a SELECT statement is used to?
     3. Which columns do you need to set a value for when issuing an INSERT statement?
        When you do, which function do you need to apply and where?
     4. Do you need to set a value for a column that has a DEFAULT constraint when issuing an INSERT statement?
121. The time data type stores only time information up to 100 nanosecond accuracy. It does not store a time zone offset.
     1. Boolean
     2. time
     3. Integer
     4. IDENTITY
122. the database must be available 24 hours a day, 7 days a week
     1. In which situation is the use of a replication service recommended?
     2. when you assign a DEFAULT value to a column?
     3. Which clause is REQUIRED when issuing an UPDATE statement?
     4. What is meant by a data type- variable length
123. references the primary key in another table.
     1. Stored procedures
     2. An INDEX
     3. A login
     4. A foreign key (SG)
124. avoid large index keys for more optimal performance.
     1. What does the ON DELETE NO ACTION option do?
     2. What about an index should you avoid? and why?
     3. What does the CASE statement create?
     4. What does the word inclusion mean?
125. a schema-scoped securable. A schema-scoped securable is one that is created within a schema and can receive permissions through that schema.
     1. indexes are used to optimize what?
     2. A stored procedure what type of securable?
     3. What do Roles do, regarding security?
     4. The GROUP BY clause
126. 1. b-tree structure.
     2. each node in the tree contains a sorted list of key values and links that correspond to ranges of key values between the listed values.
     1. What is the correct syntax for inserting multiple rows at one time?
     2. The CREATE INDEX statement is a what statement?
     3. Which is Not a result of using indexes?
        a. increased speed of data retrieval
        b. increased storage requirements
        c. increased speed of writing records
     4. 1. What is a structure for storing database indexes?
        2. In that structure, how are the database indexes stored?
127. automatically assign sequential integer values to a column.
     1. timestamp
     2. DISTINCT
     3. IDENTITY
     4. time
128. is used to update rows in a table based on information stored in another table.
     1. What does a WHERE clause in an UPDATE statement do?
     2. The INSERT INTO with SELECT statement is used (when?)
     3. The FROM clause is used in an UPDATE statement, when/used for?
     4. Which clause is required when issuing an UPDATE statement?
129. re-create a full or incremental reproduction of the database.
     1. A physical security plan does what?
     2. Replicated services, do? REPLICATED SERVICES
     3. What do Roles do, regarding security?
     4. The INTERSECT query is used:
130. Security Attacks
     1. The LIKE keyword is used in what?
     2. A security plan identifies what?
     3. privilege escalation and SQL injections are examples of what?
     4. How can a database of addresses be simplified?
131. combines two or more SELECT statements with an OR function.
     1. UNION
     2. a View
     3. A login
     4. Functions
132. DML statements can be performed using the view, but only on a single base table.
     1. A full outer join
     2. what does a user account provide?
     3. when you assign a DEFAULT value to a column?
     4. when a view definition contains a join:
133. (equals) = 2NF + removing columns that are not dependent upon the primary key.
     1. The Third Normal Form (3NF)----(SG) GENERAL
     2. What does the word inclusion mean?
     3. The INTERSECT query is used:
     4. The Second Normal Form (2NF)----(SG) GENERAL
134. you can override by using SET IDENTITY_INSERT to turn the identity insert option ON. After you issue the INSERT statement, you should turn identity insert OFF because only a single table can be enabled for identity insert within a session.
     1. You define an output parameter by using, which keyword?
     2. how is data about each instance of an entity stored in a relational database?
     3. By, default you can't specify a value for an identity column within an INSERT statement. Can you override that default? if so, how?
     4. Boolean logical operators (AND,OR,Truth tables)
135. 1. a RETURNS clause and a RETURN statement.
     2. RETURN clause, to specify the type of data that will be returned by the function.
     3. RETURN statement is used to return the value from the function.
     1. 1. A user-defined function must contain which clause AND which statement?
        2. What does the clause do?
        3. what does the statement do?
     2. A paramater name must begin with what?
     3. Which columns do you need to set a value for when issuing an INSERT statement?
        When you do, which function do you need to apply and where?
     4. The CREATE FUNCTION statement is used when?
136. the INSERT statement uses the default value for the column
     1. when you assign a DEFAULT value to a column?
     2. When data is missing from a particular column, if you use the INSERT statement what happens to those column?
     3. Which clause is required when issuing an UPDATE statement?
     4. Which columns do you need to set a value for when issuing an INSERT statement?
        When you do, which function do you need to apply and where?
137. the or operator and at least one field = true
     1. The condition that always results in true is:
     2. The LIKE keyword is used in what?
     3. What does the CASE statement create?
     4. The INTERSECT query is used:
138. the data in permanent tables and return multiple values as output parameters.
     1. A stored procedure can modify what?
     2. Backup is a process of what?
     3. A stored procedure what type of securable?
     4. A login is a what?
139. ensures that data is consistent, correct, and usable throughout the database.
     1. A cross join
     2. Integer
     3. Data integrity (SG)
     4. An inner join
140. Normalizing to INF requires that you eliminate repeating groups.
     1. A primary key (SG)
     2. A scalar function
     3. Normalizing 1st form
     4. Functions
141. involves applying a body of techniques to a relational database to minimize the inclusion of
     duplicate information.
     1. Floating-Point
     2. Normalization-(from study guide)
     3. A foreign key (SG)
     4. A scalar function
142. ...
     1. In a table scan-
     2. IDENTITY
     3. a self-join
     4. DEFAULT constraint
143. differential backup
     1. In a VIEW what does the WITH CHECK OPTION clause do?
     2. The backup strategies that only copies files that have changed since the last full backup is:
     3. in an Incremental Backup, what takes place? INCREMENTAL
     4. The command that returns an alphabetical list is:
144. CHECK is specified for a column to ensure that all column values meet a specified condition, such as falling within a specified range of values.
     1. The TRUNCATE TABLE statement does?
     2. when you assign a CHECK (constraint) value to a column?
     3. The ON DELETE CASCADE option causes, what to happen?
     4. When no join is provided in a query, what happens?
145. Add an Index! (large number of records, the benefits of adding an index out-weighs the necessary time and effort!)
     1. If you group users by roles which statement would you use and what would that do?
     2. To update data in one table from another table, the developer should use: (what syntax?) (Rentals,equipment)
     3. If a database will contain a large number of records, what should you think about adding, even if it requires more time and effort to do?
     4. The ON DELETE CASCADE option causes, what to happen?
146. the getdate() function
     1. Which function do you use to provide the current date?
     2. What does the CASE statement create?
     3. The CREATE FUNCTION statement is used when?
     4. When no join is provided in a query, what happens?
147. ORDER BY column _ name (either ASC or DESC)
     1. What does a WHERE clause in an UPDATE statement do?
     2. The command that returns an alphabetical list is:
     3. The condition that always results in true is:
     4. What do application roles allow access to?
148. are granted to a principal for every SQL Server securable
     1. Permissions
     2. bigint
     3. int
     4. A login
149. Only files that have been changed since the last full_backup are copied.
     1. a differential backup, back ups what? DIFFERENTIAL
     2. In a full backup what happens? FULL BACKUP
     3. A physical security plan does what?
     4. DELETE FROM (does what?)
150. saving all critical data to re-create the database in useful form in a relatively short time.
     1. A login is a what?
     2. In a table scan-
     3. DELETE FROM (does what?)
     4. Backup is a process of what?
151. the data from the table is deleted
     1. The FROM clause is used in an UPDATE statement, when/used for?
     2. The CREATE INDEX statement is a what statement?
     3. If you group users by roles which statement would you use and what would that do?
     4. If you do not include a WHERE statement in the DELETE statement: what happens?
152. the WHERE clause of a SELECT statement to return results with character column values that contain specific characters or specific character strings.
     1. The INTERSECT query is used:
     2. A login is a what?
     3. The LIKE keyword is used in what?
     4. What does the word inclusion mean?
153. The act or state of being included into a group or structure (a larger group). TO INCLUDE SOMEONE!
     1. Backup is a process of what?
     2. What does the word inclusion mean?
     3. What do Roles do, regarding security?
     4. what does a user account provide?
154. The datetime2 data type stores date and time information at user- defined precision. However, it does not store a time zone offset.
     1. datetime2
     2. Functions
     3. a View
     4. time
155. to insert a new row in a table when a sub-select is used instead of the VALUES clause.
     1. The ORDER BY clause of a SELECT statement is used to?
     2. The TRUNCATE TABLE statement does?
     3. What does the CASE statement create?
     4. The INSERT INTO with SELECT statement is used (when?)
156. that a function can be directly referenced in a SELECT statement. A stored procedure cannot be directly referenced in a SELECT statement or expression.
     1. primary difference between a function and a stored procedure is
     2. what is one difference between an application role and a database role?
     3. Data types are assigned and stored where?
     4. The CREATE FUNCTION statement is used when?
157. used to ensure that no changes to the underlying data can be made through the view that would cause the data to not conform to the view's definition.
     1. what does a user account provide?
     2. indexes are used to optimize what?
     3. What does ROLLBACK do?
     4. In a VIEW what does the WITH CHECK OPTION clause do?
158. UNION combines the results of two queries (note: must have same number of columns and data types)
     JOIN returns rows when there is at least one column match
     1. The LIKE keyword is used in what?
     2. The INTERSECT query is used:
     3. The TRUNCATE TABLE statement does?
     4. The difference between UNION and JOIN is:
159. 1. each column to be updated, along with..
     2. an assignment operator (=) and the value to which the column should be updated.
     1. What does a WHERE clause in an UPDATE statement do?
     2. Which clause is REQUIRED when issuing an UPDATE statement?
     3. The SET clause includes what, to be updated? (list two things)
     4. The FROM clause is used in an UPDATE statement, when/used for?
160. B. server files such as user security NAT
     1. The command that would ensure that return visitors are only counted once is:
     2. 1. Can you use a INTO clause with an UPDATE statement?
        2. When can a VALUES clause be used? (list two ways)
     3. When performing a full backup, what information is optional?
        a. data that has not changed
        b. server files such as user security NAT
        c. data that has not changed since the last full backup
     4. it is important that backup software should work with what?
161. uses extended logical constructs in the WHERE clause using AND, OR, LIKE, BETWEEN, AS, and TOP
     1. A predicate subquery:
     2. INTERSECT
     3. a Graphical Designer
     4. A primary key (SG)
162. A column (is assigned a data type)
     1. What does the CASE statement create?
     2. Backup is a process of what?
     3. What are TRANSACTIONS?
     4. Data types are assigned and stored where?
163. update existing records in a table.
     1. UPDATE is used to what?
     2. A login is a what?
     3. An inner join
     4. DELETE FROM (does what?)
164. 1. the value of the first WHEN clause that is true.
     2. if non is true, the result is the ELSE.
     1. What does the CASE statement create?
     2. 1. What is the value of the case expression?
        2. What is the result if none is true?
     3. What are three (common) types of data integrity? and what do they focus on?
     4. What does a WHERE clause in an UPDATE statement do?
165. the changes are automatically saved to the database if the statement is successful. So if you issue two statements at once and only one is successful, by default only the one would be implemented to the database.
     1. in a view can DML statements be used? are there limitations?
     2. What is ONE difference between application roles and database roles?
     3. What does a WHERE clause in an UPDATE statement do?
     4. If you have two DELETE statements, deleting rows from separate tables. By default when you execute a DML statement (such as DELETE) what happens automatically?
166. nest inside another query.
     1. UNION
     2. datetime2
     3. Subqueries
     4. Integer
167. returns all matching rows from both tables and all unmatched rows.
     1. An inner join
     2. DEFAULT constraint
     3. A full outer join
     4. a self-join
168. What contains 'keywords' and 'associated data' that point to the 'location' of more comprehensive information, (such as files and records on a disk or record keys in a database.)
     1. JOIN
     2. int
     3. A login
     4. An INDEX