Answer the following statements true (T) or false (F)
1) The set operator UNION does not repeat duplicate rows, but UNION ALL does.
2) TableA MINUS TableB is same as TableB MINUS TableA all the time.
3) A self join can be performed on any table, because all you need is one table.
4) An outer join usually returns more information than an equijoin on same tables.
5) Two tables must have established foreign key – primary key relationship in order to perform non-equijoin on them.
1) T
2) F
3) F
4) T
5) F
You might also like to view...
When Hyper-V loads for the first time, it creates the parent _______________.
Fill in the blank(s) with the appropriate word(s).
Web 2.0 is often referred to as a(n) ____________________ or a database-backed Web because Web-based applications read from or write to a database when they access or update content.
Fill in the blank(s) with the appropriate word(s).
You need to write some text for a new page the Director asked you to create. In what program is it easiest to do this?
A. Dreamweaver B. Word C. Access D. Acrobat
Infrared technology is the preferred technology for wireless devices.
Answer the following statement true (T) or false (F)