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