Untitled

In MS Access, is it possible to create a query based on an existing query?

If referential integrity with 'restrict deletion' is enforced between STUDENTS and REGISTER tables, and a record exists in REGISTER referencing a student, can that student's record be deleted from STUDENTS?

What type of relationship typically exists between PRODUCTS and CUSTOMERS in a real-world database?

Given SALES and EMPLOYEES tables, what type of query would you use to output the total sales for each employee?

If 'Cascade Update Related Fields' is enabled between STUDENTS and REGISTER, what happens if you update a StudId in STUDENTS from 1 to 5?

In Access, what does the Record Source property of a form define?

Which of the following represents the correct layers of database architecture?

Tables US_Banks (B1, B2, B3, B4) and EU_Banks (B1, B4, B5) list banks operating in the US and Europe. Which relational operator yields a distinct list of all banks (B1, B2, B3, B4, B5)?

Which database object is best described as 'a list of commands or options that a user can choose from during interactive work on a screen'?

In a 'Students' table, which property is most appropriate to set if a new record should not be saved unless the student's name is entered?

In a 'User Profile' table, if you want to ensure a telephone number field contains the country code, area code, and personal number in a specific format, which field property should you configure?

If a 'restrict for insert' rule is in place to maintain referential integrity between the 'STUDENTS' and 'REGISTER' tables, can a new record with 'StudId = 5' be inserted into 'REGISTER' if no student with 'StudId = 5' exists in 'STUDENTS'?

Given a relationship between 'STUDENTS' and 'REGISTER', where 'REGISTER' likely contains records of student registrations, which table is typically the parent table?

What does the query SELECT Discipline, AVG(Mark) FROM Results GROUP BY Discipline; represent?

Which statement best describes the function of an index in a database?

What type of relationship is most likely to exist between 'REGISTER' and 'STUDENTS' tables, where one student can register for multiple courses?

What is the primary purpose of configuring a field in a database to require unique values?

Which of the following is NOT a characteristic of candidate keys in a relational database?

In MS Access, if 'Cascade Update Related Fields' is enabled between the STUDENTS and REGISTER tables, what happens when you update the StudId from 1 to 5 in the STUDENTS table?

Given two tables, US_Banks and EU_Banks, both containing a list of bank codes. Which relational operator would you use to find the bank codes that appear in both tables (i.e., banks operating in both the US and Europe)?

A person must update their account number before depositing money. Which referential integrity property should be set between 'Customers' and 'Deposits' tables in Access to ensure that transactions are only recorded for customers with existing account numbers?

Which of the following clauses is NOT typically considered one of the main clauses in a SELECT statement?

A user adding a new record to a table notices a value is automatically filled in for a cell. Which table property causes this?

Given a STUDENTS table with fields like StudId, Birth_Date, First_Name, and Last_Name, which of the following is the most suitable primary key?

Which of the following best describes a DBMS (Database Management System)?

What is the most appropriate field type to store phone numbers in a database?

To calculate monthly salary subtotals for each department in an Employees table (containing employee contact data, wages, and department), which query operation is most suitable?

A report is based on a Products table containing 7 records. If a label control is placed in the Detail area of the Report Design, how many times will the label's content be displayed in Report View?

Assuming 'Cascade Update Related Fields' is enabled between STUDENTS and REGISTER tables, can you update a StudId from 3 to 5 in the STUDENTS table?

Why is it advantageous for a database to implement a primary key within a table?

Which SQL clause is used to filter records based on a specified condition?

A database has a RESTRICT referential integrity constraint between the STUDENTS and REGISTER tables. If deletion is restricted, can record #2 be deleted from STUDENTS?

Which of the following best describes the query that retrieves students with marks higher than 8 in disciplines whose names start with the letter 'M'?

Is it possible to combine the results of two or more SELECT statements into a single result set?

A database has a RESTRICT referential integrity constraint between STUDENTS and REGISTER during insertion. Can a record with StudId = 5 be inserted into STUDENTS if it violates the constraint?

Is it possible to create an Access table outside an Access database (.accdb or .mdb file)?

Which of the following does a query that groups exam records by student and counts the number of exams in each group represent?

To display the Invoice Date in a Purchase Invoices table as a medium date (e.g., dd-mmm-yyyy), which property should be set in the table design?

If a database enforces a RESTRICT rule for referential integrity between the STUDENTS and REGISTER tables, what will happen if you attempt to insert a record into REGISTER with a StudId of 5, and there is no corresponding StudId in the STUDENTS table?

Consider a REGISTER table with fields StudId, Discipline, Ex_Date, and Mark. Which of the following options is the most appropriate choice for a primary key or candidate key for the REGISTER table, assuming StudId is a foreign key referencing the STUDENTS table?

What is the primary function of a primary key in a database table?

In database architecture, what does the external data level represent?

Assuming a RESTRICT rule is established to maintain referential integrity between STUDENTS and REGISTER, can you insert a record into REGISTER with a StudId of 5 if there's no corresponding record in STUDENTS?

Consider a scenario where a customer (stored in the Customers table) can deposit money into a bank, and these transactions are recorded in the Deposits table. The business rule states that a customer can only make a deposit if they have previously updated their account number. Which referential integrity option(s) are most important to set in a database management system like Access to enforce this rule?

How does enabling 'Enforce Referential Integrity' in a database management system primarily contribute to data quality?

Which is most accurate regarding cascade update?