QUESTION 9 10 points Save Answer What is the purpose for having a relational database management system? To extract and manipulate big data To store data tables that relate to one another through keys To access data more quickly O To share data across platforms QUESTION 10 10 points Save Answer Which of the following does a relational database not contain? O Tables O Queries OID Graphs Indices QUESTION 11 10 points Save Answer Microsoft Access can help beginners learn SQL because it... O offers more SQL functionality than other SQL tools O generates SQL code from visual representations of queries O offers a video tutorial on creating strong SQL commands integrates well with Microsoft Excel to create advanced SQL statements QUESTION 12 10 points Save Answer When was SQL developed by IBM? 1950s O 1960s 1970s 1980s QUESTION 13 10 points Save Answer Which of the following includes matched records from the right table and all records from the left table? O INNER JOIN LEFT JOIN RIGHT JOIN O FULL JOIN QUESTION 14 10 points Save Answer Which of the following is using records that have matching values in both tables? O INNER JOIN LEFT JOIN O RIGHT JOIN FULL JOIN QUESTION 15 10 points Save Answer If we run this query SELECT departmentid, MAX(salary) FROM employees group by departmentid. What will the query show? The maximum salary for every department The maximum salary for every employee, organized by department The department id that has the highest salary across all the departments The employee that has the highest salary within each department QUESTION 16 10 points Save Answer Which join uses records that have matching values in both tables? Inner join O Left join O Right join O Full join QUESTION 17 10 points Save Answer Which join uses records whether or not there are matching values in both tables? Inner join O Left join Right join O Full join QUESTION 18 10 points Save Answer Which of the following is correct? Select EmployeeName From Employees Where 1234 Select EmployeeName Where ID = 1234 From Employees Select Employee Name From Employees Where ID = 1234 O Select Employees. EmployeeName Where ID = 1234