What is meant by cascade delete ?

A process that deletes all the rows in the linked table with the related foreign key when a row with the primary key is deleted.

A process that updates foreign keys when a primary key is changed.

A process that prevents deletion of a row with a primary key that is referenced by a foreign key.

A process that creates a backup of the deleted data.

If Sharon Watt's primary key in the 'hairdresser' table is changed from 2019 to 3982, what will be her new foreign key value in the 'client' table?

The primary key value in the 'client' table will not change

What is the impact of deleting the first row of the pricelist table (i.e., code = 2374) which ONLY changes data in the pricelist table?

Referential integrity has been broken and foreign keys in the order table no longer have linked primary key values.

Cascade deletes will be activated and all related rows in the order table will be deleted.

Cascade updates will set the related foreign keys to an empty value.

Referential integrity ensures that the related foreign keys will be allocated the next available primary key value from the pricelist table.

If a row in the car table is deleted, what will happen in the carcollector table?

The row with the related primary key value will be deleted.

The primary key in carcollector, with the same value, will be set to empty.

A row will be added to include the deleted value.

What is the Microsoft Access database software normally used for?

Standalone databases not accessed from the internet

What is the first step to create an SQL query in Microsoft Access 365 ?

Display the Create ribbon and then choose Query Design

Close the table selection dialogue

How can you execute a query in the Access software shown in the image?

Select 'Execute' from the 'File' menu

Right-click on the table and select 'Run Query

What will be displayed as a result of executing a query in the Access software?

An answer table with the query results

What is the purpose of the SQL keyword SELECT?

Displays all or specific columns from a table.

Add a new row or rows into a table.

Amend existing rows in a table.

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

Sort the column data into ascending or descending order.

Specify which table or tables to get the data from.

Uses comparators and operations to identify and select only the data required.

Amend existing rows in a table.

What will be the result of the SQL query shown?

It will display the userid and accountname from the user table in descending order by accountname and then ascending order by userid.

It will display the userid and accountname from the user table in ascending order by userid.

It will display all columns from the user table.

It will display the userid and accountname from the user table in random order.

What does the asterisk (*) symbol represent in an SQL SELECT statement?

It is used to select every column from a specified table.

It represents a multiplication operation.

It selects only the first column of a table.

It indicates an error in the query.

Which SQL statement would you use to display all records from the client table?

SELECT clientid, clientlastname, clientfirstname FROM client;

SELECT clientid FROM client WHERE clientid = 1;

Which SQL statement correctly displays just the clientid column from the client table?

SELECT clientid FROM hairdresser;

Which SQL statement correctly displays just the contactnumber and salon columns from the hairdresser table?

SELECT contactnumber, salon FROM hairdresser;

SELECT contactnumber FROM salon;

SELECT salon, contactnumber FROM client;

What is the result of executing the SQL statement "SELECT * FROM client, hairdresser;"?

It displays all the rows from the client table, immediately followed by all the rows from the hairdresser table.

It displays all the rows from the client table only.

It displays all the rows from the hairdresser table only.

It displays all the rows from both the client and hairdresser tables with a matching value in each.

Which SQL statement would display all the columns from the hairdresser table where the hairdresserid is greater than 1928?

SELECT * FROM hairdresser WHERE hairdresserid > 1928;

SELECT * FROM hairdresser WHERE hairdresserid = 1928;

SELECT * FROM hairdresser WHERE hairdresserid

SELECT * FROM hairdresser WHERE hairdresserid >= 1928;

What is the purpose of an equi-join in SQL?

To combine rows from two or more tables based on a related column between them

To update column values in a table

To filter rows based on a condition

What is the correct SQL statement to display all the sorted rows from the client table in ascending order of hairdresserid and then clientfirstname descending where clientid is greater than 11000?

SELECT * FROM client WHERE clientid > 11000 ORDER BY hairdresserid ASC, clientfirstname DESC;

SELECT * FROM client ORDER BY hairdresserid ASC, clientfirstname DESC WHERE clientid > 11000;

SELECT * FROM client WHERE clientid > 11000 ORDER BY clientfirstname DESC, hairdresserid ASC;

SELECT * FROM client ORDER BY clientid ASC, hairdresserid DESC WHERE clientid > 11000;

Which SQL statement correctly displays the clientid and the hairdresserid from the client table where the hairdresserid is greater than 2000, sorted by hairdresserid ascending and clientid ascending?

SELECT clientid, hairdresserid FROM client WHERE hairdresserid > 2000 ORDER BY hairdresserid ASC, clientid ASC;

SELECT clientid, hairdresserid FROM client ORDER BY hairdresserid DESC, clientid DESC WHERE hairdresserid > 2000;

SELECT hairdresserid, clientid FROM client WHERE hairdresserid > 2000 ORDER BY clientid ASC, hairdresserid ASC;

SELECT hairdresserid, clientid FROM client ORDER BY hairdresserid ASC, clientid ASC WHERE hairdresserid > 2000;

What is the purpose of the FROM clause in a SQL query?

To state which table or tables to get the data from

To specify the condition for selecting rows

To define the order in which the results are returned

To list the columns that should be updated in a table

What does the WHERE clause do in a SQL query?

It uses comparators and operations to select only the records required

It specifies the tables from which to retrieve data

It defines the columns to be displayed in the result set

It determines the order in which rows are returned

What does the following SQL query do? SELECT userid, accountname FROM user WHERE userid > 70000 ORDER BY accountname DESC, userid ASC;

It selects all user IDs and account names from the user table where the user ID is greater than 70000 and sorts them in descending order by account name and then in ascending order by user ID.

It selects all user IDs and account names from the user table where the user ID is greater than 70000 and sorts them in ascending order by account name and then by user ID.

