A table can be deleted from the database by using the _______ command. MODIFY TA

Question

A table can be deleted from the database by using the _______ command. MODIFY TABLE DELETE TABLE DROP TABLE ERASE TABLE A _______ is a query (SELECT statement) inside a query. range query subquery join set query The SQL data manipulation command HAVING, _______ restricts the selection of rows based on a conditional expression. restricts the selection of grouped rows based on a condition. modifies an attribute's values in one or more table's rows. groups the selected rows based on one or more attributes. Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customer Jenna and Howard are included in the CUSTOMER tables as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator? _______ 7 10 15 17

Explanation / Answer

7. A table can be deleted by using DELETE command.

a) MODIFY table – is used to modify the data in the table.

b) DELETE table – is used to delete the table in a database.

c) DROP table – is used to drop an existing table in a database.

d) ERASE table – no such command.

So the answer is (b) DELETE table

8. _________ is a query (select statement) within a query

(a) range query – the values will selected or tested within a range Ex: between

(b) subquery – is a query which is been embedded in the main SELECT statement.

(c) join – join clause is used in sql to combine column from one or more tables in a relational database.

(d) set query – to update the value of the columns in a database

So the answer is (b) subquery

9. The SQL data manipulation command Having,

(a) restricts the selection of rows based on a conditional expression – where clause is used

(b) restricts the selection of grouped rows based on a condition. – where clause is used

(c) modifies an attribute’s values in or more tables rows. – modify table is used

(d) groups the selected row based on one or more attributes – HAVING is used to group the selected rows based on one or more attributes.

So the answer is (d) groups the selected row based on one or more attributes

10.

Answer: the union all operators is used to combine the result sets of more than 2 tables using SELECT statement without removing the duplicate rows between the tables.

(a) 7

(b) 10

(C) 15

(d) 17

Answer: (d) 17.

(Table1) CUSTOMER contains 10 rows and table2 CUSTOMER_2 contains 7 rows. The UNION ALL operator is used to combine the two tables without any removal of duplication.

So combining the two table rows (10 + 7), 17 rows will be displayed as a result.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.