113 Multiple choice questions
- 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).
- CHAR and VARCHAR
- myAddress and vendorTerms
- 4 bytes of storage
- 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)
- This data type will be removed in future SQL releases; therefore, use varbinary(max) instead.
- force a conversion
- ANSI standards, which allow you to import or export to other database management systems.
- 1 byte
- underlying tables.
- This data type converts true and false string values to bit values, with true converted to 1 and false converted to 0.
- current date within each new record for that specific field.
- 16-byte GUID.
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.
- query object
- bytes of storage used for each.
- single quotes. For example: 'This is how a regular character string literal looks'
- Right-click the Views folder, then select New View.
- between January 1, 1900, and June 6, 2079, that are accurate to only 1 minute.
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.
- 2 bytes
- Defines a date. Range: 0001-01-01 through 9999-12-31. Accuracy: one day.
- exec usp_displayallusers
- is an easy-to-use graphical interface.
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.
- Character data type with fixed length.
- data type with lower precedence
is converted to the data type with higher precedence.
- INSERT INTO planets (name, diameter) VALUES ('earth', CAST (10000 as varchar(50)))
- stored procedure that you can then execute from within the database's command environment.
- variable-length data set that can consist of 1 to 8,000 characters.
- store mathematical computations and is employed when you do not require a decimal point output.
- int, bigint, bit, decimal, numeric, money, and smallmoney
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.
- to bit values. Specifically, TRUE is converted to 1 and FALSE is converted to 0.
- predefined data types (Microsoft SQL Server)
- Character data type with variable length.
- you may not implicitly convert to a float because it is meant to be a date and/or time.
- • Exact numbers
• Approximate numbers
• Date and time
• Character strings
• Unicode character strings
• Binary strings
• Other data types
• CLR data types
• Spatial data types
- previously written SQL statement that has been "stored" or saved into a database.
- What this select statement does is return all the data that is found in the USERLIST table.
- database performance improvements.
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.
- Integer data from 0 to 255.
- convert the count variable to a float
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.
- Binary data with variable length.
- This data type will be removed in future SQL releases; therefore, use nvarchar(max) instead.
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.
- -922,337,203,685,477.508 to 922,337, 203,685,477.5807
- create a stored procedure for them and run that stored procedure from within the Query Analyzer using an execute (exec) command.
- is a Transact-SQL integer data type that takes a value of 1, 0, or NULL
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
- table in a database.
value with a size greater than the default threshold, that value will
be stored external to the row and identified as a large object.
- using simple query statements.
- This numeric data type is used in places where you want money or currency involved in your database;
- This character-string data type is commonly used in databases where you are supporting English attributes.
- • 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
- simplify query execution.
- Binary data with fixed length.
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.
- If you are supporting multiple languages, use this data type.
- NCHAR and NVARCHAR
- you will use the create table statement to accomplish this task.
- bit data type.
- OrderDetails or CustomerAddresses
- • 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
- expressed as a float.
[(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.
- Integer data from -2^15 (-32,768) to 2^15-1 (32,767).
- date, datetime, datetime2, datetimeoffset, smalldatetime, and time.
- Regular and Unicode.
- A value with a size identified up to a certain threshold (the default is 8,000) is stored inline in the row.
in which malicious code is inserted into strings that are later passed
on to instances of SQL Server waiting for parsing and execution.
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
seconds. Range: 1900-01-01 through 2079-06-06 Accuracy: one minute.
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.
- Transact-SQL data types that have a fixed precision and scale. Valid values range from -10^38+1 through 10^38-1.
- user-input variables that are concatenated with SQL commands and then executed.
- a virtual table consisting of different columns from one or more tables;
( or )
an object that obtains its data from one or more tables.
- SQL Server Management Studio
- 1 and 8,000, making the storage size n bytes.
- Programmability section >>> Right-click Stored Procedures and choose New Stored Procedure
- subtypes of datetime data type
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
- ongoing maintenance of these indexes.
- Unicode Character data type with fixed length.
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.
- implicit conversion.
- provide a structure for storing data within a relational database.
will convert the OrderDate, which is a DateTime data type to nvarchar
value. The 101 style represents USA date with century. mm/dd/yyyy.
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
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.
- one or more tables in an alternative way.
- cast(source-value AS destination-type)
- N (for National) prefixing the single quote. For example: N'This is how a Unicode character string literal looks'
- • By using SSMS
• By writing a Transact-SQL statement
- CONVERT ( data_type [ ( length ) ], expression [,style ] )
- used to store date and time data in many different formats.
- an attribute that specifies the type of data an object can hold, as well as how many bytes each data type takes up.
- Stores values of various SQL Server-supported data types, except text, ntext, image, timestamp, and sql_variant.
- stored in a database.
- Specify that a string supports a maximum of only 25 characters
- between the dates of January 1, 1753, and December 31, 9999, that are accurate to 3.33 milliseconds,
- This data type will be removed in future SQL releases; therefore, use varchar(max) instead.
- 8 bytes of storage
- -214,748.3648 to 214,748.3647
- Unicode Character data type with variable length.
- 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).
- tells SQL Server to execute the code in the stored procedure.
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.