When you code a select statement. you must code the four main clauses in the following order

SQL Question 1 When coded within a SELECT clause, which TOP clause will return a result set consisting of the ten largest InvoiceNumbers?

a. TOP InvoiceNumber, InvoiceTotal
b. TOP 10 InvoiceTotal
c. TOP 10 InvoiceNumber
d. TOP 10 PERCENT WITH TIES InvoiceNumber
e. TOP 10 PERCENT InvoiceNumber
10 points Question 2 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?
a. NOT (PaymentDate IS NULL AND InvoiceTotal <= 500)
b. PaymentDate IS NOT NULL OR InvoiceTotal >= 500
c. PaymentDate IS NOT NULL AND InvoiceTotal >= 500
d. PaymentDate IS NULL AND InvoiceTotal > 500
10 points Question 3 When you code an ORDER BY clause, you can specify a
a. column name or expression
b. column name or alias
c. column name, alias, or expression
d. column name, alias, expression, or column number
10 points Question 4 The order of precedence for the logical operators in a WHERE clause is
a. Not, Or, And
b. And, Or, Not
c. Not, And, Or
d. Or, And, Not
10 points Question 5 Which of the following is not a valid column alias name?
a. TotalSales
b. Total
c. “Total Sales”
d. Total Sales
10 points Question 6 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?
a. (InvoiceTotal – (PaymentTotal + CreditTotal)) * 0.10
b. ((InvoiceTotal – PaymentTotal) – CreditTotal) / 10
c. (InvoiceTotal – PaymentTotal – CreditTotal) / 10
d. InvoiceTotal – CreditTotal – PaymentTotal / 10
10 points Question 7 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?
a. InvoiceTotal BETWEEN 0 AND 1000
b. InvoiceTotal IN (0,1000)
c. NOT (InvoiceTotal > 1000)
d. InvoiceTotal <= 1000
10 points Question 8 Which ORDER BY clause will cause 10 rows to be retrieved from the result set, starting with the 20th row?
a. ORDER BY InvoiceTotal DESC
    OFFSET 20 ROWS
    FETCH FIRST 10 ROWS
b. ORDER BY InvoiceTotal DESC
    OFFSET 0 ROWS
    FETCH NEXT 10 ROWS
c. ORDER BY InvoiceTotal DESC
    OFFSET 10 ROWS
    FETCH FIRST 20 ROWS
d. ORDER BY InvoiceTotal DESC
    OFFSET 20 ROWS
    FETCH NEXT 10 ROWS
10 points Question 9 When you code a SELECT statement, you must code the four main clauses in the following order
a. SELECT, FROM, WHERE, ORDER BY
b. SELECT, WHERE, ORDER BY, FROM
c. SELECT, FROM, ORDER BY, WHERE
d. SELECT, ORDER BY, FROM, WHERE

Answer

Answer 1> c 2> c 3>a 4> c 5> d 7> b 8> d 9> aCoturmn name AnsNO AND, OP Not, AND, OR ofols

Leave a Comment