IST 272 Test 1

To return all of the columns from the base table, you can code the ___________ operator in the SELECT clause.

*

To concatenate character strings, you use the _____________ operator in a string expression.

+

Insert, Update, and Delete statements can be referred to as ______________ queries.

action

Unless you assign a/an _____________________________, the column name in the result set is the same as the column name in the base table.

alias

___________________ names can be used when you want to assign a temporary name to a table.

Correlation

SQL statements that define the tables in a database are referred to as _______________ statements.

DDL

To sort the records that are retrieved by a SELECT statement in descending sequence by InvoiceTotal, you code _________ after ORDER BY InvoiceTotal.

DESC

To prevent duplicate rows from being returned by a SELECT statement, you can code the __________________ keyword in the SELECT clause.

DISTINCT

Select, Insert, Update, and Delete statements can be referred to as ______________ statements.

DML

To retrieve rows in which an expression matches a string pattern called a mask, you can use the ______________ keyword followed by the mask.

LIKE

The ________________________________________ is a graphical user interface for working with the objects in a SQL Server database.

Management Studio

In the join shown here: SELECT VendorName AS Vendor, InvoiceDate AS I_Date FROM Vendors AS V JOIN Invoices AS I ON V.VendorID = I.VendorID The column name for the second column in the result set will be __________________________.

I_Date

When coded in a WHERE clause, which search condition will return invoices when PaymentDate is not null and InvoiceTotal is greater than or equal to $500?

PaymentDate IS NOT NULL AND InvoiceTotal >= 500

Which of the following is not a valid column alias name?

Total Sales

To override the order of precedence in an arithmetic expression, you can use parenthesis.

True

Which of the following expressions will not compute 10% of the balance due if balance due is the invoice total minus the credit total minus the payment total?

InvoiceTotal - CreditTotal - PaymentTotal / 10

When coded in a WHERE clause, which of the following search conditions will not return a result set that includes all invoices with an InvoiceTotal value of $1000 or less?

InvoiceTotal IN (0,1000)

The join shown here: SELECT VendorName AS Vendor, InvoiceDate AS Date FROM Vendors AS V JOIN Invoices AS I ON V.VendorID = I.VendorID is called a/an __________________ join.

inner

A/An __________________ uniquely identifies each row in a table.

primary key

You don't ever need to code a right outer join because _____________.

right outer joins can be converted to left outer joins

In the join shown here: SELECT VendorName, InvoiceNumber FROM Invoices LEFT JOIN Vendors ON Invoices.VendorID = Vendors.VendorID The total number of rows returned by this query must equal_____________.

the number of rows in the Invoices table

When a column in a table is defined, it is given a data _________ that determines what kind of data it can store.

type

When you use Windows authentication to connect to a database, SQL Server

uses the login name and password that you use for your PC to authorize your connection

In a join, column names need to be qualified only _____________

when the same names are used in both tables.

In the join shown here: SELECT VendorName AS Vendor, InvoiceDate AS Date FROM Vendors AS V JOIN Invoices AS I ON V.VendorID = I.VendorID The name V is known as a/an ____________________________________.

correlation name (or table alias)

The ________________ clause of the SELECT statement names the table that contains the data to be retrieved.

FROM

Because the American National Standards Institute publishes the specifications for a standard SQL language, each DBMS vendor's version of SQL follows exactly the same syntax rules.

False

When you code a SELECT statement, you must code the four main clauses in the following order

SELECT, FROM, WHERE, ORDER BY

The SQL dialect that Microsoft SQL Server uses is called _______________.

T-SQL

When you use the implicit syntax for coding joins, the join conditions are coded in the ____________ clause.

WHERE

In most cases, the join condition of an inner join uses the _______________ operator to compare two keys.

equal

The join shown here: SELECT VendorName AS Vendor, InvoiceDate AS Date FROM Vendors AS V JOIN Invoices AS I ON V.VendorID = I.VendorID is coded using the _____________________________ syntax.

explicit (SQL-92)

In most cases, the join condition of an inner join compares the primary key of one table to the ____________________ key of another table.

foreign

To relate one table to another, a/an __________________ in one table is used to point to the primary key in another table.

foreign key

If you want to retrieve all the rows from both tables involved in the join including all unmatched rows, you use a/an _______________ join.

full outer

If you want to retrieve all the rows that satisfy the join condition plus the unmatched rows in the first table, you use a/an _______________ join.

left outer

A relational database can contain ___________.

one or more tables

The most common type of relationship between two tables is a/an ___________________ relationship.

one-to-many