Search Header Logo

DB Revision

Authored by Kesmat AbdelAziz

Computers

University

Used 2+ times

DB Revision
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

32 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A two-dimensional table of data sometimes is called a

Group

Relation

Set

declartion

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

Business rule constraint

Data integrity

Business integrity

Data Structure

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Foreign Key

Primary Key

Column

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A primary key that consists of more than one attribute is called a:

foreign key

composite key

multivalued key.

cardinal key.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the SQL language, the ________ statement is used to make table definitions.

create session

create table

create index

select

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

All of the following are the main goals of normalization EXCEPT:

minimize data redundancy.

simplify the enforcement of referential integrity.

maximize storage space.

make it easier to maintain data.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When all multivalued attributes have been removed from a relation, it is said to be in:

First Normal Form

Second Normal Form

Third Normal Form

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?