Search Header Logo

Constraints in SQL

Authored by ALDO STALIN J L

Computers

University

Used 1+ times

Constraints in SQL
AI

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

1 min • 1 pt

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Correct syntax query syntax to drop a column from a table is

DELETE COLUMN column_name;

DROP COLUMN column_name;

ALTER TABLE table_name DROP COLUMN column_name;

None is correct.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL has how many main commands for DDL:

1

2

3

4

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which command is used for removing a table and all its data from the database:

Create command

Drop table command

Alter table command

All of the mentioned

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following language is used to specify database Schema ?

DDL

DML

DCL

None

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

With SQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')  
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy, Jackson') INTO Persons
INSERT ('Jimmy', 'Jackson') VALUES into Persons

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a type of SQL constraint?

Primary Key

Foreign Key

Alternate Key

Unique

NOT NULL

Access all questions and much more by creating a free account

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?

Discover more resources for Computers