Question

QUESTION 5

1. Suppose there are two tables: A and B. and we run command SELECT * from A LEFT JOIN B on A.orderid = B.orderid. What would be the code output?

   		only the records from table A where tables A and B have the same orderid
   		only the records from table B where tables A and B have the same orderid
   		the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid
   		the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid

10 points   

QUESTION 6

1. Suppose there are two tables: A and B and we run command SELECT * from A INNER JOIN B on A.orderid = B.orderid. What would be the code output? ;

   		only the records from table A where tables A and B have the same orderid
   		only the records from both tables A and B where tables A and B have the same orderid
   		the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid
   		the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid

10 points   

QUESTION 7

1. What is the function COUNT() used for?

   		to return the number of tables in a database.
   		To return the number of SQL statements in query
   		To return the number of columns that match a specified criteria
   		To return the number of rows that match a specified criteria

10 points   

QUESTION 8

1. Which of the following is not a type of join?

   		LEFT JOIN
   		FULLER INNER JOIN
   		INNER JOIN
   		FULL OUTER JOIN

10 points   

QUESTION 9

1. 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
   		To share data across platforms

10 points   

QUESTION 10

1. Which of the following does a relational database not contain?

   		Tables
   		Queries
   		ID Graphs
   		Indices

10 points   

QUESTION 11

1. Microsoft Access can help beginners learn SQL because it...

   		offers more SQL functionality than other SQL tools
   		generates SQL code from visual representations of queries
   		offers a video tutorial on creating strong SQL commands
   		integrates well with Microsoft Excel to create advanced SQL statements

10 points   

QUESTION 12

1. When was SQL developed by IBM?

   		1950s
   		1960s
   		1970s
   		1980s

10 points   

QUESTION 13

1. Which of the following includes matched records from the right table and all records from the left table?

   		INNER JOIN
   		LEFT JOIN
   		RIGHT JOIN
   		FULL JOIN

10 points   

QUESTION 14

1. Which of the following is using records that have matching values in both tables?

   		INNER JOIN
   		LEFT JOIN
   		RIGHT JOIN
   		FULL JOIN

10 points   

QUESTION 15

1. 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

10 points   

QUESTION 16

1. Which join uses records that have matching values in both tables?

   		Inner join
   		Left join
   		Right join
   		Full join

10 points   

QUESTION 17

1. Which join uses records whether or not there are matching values in both tables?

   		Inner join
   		Left join
   		Right join
   		Full join

10 points   

QUESTION 18

1. Which of the following is correct?

   		Select EmployeeName From Employees Where 1234
   		Select EmployeeName Where ID = 1234 From Employees
   		Select EmployeeName From Employees Where ID = 1234
   		Select Employees.EmployeeName Where ID = 1234

Answer 1

Q5). C

Q6). B

Q7). D

Q8). B

Q9). B

Q10). C

Q11). B

Q12). C

Q13). B

Q14). A

Q15). A

Q16). A

Q17). D

Q18). C