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
