Suppose we have a relational table EMPLOYEE(EMPNO, NAME, DNO, MGR, SAL). Duplicate values in the EMPNO attribute can be allowed under relational DB design principles.   

Select ALL that apply to indexing:

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

Who first proposed the relational database design?

Complete SQL statement to set the value of the City field to ‘Columbus’ for zip code values 43235: [BLANK1] Customers [BLANK2] City = ‘Columbus’ [BLANK3] Zip = ‘43235’ ;

JOIN SQL keyword is used to:

The functions of a DBMS are:

Consider the following schema: Employees (Empcode, Name, Sex, Salary, Dept) If this query is executed, what is it going to display? SELECT Dept FROM Employees WHERE Sex = ‘M’ GROUP by Dept HAVING AVG (Salary) > (SELECT AVG (Salary) FROM Employees)

What will this SQL statement do?   SELECT PART, SUPPLIER, PARTS.PROD#, PRODUCT, PRICE FROM PARTS LEFT OUTER JOIN PRODUCTS ON PARTS.PROD#=PRODUCTS.PROD# AND PRODUCTS.PRICE>10.00;

Tree-based indexes are best for looking up values based on the range tests because they keep references to data in sorted order.