問題一覧
1
In MS Access, may we create a query based on existing query?
True
2
Assuming there has been established RESTRICT DELETION, as a rule to PRESERVE REFERENTIAL INTEGRITY between STUDENTS and REGISTER, may we DELETE record #2 fromREGISTER?
True
3
What kind of relationship do we have between PRODUCTS and CUSTOMERS in real world?
N:M
4
Considering the following tables: For OUTPUTTING the TOTAL SALES for each person what kind of gueries would you use?
Union + Select
5
Let's assume there has been established CASCADE UPDATE RELATED FIELDS, as a rule to PRESERVE theREFERENTIAL INTEGRITY between STUDENTS and REGISTER, in MS Access. What happens if we UPDATE the StudId from value 1 to value 5?
Records #1, #3 and #4 from REGISTER will be automatically updated to value 5 as for StudId
6
The database architecture has the following layers:
External, conceptual and internal levels
7
Two tables with the same structure - US_Banks: B1, B2, B3, B4 andEU_Banks: B1, B4, B5 - contain the list of the banks operating in US and Europe, respectively. What relational operator has to be used in order to obtain the list of the banks from both countries listed once B1, B2, B3, B4, B5)? Note that B1, B2, B3, B4 and B5 are examples of banks.
Union
8
Two tables with the same structure - US_Banks: B1, B2, B3, B4 andEU_Banks: B1, B4, B5 - contain the list of the banks operating in US and Europe, respectively. What relational operator has to be used in order to obtain the list of the banks from US, operating in Europe, too (B1, B4). Note that B1, B2, B3, B4 and B5 are example of banks codes.
Inner join
9
If in a USER PROFILE table you would like to SUGGEST to the user that the telephone numberNEEDS TO CONTAIN the country code, area code and personal number, which field property would you set?
Input mask
10
Consider the following REGISTER & STUDENTS tables. How many records would be outputted by a RIGHT JOIN?
5
11
Objects having the same properties and behaviors to the same events belong to the same…
Class
12
The Recodr Source property from an Access form indicates that
The table on the query used data source from this form
13
“A list of commands or potions that user can choose during his interactive work on a screen" is definition for a:
Menu
14
If in a Students table, a new record cannot be saved if the name of the student is not inputted, which property would you set?
Required
15
Assume there has been established RESTRICT FOR INSERT, as a rule to PRESERVE REFERENTIAL INTEGRITY, between STUDENTS and REGISTER, may we insert inREGISTER a record having StudId=5?
False
16
Considering there is a RELATIONSHIP between STUDENTS and REGISTER, which one is the parent-table?
STUDENTS
17
What does represent the following query?
The average of all marks obtained by each student
18
What assertion describe better an index:
An index is a map for the records, according to a search criterion
19
What kind of RELATIONSHIP could be between REGISTER and STUDENTS?
Many to one
20
Is the REFERENTIAL INTEGRITY between STUDENTS and RECORDS accomplished?
Yes
21
The primary key from a table is:
The minimal combination of NOT NULL fields which assure the unique identification of a record
22
If the database designer wants to ORDER records ALPHABETICALLY by some fields, which table property should be changed?
Indexes
23
Which one is the primary/candidate key from STUDENTS table from our example?
StudId
24
The DBMS (DataBase Management System) is:
Software component
25
Which is the most appropriate field type to store phone number inAccess database?
Text
26
If the user adds a new record to a table and he sees a value already field-in for a cell of his new record, this is the effect of which table property?
Default value
27
Employee tables contains info regarding our current employees’ contact and identification data, monthly wages and department name. In order to compute monthly salary subtotals by each department we well create a query where:
We are grouping the employees by department and we sun up the salaries
28
A report is based on Products table, a table that contains 7 records. What happens if in Report Designe mode we place a LABLE CONTROL in Detail area?
In Report View mode the content will be displayed for 7 times
29
How many records would OUTPUT a LEFT JOIN?
4
30
Let’s assume there has been established CASCADE UPDATE RELATED FIELDS, as a rule to PRESERVE the REFERENTIAL INTEGRITY between STUDENTS and REGISTER, in MS Access. May we UPDATE in STUDENTS theStudId from the value 3 to 5?
True
31
Why should a database create a primary key in a table?
To force the user to always input some value in that particular field and only unique values
32
Which of the following is NOT a characteristic for CANDIDATE KEY?
Consistency
33
Let’s assume there has been established CASCADE UPDATE RELATED FIELDS, is a rule to PRESERVE the REFERENTIAL INTEGRITY between STUDENTS and REGISTER, in MS Access. What happens if we UPDATE in STUDENTS the StudId from the value 1 to value 5 in REGISTER?
This action is prohibited
34
Given the following scenario, which REFERENTIAL INTEGRITY property audio set in Access: “A person (stored in Company table) can deposit money in a bank (these kind of transactions are recorded in Deposits) only if he previously updated his account number”
This has nothing to do with referential integrity rules
35
Which one is NOT One of the main clothes into a SELECT statement?
FILTER BY
36
Assuming it has been established RESTRICT DELETION, as a rule to PRESERVE REFERENTIAL INTEGRITY between STUDENTS and REGISTER, may we delete record #2 from Students?
True
37
What does represent the following query?
The student which got marks hired than 8 to those disciplines whose name are starting with the “M”
38
Is it possible to run in UNION QUERY?
No
39
Assuming there has been established RESTRICT for INSERT, as a rule to PRESERVE REFERENTIAL INTEGRITY between STUDENTS and REGISTER, CAN we insert in STUDENTS a recording having StudId=5?
True
40
Can we create an Access table outside an Access database?
False
41
What does represent the following query?
The number of exams given by each student
42
If the user needs to see the Invoice Date in a Purchase Invoice table a medium date (i.e. dd-mmm-yyyy), which property you set?
Format
43
According to the RELATIONAL DATABASE THEORY, CARDINALITY is
The number of tulles in a relation
44
Which of the following students in the table containing the students from English line is more suitable to be a group in criterion?
Gender
45
In a PURCHASE REPORT, in which section would you place the AVERAGE PURCHASE PRICE for all purchases (based on a field containing purchase price)
Report header or report footer
46
Let’s assume there has been established CASCADE UPDATE RELATED FIELDS, as a reels to PRESERVE the REFERENTIAL INTEGRITY between STUDENTS and REGISTER in MS Access. What happens if we UPDATE in STUDENTS the StudId from the value of 3 to value of 5?
Nothing
47
Consider the following REGISTER & STUDENTS table Which one is the primary/candidate key from REGISTER table from our example
StudId, Discipline
48
What is a PRIMATY KEY?
One or a group of fields (attributes) from a table
49
The EXTERNAL DATA LEVEL from a database architecture represents
The user's view
50
Assuming there has been established RESTRICTON for INSERT, as a rule toPRESERVE REFERENTIAL INTEGRITY between STUDENTS and REGISTER, MAY we INSERT in REGISTER a record having StudId=5?
False
51
Given the following scenario, which REFERENTIAL INTEGRITY options are MANDATORY To be set in Access: “A person (store in Customers table) can deposit money in a bank (this kind of transactions are recorded in Deposits) only if he has previously updated his account number
Set the Enforced referential integrity property of the relationship between Customer and Deposits