Question

Hi good day i need homework help fast please

d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you to do? a. define your own custom sort order for the values in a column b. select which fields you wish to use in your query c. define which columns will be concatenated d. select the alias for a column 4.)What would the REPLACE statement do if the row being replaced does not already exist? a. prompt the user for the desired action b. Insert the new row c. display an error d. replace the row with the nearest key 5.)What do foreign keys enforce? a schema structure b. database security C. referential integrity d. user security 6.) What statement is used to change name of a. MODIFY NAME TO b. CHANGE TO C. RENAME TO d. MOVE TO 7.)To begin an SQL Transaction, you must a. START COMMITMENT b. START TRANSACTION C. BEGIN TRANSACTION d. START COMMIT 8.Which wildcard character do you y string of zero or more characters? the use E d. & 9.)What does a table look do? a. sets up a table for deletion b. ensures that nobody can update the table until an administrator unlocks it c. prevents other sessions from accessing a table during a specific period d. creates an environment for Transaction Processing 10. Which TWO of the following does MySQL support in the GROUP BY clause that supported in standard SQL? Select one or more: a sorting by ascending or descending order b. using an alias c. using a SELECT clause d. grouping of a subquery 11.) If you want to sort your query which uses the UNION operator, ator, where must the ORDER BY clause be placed? a in the last SELECT statement b. right after the UNION operator c. in the first SELECT statement d. just before the UNION operator

Answer 1

1st Answer: Option A

2nd Answer: Option A

3rd Answer: Option A

4th Answer: Option B

5th Answer: Option C

6th Answer: Option C

7th Answer: Option C

8th Answer: Option C

9th Answer: Option C

10th Answer: Option B

11th Answer: Option A