MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Sql Server
Quiz 3
1
2
3
4
5
6
7
8
9
10
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?
SUM
MAX
GROUP BY
WHERE
Q.4
How many kinds of RAID are there
4
5
6
7
Q.5
Mirroring is which kind of RAID
RAID 0
RAID 1
RAID 2
RAID 3
Q.6
The back up that we take before Mirroring
Full Backup
Transactional Log Backup
Differential Backup
Both A & B
Q.7
How many parts in a SQL UPDATE statement?
2
3
4
6
Q.8
The correct order of keywords in an UPDATE SQL statement is?
UPDATE, SET, WHERE
UPDATE, WHERE, SET
SET, WHERE, UPDATE
WHERE, UPDATE, SET
Q.9
How many columns can you set to update data in a SQL update statement?
only 1
unlimited
equal to the number of columns in the table
At least 1 column and maximum is equal to the number of columns in the table
Q.10
Which query would return only the fields DesignerID and Designer?
SELECT * FROM Designers
SELECT DesignerID, Name FROM Designers
SELECT DesignerID AND Designer FROM Designers
SELECT DesignerID, Designer FROM Designers
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page