NAME

Question types


Start with


Question limit

of 235 available terms

Print test

235 True/False questions

  1. ORDER BYTo cause the result set to be sorted by the value in a specific column or columns. Not allowed in a CREATE VIEW Statement.

          

  2. INSERTAdds one or more new rows to a table or a view in SQL Server. Must contain a table or view name into which to insert the data. Can be used to insert explicit values into a table or to insert the result set returned by a query into a table.

          

  3. three things you need to be sure to identify in your statement to form a proper SELECT query:• Columns to retrieve
    • Tables to retrieve the columns from
    • Conditions, if any, that the data must satisfy

          

  4. CREATE TYPEused to create a user-defines data type or an alias data type.

          

  5. How do you gather the size of a file?1MB = 1024KB
    1 record is 165 bytes - Multiply by amt of records.

          

  6. A ____ will combine the results of two or more queries into a resulting set that includes all the rows belonging to the query:ALTER TABLE tablename
    ENABLE CHANGE_TRACKING

          

  7. What is DB prototyping?This is a column in one table that points to the primary key in another table(defines relationship between two tables). Ensures domain and referential integrity, not entity integrity. There is not a predefined limit for foreign keys.

          

  8. SQL injectionis a database object that can accept values, perform a calculation and return the result to the caller. Can be directly referenced using a SELECT statement.

          

  9. server-scoped securableAvailable across all database instances(network)(LOGIN)

          

  10. What is native auditing?Non-clustered indexes are not copies of the table but a sorting of the columns you specify that "point" back to the data pages in the clustered index. Add non-clustered indexes for queries that return smaller result sets. (Optimal Performance)

          

  11. UPDATERemoves rows from a table or view(, which deletes data from within a table) Use for smaller databases

          

  12. What does ANSI SQL syntax refer to?The number of columns.

          

  13. What is abstraction?This is a column in one table that points to the primary key in another table(defines relationship between two tables). Ensures domain and referential integrity, not entity integrity. There is not a predefined limit for foreign keys.

          

  14. What command would you use to track changes to a table?SELECT AVG("column name") FROM "table name"

          

  15. What is TRANSACT-SQLThis is the primary means of programming and manageing SQL Server. When you use an SSMS to perform an action, it is using T-SQL commands in the background to do the work.

          

  16. Scalar functionReturns a single value, based on the input value of a single field(EX: UCASE - Returns the value of the field in all upper case).

          

  17. Exact numeric data typesare the most common SQL Server data types used to store numeric information.

          

  18. covering indexCreates a SQL Server database object (table, view, or stored procedure)

          

  19. What does the REPLACE function do?It's used on the primary key to automatically start with 1 and auto-increment by 1.

          

  20. What is a two-phase commit system?Specifically identifies which column should not contain duplicate values.

          

  21. Full-Text indexCreates a full-text index on a table or indexed view in a database. Only one full-text index is allowed per table or indexed view, and each full-text index applies to a single table or indexed view

          

  22. What is a clustered index?Large amount of selects on a table, create a clustered index on the primary key of the table. This index should be the most common column that is in your WHERE clauses for queries against this table. So if most of the time you search by primary key, then leave it as the default. But if you search by DateCreated or LastName most of the time on this table, then you might want to consider changing the clustered index to this column instead. Each table can only have 1 clustered index. (faster searching)

          

  23. HAVING clauseto filter the results grouped by a GROUP BY clause. Can only reference aggregate functions or column that are also specified in the GROUP BY clause.

          

  24. DiskadminCan create, alter, and drop disk files. This is a Fixed server role

          

  25. OPTIONused to specify query hints that will allow for optimization of a query's execution.

          

  26. What is XQuery?A query and functional programming language designed to query collections of XML data.

          

  27. Name 4 types of decompositionTop-down, Bottom-up, Inside-out, Mixed

          

  28. A bit is the T-SQL integer data type that can take a ___ of 1, 0 or NULL.A type of bottom-up approach, the inside-out method begins with identifying a few important concepts then proceeds outward radially.

          

  29. What's the most efficient way to delete all rows from a table?When creating a stored procedure, this can be used to allow the person running the SP to have the same permissions as the person who owns the SP. This is better than granting SELECT to the user.

          

  30. You would include a HAVING clause in a query to:The number of columns.

          

  31. Define 5NFIsolate semantically related multiple relationships

          

  32. Data Typesused to optimize operations that use spatial data types, such as geometry and geography data types.

          

  33. sysobjectsAdds one or more new rows to a table or a view in SQL Server. Must contain a table or view name into which to insert the data. Can be used to insert explicit values into a table or to insert the result set returned by a query into a table.

          

  34. DBCC CHECKDBTo check all pages in a DB are correctly allocated

          

  35. A Parameter name must begin withused to define a clustered or non clustered index.

          

  36. What are the three methods for whicha user can be initially identified?1. If a view definition contains the DISTINCT keyword, rows cannot be deleted through the view.
    2. The WITH OBJECT IDENTIFIER clause is used to specify a top level (root) object view.
    3. The OR REPLACE option is used to change the definition of a existing view without dropping and recreating.

          

  37. Cross Joinsreturns a result set that contains all the combinations of rows from two tables that do not have a column in common, also know as a Cartesian product. WHERE conditions should always be included.

          

  38. SQL Server utility can view what entitiesInstances of SQL server, Data-Tier apps, Databse Files, Volumes

          

  39. When is the best time to back up dynamic log files?When the server is stopped.

          

  40. What command do you use to invoke a stored procedure?A function can be directly referenced in a select statement, and return only a single scalar or table vaule.

          

  41. primary drawbacks to using indexesLarge amount of selects on a table, create a clustered index on the primary key of the table. This index should be the most common column that is in your WHERE clauses for queries against this table. So if most of the time you search by primary key, then leave it as the default. But if you search by DateCreated or LastName most of the time on this table, then you might want to consider changing the clustered index to this column instead. Each table can only have 1 clustered index. (faster searching)

          

  42. All users are automatically members of the ______ database role.Relationship; Enforces referential integrity

          

  43. DELETERemoves rows from a table or view(, which deletes data from within a table) Use for smaller databases

          

  44. Which of the following statements are true regarding the procedural data manipulation language?A function can be directly referenced in a select statement, and return only a single scalar or table vaule.

          

  45. What is the With Execute Owner clause?When the foreign key refers to columns in the same table.

          

  46. two major reasons you might want to provide a view instead of enabling users to access the underlying tables in your database:A primary key, a UNIQUE index and a CLUSTERED index

          

  47. A user-defined functionReturns a single value, based on the input value of a single field(EX: UCASE - Returns the value of the field in all upper case).

          

  48. UPDATE clauseallows you to modify data stored in tables using data attributes. Note: If you don't specify what records to update, all records or rows will be updated with the new value. To update another table use FROM clause. In this, SET specifies column to be updated.

          

  49. PERSISTENT clausegives you the final result set where values in both of the queries match by the query on both the left and right sides of the operand.
    • The number and order of the columns must be the same in all queries.
    • The data types must be compatible.

          

  50. relational databaseupdate columns with calculated values

          

  51. A unicode characters uses how much storage?Specifically identifies which column should not contain duplicate values.

          

  52. A regular character uses how much storage?1. It does not have any usage of SQL group functions or grouping of data.
    2. DML operations are allowed on the view
    3. It fetches data from one database table only

          

  53. DBCC CHECKFILEGROUPIsolate independent multiple relationships

          

  54. What clause is required when issuing a UPDATE statementA function

          

  55. ALTER TABLEModifies a table definition by altering, adding, or dropping columns and constraints, reassigning partitions or disabling or enabling constraints and triggers.(cannot change IDENTITY constraint)

          

  56. DROPA DDL statement used to remove objects, such as tables, views, stored procedures, and triggers , from a database.

          

  57. SetupadminCan create, alter, and drop disk files. This is a Fixed server role

          

  58. .WRITEremoves user access rights or privileges on the database objects granted using the GRANT statement, but does not prevent permissions from being obtained through membership in other roles.

          

  59. What is the CHECK constraint?Used to insert a default value into a column.

          

  60. SELECT statement querylets you produce individual lists, but the result may be that you get all the information you need but in an individual list format.

          

  61. Full Outer Joinsreturns all rows from the left table (table1) and from the right table (table2).

          

  62. What are the three types of files in SQL?MDF = Primary data files, NDF = Secondary data files and LDF = Log files

          

  63. EXCEPT clauseChanges the database context

          

  64. Name the two types of prototypingRequirements and Evolutionary

          

  65. DDL influences _____, while _______ influences actual data stored in tables.Database objects, DML

          

  66. Tables created using the ________ statement are used to store data.Database objects, DML

          

  67. Explicit transactionAn explicit transaction is one where all events of the transaction either happen together or they don't take place at all.

          

  68. database indexused to optimize operations that use spatial data types, such as geometry and geography data types.

          

  69. Cartesian Productincludes a row for each possible combination of results from the other tables. the number of rows returned will equal the number of rows in one table multiplied by the number of rows in the other table.

          

  70. index(table scoped object and not securable) is a data structure that improves the speed of data retrieval operations on a database table. The disadvantage of indexes is that they need to be created and updated,.

          

  71. Use the _____ command to recover data that was accidentally deleted by a user.ALTER TABLE tablename
    ENABLE CHANGE_TRACKING

          

  72. db_denydatawriterCan create, alter,drop, and restore databases

          

  73. Advantage of database over spreadsheetDatabase can parse out redundant storage and information obtained from various relational spreadsheets.

          

  74. What does floating-point store in relation to data types?Real numbers

          

  75. What is the top-down approach?Breaking down the smaller components so that each describes a basic fragment.

          

  76. What is the bottom up approach?Breaking down the smaller components so that each describes a basic fragment.

          

  77. System views belong to the ______sys schema

          

  78. In order to use views, you must use the ______ T-SQL statement to show data from the tables.Real numbers

          

  79. What does degree refer to?The number of columns.

          

  80. What's the difference between an INNER join and an OUTER join?INNER will only produce matching rows from both tables while OUTER will join all rows from both tables whether they match or not.

          

  81. What is the diffrence between an application role and a database role?A database role is assigned to users

          

  82. If you are querying the same table for two different things you'd use a....MDF = Primary data files, NDF = Secondary data files and LDF = Log files

          

  83. If you have already defined a view on a specific table, then you add columns to that table, what must you do to the view?filter the results grouped by a GROUP BY clause.

          

  84. Define Normal Form1NF - Eliminate duplicative columns from the same table.
    -Create separate tables for each group of related data and identify each row with a unique column (the primary key).
    2NF - Move repeating fields into a new table that contains a primary key, and relate it back to the old table using a foreign key. (requirement that each field value in a table is associated with only one row)
    3NF - Eliminate columns not- transitively dependent (useless) on key
    4NF - all in table are dependent on superkey
    5NF - every join is implied by superkeys of the table

          

  85. DROP LOGINCommand will remove a windows user or group from the SQL server. This will not alter Windows its self

          

  86. What always returns a value but never updates data?Breaking down the smaller components so that each describes a basic fragment.

          

  87. in a relational database, data is stored inMultiple tables that are related using primary and foreign keys

          

  88. ON DELETE CASCADETo ensure all child tables are deleted inf the parent is deleted. This can be your FOREIGN KEY constraint.

          

  89. Check constraintreturns a result set that contains all the combinations of rows from two tables that do not have a column in common, also know as a Cartesian product. WHERE conditions should always be included.

          

  90. What command allows a Windows account to access SQL-Server?CREATE LOGIN

          

  91. SchemaRetrieves rows from the database and enables the selection of one or many rows or columns from one or many tables in SQL Server.

          

  92. ADDFunction returns the maximum value of an expression(IE: The maximum salary of all employees)

          

  93. Table-valued functionmust contain a RETURNS clause and a RETURN statement.

          

  94. SET NOCOUNT statementupdate columns with calculated values

          

  95. to search strings in a columnlets you produce individual lists, but the result may be that you get all the information you need but in an individual list format.

          

  96. Graphical designers are _________ and are drag-and-drop given.When the server is stopped.

          

  97. SET clauseupdate columns with calculated values

          

  98. Boolean stores what data type?are the most common SQL Server data types used to store numeric information.

          

  99. What is a self-reference?Non-clustered indexes are not copies of the table but a sorting of the columns you specify that "point" back to the data pages in the clustered index. Add non-clustered indexes for queries that return smaller result sets. (Optimal Performance)

          

  100. What 2 things speeds up data retrieval?A query and functional programming language designed to query collections of XML data.

          

  101. What does the IDENTITY constraint do?It's used on the primary key to automatically start with 1 and auto-increment by 1.

          

  102. T/F: Null is a valid constraintFalse, NULL is not a constraint

          

  103. INTERSECT clausegives you the final result set where values in both of the queries match by the query on both the left and right sides of the operand.
    • The number and order of the columns must be the same in all queries.
    • The data types must be compatible.

          

  104. Which column do you need to set a value for when issuing a INSERT statement?ALTER TABLE tablename
    ENABLE CHANGE_TRACKING

          

  105. How do you adjust indexes to reduce fragmentation from page splits?Set the fillfactor to 60.

          

  106. Deterministic functionOne that returns the same predictable value when called with same nvarchar(3500). Meets requirements using least amt of storage. Supports multiple language input parameters.

          

  107. Schema-scoped secure-able(stored procedure)one that is created within a schema and can receive permissions through that schema.

          

  108. %Returns character data converted from numeric data. The second parameter is for the total length of the output including the decimal point, signs, digits, and spaces. output is round as specified in the third parameter.

          

  109. Which normal form ensures that each attribute describes the entity?A type of bottom-up approach, the inside-out method begins with identifying a few important concepts then proceeds outward radially.

          

  110. MAXPerforms insert, update, or delete operations on a target table based on the results of a join with a source table.

          

  111. What is the UNIQUE constraint?Specifically identifies which column should not contain duplicate values.

          

  112. Some common examples of views include the following:• A subset of rows or columns of a base table
    • A union of two or more tables
    • A join of two or more tables
    • A statistical summary of base tables
    • A subset of another view or some combination of views and base tables

          

  113. What is SQLCMD?Can create, alter, and drop disk files. This is a Fixed server role

          

  114. Between statement, which combine columns from multiple different tables. JOIN statements can be specified in either the FROM or the WHERE clause, but it is recommended that you specify them in the FROM clause.

          

  115. COLLATE clausegives you the final result set where values in both of the queries match by the query on both the left and right sides of the operand.
    • The number and order of the columns must be the same in all queries.
    • The data types must be compatible.

          

  116. A stored procedureincludes a row for each possible combination of results from the other tables. the number of rows returned will equal the number of rows in one table multiplied by the number of rows in the other table.

          

  117. DbcreatorCan create, alter,drop, and restore databases

          

  118. Triggeris simply a virtual table consisting of different columns from one or more tables. Unlike a table, a view is stored in a database as a query object; therefore, a view is an object that obtains its data from one or more tables. View is a database object that can be used in SELECT queries just like a table. When a view contains a join, DML can be preformed but only a single base table.

          

  119. SubqueryA select statement that is nested within another SQL statement.

          

  120. What is a foreign key?This is a column in one table that points to the primary key in another table(defines relationship between two tables). Ensures domain and referential integrity, not entity integrity. There is not a predefined limit for foreign keys.

          

  121. Precision (p)is a database-specific role intended to allow an application to gain access regardless of the user.

          

  122. HeapWild Card character(IE: WHERE lastname LIKE 'J%'); LIKE operator is used with %

          

  123. WITH SCHEMABINDINGused to ensure that none of the tables references by the view are dropped or have their structure changes such that the view would not function properly. Cannot use asterisk in SELECT list., must specify column by name

          

  124. WITH CHECK OPTIONused to ensure that no changes to the underlying data can be made through the view that would cause data no to conform to the definitions of the view.

          

  125. Flat-type databasesis similar to a tree structure (such as a family tree). Each parent table can have multiple children, but each child table can have only one parent.

          

  126. FunctionPrevents users of members of a role from performing an action on a secure-able object, such as a view, or stored procedure. even if permission is grated directly through membership in another role.

          

  127. CollationRemoves rows from a table or view(, which deletes data from within a table) Use for smaller databases

          

  128. Mark works as a Database Designer for Reon Inc. He is assigned the task to create a database for the company. He issues the following query to create the database.

    CREATE DATABASE '24342'

    What will be the output of the query?
    A database will be created.

          

  129. What is a non-clustered index?Non-clustered indexes are not copies of the table but a sorting of the columns you specify that "point" back to the data pages in the clustered index. Add non-clustered indexes for queries that return smaller result sets. (Optimal Performance)

          

  130. Can you change the IDENTITY constraint of an existing column with an ALTER statement?A column of the uniqueidentifer data type. You need to use the NEWID() function in the values list to generate the value.

          

  131. Views ensure the security of data by restricting access to the following data• A subset of rows or columns of a base table
    • A union of two or more tables
    • A join of two or more tables
    • A statistical summary of base tables
    • A subset of another view or some combination of views and base tables

          

  132. Both the EXCEPT and the INTERSECT statementsAllows the admin to limit the types of data a user can insert into that column of the database.

          

  133. What prefix must you have in front of a string to use Unicode?It's used on the primary key to automatically start with 1 and auto-increment by 1.

          

  134. SELECTRetrieves rows from the database and enables the selection of one or many rows or columns from one or many tables in SQL Server.

          

  135. Transact-SQL data typesbit, decimal and numeric. Transact-SQL data types that have a fixed precision and scale. money and smallmoney are Transact-SQL data types you would use to represent monetary or currency values.

          

  136. COMMIT statementused to define a clustered or non clustered index.

          

  137. What is the difference between a function and a stored procedure?SELECT AVG("column name") FROM "table name"

          

  138. composite primary keyTo commit changes made within a manual transaction to the database.

          

  139. Character stores what data type?A-z or 0-9(any digit or letter that math functions will not be applied to)

          

  140. USEChanges the database context

          

  141. JOIN statements, which combine columns from multiple different tables. JOIN statements can be specified in either the FROM or the WHERE clause, but it is recommended that you specify them in the FROM clause.

          

  142. What is the default length for the CAST function?30

          

  143. What is the correct way to select an avg of a column?SELECT AVG("column name") FROM "table name"

          

  144. Good candidate for key columns in a non clustered indexColumns frequently uses as a query join conditions.

          

  145. Table sizes1MB - 1024 KB - 1 field - 165 bytes. a 100k table - = 16113.28125 kb(15.73563 mb)

          

  146. What's the difference between time, date, datetime, datetime2, datetimeoffset and smalldatetime?Column, localvariable, expression and parameter.

          

  147. Explicit conversions require you to useGenerates a continuous chain of transactions without stopping until completed

          

  148. application roleCreates a SQL Server database object (table, view, or stored procedure)

          

  149. IDENTITYCreates a SQL Server database object (table, view, or stored procedure)

          

  150. spatial indexis a data structure that improves the speed of data retrieval operations on a database table.

          

  151. A ____ backup contains only the data that has changed since the last FULL backup.Differential

          

  152. REVOKEremoves user access rights or privileges on the database objects granted using the GRANT statement, but does not prevent permissions from being obtained through membership in other roles.

          

  153. De-normailizationCommand will remove a windows user or group from the SQL server. This will not alter Windows its self

          

  154. What are 6 constraint types?Unique, Check(domain Integrity), Default(domain integrity), Not Null, Primary Key(entity integrity), Foreign Key(referential integrity)

          

  155. A ____ backup contains only the data that has changed since the LAST backup.value

          

  156. Aggregate FunctionsReturn a single value, calculated from values in a column. Ex. COUNT

          

  157. referential integrityA relational database is similar to a hierarchical database in that data is stored in tables and any new information is automatically added to the table without the need to reorganize the table itself. Minimizes the amount of redundant data stored in the database. database can have multiple parents.

          

  158. The foreign key constraint is a ____ identifier.1. If a view definition contains the DISTINCT keyword, rows cannot be deleted through the view.
    2. The WITH OBJECT IDENTIFIER clause is used to specify a top level (root) object view.
    3. The OR REPLACE option is used to change the definition of a existing view without dropping and recreating.

          

  159. Application design involves 2 important activities:transaction design and interface design

          

  160. OLTP(Online Transaction Processing) databaseto create a computed column that can be included in an index.

          

  161. What would happen if you had a BETWEEN operator of BETWEEN 'D' and 'F'You would get all values for D, E but not F. (MUST HAVE AND IN BETWEEN STATEMENT)

          

  162. The code DML statements are (5)lets you produce individual lists, but the result may be that you get all the information you need but in an individual list format.

          

  163. DBCC CHECKDALLOCTo check all pages in a DB are correctly allocated

          

  164. What language are triggers written in?DML or DDL

          

  165. Which DB design process allows you to create a data model independent of a specific DBMS?Relationship; Enforces referential integrity

          

  166. db_denydatareaderCan read from any table in the database, this deny will override an object-level grant

          

  167. db_backupoperatorcan perform backups, checkpoints, and DBCC commands, but not restores(only sysadmins can perform restores)

          

  168. Windows Authentication mode is superior to mixed mode becauseA type of bottom-up approach, the inside-out method begins with identifying a few important concepts then proceeds outward radially.

          

  169. The MS database server that hosts relational databases is called _____Storage and Programmability

          

  170. CREATEused in a UPDATE statement when you need to update the values of columns that have a large object data type such as varchar(max) or varbinary(max) columns.

          

  171. The ___ role gives access to anything on the SQL server, while the ____ role gives full access to a specific database:Public

          

  172. DELETE syntaxYou can identify and delete individual rows from the database

          

  173. What is a fillfactor?It specifies a percentage that indicates how much free space will be in the leaf level of each index page.

          

  174. What is one thing to consider when creating a view?When creating a stored procedure, this can be used to allow the person running the SP to have the same permissions as the person who owns the SP. This is better than granting SELECT to the user.

          

  175. Name 3 things which can be used to improve query performance1 byte, 256 possible characters.

          

  176. What is the primary key?A method of coding that enables a user to focus on the coding rather than the syntax for a specific database API, allowing them to use generic methods of access as long as they have the additional codes or libraries which fill in the blanks.

          

  177. Grant ExecuteGives a database user or group(defined with a role) specific permissions to data objects. Uses ON clause preceding it.

          

  178. Which 4 things always have a related data type?Column, localvariable, expression and parameter.

          

  179. SQL server supports ____ conversions without using actual callout functions CAST or CONVERTInstances of SQL server, Data-Tier apps, Databse Files, Volumes

          

  180. Database objects are divided into two categories:CREATE, DROP, ALTER

          

  181. ON DELETE NO ACTIONTo ensure all child tables are deleted inf the parent is deleted. This can be your FOREIGN KEY constraint.

          

  182. A clustered index usually _____ performance when inserting data.worsens, because it's constantly sorting it. Improves it for retrieving it though. Physical sort. Only 1 per table.

          

  183. Databases are often put on database servers for what reasonMultiple tables that are related using primary and foreign keys

          

  184. UPDATE statementThe function of the is to change data in a table or view

          

  185. What is a default constraint?Used to insert a default value into a column.

          

  186. CHARINDEX functionreturns the starting position of the specifies expression in a character string. The third parameter of the function is the character position to start searching for the first parameter in the second parameter. If starting ocation is a negative number, search starts at beginning of second parameter.

          

  187. db_ddladminCommand will remove a windows user or group from the SQL server. This will not alter Windows its self

          

  188. DENYphysical structure in non clustered index

          

  189. Constraints are also referred to as ____ constraints.Allows the admin to limit the types of data a user can insert into that column of the database.

          

  190. Non Clustered IndexNon-clustered indexes are not copies of the table but a sorting of the columns you specify that "point" back to the data pages in the clustered index. Add non-clustered indexes for queries that return smaller result sets

          

  191. When do you pick the DBMS?Prior to the Logical design phase.

          

  192. CRUDIn computer programing, create, read, update and delete (CRUD)are the four basic functions of persistent change

          

  193. sysindexescontains one row for each function, constraint or trigger created within a database. Indexes are not stored in this table(sysindexes).

          

  194. How would you set fillfactor?ALTER INDEX ALL ON dbo.OrderDetails REBUILD WITH (FILLFACTOR = 60);

          

  195. Normalizationseries of steps(or rules) called "forms" the more steps you take, the more normalized your tables.

          

  196. What happens if data is missing for a particular column when designing the INSERT SQL statement?Database performance

          

  197. Not null constraintallows you to limit the types of data a user can insert into a the database and that they meet a certain condition.

          

  198. Database objects are divide into two categories:are designed to return distinct values by comparing the results of two queries.

          

  199. The core DDL statements are:shows line stating the number of rows "affected". This is off by default. This will suppress the '(1 row affected)

          

  200. What 3 reasons should you consider using a clustered index?1. Columns contain a large number of distinct values
    2. Columns are accessed sequentially
    3. Queries return large result sets

          

  201. An inline table-valued FunctionWould prevent a parent row from being deleted if it had a related child rows in another table.

          

  202. A regular character uses ___ bytes of storage, whereas a unicode character requires ____ bytes.one, two

          

  203. Any ___ permission will always override a GRANT permission.DENY

          

  204. Which form of database design uses secondary storage media?Used to insert a default value into a column.

          

  205. STR Function does what?returns character data converted from numeric data.

          

  206. INNER JOINreturns when there is at least one match in both tables.

          

  207. WHEREphysical structure in non clustered index

          

  208. STRChanges the database context

          

  209. Define 4NFRemoves rows from a table or view(, which deletes data from within a table) Use for smaller databases

          

  210. Inline tablevalued function includes only a single SELECT statement.

          

  211. How do you start a transaction?Use BEGIN TRAN

          

  212. RIGHT OUTER JOINpreserves the unmatched rows from the second (right) table, joining them with a NULL in the shape of the first (left) table

          

  213. Name 3 levels of security supported by SQL ServerServer, Database and Table

          

  214. CREATE INDEX statementThe function of the is to change data in a table or view

          

  215. RESTORE DATABASE commandA relational database is similar to a hierarchical database in that data is stored in tables and any new information is automatically added to the table without the need to reorganize the table itself. Minimizes the amount of redundant data stored in the database. database can have multiple parents.

          

  216. T/F: A single INSERT statement can be used to add rows to multiple tables.TRUNCATE command; does not log each row

          

  217. DEFAULTEnsures domain integrity by ensuring each record has a column value if one is not assigned.

          

  218. An ___ ____ is the same thing as a CROSS JOIN with a WHERE condition:INNER JOIN

          

  219. ALTERChanges an existing object(changes the object definition)

          

  220. For the CHAR data set, it is a _____ length and uses ___ bytes:Fixed, N

          

  221. what happens when you connect two tablesthe primary key is replicated from the primary to secondary table, and all the key attributes duplicated from the primary table are known as the foreign key.

          

  222. Why is it a bad idea to let a foreign key contain a NULL value?1. It does not have any usage of SQL group functions or grouping of data.
    2. DML operations are allowed on the view
    3. It fetches data from one database table only

          

  223. What is the inside-out approach to db design?A type of bottom-up approach, the inside-out method begins with identifying a few important concepts then proceeds outward radially.

          

  224. MERGEPerforms insert, update, or delete operations on a target table based on the results of a join with a source table.

          

  225. viewis simply a virtual table consisting of different columns from one or more tables. Unlike a table, a view is stored in a database as a query object; therefore, a view is an object that obtains its data from one or more tables. View is a database object that can be used in SELECT queries just like a table. When a view contains a join, DML can be preformed but only a single base table.

          

  226. The sa account is only used inA command line application that comes with SQL and exposes the management features of SQL Server. It allows SQL queries to be written and executed from the command prompt.

          

  227. What are 3 characteristics of a simple view?1. It does not have any usage of SQL group functions or grouping of data.
    2. DML operations are allowed on the view
    3. It fetches data from one database table only

          

  228. What steps should you take to create full-text searching?the primary key is replicated from the primary to secondary table, and all the key attributes duplicated from the primary table are known as the foreign key.

          

  229. What is represented by a column in a well-designed relational database tableA single entity attribute

          

  230. What are three things true about views?1. If a view definition contains the DISTINCT keyword, rows cannot be deleted through the view.
    2. The WITH OBJECT IDENTIFIER clause is used to specify a top level (root) object view.
    3. The OR REPLACE option is used to change the definition of a existing view without dropping and recreating.

          

  231. Implicit TransactionsGenerates a continuous chain of transactions without stopping until completed

          

  232. When querying a database you can obtain faster results from properly ______ tables and views.N

          

  233. Partial Backupincludes a row for each possible combination of results from the other tables. the number of rows returned will equal the number of rows in one table multiplied by the number of rows in the other table.

          

  234. hierarchical databaseallows you to modify data stored in tables using data attributes. Note: If you don't specify what records to update, all records or rows will be updated with the new value. To update another table use FROM clause. In this, SET specifies column to be updated.

          

  235. serveradmin fixed server rolecan Configure server -wide settings and issue SHUTDOWN command which immediately stops the SQL server.