Help with mysql questions as much as you can

Question 12 options:

Suppose we have two tables, the first table has 5 rows and the second has 8 rows. A developer executes a cartesian product. There are

rows in the result.

Question 13 (5 points)

Check zero, one or more. When using the IN operator we can use

Question 13 options:

	A subquery
	An enumerated list of items
	A freetext string
	A CASE expression

Question 14 (5 points)

Which subset of SQL is used for managing user privileges?

Question 14 options:

	DCL
	TCL
	DML
	DDL

Question 15 (5 points)

Suppose you are creating a database to support a web application and you need to store the price of an inventory item. What is the best MS SQL Datatype to store that information?

Question 15 options:

	FLOAT
	MONEY
	DECIMAL
	INT
	NUMERIC

Question 16 (5 points)

What scalar SELECT list function would you use to find the first occurrence of a ~ in a varchar column named Y?

Question 16 options:

	SELECT SUBSTRING(Y, '~', 1, LEN(Y))
	SELECT REVERSE(CHARINDEX(Y, '~'), LEN(Y))
	SELECT LTRIM(Y, 1)
	SELECT CHARINDEX('~', Y)

Question 17 (5 points)

No entity without a natural identity is enforced by

Question 17 options:

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

Question 18 (5 points)

With a table that has an identity column as the primary key named PersonId and a non-key column LastName, which is the correct INSERT statement

Question 18 options:

	INSERT INTO Person (PersonId, LastName) VALUES (1, 'Smith')
	INSERT INTO Person (PersonId, LastName) VALUES (IDENTITY, 'Smith')
	INSERT INTO Person (LastName) VALUES ('Smith')
	INSERT INTO Person (LastName) VALUES (GETIDENTITY(), 'Smith')

Question 19 (5 points)

Scalar columns not used in aggregate functions must be mentioned in the GROUP BY clause.

Question 19 options:

	True
	False

Question 20 (5 points)

When trying to see if a pattern can be matched within another string we should use which operator?

Question 20 options:

	The REGEX operator
	A relational operator
	The EXISTS operator
	The LIKE operator

Question 21 (5 points)

Which join operator is more likely to return more results?

Question 21 options:

	OUTER JOIN
	UNION JOIN
	INNER JOIN
	INTERSECTION JOIN

Question 22 (5 points)

A subquery can be used in the SELECT list

Question 22 options:

	True
	False

Question 23 (5 points)

Which subset of SQL is used for dropping tables?

Question 23 options:

	DCL
	DML
	TCL
	DDL

Question 24 (5 points)

The result of this operation 'AB' + NULL + 'CD' is

Question 24 options:

	'ABCD'
	NULL
	AB?CD
	'AB CD'

Question 25 (5 points)

Suppose you are creating a database to support a web application and you need to store a narrative of someones personal history. What is the best MS SQL datatype to store that information?

Question 25 options:

	VARCHAR(MAX)
	VARCHAR(100)
	INT
	Binary Large Object (BLOB)