Quiz 4

When coding search conditions, you can use which keyword to create compound search conditions?

AND

You can use a ________________ in the ________________ clause if you need to specify column values or search conditions other than the one named in the UPDATE clause.

join, FROM

The difference between the CAST function and the CONVERT function is that the ________________ function accepts an optional style argument that lets you specify a format for the result

CONVERT

When you code an UPDATE statement for one or more rows, the SET clause specifies the new data for the specified columns and the _________________ clause specifies which row or rows are to be updated.

WHERE

You use the UPDATE statement to modify one or more rows in the table named in the ________________ clause.

UPDATE

All of the following values can be stored in a column that's defined as decimal(6,2), except a. 32492.05 b. -246.29 c. 0 d. 2479.95

a

If you omit the WHERE clause from a DELETE statement

all rows in the table will be deleted

The char and nchar data types are used to store fixed-length strings. Which of the statements below is true? a. The char(2) data type will always contain two characters b. all of the above c. They are typically used to define columns that have a fixed number of characters d. Data stored using these data types occupies the same number of bytes regardless of the actual length of the string.

b

The varchar and nvarchar data types to store variable-length strings. Which of the statements below is true? a. In general, they are less efficient than fixed-length strings. b. Data stored using these data types occupies only the number of bytes needed to store the string c. all of the above d. They are typically used to define columns with a fixed number of characters.

b

When you use the SELECT INTO technique to create tables a. only the column definitions and data are copied b. primary keys, foreign keys, and default values aren't retained c. a and b d. none of the above

c

You can code a subquery a. in the WHERE clause to provide one or more values used in the search condition b. in the FROM clause to identify the rows that are available for update c. all of the above d. in the SET clause to return the value that's assigned to a column

c

You can use what data type to store a date that includes a time zone offset?

datetimeoffset

The integer and decimal data types are considered ________________ because their precision is exact.

exact numeric data types

When you code a column list in an INSERT statement, you can omit to identify columns, columns that have default values, and columns that allow __________ values.

null

To express the value of a floating-point number, you can use

scientific notation

The real data type can be used to store a _________________, which provides for numbers with up to 7 significant digits.

single-precision number

SQL Server supports ________________ of the ANSI-standard data types

some, but not all

To insert several rows selected from another table into a table, you can code an INSERT statement with a/an ______________ in place of the VALUES clause.

subquery

Which choice below will increase the storage capacity of a varchar column so it can store up to 2 gigabytes of data?

varchar(max)