Practice Sql Server Multiple Choice Questions with Answers Quiz-3

Q.1.

The way to write the INSERT INTO statement

INSERT INTO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...);
INSERT INTO table_nameVALUES (value1, value2, value3, ...);
Both ways are true
Both ways are false

Q.2.

What's one solid reason for us to use databases instead of just storing stuff in a variable on the server?

If the server goes down, we won't lose all our data--our data will persist between sessions
A database is a more compact way of storing the information
Accessing information from a database is faster than accessing information from a variable
It's a toss-up, really--they're both good ways of storing information

Q.3.

Which aggregate function would I want to use to see which actor in my table is the oldest?

Q.4.

How many kinds of RAID are there

Q.5.

Mirroring is which kind of RAID

Q.6.

The back up that we take before Mirroring

Q.7.

How many parts in a SQL UPDATE statement?

Q.8.

The correct order of keywords in an UPDATE SQL statement is?

Q.9.

How many columns can you set to update data in a SQL update statement?

Q.10.

Which query would return only the fields DesignerID and Designer?