Databases (Week 02)

Databases (Week 02)

University

20 Qs

quiz-placeholder

Similar activities

2.3.1 Graph Traversal & Path Finding Algorithms

2.3.1 Graph Traversal & Path Finding Algorithms

12th Grade - University

20 Qs

Digital and Analog transmission

Digital and Analog transmission

University

20 Qs

GIS Unit III

GIS Unit III

University

15 Qs

ICT Unit-2

ICT Unit-2

University

20 Qs

Information Technology

Information Technology

University

17 Qs

Quiz 1 CCE

Quiz 1 CCE

University

15 Qs

Ms. Exel dan Fungsi Logika IF

Ms. Exel dan Fungsi Logika IF

10th Grade - University

15 Qs

Fotogrametri dan Penginderaan Jauh

Fotogrametri dan Penginderaan Jauh

University

20 Qs

Databases (Week 02)

Databases (Week 02)

Assessment

Quiz

Computers

University

Practice Problem

Medium

Created by

Long Trần

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?