
Databases (Week 02)
Authored by Long Trần
Computers
University
Used 4+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following are types of relations in SQL?
Stored relations
Views
Temporary tables
All of the above
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which SQL data type stores a fixed-length string of up to 8000 characters?
VARCHAR(n)
CHAR(n)
NCHAR(n)
TEXT
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following is a valid SQL data type for storing dates?
TEXT
DATETIME
VARCHAR
CHAR
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What does the `IDENTITY` property in SQL define?
The data type of a column
The default value for a column
The initial value and increment step for a column
The foreign key constraint
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following SQL commands is used to delete a table?
DELETE TABLE
DROP TABLE
REMOVE TABLE
ERASE TABLE
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the purpose of the `DEFAULT` option in SQL?
To specify the default data type
To specify a default value for an attribute
To modify the table structure
To define the primary key
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following SQL data types are used for fixed precision and scale numbers?
FLOAT
DECIMAL(p,s) or NUMERIC(p,s)
INT
DATETIME
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Digital and Analog transmission
Quiz
•
University
20 questions
Soal AIJ bulan Agustus 2019 kls xii
Quiz
•
University
15 questions
GIS Unit III
Quiz
•
University
15 questions
Ms. Exel dan Fungsi Logika IF
Quiz
•
10th Grade - University
20 questions
Fotogrametri dan Penginderaan Jauh
Quiz
•
University
20 questions
STS Informatika
Quiz
•
10th Grade - University
15 questions
ADB Quiz #1
Quiz
•
University
20 questions
Quiz Harian Gdevelop MPK
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade