What is a primary key in a database?

C) A unique identifier for each record in the table

A) The attribute that links two tables together

B) A single file in the database

What is a foreign key in the context of relational databases?

C) A unique identifier for each record in the table

What is the purpose of a secondary key in a database?

To slow down the search process

What is the goal of normalisation in database design?

To have the best possible layout for a relational database

To ensure no records can be added or removed

Which of the following is NOT an objective of normalisation?

Records cannot be added or removed without issues

Consistent data throughout linked tables

Complex queries can be carried out

What is required for a database to be in First Normal Form (1NF)?

There must be no attribute that contains more than a single value.

There must be no partial dependencies.

There must be no non-key dependencies.

All attributes must depend on part of a composite key.

Which of the following is a condition for a database to be in Second Normal Form (2NF)?

It doesn't have any partial dependencies and is in first normal form.

It contains no non-key dependencies and is in third normal form.

It has a composite key and no non-key dependencies.

It allows attributes to depend on part of a composite key.

What is a non-key dependency in the context of Third Normal Form (3NF)?

An attribute that depends on the value of the primary key and nothing else.

An attribute that does not depend on the value of the primary key.

An attribute that depends on part of a composite key.

An attribute that depends on another non-key attribute.

Which technology is used by banks to scan cheques?

Magnetic Ink Character Recognition (MICR)

Optical Character Recognition (OCR)

What is Optical Mark Recognition (OMR) commonly used for?

Processing multiple choice questions on a test.

Entering survey responses into a database.

Recognizing characters in a document.

What is an important part of data preprocessing?

Selecting data that fits a certain criteria to reduce the volume of input.

Automatically indexing every attribute in the database.

Manually entering all data into the database.

Ensuring that all data is stored in third normal form.

What is the purpose of the ORDER BY clause in SQL?

To select which database to use

To choose which columns to display

To filter the results based on a condition

What is the correct SQL syntax to select the MovieTitle and DatePublished from the Movie table where the DatePublished is between January 1, 2000, and December 31, 2005?

SELECT MovieTitle, DatePublished FROM Movie WHERE DatePublished BETWEEN #01/01/2000# AND #31/12/2005#

SELECT MovieTitle, DatePublished FROM Movie WHERE DatePublished AFTER #01/01/2000# AND BEFORE #31/12/2005#

SELECT MovieTitle AND DatePublished FROM Movie WHERE DatePublished BETWEEN #01/01/2000# AND #31/12/2005#

SELECT MovieTitle, DatePublished FROM Movie WHERE DatePublished IS BETWEEN #01/01/2000# AND #31/12/2005#

How do you modify the 'ORDER BY' clause to sort the results in descending order?

Add 'DESC' to the end of the statement

Add 'ASC' to the end of the statement

Add 'DOWN' to the end of the statement

Add 'LOWER' to the end of the statement

What is the purpose of the JOIN keyword in SQL?

To combine rows from multiple tables based on a related field between them

To create new tables in the database

To insert new rows into a table

To update existing records in a table

Which SQL statement is used to add a new column to an existing table?

ALTER TABLE TableName ADD AttributeX and their dataTypes

UPDATE TABLE TableName ADD AttributeX

CREATE TABLE TableName ADD AttributeX

INSERT INTO TableName ADD AttributeX

How do you delete a column from a database table?

ALTER TABLE TableName DROP COLUMN AttributeX

DELETE TABLE TableName COLUMN AttributeX

REMOVE TABLE TableName COLUMN AttributeX

ALTER TABLE TableName DELETE COLUMN AttributeX

What is the purpose of the INSERT INTO statement in SQL?

To insert a new record into a database table

To update an existing record in a database table

To delete a record from a database table

What is the purpose of referential integrity in a database?

To ensure consistency between linked tables

To delete records from a database

To process transactions in isolation

What is the purpose of record locking in a database?

To prevent simultaneous access to records

To ensure transactions are processed in their entirety

To maintain referential integrity rules

To delete records from a database

What is a deadlock in the context of the example provided?

A condition where two users are waiting for each other to release a record, causing no progress.

A situation where multiple users can access the same record without any issues.

A scenario where data is stored in physically different locations to prevent loss.

A process of creating multiple copies of data to ensure its safety.

What is the purpose of redundancy in data management?

To have multiple copies of data in different locations to prevent total data loss.

To lock user records to prevent unauthorized access.

To create a situation where users have to wait for each other.

To allow multiple users to access the same data simultaneously without issues.

Alsager - A2 - 1.3.2 - Databases

Quiz

•

Computers

•

4th Grade

•

Practice Problem

•

Medium

Richard Steed

Used 3+ times

FREE Resource

C) Two or more linked tables

D) A unique identifier for each record

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

41 questions

ee092101

Quiz

•

4th Grade

39 questions

Term3 - Grade 4 - Revision

Quiz

•

4th Grade

40 questions

Scratch Coding Assessment

Quiz

•

3rd - 6th Grade

47 questions

Ulangkaji ASK T2 Bab 2 Algoritma

Quiz

•

1st - 12th Grade

43 questions

Ôn Tập Kiểm Tra KHTN 7

Quiz

•

1st Grade - University

40 questions

Microsoft Powerpoint

Quiz

•

4th Grade

40 questions

PENGAYAAN TKJ 1

Quiz

•

1st - 10th Grade

40 questions

UF0321: Aplicaciones Informáticas de Hojas de Cálculo

Quiz

•

1st - 8th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

10 questions

Introduction to Coding

Interactive video

•

3rd - 6th Grade