Create a table with SQL – Quiz

For each question below, select the best answer. To select the best answer, click on the circle located on the left of this answer. When all questions are answered, click on the Submit button.

Question 1

When creating a table, the information beside each column name helps finding out:
The biggest amount of information a field in the column can hold.
The biggest amount of information the column can hold.
The biggest amount of information the table can hold.

Question 2

Which of the following create statement fragment is correct?:
revenue int,
int revenue,
int revenue;
int, revenue

Question 3

Which of the following is not an integer?:
1
-1
2.1
5

Question 4

Which of the following is not an integer?:
1
-1
a

Question 5

Which of the following is not compatible with varchar(2)?:
“a2”
“z”
“!”
“ijk”

Question 6

Which of the following is not compatible with decimal(7,2)?:
2.1
7
12345.23
1.234
123456.1
0

Question 7

Which of the following is compatible with decimal(7,2)?:
123455.23
12.133
1.234
0
123455.133

 

 

Once you have completed the quiz, calculated your score and reviewed your answers, I invite you to go to the next lesson about modifying tables with ALTER TABLE.
 
Share on:


Author:
Last udpated: September 10, 2017
Created: September 2, 2014