Search Header Logo

Database Concepts Quiz

Authored by rach tj

Computers

11th Grade

Database Concepts Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a database?

A collection of data items and links between them

A type of computer program

A physical storage device

A type of computer network

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary key in a table?

A data structure built from one or more columns in a database table

A set of attributes that form a primary key

A unique identifier for a table

An individual data item stored for an entity

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of normalisation in a relational database?

To reduce data redundancy and ensure integrity

To increase data redundancy and complexity

To speed up searching for data

To store data in a non-structured manner

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of an E-R diagram in database design?

To provide a visual representation of how entities are related

To store data in a file-based approach

To write SQL scripts for database manipulation

To create database tables

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the cardinality of a relationship that is one-to-many?

1:m

m:1

m:m

0:1

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a Database Management System (DBMS) in relation to a file-based approach?

To improve data security

To create data dependencies

To decrease data inconsistency

To increase data redundancy

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which command is used in SQL to add a primary key to a table?

FOREIGN KEY

CREATE TABLE

PRIMARY KEY

ALTER TABLE

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?