PLEASE ONLY ANSWER $($A B C D$)$

$1.$What is SQL Server?

a$)$ SQL Server is a relational database management system

b$)$ SQL Server is a software whose main purpose is to store and retrieve data

c$)$ SQL Server is a highly secure server and does not allow any database file manipulation during execution

d$)$ All of the mentioned

$2.$ SELECT name $\_\_\_\_$ instructor name, course id FROM instructor, teaches WHERE instructor.ID$=$ teaches.ID;

Which keyword must be used here to rename the field name?

a$)$ From

b$)$ Rename

c$)$ As

d$)$ Join

$3.$ Which SQL function is used to count the number of rows in a SQL query?

a$)$ COUNT$()$

b$)$ NUMBER$()$

c$)$ SUM$()$

d$)$ COUNT$(*)$

$4.$ With SQL$,$ how can you return all the records from a table named $$Persons$$ sorted descending by $$FirstName$?$

a$)$ SELECT $*$ FROM Persons SORT BY $$FirstName$$ DESC

b$)$ SELECT $*$ FROM Persons ORDER FirstName DESC

c$)$ SELECT $*$ FROM Persons SORT $$FirstName$$ DESC

d$)$ SELECT $*$ FROM Persons ORDER BY FirstName DESC

$5.$ Which of the following statement is true?

a$)$ DELETE does not free the space containing the table and TRUNCATE free the space containing the table

b$)$ Both DELETE and TRUNCATE free the space containing the table

c$)$ Both DELETE and TRUNCATE does not free the space containing the table

d$)$ DELETE free the space containing the table and TRUNCATE does not free the space containing the table

$5.$ SELECT $*$ FROM employee WHERE dept$\_$name$=$"Comp Sci";

In the SQL given above there is an error $.$ Identify the error.

a$)$ Dept$\_$name

b$)$ Employee

c$)$Comp Sci$$

d$)$ From

$6.\_\_\_\_\_\_\_\_\_\_\_$removes all rows from a table without logging the individual row deletions.

a$)$ DELETE

b$)$ REMOVE

c$)$ DROP

d$)$ TRUNCATE

$7.$ What is the purpose of the SQL AS clause?

a$)$ The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

b$)$ The AS clause is used with the JOIN clause only

c$)$ The AS clause defines a search condition

d$)$ All of the mentioned

$8.$ Which SQL keyword is used to retrieve a maximum value?

a$)$ MOST

b$)$ TOP

c$)$ MAX

d$)$ UPPER

$9.$ If you don$$t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default $\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

a$)$ ASC

b$)$ DESC

c$)$ There is no default value

d$)$ None of the mentioned

$10.$ SQL query to find all the cities whose humidity is $95.$

a$)$ SELECT city WHERE humidity $=95$

b$)$ SELECT city FROM weather WHERE humidity $=95$

c$)$ SELECT humidity $=89$ FROM weather

d$)$ SELECT city FROM weather

$11.$ How can you change $$Hansen$$ into $$Nilsen$$ in the $$LastName$$ column in the Persons table?

a$)$ UPDATE Persons SET LastName$=$Hansen$$ INTO LastName$=$Nilsen$$

b$)$ MODIFY Persons SET LastName$=$Nilsen$$ WHERE LastName$=$Hansen$$

c$)$ MODIFY Persons SET LastName$=$Hansen$$ INTO LastName$=$Nilsen$$

d$)$ UPDATE Persons SET LastName$=$Nilsen$$ WHERE LastName$=$Hansen$$

$12.$ Which SQL statement is used to return only different values?

a$)$ SELECT DIFFERENT

b$)$ SELECT UNIQUE

c$)$ SELECT DISTINCT

d$)$ SELECT ALL

$13.$ SELECT $*$ FROM instructor ORDER BY salary $\_\_\_\_,$ name $\_\_\_$;

To display the salary from greater to smaller and name in ascending order which of the following options should be used?

a$)$ Ascending, Descending

b$)$ Asc, Desc

c$)$ Desc, Asc

d$)$ Descending, Ascending