MTA 98-364 Lesson 2 Test Bank

Answer: b Difficulty: Easy Section Reference: Defining Data Types Explanation: A data type is an attribute that specifies the type of data that an object can hold. It also specifies how many bytes each data type takes up. For example, several data types define only whole numbers, which are good for counting or for identification. Other data types allow decimal numbers and come in handy when storing values dealing with money. Other data types are designed to store strings or multiple characters so that you can define labels, descriptions, and comments. Lastly, you have other miscellaneous data types that can store dates, times, and binary numbers consisting of 0s and 1s or can be used to store digital images.

Answer: b Difficulty: Easy Section Reference: Using Built-in Data Types Explanation: The int numeric data type is used to store mathematical computations and is used when you do not require a decimal point output. An example of an integer would be: 2 or -2

Answer: c Difficulty: Medium Section Reference: Using Built-in Data Types Explanation: A float numeric data type is commonly used in the scientific community and is considered an approximate-number data type. This means that not all values within the data type range will be represented exactly. When considering using this numeric data type, note that the float data type ranges are different. For storage of 4 bytes, you would use the range of 1-24, as in float(24), and for 8 bytes, you would use the range of 25-53, as in float(53).

Answer: d Difficulty: Medium Section Reference: Using Built-in Data Types Explanation: A varchar character string data type is commonly used in databases in which you are supporting English attributes. If you are supporting multiple languages, use the nvarchar data type instead because this will help minimize the issues that come with character conversion.

Answer: c Difficulty: Hard Section Reference: Using Built-in Data Types Explanation: The int data type holds integer data from -2^31(-2,147,483,648) to 2^31-1(2,147,483,647). It takes 4 bytes of data.

Answer: d Difficulty: Hard Section Reference: Using Built-in Data Types Explanation: The money data type holds currency values from -922,337,203,685,477.508 to 922,337,203,685,477.5807. It takes 8 bytes of data.

Answer: a Difficulty: Medium Section Reference: Understanding Implicit Conversions Explanation: SQL Server supports implicit conversions, which can occur without specifying the actual callout function (cast or convert). This means that if you are doing calculations with multiple data types, implicit conversion will occur automatically.

Answer: a Difficulty: Medium Section Reference: Using Regular Character Strings Explanation: A regular character uses 1 byte of storage for each character, which allows you to define one of 256 (8 bits are in a byte and 2^8=256) possible characters that accommodate English and some European languages.

Answer: a Difficulty: Hard Section Reference: Understanding Unicode Character Strings Explanation: The Unicode character strings nchar and nvarchar can be either fixed or variable like their regular character strings. They use the Unicode UCS-2 character set.

Answer: a Difficulty: Hard Section Reference: Creating and Using Tables Explanation: It really doesn't make a difference how you use upper- and lowercase, as long as you are consistent. Two common naming conventions are PascalCase and camelCase. Examples of PascalCase include such names as OrderDetails or CustomerAddresses.

Answer: b Difficulty: Easy Section Reference: Creating Views Explanation: A view is simply a virtual table consisting of different columns from one or more tables. Unlike a table, a view is stored in the database as a query object; therefore, a view is an object that obtains its data from one or more tables.

What are previously written SQL statements that have been stored within a database? a) data statements b) views c) DDL statements d) stored procedures

Answer: d Difficulty: Easy Section Reference: Creating Stored Procedures Explanation: An example of executing a stored procedure is as follows: The name of the stored procedure is usp_displayallusers, and exec tells SQL Server to execute the code in the usp_displayallusers stored procedure.

Answer: c Difficulty: Medium Section Reference: Understanding SQL Injections Explanation: A SQL injection is an attack in which malicious code is inserted into strings that are later passed to instances of SQL Server waiting for parsing and execution. Any procedure that constructs SQL statements should be reviewed continually for injection vulnerabilities, because SQL Server will execute all syntactically valid queries from any source.

Answer: d Difficulty: Medium Section Reference: Using Built-in Data Types Explanation: Collation refers to a set of rules that determine how data is sorted and compared. By default, SQL Server has predefined collation precedence. If you want to override how data is sorted, you must use a collation clause.

Answer: c Difficulty: Medium Section Reference: Using Build-in Data Types Explanation: Boolean is also known as a bit data type. If you are storing 8 or less bit columns in a table, the columns are then stored as 1 byte; if you are storing 9 to 16 bits, the columns are stored as 2 bytes, and so forth. The Boolean data type converts true and false string values to bit values, with true converted to 1 and false converted to 0.

Answer: 8,000 Difficulty: Hard Section Reference: Understanding Regular Character Strings Explanation: For the data set char, it is identified as char [(n)] and is a fixed-length, non-Unicode character (in other words, regular character) and has a length of n bytes. The value of n must be between 1 and 8,000 bytes. The other non-Unicode data type, varchar[(n|max)], is a variable-length data set, which can consist of 1 to 8,000 characters.

What does VARCHAR(25) represent?

Answer: Cast and Convert. Difficulty: Hard Section Reference: Understanding Implicit Conversions Cast and convert play an integral partnership with any data type function as they convert an expression of one data type to another. convert was the old style of converting, with cast being used in the same manner.