Question types

Start with

Question limit

of 113 available terms

Print test

113 Matching questions

  1. The syntax for numeric data type is expressed as ___
  2. data type ???
  3. TRUE and FALSE string values can be converted ___
  4. Views ensure the security of data by restricting access to the following data:
  5. A Unicode character uses ___
  6. smalldatetime ???
  7. varchar ???
  8. NVarchar ???
  9. char [(n)] , the value of n must be between ___
  10. syntax of the convert function ???
  11. A stored procedure is a ___
  12. Scale(s) ???
  13. Reasons to provide a view instead of enabling users to access the underlying tables in your database:
  14. A view is ___
  15. numeric & decimal ???
  16. if your columns contain 9 to 16 bits, the columns will be stored as ___
  17. Cast is compliance with ___
  18. ntext ??
  19. built-in data types is a wide range of ___
  20. Microsoft SQL Server 2008's built-in data types are organized into the following general categories:
  21. char ???
  22. money, monetary or currency values from ___
  23. MAX specifier ?
  24. Examples of PascalCase are such names as ___
  25. CONVERT(nvarchar(10), OrderDate, 101) ???
  26. data set char is identified as ___
  27. The injection process's function is to ___
  28. A view is also a mechanism to ___
  29. indexing plays a role in query time and an even greater role in ___
  30. One way to save time when running the same query over and over again is to create a ___
  31. Money and smallmoney are ___
  32. CREATE VIEW vwCustomer
    SELECT CustomerId, Company Name, Phone
    FROM Customers
  33. Steps to create your view:
  34. Varchar ???
  35. A regular character uses ___
  36. smallmoney, monetary or currency values from ___
  37. time* ???
  38. If you are creating complex query statements, your best bet is to ___
  39. uniqueidentifier (UUID) ???
  40. Steps to create a stored procedure (SSMS) :
  41. Complex queries can be stored in the form of a view and data from the view can then be mined ___
  42. when you are expressing a Unicode character literal, it must have the letter ___
  43. nchar ???
  44. how many bytes datetime data type uses ___
  45. When two expressions (mathematical functions or comparison functions) have different data types, rules for data-type precedence specify that the ___
  46. A less direct method of attack injects malicious code into ___
  47. Set the Default Value of the DateCreated column to (getdate()); this will insert the ___
  48. Using a stored procedure ___
  49. binary ???
  50. tinyint ???
  51. "exec"
  52. Exact numerics include ___
  53. int ??
  54. Database views are designed to create a virtual table that is representative of ___
  55. A stored procedure is an already-written SQL statement that is ___
  56. datetime2* ???
  57. A regular character literal is always expressed with ___
  58. When you use a VAR element ___
  59. date* ???
  60. datetime and datetime2 ???
  61. An example of executing a stored procedure:
  62. datetime2 is the data type to use if you will be storing values ___
  63. nvarchar ???
  64. cast(count AS float) ???
  65. The primary form of SQL injection is a direct insertion of code into ___
  66. Differences between regular and Unicode are the ___
  67. image ???
  68. VARCHAR(25) ?
  69. LOB ?
  70. Add Table dialog box ???
  71. There are two methods for creating a view:
  72. The purpose of a table is to ___
  73. Money ???
  74. Examples of camelCase are names like ___
  75. The date and time data types include ___
  76. Datetime ???
  77. The syntax for decimal data type is expressed as ___
  78. INSERT INTO planets (name, diameter) VALUES ('earth', 10000);
    if SQL Server didn't support implicit conversion, the following syntax would be needed:
  79. Precision (p) ???
  80. Views are referred to as ___
  81. Cast and Convert functions ???
  82. text ???
  83. Non-Unicode data type varchar[(n|max)] is a ___
  84. The float numeric data type is commonly used in the ___
  85. SSMS definition :
  86. Some common examples of views include the following:
  87. The Boolean data type is also known as the ___
  88. The integer (int) numeric data type is used to ___
  89. bit ???
  90. if your columns store 8 bits or fewer, the columns will be stored as ___
  92. When a conversion (convert values from one data type to another) is done automatically it is called an ___
  93. Once you have defined a view, you can reference it as you would any other ___
  94. You should also avoid using spaces because they add complications that make it necessary for you to use ___
  95. datetimeoffset* ???
  96. Boolean ???
  97. Microsoft SQL Server supports only two character string types:
  98. syntax of the cast function ???
  99. you should use the datetime data type if you will be storing values ___
  100. Creating tables within SSMS is simple because SSMS ___
  101. Unicode data types are identified with ___
  102. varbinary ???
  103. how can you create tables using ANSI SQL syntax?
  104. bigint ???
  105. Regular data types include those identified with ___
  106. Adding indexes to the schema can actually increase the overhead of your database due to the ___
  107. A view is stored in a database as a ___
  108. For example, although a DateTime value is represented as a float, ___
  109. if you multiply an item's cost (represented as a float) with the number of items (represented as an integer), the answer will be ___
  110. how many bytes datetime2 data type requires ___
  111. smallint ???
  112. SQL injection is an ___
  113. sql_variant ???
  1. a Integer data from -2^63 (-9,223,372,036,854,775,808) to 2^63-1 8 bytes (9,223,372,036,854,775,807).
  2. b to bit values. Specifically, TRUE is converted to 1 and FALSE is converted to 0.
  3. c store mathematical computations and is employed when you do not require a decimal point output.
  4. d • Views allow you to limit the type of data users can access. You can grant view permissions in designated tables, and you can also choose to deny permissions for certain information.
    • Views reduce complexity for end users so they don't have to learn how to write complex SQL queries. Instead, you can write those queries on their behalf and hide them in a view.
  5. e quotes
  6. f 4 bytes of storage
  7. g -214,748.3648 to 214,748.3647
  8. h • 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
  9. i you may not implicitly convert to a float because it is meant to be a date and/or time.
  10. j Unicode Character data type with fixed length.
  11. k between January 1, 1900, and June 6, 2079, that are accurate to only 1 minute.
  12. l Character data type with fixed length.
  13. m terminate a text string prematurely and append a new command directed from it; because the inserted command may have additional strings appended to it before it is executed, the malefactor terminates the injected string with a comment mark "—", making subsequent text ignored at execution time.
  14. n bit data type.
  15. o Binary data with variable length.
  16. p provide a structure for storing data within a relational database.
  17. q What this select statement does is return all the data that is found in the USERLIST table.
  18. r date, datetime, datetime2, datetimeoffset, smalldatetime, and time.
  19. s a virtual table consisting of different columns from one or more tables;
    ( or )
    an object that obtains its data from one or more tables.
  20. t user-input variables that are concatenated with SQL commands and then executed.
  21. u Binary data with fixed length.
  22. v tells SQL Server to execute the code in the stored procedure.
  23. w 8 bytes of storage
  24. x OrderDetails or CustomerAddresses
  25. y 16-byte GUID.
  26. z SQL Server will preserve space in the row in which that element resides based on the column's defined size (and not on the actual number of characters in the character string itself ), plus an extra two bytes of data for offset data.
  27. aa INSERT INTO planets (name, diameter) VALUES ('earth', CAST (10000 as varchar(50)))
  28. ab NCHAR and NVARCHAR
  29. ac int, bigint, bit, decimal, numeric, money, and smallmoney
  30. ad stored in a database.
  31. ae Transact-SQL data types that have a fixed precision and scale. Valid values range from -10^38+1 through 10^38-1.
  32. af Specify that a string supports a maximum of only 25 characters
  33. ag attack in which malicious code is inserted into strings that are later passed on to instances of SQL Server waiting for parsing and execution.
  34. ah • Specific rows of tables
    • Specific columns of tables
    • Specific rows and columns of tables
    • Rows obtained by using joins
    • Statistical summaries of data in given tables
    • Subsets of another view or subsets of views and tables
  35. ai A value with a size identified up to a certain threshold (the default is 8,000) is stored inline in the row.
  36. aj convert the count variable to a float
  37. ak This data type will be removed in future SQL releases; therefore, use varbinary(max) instead.
  38. al char [(n)] and is a fixed-length, non-Unicode character (regular character) with a length of n bytes. The value of n must be between 1 and 8,000, making the storage size n bytes.
  39. am expressed as a float.
  40. an This creates a view called vwCustomer that will be stored as an object. Here, the data that is queried from the columns comes from the Customers table.
  41. ao SQL Server Management Studio
  42. ap using simple query statements.
  43. aq ANSI standards, which allow you to import or export to other database management systems.
  44. ar CONVERT ( data_type [ ( length ) ], expression [,style ] )
  45. as • Exact numbers
    • Approximate numbers
    • Date and time
    • Character strings
    • Unicode character strings
    • Binary strings
    • Other data types
    • CLR data types
    • Spatial data types
  46. at one 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, accommodating English and some European languages.
  47. au between the dates of January 1, 1753, and December 31, 9999, that are accurate to 3.33 milliseconds,
  48. av This numeric data type is used in places where you want money or currency involved in your database;
  49. aw used to store date and time data in many different formats.
  50. ax Unicode Character data type with variable length.
  51. ay numeric[(p[,s])]
  52. az is the primary integer (whole number) data type.
    Integer data from -2^31(-2,147,483,648) to 2^31-1 (2,147,483,647).
  53. ba create a stored procedure for them and run that stored procedure from within the Query Analyzer using an execute (exec) command.
  54. bb Stores values of various SQL Server-supported data types, except text, ntext, image, timestamp, and sql_variant.
  55. bc N (for National) prefixing the single quote. For example: N'This is how a Unicode character string literal looks'
  56. bd 1 and 8,000, making the storage size n bytes.
  57. be stored procedure that you can then execute from within the database's command environment.
  58. bf one or more tables in an alternative way.
  59. bg scientific community and considered an approximate-number data type. This means that not all values within the data-type range will be represented exactly. In addition, depending on which type of float is used, a 4-byte float supports precision up to 7 digits and an 8-byte float supports precision up to 15 digits.
  60. bh simplify query execution.
  61. bi cast(source-value AS destination-type)
  62. bj -922,337,203,685,477.508 to 922,337, 203,685,477.5807
  63. bk Defines a date that is combined with a time of day. The time is based on a 24-hour day, with seconds always zero (:00), meaning there are no fractional
    seconds. Range: 1900-01-01 through 2079-06-06 Accuracy: one minute.
  64. bl myAddress and vendorTerms
  65. bm allows you to store all the logic inside the database, so by using a simple command, you can query and retrieve all information from all sources.
  66. bn This dialog box allows you to do:

    • specify the table to be used as the primary source...
    • To use another existing view, click the Views tab...
    • generate records from a function (Functions tab).
    • If you want to use more than one source, you can click each of the different tabs to find the table, view, or function you wish to add to your query.
    • Once you have selected the desired source(s) (click the Add button)
    • Once you have selected and added all your desired sources (Close button)
  67. bo implicit conversion.
  68. bp predefined data types (Microsoft SQL Server)
  69. bq single quotes. For example: 'This is how a regular character string literal looks'
  70. br query object
  71. bs Regular and Unicode.
  72. bt Defines a date that is combined with a time of day that is based on a 24-hour clock. Range: 0001-01-01 through 9999-12-31. Range: 00:00:00 through 23:59:59.9999999. Accuracy: 100 nanoseconds.
  73. bu Integer data from 0 to 255.
  74. bv decimal[(p[,s])]
  75. bw exec usp_displayallusers
  76. bx bytes of storage used for each.
  77. by database performance improvements.
  78. bz This data type will be removed in future SQL releases; therefore, use varchar(max) instead.
  79. ca is an easy-to-use graphical interface.
  80. cb force a conversion
  81. cc This data type converts true and false string values to bit values, with true converted to 1 and false converted to 0.
  82. cd previously written SQL statement that has been "stored" or saved into a database.
  83. ce A value with a size greater than the default threshold, that value will be stored external to the row and identified as a large object.
  84. cf subtypes of datetime data type
  85. cg two bytes of storage per character so that you can represent one of 65,536 (16 bits are in 2 bytes, and 2^16 = 65,536) characters. The additional space allows Unicode to store characters from just about any language, including Chinese, Japanese, Arabic, and so on.
  86. ch Defines a date. Range: 0001-01-01 through 9999-12-31. Accuracy: one day.
  87. ci 1 byte
  88. cj data type with lower precedence
    is converted to the data type with higher precedence.
  89. ck Character data type with variable length.
  90. cl current date within each new record for that specific field.
  91. cm strings that are destined for storage in a table or are considered metadata. When these stored strings are subsequently concatenated into the dynamic SQL command, the malicious code will be executed.
  92. cn Right-click the Views folder, then select New View.
  93. co 2 bytes
  94. cp Transact-SQL data types you would use to represent monetary or currency values. Both data types are accurate to 1/10,000th of the monetary units they represent.
  95. cq CHAR and VARCHAR
  96. cr Integer data from -2^15 (-32,768) to 2^15-1 (32,767).
  97. cs • By using SSMS
    • By writing a Transact-SQL statement
  98. ct This data type will be removed in future SQL releases; therefore, use nvarchar(max) instead.
  99. cu This will convert the OrderDate, which is a DateTime data type to nvarchar value. The 101 style represents USA date with century. mm/dd/yyyy.
  100. cv is the maximum total number of decimal digits that can be stored, both to the left and the right of the decimal point. This value must be a minimum of 1 and a maximum of 38. The default precision number is 18.
  101. cw If you are supporting multiple languages, use this data type.
  102. cx you will use the create table statement to accomplish this task.
  103. cy is a Transact-SQL integer data type that takes a value of 1, 0, or NULL
  104. cz Defines a date that is combined with a time of day that has time-zone awareness and is based on a 24-hour clock. Range: 0001-01-01 through 9999-12-31 ... 00:00:00 through 23:59:59.9999999. Accuracy: 100 nanoseconds.
  105. da variable-length data set that can consist of 1 to 8,000 characters.
  106. db table in a database.
  107. dc underlying tables.
  108. dd Programmability section >>> Right-click Stored Procedures and choose New Stored Procedure
  109. de Defines a time of day. This time is without time-zone awareness and is based on a 24-hour clock. Range: 00:00:00.0000000 through 23:59:59.9999999. Accuracy: 100 nanoseconds.
  110. df an attribute that specifies the type of data an object can hold, as well as how many bytes each data type takes up.
  111. dg ongoing maintenance of these indexes.
  112. dh This character-string data type is commonly used in databases where you are supporting English attributes.
  113. di Reflects the maximum number of decimal digits that can be stored to the right of the decimal point. This must be a value from 0 through p, but it can be specified only if precision is also specified. The default scale is 0.