It selects all user IDs and account names from the user table and sorts them in descending order by account name and then by user ID.

It updates user IDs and account names in the user table where the user ID is greater than 70000.

What is the result of the following SQL query? SELECT userid, accountname FROM user WHERE userid = 70000 ORDER BY accountname DESC, userid ASC;

It selects rows where the userid is equal to 70000.

It selects rows where the userid is less than 70000.

It selects rows where the userid is not equal to 70000.

It selects rows where the userid is greater than 70000.

N5CS: Database Implementation Quiz

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Before studying the implementation of relational databases, you should already be familiar with the concept that information can be stored in what type of database?

Hierarchical database

Object-oriented database

Flat-file database

NoSQL database

Answer explanation

Before studying relational databases, you should know information can be stored in a flat-file database, making it the correct type of database to be familiar with.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following SQL operations are you expected to describe and implement for pre-populated relational databases with a maximum of two linked tables?

SELECT, CREATE, JOIN, DELETE

SELECT, INSERT, UPDATE, DELETE

SELECT, ALTER, DROP, INSERT

CREATE, INSERT, UPDATE, TRUNCATE

Answer explanation

The correct operations for pre-populated relational databases with two linked tables are SELECT, INSERT, UPDATE, DELETE.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When constructing queries, which of these SQL keywords are you expected to use to filter results based on specific conditions?

FROM, HAVING, GROUP BY

SELECT, JOIN, LIMIT

FROM, WHERE, ORDER BY

INSERT, UPDATE, DELETE

Answer explanation

When constructing queries, you are expected to use the SQL keywords FROM, WHERE, and ORDER BY to filter results based on specific conditions.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of join is used to select data from two tables based on a common field?

Outer join

Cross join

Equi-join

Natural join

Answer explanation

Equi-join is used to select data from two tables based on a common field, making it the correct choice for this scenario.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary key of the hairdresser table in the given database schema?

firstname

contactnumber

hairdresserid

salon

Answer explanation

The primary key of the hairdresser table in the given database schema is hairdresserid, which uniquely identifies each record in the table.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the foreign key in the client table that references the hairdresser table?

clientid

clientfirstname

hairdresserid

phonenumber

Answer explanation

The foreign key in the client table that references the hairdresser table is 'hairdresserid'.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If the row for Huda Quhshi is removed from the hairdresser table and referential integrity is enforces, what impact will it have on the client table?

There will be no impact on the client table.

A new hairdresser will be automatically assigned to the clients.

All records with the related foreign key will be deleted

The contactnumber for clients will be removed.

Answer explanation

All records with the related foreign key will be deleted as a result of enforcing referential integrity when the row for Huda Quhshi is removed from the hairdresser table.

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following best defines referential integrity in the context of a relational database?

It is the uniqueness of the primary key in any given table.

It is the relationship between two tables that checks that a foreign key in one table is a primary key in another table.

It is the relationship between two tables that allows for duplicate foreign keys.

It is the process of creating new tables from existing ones.

Answer explanation

The best definition of referential integrity in a relational database is the relationship between two tables that checks that a foreign key in one table is a primary key in another table.

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does enforcing referential integrity ensure in a database?

It ensures that all primary keys have unique values.

It ensures that there cannot be foreign key values which do not have a corresponding primary key value in the linked table.

It ensures that all foreign keys have unique values.

It ensures that all tables must have the same number of rows.

Answer explanation

It ensures that there cannot be foreign key values which do not have a corresponding primary key value in the linked table.

10.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the consequence of deleting a row in the 'hairdresser' table that has a primary key value referenced in the 'client' table if cascade delete is not enforced?

It will update the corresponding rows in the 'client' table.

It will create inconsistent rows in the 'client' table.

It will delete the 'client' table entirely.

It will prevent new rows from being added to the 'hairdresser' table.

Answer explanation

N5CS: Database Implementation

77 questions

Before studying the implementation of relational databases, you should already be familiar with the concept that information can be stored in what type of database?

Before studying relational databases, you should know information can be stored in a flat-file database, making it the correct type of database to be familiar with.

Which of the following SQL operations are you expected to describe and implement for pre-populated relational databases with a maximum of two linked tables?

The correct operations for pre-populated relational databases with two linked tables are SELECT, INSERT, UPDATE, DELETE.

When constructing queries, which of these SQL keywords are you expected to use to filter results based on specific conditions?

When constructing queries, you are expected to use the SQL keywords FROM, WHERE, and ORDER BY to filter results based on specific conditions.

What type of join is used to select data from two tables based on a common field?

Equi-join is used to select data from two tables based on a common field, making it the correct choice for this scenario.

What is the primary key of the hairdresser table in the given database schema?

The primary key of the hairdresser table in the given database schema is hairdresserid, which uniquely identifies each record in the table.

What is the foreign key in the client table that references the hairdresser table?

The foreign key in the client table that references the hairdresser table is 'hairdresserid'.

If the row for Huda Quhshi is removed from the hairdresser table and referential integrity is enforces, what impact will it have on the client table?

All records with the related foreign key will be deleted as a result of enforcing referential integrity when the row for Huda Quhshi is removed from the hairdresser table.

Which of the following best defines referential integrity in the context of a relational database?

The best definition of referential integrity in a relational database is the relationship between two tables that checks that a foreign key in one table is a primary key in another table.

What does enforcing referential integrity ensure in a database?

It ensures that there cannot be foreign key values which do not have a corresponding primary key value in the linked table.

What is the consequence of deleting a row in the 'hairdresser' table that has a primary key value referenced in the 'client' table if cascade delete is not enforced?

It will create inconsistent rows in the 'client' table.

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers