Database Systems I

Database Systems I

1st - 5th Grade

10 Qs

quiz-placeholder

Similar activities

QUIZZ 2 : DATABASE FUNDAMENTALS

QUIZZ 2 : DATABASE FUNDAMENTALS

1st - 3rd Grade

10 Qs

ICT  - Know Your Computer Test

ICT - Know Your Computer Test

5th Grade

15 Qs

KS3_Data Representations (from clay to silicon)

KS3_Data Representations (from clay to silicon)

1st - 3rd Grade

15 Qs

First step to Internet 5B1

First step to Internet 5B1

5th Grade

10 Qs

Gr3-Scratch - Revision

Gr3-Scratch - Revision

3rd - 5th Grade

11 Qs

Year 1 I.T.

Year 1 I.T.

1st - 2nd Grade

12 Qs

Logos - Digital Images

Logos - Digital Images

2nd - 10th Grade

10 Qs

Learning and playing via computer

Learning and playing via computer

2nd Grade

10 Qs

Database Systems I

Database Systems I

Assessment

Quiz

Computers

1st - 5th Grade

Practice Problem

Medium

Created by

Yona Sangula

Used 18+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Characteristic of database management system which allows program operation independence and program data independence is classified as

Conceptual abstraction

Implementation abstraction

Data abstraction

Interface abstraction

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which statement is wrong about PRIMARY KEY constraint in SQL?

The PRIMARY KEY uniquely identifies each record in a SQL database table

Primary key can be made based on multiple columns

Primary key must be made of any single columns

Primary keys must contain UNIQUE values.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The DROP TABLE statement:

deletes the table structure only.

deletes the table structure along with the table data.

works whether or not referential integrity constraints would be violated

is not an SQL statement

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

DELETE FROM table_name;

DELETE TABLE table_name;

DROP TABLE table_name;

NONE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Data administrators are responsible for:

Physical database design

Managing technical issues in the database environment

Overall management of data resources in an origination

Writing application programs

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is Entity relationship model?

An item about which information is stored in the database

The model that focuses on representing the data as it exists in the real world

The models that identify the data that different groups will need and eventually translate into forms and reports

Characteristics attached to each entity.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

The graphic below indicates;

That student can own many cars

A student can own many cars and a car can be owned by many students

A student cannot own a car

A car can be owned by many students

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?