9. What is data redundancy?

C. The unnecessary repetition of data

A. The construction of a relationship between two tables

B. It refers to the electronic exchange of documents by respecting standards for their formatting so that the data set can be conveniently used by the receiving party

A. EDI is Electronic Database Interrogation and suggests that a SQL query is being run on a database from across a network

C. EDI stands for Error in Data Integrity and it is a warning message system used to report errors in databases

D. It is used for data capture using technologies such as OMR and OCR

13. If a database table of shoes is queried using the criteria Size>=7, which of the following statements applies?

C. This is data being exchanged

D. This is data being manipulated

14. What is the goal of progressing to third normal form when normalising a database schema?

D. It removes non-key (transitive) dependencies

A. It ensures dependency on a key and removes repeating groups of attributes

C. It removes partial key dependencies

15. What will the following SQL query do? SELECT * FROM Horses WHERE Ability= 'Dressage' ORDER BY Name;

A. It will produce an A-Z listing of the entire Horse table showing only those horses that do dressage

B. It will produce an A-Z listing of just the names of all of the horses that do dressage

C. It will produce an A-Z of all the horses and join in the information from the Ability table so that it is clear which horses do dressage

D. It will list all of the horses from the Horses table in reverse alphabetical order (Z-A) based on their names

16. Which of the following descriptions is accurate once the following lines of SQL have been executed? CREATE TABLE Foods (FoodID INT PRIMARY KEY, FName VARCHAR (50), FPrice REAL); ALTER TABLE Foods ADD FDept VARCHAR (20); ALTER TABLE Foods DROP COLUMN FDept;

C. The table that remains will have three columns with three different data types but there will be no records in it

A. Two tables will have been created: one called Food and one called FDept, but the second one will get deleted

B. A table containing five columns will remain

D. A table containing four columns will remain and there will be room for up to 50 records

17. What does referential integrity guarantee?

D. Any values used as foreign key values do already exist as primary key values in the corresponding table

A. All primary key values in a table are unique

B. A relationship must be one-to-one or one-to-many as many-to-many relationships are not permitted

C. It ensures that only values from both tables that have corresponding, matching values are returned when a JOIN statement is used in a SQL query

18. What does ACID mean?

D. Atomicity, Consistency, Isolation, Durability

A. Authentication, Consistency, Integrity, Duration

B. Authentication, Correctness, Isolation, Durability

C. Atomicity, Consistency, Integrity, Duration

19. Why is record locking used when processing database transactions?

A. This prevents a database from losing its integrity by limiting edits to just one transaction at a time, preventing multiple accesses to the same record simultaneously

B. This keeps the database secure by authenticating all users and only allowing certain types of user to view certain tables of data

C. It helps to prevent deadlock

D. It stops multiple users from using the database simultaneously

20. The term 'redundancy' has two different interpretations in the study of databases depending on the context. The first is that data redundancy is the unnecessary repetition of data, and this can be avoided by moving away from flat files towards a relational schema. What is the other meaning of redundancy?

C. Keeping a second and possibly third version of the system on additional hardware so that the redundant system can kick in when the main system fails

A. It is the goal of referential integrity, as it ensures that data is always connected

B. Keeping a flat file of all of the data to speed up searches

D. Hiring additional staff for inputting data

#12 Databases

Quiz

•

others

•

Practice Problem

•

Hard

Claire Buckler

FREE Resource

20 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. Define a relational database.

A. A set of organised information held in a table

B. An organised, persistent store of data organised into related tables

C. A set of tables and validation rules

D. A structured collection of tables where blank fields are not allowed

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

2. How does a flat file differ from a relational database?

A. All data is held in one table, causing data redundancy

B. Data is held in one table but validation rules cannot be applied

C. It is not possible to query (or filter) data in a flat file database

D. Searches for data are much faster in a flat file database

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

3. What is a primary key?

A. It is a unique identifier for each record in a database

B. It is a unique identifier for each field in a database

C. It is a unique identifier for each field in a table

D. It is a unique identifier for each record in a table

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

4. Which of the following could make a suitable primary key in a table of adult residents of a town?

A. Gender

B. Landline phone number

C. Surname

D. National Insurance number

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

5. How are foreign keys used in relational databases?

A. They act as a validation rule, ensuring the right type of data is input

B. They act as a referential constraint, cross-referencing to a record in another table to prevent data redundancy

C. They uniquely identify each record in a table

D. They allow two or more field values to jointly uniquely identify a record within a table

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

6. If a table called CUSTOMERS has a primary key called CustomerNumber and a separate table called SALES has a foreign key called CustomerToCharge, which of these is true?

A. The value of CustomerToCharge is a cross-reference to one of the values of CustomerNumber in the CUSTOMERS table, and referential integrity will check that any values entered for CustomerToCharge already exist in the CUSTOMERS table somewhere in the CustomerNumber column

B. All values of the primary key column CustomerNumber must be used at some point in the CustomerToCharge column

C. All values of the foreign key column CustomerToCharge must be unique in the SALES table

D. Referential integrity cannot be applied to this scenario because there is a one-to-many relationship between the two tables

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

7. When a non-key column/field is used as a secondary key, which of these advantages is derived?

A. It speeds up searches when the non-key column is searched because it is now indexed

B. It applies the rule that all values in the non-key column must now be unique

C. It means that the index on the secondary key column will be reconstructed each time the table changes

D. The table now benefits from having two primary keys

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

20 questions

G9-SOC-L1 India: Size and location

Quiz

•

KG - University

19 questions

PRE UPS 1 SM025

Quiz

•

KG - University

18 questions

The Challenges of Starting a Business

Quiz

•

KG - University

15 questions

LibreCAD

Quiz

•

10th Grade

16 questions

G2 L2

Quiz

•

6th - 8th Grade

18 questions

Lý CKII

Quiz

•

KG - University

20 questions

PAS MATH X_DKV SEMESTER GANJIL TAHUN 2023

Quiz

•

KG - University

20 questions

MARKETING PARTE III

Quiz

•

KG - University

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

$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

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for others

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th 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

20 questions

Figurative Language Review

Quiz

•

6th Grade

#12 Databases

20 questions

1. Define a relational database.

2. How does a flat file differ from a relational database?

3. What is a primary key?

4. Which of the following could make a suitable primary key in a table of adult residents of a town?

5. How are foreign keys used in relational databases?

6. If a table called CUSTOMERS has a primary key called CustomerNumber and a separate table called SALES has a foreign key called CustomerToCharge, which of these is true?

7. When a non-key column/field is used as a secondary key, which of these advantages is derived?

8. Which of the following is not shown on an ER diagram?

9. What is data redundancy?

10. Which of the following is not a method for capturing data to be stored in a database?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for others