CH8 of database

CH8 of database

University

11 Qs

quiz-placeholder

Similar activities

PAW-Q1-2023

PAW-Q1-2023

University

10 Qs

Excel Quiz

Excel Quiz

KG - University

15 Qs

DBMS-Quiz1

DBMS-Quiz1

University

15 Qs

HTML Quiz

HTML Quiz

11th Grade - University

15 Qs

ລະບົບຖານຂໍ້ມູນ ທົດສອບ1

ລະບົບຖານຂໍ້ມູນ ທົດສອບ1

University

15 Qs

Microsoft Word

Microsoft Word

University

10 Qs

EXCEL

EXCEL

University

15 Qs

Information System and Modern Organization part 1

Information System and Modern Organization part 1

University

14 Qs

CH8 of database

CH8 of database

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Rodah Alkaabi

FREE Resource

AI

Enhance your content in a minute

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

11 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the action taken when a referential integrity constraint is violated by inserting, deleting, or modifying tuples?

Ignore the violation and proceed

Rollback the transaction

Modify the constraint

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which command is used to remove a base table that is no longer needed?

Drop table

Remove table

Delete table

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What are the options available for actions in Referential Triggered Action?

SET PRIMARY , SET FOREIGN , SET UNIQUE

SET INDEX , SET CHECK , SET CONSTRAINT

SET NULL , CASCADE , and SET DEFAULT

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

In table creation with foreign key references, which actions can be specified like SET DEFAULT and SET NULL?

CREATE TABLE REF

CREATE TABLE KEY

CREATE TABLE EMP

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What does the ALTER TABLE command do?

Creates new table

Deletes the entire table

Modifies a base table by adding \ dropping columns , changing definitions , or adding \ dropping constraints

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which command is used to add a column to an existing table?

MODIFY TABLE EMPLOYEE ADD JOB VARCHAR(12);

ALTER TABLE EMPLOYEE ADD JOB VARCHAR(12);

ADD COLUMN EMPLOYEE JPB VARCHAR(12);

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

When dropping a column using ALTER TABLE, which behavior can be chosen between CASCADE and RESTRICT?

CASCADE drops constraints and views automatically

CASCADE ensures data loss

RESTRICT ensures no data loss

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?