NAME

Question types


Start with


Question limit

of 113 available terms

Print test

113 True/False questions

  1. char [(n)] , the value of n must be between ___4 bytes of storage

          

  2. The syntax for numeric data type is expressed as ___store mathematical computations and is employed when you do not require a decimal point output.

          

  3. The purpose of a table is to ___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.

          

  4. Views ensure the security of data by restricting access to the following data:• By using SSMS
    • By writing a Transact-SQL statement

          

  5. A view is stored in a database as a ___simplify query execution.

          

  6. if your columns contain 9 to 16 bits, the columns will be stored as ___bit data type.

          

  7. The integer (int) numeric data type is used to ___8 bytes of storage

          

  8. Regular data types include those identified with ___NCHAR and NVARCHAR

          

  9. A view is ___a virtual table consisting of different columns from one or more tables;
    ( or )
    an object that obtains its data from one or more tables.

          

  10. When you use a VAR element ___provide a structure for storing data within a relational database.

          

  11. Cast and Convert functions ???force a conversion

          

  12. Varchar ???This character-string data type is commonly used in databases where you are supporting English attributes.

          

  13. Money ???This numeric data type is used in places where you want money or currency involved in your database;

          

  14. Some common examples of views include the following:exec usp_displayallusers

          

  15. Examples of PascalCase are such names as ___previously written SQL statement that has been "stored" or saved into a database.

          

  16. Set the Default Value of the DateCreated column to (getdate()); this will insert the ___store mathematical computations and is employed when you do not require a decimal point output.

          

  17. datetime and datetime2 ???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.

          

  18. The float numeric data type is commonly used in the ___store mathematical computations and is employed when you do not require a decimal point output.

          

  19. Cast is compliance with ___convert the count variable to a float

          

  20. Examples of camelCase are names like ___myAddress and vendorTerms

          

  21. A regular character uses ___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.

          

  22. When two expressions (mathematical functions or comparison functions) have different data types, rules for data-type precedence specify that the ___data type with lower precedence
    is converted to the data type with higher precedence.

          

  23. A stored procedure is an already-written SQL statement that is ___stored in a database.

          

  24. sql_variant ???Unicode Character data type with fixed length.

          

  25. Microsoft SQL Server 2008's built-in data types are organized into the following general categories:Regular and Unicode.

          

  26. Precision (p) ???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.

          

  27. datetime2 is the data type to use if you will be storing values ___between January 1, 1900, and June 6, 2079, that are accurate to only 1 minute.

          

  28. Datetime ???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.

          

  29. how many bytes datetime2 data type requires ___4 bytes of storage

          

  30. Complex queries can be stored in the form of a view and data from the view can then be mined ___using simple query statements.

          

  31. smallint ???Integer data from -2^15 (-32,768) to 2^15-1 (32,767).

          

  32. binary ???Binary data with fixed length.

          

  33. The Boolean data type is also known as the ___predefined data types (Microsoft SQL Server)

          

  34. syntax of the convert function ???CONVERT ( data_type [ ( length ) ], expression [,style ] )

          

  35. INSERT INTO planets (name, diameter) VALUES ('earth', 10000);
    if SQL Server didn't support implicit conversion, the following syntax would be needed:
    INSERT INTO planets (name, diameter) VALUES ('earth', CAST (10000 as varchar(50)))

          

  36. Creating tables within SSMS is simple because SSMS ___is an easy-to-use graphical interface.

          

  37. uniqueidentifier (UUID) ???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.

          

  38. MAX specifier ?A value with a size identified up to a certain threshold (the default is 8,000) is stored inline in the row.

          

  39. TRUE and FALSE string values can be converted ___to bit values. Specifically, TRUE is converted to 1 and FALSE is converted to 0.

          

  40. SSMS definition :A value with a size identified up to a certain threshold (the default is 8,000) is stored inline in the row.

          

  41. money, monetary or currency values from ___-922,337,203,685,477.508 to 922,337, 203,685,477.5807

          

  42. If you are creating complex query statements, your best bet is to ___create a stored procedure for them and run that stored procedure from within the Query Analyzer using an execute (exec) command.

          

  43. An example of executing a stored procedure: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.

          

  44. CONVERT(nvarchar(10), OrderDate, 101) ???subtypes of datetime data type

          

  45. CREATE VIEW vwCustomer
    AS
    SELECT CustomerId, Company Name, Phone
    FROM Customers
    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.

          

  46. how can you create tables using ANSI SQL syntax?you will use the create table statement to accomplish this task.

          

  47. tinyint ???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).

          

  48. Boolean ???This data type converts true and false string values to bit values, with true converted to 1 and false converted to 0.

          

  49. VARCHAR(25) ?Specify that a string supports a maximum of only 25 characters

          

  50. datetime2* ???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.

          

  51. A Unicode character uses ___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.

          

  52. smalldatetime ???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.

          

  53. The date and time data types include ___date, datetime, datetime2, datetimeoffset, smalldatetime, and time.

          

  54. A less direct method of attack injects malicious code into ___date, datetime, datetime2, datetimeoffset, smalldatetime, and time.

          

  55. if your columns store 8 bits or fewer, the columns will be stored as ___between the dates of January 1, 1753, and December 31, 9999, that are accurate to 3.33 milliseconds,

          

  56. For example, although a DateTime value is represented as a float, ___8 bytes of storage

          

  57. Unicode data types are identified with ___NCHAR and NVARCHAR

          

  58. time* ???Defines a date. Range: 0001-01-01 through 9999-12-31. Accuracy: one day.

          

  59. datetimeoffset* ???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.

          

  60. syntax of the cast function ???CONVERT ( data_type [ ( length ) ], expression [,style ] )

          

  61. Using a stored procedure ___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.

          

  62. Money and smallmoney are ___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.

          

  63. Non-Unicode data type varchar[(n|max)] is a ___bit data type.

          

  64. nchar ???Unicode Character data type with fixed length.

          

  65. Exact numerics include ___underlying tables.

          

  66. The syntax for decimal data type is expressed as ___numeric[(p[,s])]

          

  67. A view is also a mechanism to ___simplify query execution.

          

  68. bigint ???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).

          

  69. Scale(s) ???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.

          

  70. varbinary ???Binary data with variable length.

          

  71. "exec"tells SQL Server to execute the code in the stored procedure.

          

  72. char ???If you are supporting multiple languages, use this data type.

          

  73. Once you have defined a view, you can reference it as you would any other ___create a stored procedure for them and run that stored procedure from within the Query Analyzer using an execute (exec) command.

          

  74. how many bytes datetime data type uses ___8 bytes of storage

          

  75. cast(count AS float) ???convert the count variable to a float

          

  76. You should also avoid using spaces because they add complications that make it necessary for you to use ___quotes

          

  77. ntext ??This data type will be removed in future SQL releases; therefore, use nvarchar(max) instead.

          

  78. Reasons to provide a view instead of enabling users to access the underlying tables in your database:you will use the create table statement to accomplish this task.

          

  79. smallmoney, monetary or currency values from ___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.

          

  80. text ???This data type will be removed in future SQL releases; therefore, use varchar(max) instead.

          

  81. if you multiply an item's cost (represented as a float) with the number of items (represented as an integer), the answer will be ___you may not implicitly convert to a float because it is meant to be a date and/or time.

          

  82. indexing plays a role in query time and an even greater role in ___database performance improvements.

          

  83. Views are referred to as ___previously written SQL statement that has been "stored" or saved into a database.

          

  84. Add Table dialog box ???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)

          

  85. nvarchar ???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.

          

  86. data set char is identified as ___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.

          

  87. image ???Defines a date. Range: 0001-01-01 through 9999-12-31. Accuracy: one day.

          

  88. Steps to create a stored procedure (SSMS) :Programmability section >>> Right-click Stored Procedures and choose New Stored Procedure

          

  89. Database views are designed to create a virtual table that is representative of ___decimal[(p[,s])]

          

  90. Steps to create your view:Right-click the Views folder, then select New View.

          

  91. When a conversion (convert values from one data type to another) is done automatically it is called an ___numeric[(p[,s])]

          

  92. Differences between regular and Unicode are the ___bytes of storage used for each.

          

  93. NVarchar ???If you are supporting multiple languages, use this data type.

          

  94. when you are expressing a Unicode character literal, it must have the letter ___table in a database.

          

  95. Adding indexes to the schema can actually increase the overhead of your database due to the ___ongoing maintenance of these indexes.

          

  96. varchar ???Character data type with variable length.

          

  97. There are two methods for creating a view:• By using SSMS
    • By writing a Transact-SQL statement

          

  98. A regular character literal is always expressed with ___CHAR and VARCHAR

          

  99. SQL injection is an ___SQL Server Management Studio

          

  100. date* ???is a Transact-SQL integer data type that takes a value of 1, 0, or NULL

          

  101. data type ???Defines a date. Range: 0001-01-01 through 9999-12-31. Accuracy: one day.

          

  102. The injection process's function is to ___provide a structure for storing data within a relational database.

          

  103. SELECT * FROM USERLISTWhat this select statement does is return all the data that is found in the USERLIST table.

          

  104. numeric & decimal ???If you are supporting multiple languages, use this data type.

          

  105. LOB ?Character data type with fixed length.

          

  106. One way to save time when running the same query over and over again is to create a ___to bit values. Specifically, TRUE is converted to 1 and FALSE is converted to 0.

          

  107. built-in data types is a wide range of ___NCHAR and NVARCHAR

          

  108. you should use the datetime data type if you will be storing values ___between the dates of January 1, 1753, and December 31, 9999, that are accurate to 3.33 milliseconds,

          

  109. bit ???Binary data with fixed length.

          

  110. A stored procedure is a ___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.

          

  111. int ??Binary data with fixed length.

          

  112. Microsoft SQL Server supports only two character string types:-922,337,203,685,477.508 to 922,337, 203,685,477.5807

          

  113. The primary form of SQL injection is a direct insertion of code into ___numeric[(p[,s])]