Question
QUESTION 5 Suppose there are two tables: A and B. and we run command SELECT * from A LEFT JOIN B on A.orderid = B.orderid.
QUESTION 5
-
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
-
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
-
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
-
Which of the following is not a type of join?
LEFT JOIN
FULLER INNER JOIN
INNER JOIN
FULL OUTER JOIN
10 points
QUESTION 9
-
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
-
Which of the following does a relational database not contain?
Tables
Queries
ID Graphs
Indices
10 points
QUESTION 11
-
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
-
When was SQL developed by IBM?
1950s
1960s
1970s
1980s
10 points
QUESTION 13
-
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
-
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
-
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
-
Which join uses records that have matching values in both tables?
Inner join
Left join
Right join
Full join
10 points
QUESTION 17
-
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
-
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started