問題一覧
1
Which one is NOT One of the main clothes into a SELECT statement?
FILTER BY
2
Considering the following tables: For OUTPUTTING the TOTAL SALES for each person what kind of gueries would you use?
Union + Select
3
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
4
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
5
Consider the following REGISTER & STUDENTS tables. How many records would be outputted by a RIGHT JOIN?
5
6
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
7
What does represent the following query?
The number of exams given by each student
8
Is the REFERENTIAL INTEGRITY between STUDENTS and RECORDS accomplished?
Yes
9
Can we create an Access table outside an Access database?
False
10
Consider the following REGISTER & STUDENTS table Which one is the primary/candidate key from REGISTER table from our example
StudId, Discipline
11
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
12
Which of the following is NOT a characteristic for CANDIDATE KEY?
Consistency
13
What kind of RELATIONSHIP could be between REGISTER and STUDENTS?
Many to one
14
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
15
What is a PRIMATY KEY?
One or a group of fields (attributes) from a table
16
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
17
Which is the most appropriate field type to store phone number inAccess database?
Text
18
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
19
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
20
What assertion describe better an index:
An index is a map for the records, according to a search criterion
21
Which of the following students in the table containing the students from English line is more suitable to be a group in criterion?
Gender
22
Which one is the primary/candidate key from STUDENTS table from our example?
StudId
23
Considering there is a RELATIONSHIP between STUDENTS and REGISTER, which one is the parent-table?
STUDENTS
24
How many records would OUTPUT a LEFT JOIN?
4
25
What does represent the following query?
The student which got marks hired than 8 to those disciplines whose name are starting with the “M”
26
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
27
Is it possible to run in UNION QUERY?
No
28
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
29
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
30
According to the RELATIONAL DATABASE THEORY, CARDINALITY is
The number of tulles in a relation
31
The database architecture has the following layers:
External, conceptual and internal levels
32
The primary key from a table is:
The minimal combination of NOT NULL fields which assure the unique identification of a record
33
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
34
The EXTERNAL DATA LEVEL from a database architecture represents
The user's view
35
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
36
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
37
“A list of commands or potions that user can choose during his interactive work on a screen" is definition for a:
Menu
38
What does represent the following query?
The average of all marks obtained by each student
39
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
40
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
41
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
42
The Recodr Source property from an Access form indicates that
The table on the query used data source from this form
43
If the database designer wants to ORDER records ALPHABETICALLY by some fields, which table property should be changed?
Indexes
44
In MS Access, may we create a query based on existing query?
True
45
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
46
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
47
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
48
What kind of relationship do we have between PRODUCTS and CUSTOMERS in real world?
N:M
49
The DBMS (DataBase Management System) is:
Software component
50
Objects having the same properties and behaviors to the same events belong to the same…
Class
51
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