Question types

Start with

Question limit

of 113 available terms

Print test

113 Multiple choice questions

  1. 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).
  3. myAddress and vendorTerms
  4. 4 bytes of storage
  5. 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)
  6. This data type will be removed in future SQL releases; therefore, use varbinary(max) instead.
  7. force a conversion
  8. ANSI standards, which allow you to import or export to other database management systems.
  9. 1 byte
  10. underlying tables.
  11. This data type converts true and false string values to bit values, with true converted to 1 and false converted to 0.
  13. current date within each new record for that specific field.
  14. 16-byte GUID.
  15. 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.
  16. query object
  17. bytes of storage used for each.
  18. single quotes. For example: 'This is how a regular character string literal looks'
  19. Right-click the Views folder, then select New View.
  20. between January 1, 1900, and June 6, 2079, that are accurate to only 1 minute.
  21. 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.
  22. 2 bytes
  23. Defines a date. Range: 0001-01-01 through 9999-12-31. Accuracy: one day.
  24. exec usp_displayallusers
  25. is an easy-to-use graphical interface.
  26. 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.
  27. Character data type with fixed length.
  28. data type with lower precedence
    is converted to the data type with higher precedence.
  29. INSERT INTO planets (name, diameter) VALUES ('earth', CAST (10000 as varchar(50)))
  30. stored procedure that you can then execute from within the database's command environment.
  31. variable-length data set that can consist of 1 to 8,000 characters.
  32. store mathematical computations and is employed when you do not require a decimal point output.
  33. int, bigint, bit, decimal, numeric, money, and smallmoney
  34. 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.
  35. to bit values. Specifically, TRUE is converted to 1 and FALSE is converted to 0.
  36. predefined data types (Microsoft SQL Server)
  37. Character data type with variable length.
  38. you may not implicitly convert to a float because it is meant to be a date and/or time.
  39. • Exact numbers
    • Approximate numbers
    • Date and time
    • Character strings
    • Unicode character strings
    • Binary strings
    • Other data types
    • CLR data types
    • Spatial data types
  40. previously written SQL statement that has been "stored" or saved into a database.
  41. What this select statement does is return all the data that is found in the USERLIST table.
  42. database performance improvements.
  43. 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.
  44. Integer data from 0 to 255.
  45. convert the count variable to a float
  46. 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. Binary data with variable length.
  48. This data type will be removed in future SQL releases; therefore, use nvarchar(max) instead.
  49. 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.
  50. -922,337,203,685,477.508 to 922,337, 203,685,477.5807
  51. create a stored procedure for them and run that stored procedure from within the Query Analyzer using an execute (exec) command.
  52. is a Transact-SQL integer data type that takes a value of 1, 0, or NULL
  53. 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.
  54. table in a database.
  55. 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.
  56. using simple query statements.
  57. This numeric data type is used in places where you want money or currency involved in your database;
  58. This character-string data type is commonly used in databases where you are supporting English attributes.
  59. • 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
  60. simplify query execution.
  61. Binary data with fixed length.
  62. • 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.
  63. If you are supporting multiple languages, use this data type.
  65. you will use the create table statement to accomplish this task.
  66. bit data type.
  67. OrderDetails or CustomerAddresses
  68. • 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
  69. expressed as a float.
  70. 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.
  71. Integer data from -2^15 (-32,768) to 2^15-1 (32,767).
  72. date, datetime, datetime2, datetimeoffset, smalldatetime, and time.
  73. Regular and Unicode.
  74. A value with a size identified up to a certain threshold (the default is 8,000) is stored inline in the row.
  75. attack in which malicious code is inserted into strings that are later passed on to instances of SQL Server waiting for parsing and execution.
  76. 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.
  77. 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.
  78. Transact-SQL data types that have a fixed precision and scale. Valid values range from -10^38+1 through 10^38-1.
  79. user-input variables that are concatenated with SQL commands and then executed.
  80. a virtual table consisting of different columns from one or more tables;
    ( or )
    an object that obtains its data from one or more tables.
  81. SQL Server Management Studio
  82. 1 and 8,000, making the storage size n bytes.
  83. Programmability section >>> Right-click Stored Procedures and choose New Stored Procedure
  84. subtypes of datetime data type
  85. 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.
  86. ongoing maintenance of these indexes.
  87. Unicode Character data type with fixed length.
  88. 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.
  89. implicit conversion.
  90. provide a structure for storing data within a relational database.
  91. 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.
  92. 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.
  93. 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.
  94. one or more tables in an alternative way.
  95. cast(source-value AS destination-type)
  96. N (for National) prefixing the single quote. For example: N'This is how a Unicode character string literal looks'
  97. decimal[(p[,s])]
  98. • By using SSMS
    • By writing a Transact-SQL statement
  99. CONVERT ( data_type [ ( length ) ], expression [,style ] )
  100. used to store date and time data in many different formats.
  101. an attribute that specifies the type of data an object can hold, as well as how many bytes each data type takes up.
  102. Stores values of various SQL Server-supported data types, except text, ntext, image, timestamp, and sql_variant.
  103. stored in a database.
  104. Specify that a string supports a maximum of only 25 characters
  105. between the dates of January 1, 1753, and December 31, 9999, that are accurate to 3.33 milliseconds,
  106. This data type will be removed in future SQL releases; therefore, use varchar(max) instead.
  107. 8 bytes of storage
  108. -214,748.3648 to 214,748.3647
  109. Unicode Character data type with variable length.
  110. numeric[(p[,s])]
  111. 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).
  112. tells SQL Server to execute the code in the stored procedure.
  113. 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.