Quiz
CET_TARDE - MTA Database - E_Join_Union_Intersect
Questions in this quiz (5)
1You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?
- AINTERSECT
- BUNION
- CJOIN
- DTRUNCATE
2You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?
- ATRUNCATE
- BJOIN
- CEXCEPT
- DUNION
3You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include:
. All customers and their orders
. Customers who have no orders
Which type of join do these results represent?- AComplete join
- BPartial join
- CInner join
- DOuter join
4You have two tables named Cars and Color as defined below. The two tables are related by ColorId.
How many rows does the SQL statement return?
- A0
- B2
- C3
- D6
5This question requires that you evaluate the underlined text to determine if it is correct. The UNION keyword combines the results of two queries and returns only rows that appear in both result sets. Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct:
- ANo change is needed
- BINTERSECT
- CALL
- DUOIN
Information
- Description
- Database Quizzes preparing to certification
- Author
- Hawerth Castro
- Language
- Português
- Views
- 58
- Tags
- Rating
- No ratings yet Rate this quiz