Author: Anonymous

What is the correct SQL syntax for selecting  Customer records with LastName alphabetically between (and including) “Hansen” and “Pettersen” ?  

What is the dot product of the two vectors below? The magnitudes of the vectors are 66 and 110, and the angle between the vectors is 40 degree. 

___________ anomaly may cause a loss of data that would be needed for other future rows or referenced in other parts of a DB.

Select ALL that apply to indexing:

For two union compatible sets R and S, the relational algebra expression R-S will always produce the same results as S-R regardless of the data contained in R and in S.

The ALTER SQL statement can do the following except:

Compared to an INNER JOIN, an OUTER JOIN may

CHECK ALL THAT APPLY : Suppose we have a table constraint, in an SQL Create Table statement for Orders, such as Foreign Key Snumb References Supplier (Snumb) On Delete Cascade. If we execute Delete from Supplier where Snumb = 100, then  …    

Using the relational schema given, suppose that S1 is a foreign key referring to A1. Which of the following statements must be true?      R1                                                                                    R2  

Which of the following is NOT TRUE about a log file used by a DBMS for transaction management: