basic SQL statements

Question 1 3ptsIf introduced as follows, the subquery can return which of the values listed below? WHERE vendor_id NOT IN (subquery) a single value a column of one or more rows a table asubquery can’t be introduced in this way Question 2 3 pts If introduced as follows, the subquery can return which of the values listed below?
WHERE (subquery) If introduced as follows, the subquery can return which of the values listed below? WHERE (subquery) a single value a column of one or more rows a table asubquery can’t be introduced in this way Question 3 3 pts

You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement. FROM WHERE SELECT NONE OF THE THESE CHOICES Question 4 3pts Skip to Question text. Assuming that all of the table and column names are spelled correctly, what’s wrong with the INSERT statement that follows? INSERT INTO invoices (vendor_id, invoice_number, invoice_total, payment_total, credit_total, terms_id, invoice_date, invoice_due_date) VALUES (97, ‘456789’, 8344.50, 0, 0, 1, ’31-AUG-08′) The column names in the column list are in the wrong sequence. There are too many items in the column list. There are too few items in the VALUES list. The number of items in the column list doesn’t match the number in the VALUES list. Question 5 3pts By default, the INSERT, UPDATE, and DELETE statements that you issue don’t make permanent changes to an Oracle database until you issue a _____________________ statement. By default, the INSERT, UPDATE, and DELETE statements that you issue don’t make permanent changes to an Oracle database until you issue a _____________________ statement. Commit Rollback Save Save Changes Question 6 3 pts

A subquerycan be coded in a WHERE, FROM, SELECT, or ______________ clause. Having Order By group By None of these choices Question 7 3pts If first_name contains Edward and last_name contains Williams, what will the Solution column contain when this code is executed? LOWER(LEFT(first_name,1) + LEFT(last_name,7)) AS solution If first_name contains Edward and last_name contains Williams, what will the Solution column contain when this code is executed? LOWER(LEFT(first_name,1) + LEFT(last_name,7)) AS solution EWilliams EWilliam ewilliams ewilliam Question 8 3 ptsWhich uses the least amount of storage? Which uses the least amount of storage? ‘example’ stored in a column of type CHAR(20) ‘exam’ stored in a column of type CHAR(20) ‘ex’ stored in a column of type CHAR(20) they all use the same amount of storage Question 9 3pts The _____________________ of a numeric data type indicates the total number of digits that can be stored in the data type. The _____________________ of a numeric data type indicates the total number of digits that can be stored in the data type. magnitude type scale precision Question 10 1 pts All of the following values can be stored in a column that’s defined as NUMBER(6,2), except All of the following values can be stored in a column that’s defined as NUMBER(6,2), except 32492.05 -246.29 0 2479.95 Question 11 3 pts The DATE data type can store The DATE data type can store dates only dates and times times only dates and numbers Question 12 3 ptsWhich uses the least amount of storage? Which uses the least amount of storage? ‘example’ stored in a column of type VARCHAR2(20) ‘exam’ stored in a column of type VARCHAR2(20) ‘ex’ stored in a column of type VARCHAR2(20) they all use the same amount of storage Question 13 3pts To store an integer with an Oracle data type (not one of the ANSI standard synonyms), you use the ____________________ data type. Pick the best answer. To store an integer with an Oracle data type (not one of the ANSI standard synonyms), you use the _…

Looking for solution of this Assignment?

WHY CHOOSE US?