ALL OF THESE QUESTIONS NEED TO BE ANSWERED WITHIN 1 HOUR!!!
1. What are SQL built-in functions?
2. What is meant by the degree of a relationship?
3. Explain the concept of a foreign key.
4. Describe the SQL keyword LIKE and how it is used. Include a SQL statement that uses the keyword LIKE based on the CUSTOMER table below.
CUSTOMER
CustNo CustName Balance SalesRepNo
9870 Winston 500 345
8590 Gonzales 350 434
7840 Harris 800 654
4870 Miles 100 345
5. What are business intelligence (BI) systems?
6. Briefly explain the strategy of two-phased locking.
7. List and describe the four types of JDBC drivers.
8. Given the following table, write the SQL query to retrieve the Name and Phone Number of customers whose name starts with 'S'.
CUSTOMER(CustID, Name, PhoneNumber, AccountBalance),