(Solved) : 1 1 Union Operator Duplicate Rows Keeps Adjusts Key B Keeps C Removes D Puts Special Dum Q42917651 . . .

$9.00

good day i need homework help please
a. 1 1.)What does the UNION operator do with duplicate rows? a. keeps them but adjusts the key b. keeps them C. removes thema. 1 1.)What does the UNION operator do with duplicate rows? a. keeps them but adjusts the key b. keeps them C. removes them d. puts them into a special dump file 2. What statement is used to create an Index on all the words in the indexed column? a. CREATE FULLTEXT INDEX b. CREATE SPATIAL INDEX C. CREATE PRIMARY INDEX d. CREATE UNIQUE INDEX 3.)What do you call the foreign key where both parts of the key are in the same table. a inward b. local c. self-referencing d. relative 4.)A correlated subquery is evaluated_ time(s) for each row in the outer query. b. O c.2 d. unlimited 5.) What do you do to handle a possible duplicate key violation on a primary key? a. use an ON DUPLICATE KEY UPDATE option b. dont do anything, because you want an error to alert you C. remove any possible duplicate row before trying to insert a new one d. check whether the key exists in the table before trying to insert it 6.What does the MINUS Operator do? a. returns all the rows from the right our only b. returns all the rows of two or more queries C. returns only distinct rows from the first query that aren’t output d. returns all the rows from the left query only 7.What statement must you use to write the changes into a COMMIT b. ROLLBACK C. CLOSE TRANSACTION d. END TRANSACTION 8.)How does the ORDER BY clause sort strings? a in a digital fashion b. in a singular fashion c. In an objective manner d. in a linear fashion 9.)if you needed to get the top three clients with the clauses would you have to add to your query? a. ORDER BY creditlimit DESC b. SORT BY creditimit ASC c. ORDER BY creditlimit ASC d. SORT BY creditlimit DESC . 10.What will be the output of a query given SELECT * FROM person WHERE person id= 1; a. Show all columns and rows b. None of the mentioned c. Shows only columns person_id d. Show all columns but only those rows which belongs to person 11.What statement should be used to add data to a table? a. ADD b. DUMP C. INSERT d. LOAD Show transcribed image text a. 1 1.)What does the UNION operator do with duplicate rows? a. keeps them but adjusts the key b. keeps them C. removes them d. puts them into a special dump file 2. What statement is used to create an Index on all the words in the indexed column? a. CREATE FULLTEXT INDEX b. CREATE SPATIAL INDEX C. CREATE PRIMARY INDEX d. CREATE UNIQUE INDEX 3.)What do you call the foreign key where both parts of the key are in the same table. a inward b. local c. self-referencing d. relative 4.)A correlated subquery is evaluated_ time(s) for each row in the outer query. b. O c.2 d. unlimited 5.) What do you do to handle a possible duplicate key violation on a primary key? a. use an ON DUPLICATE KEY UPDATE option b. dont do anything, because you want an error to alert you C. remove any possible duplicate row before trying to insert a new one d. check whether the key exists in the table before trying to insert it 6.What does the MINUS Operator do? a. returns all the rows from the right our only b. returns all the rows of two or more queries C. returns only distinct rows from the first query that aren’t output d. returns all the rows from the left query only 7.What statement must you use to write the changes into a COMMIT b. ROLLBACK C. CLOSE TRANSACTION d. END TRANSACTION 8.)How does the ORDER BY clause sort strings? a in a digital fashion b. in a singular fashion c. In an objective manner d. in a linear fashion 9.)if you needed to get the top three clients with the clauses would you have to add to your query? a. ORDER BY creditlimit DESC b. SORT BY creditimit ASC c. ORDER BY creditlimit ASC d. SORT BY creditlimit DESC . 10.What will be the output of a query given SELECT * FROM person WHERE person id= 1; a. Show all columns and rows b. None of the mentioned c. Shows only columns person_id d. Show all columns but only those rows which belongs to person 11.What statement should be used to add data to a table? a. ADD b. DUMP C. INSERT d. LOAD

Expert Answer


Answer to a. 1 1.)What does the UNION operator do with duplicate rows? a. keeps them but adjusts the key b. keeps them C. removes …

Description

good day i need homework help please
a. 1 1.)What does the UNION operator do with duplicate rows? a. keeps them but adjusts the key b. keeps them C. removes thema. 1 1.)What does the UNION operator do with duplicate rows? a. keeps them but adjusts the key b. keeps them C. removes them d. puts them into a special dump file 2. What statement is used to create an Index on all the words in the ... View full description