Help with mysql as much as you can

Question 1 (5 points)

Suppose we have two tables listed in the FROM clause in the following order, TableA and TableB. We want to preserve the data in both TableA and TableB while matching information where we can. Which join operator should be used?

Question 1 options:

	INNER JOIN
	CARTESIAN JOIN
	OUTER JOIN
	FULL OUTER JOIN

Question 2 (5 points)

If we write a query and intend to produce a cartesian product, what type of join operator should we use?

Question 2 options:

	CROSS JOIN
	INNER JOIN
	OUTER JOIN
	CARTESIAN JOIN

Question 3 (5 points)

A table should have something besides the primary key that makes each row in the table unique.

Question 3 options:

	True
	False

Question 4 (5 points)

Which clause is logically processed first in an SQL statement?

Question 4 options:

	SELECT
	FROM
	WHERE
	ORDER BY

Question 5 (5 points)

It is possible to query a table in a different database

Question 5 options:

	True
	False

Question 6 (5 points)

When using SSMS Diagrams, which table view is recommended by the instructor?

Question 6 options:

	Column names
	Keys
	Custom
	Standard

Question 7 (5 points)

A NULL is the same as:

Question 7 options:

	A blank
	Unknown
	The empty string
	A zero

Question 8 (5 points)

Suppose we have two tables listed in the FROM clause in the following order, TableA and TableB. We want to be sure to preserve all the data in TableB and get only the matching data in TableA. Which join operator should be used?

Question 8 options:

	LEFT OUTER JOIN
	RIGHT OUTER JOIN
	FULL OUTER JOIN
	INNER JOIN

Question 9 (5 points)

To format a numeric value into USD format like $104.34 which of the following should be used?

Question 9 options:

	TOMONEY(104.34)
	FORMAT(104.34, 'C')
	'$' + 104.34
	CONVERT(104.34, 'C')

Question 10 (5 points)

No entity without an identity is satisfied by

Question 10 options:

	Parent relationship
	Surrogate primary key
	Natural key/Unique key
	Foreign key

Question 11 (5 points)

Which subset of SQL is used for deleting data?

Question 11 options:

	DML
	DCL
	TCL
	DDL