SQL and Database Design Quiz

SQL and Database Design Quiz

University

25 Qs

quiz-placeholder

Similar activities

DBMS mcq -2

DBMS mcq -2

University

20 Qs

UAS Basis Data

UAS Basis Data

University

20 Qs

DBMS MCQ - 5

DBMS MCQ - 5

University

20 Qs

MSA Basics

MSA Basics

University

23 Qs

Challenging MYSQL and RDBMS Concepts

Challenging MYSQL and RDBMS Concepts

University

20 Qs

DBMS Quiz Full

DBMS Quiz Full

University

20 Qs

3450 Midterm Review

3450 Midterm Review

8th Grade - University

22 Qs

Database Systems Quiz SE(Blue)

Database Systems Quiz SE(Blue)

University

30 Qs

SQL and Database Design Quiz

SQL and Database Design Quiz

Assessment

Quiz

Other

University

Medium

Created by

33KAZ undefined

Used 1+ times

FREE Resource

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL keyword is used to enforce a condition that a column cannot contain NULL values?

NOT NULL

PRIMARY KEY

UNIQUE

CHECK

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a partial dependency in database design?

When a non-key attribute depends on only part of a composite key

When a foreign key links two tables

When a column can store multiple values

When a primary key is not unique

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, which of the following is a character data type?

BOOLEAN

CHAR

INT

DATE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, how do you ensure that a column must always have a value?

By adding the FOREIGN KEY constraint

By adding the NOT NULL constraint

By adding the CHECK constraint

By adding the UNIQUE constraint

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the SELECT statement in SQL?

To modify existing records

To create a new table

To delete data

To retrieve data from a database

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a "bad" design for a database table?

A table without NULL values

A table with redundant data

A table with atomic values

A table with a foreign key

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, which of the following commands is used to remove a table from the database?

REMOVE TABLE

DELETE TABLE

ALTER TABLE

DROP TABLE

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?