CIS 407 Practice Questions
Which statement is used to modify the structure of an existing table?
ALTER TABLE
Which statement do you use to modify an existing view?
ALTER VIEW
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
Each of the following column attributes is a column constraint, except
DEFAULT
Write the code for a DELETE statement that deletes every row in the Vendors table
DELETE Vendors;
To test whether one or more rows are returned by a subquery, you can use which operator?
EXISTS
A subquery can be coded in a WHERE, FROM, SELECT, or ______________ clause.
HAVING
A collation can affect all of the following except one. Which one?
How character data is concatenated
Which of the following statements is true?
Implicit data type conversion is performed when you mix values of different data types in an expression.
A subquery is a/an ______________ statement that's coded within another SQL statement.
SELECT
A view is a/an ________________ statement that's stored as an object in the database.
SELECT
What attribute can you use to optimize storage when coding the definition for a column that will contain a high percentage of null values?
SPARSE
You use the UPDATE statement to modify one or more rows in the table named in the ________________ clause.
UPDATE
Which of the following can you use to create or modify a view in SQL Server Management Studio?
View Designer
When you code a DELETE statement for one or more rows, which clause specifies which row or rows are to be deleted?
WHERE
You specify the conditions that must be met for a row to be deleted in the which clause?
WHERE
Each of the following is a benefit provided by using views except for one. Which one is it?
You can create a view that simplifies data insertion by hiding a complex INSERT statement within the view.
If introduced as follows, the subquery can return which of the values listed below?WHERE InvoiceTotal > ALL (subquery)
a column of one or more rows
If introduced as follows, the subquery can return which of the values listed below?WHERE 2 < (subquery)
a single value
When you identify a column as the primary key, the column
all of the above
You can code views that: Join tables summarize data use subqueries all of the above
all of the above
You use data definition language (DDL) to create, modify, and delete the ________________ of a database.
all of the above
The first character of a regular identifier can be
any of the above
What kind of constraint limits the values that can be stored in a column?
check constraint
When you use the CREATE TABLE statement to create a table, you can also define the attributes and ______________ for the columns.
constraints
The CREATE TABLE statement
creates a new table in the current database
To store a date value without storing a time value, you can use the
date data type
You can use what data type to store a date that includes a time zone offset?
datetimeoffset
Which data types are used to store whole numbers?
integer
A correlated subquery is one that
is executed once for each row in the outer query
When you code a column list in an INSERT statement, you can omit identity columns, columns that have default values, and columns that allow __________ values.
null
The WITH CHECK option of the CREATE VIEW statement
prevents an update from being performed through the view if it causes a row to no longer be included in the view
The WITH ENCRYPTION clause of the CREATE VIEW statement
prevents users from seeing the code that defines the view
An index improves performance when SQL Server
searches a table
In an UPDATE statement, the WHERE clause will
specifiy the condition a row must meet to be updated
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
When you define a foreign key constraint, you can specify all but one of the following. Which one is it?
that the insertion of a row in a foreign key table that has a foreign key that isn't matched in the primary key table should be cascaded up to the primary key table
When you code a script for creating a database,
you need to create the referred to tables before you create the tables that refer to them