rbd Flashcards
(215 cards)
1
Q
The SELECT statement is used to
A
fetching records from the database
2
Q
The INSERT statement is used to
A
inserting records into the database
3
Q
The DELETE statement is used to
A
deleting records from the database
4
Q
The UPDATE statement is used to
A
updating records in the database
5
Q
INDEX in the database speeds up
A
searching for records in the database
6
Q
The COMMIT statement is used to
A
approving changes to the database
7
Q
The ROLLBACK instruction is used to
A
Rolling back changes to the database
8
Q
The GRANT instruction is used to
A
granting permissions in the database
9
Q
The REVOKE instruction is used to
A
revoking permissions in the database
10
Q
The ALTER TABLE statement is used to
A
table schema changes
11
Q
What is the value of the expression Null=Null
A
is undefined
12
Q
What is the value of the expression True OR Null
A
True
13
Q
What is the value of the expression False OR Null
A
Null
14
Q
What is the value of the expression False AND Null
A
False
15
Q
What is the value of the expression True AND Null
A
Null
16
Q
What is the value of the NOT Null expression
A
True
17
Q
What will be the result of executing the statement SELECT * FROM Employees WHERE EmployeeID=EmployeeID OR EmployeeID=NULL, Emp’s report
A
18
Q
What will be the result of executing the statement SELECT * FROM Emp WHERE EmployeeID=EmployeeID AND NULL=EmployeeID, empty relation
A
19
Q
Relation R has an attribute a. What number can be the result of executing the statement SELECT Count() FROM R WHERE a=a, always as many as the cardinality of the relation R
A
20
Q
Relation R has an attribute a. What number can be the result of executing the statement SELECT Count() FROM R WHERE a<a, always 0
A
21
Q
An entity corresponds to in a relational database
A
table
22
Q
A unique relationship corresponds to the following in a relational database
A
foreign key
23
Q
An ambiguous relationship corresponds to the following in a relational database
A
table
24
Q
An attribute in a relational database corresponds to
A
column in table
25
A unique identifier corresponds to the following in a relational database
master key
26
Referential integrity concerns the fact that
the value of a foreign key can be null or the value of its corresponding primary key
27
Third normal form concerns the fact
values in a non-key column cannot depend on either part of the key or even transitively on the key
28
Which of the following statements are true in the relational modelx the poems are not repeated, the order of the columns is irrelevant, values in the column are not repeated
29
Which of the following statements are true in the relational model
a unique relationship is represented by a foreign key
30
Which of the following statements are true in the relational model
an index is automatically created for a unique key, a unique index is automatically created for the primary key
31
Which of the following statements are true in the relational model
primary key values cannot be repeated
32
Which of the following statements are true in the relational model
there can be multiple foreign keys, there can be multiple indexes
33
Boyce-Codd normal form refers to the fact
every nontrivial functional dependency is a dependency on a superkey
34
Which of the following statements are true
There should be no uncontrolled redundancies in the table
35
Which of the following statements are true
each fact stored in the database should be expressed in only one way
36
At what levels is a relational database designed
logical, physical
37
Who is the creator of the relational database model
Edgar Codd
38
Which company first implemented a relational database management system
IBM
39
When the table schema is not in third normal form we have
redundancy, anomalous insertion, anomalies in removal, anomalies in modification
40
Functional dependency concerns the relationship between
attributes
41
Elimination of partial and transitive dependencies leads to
III normal form
42
When moving to an object table, the table row
obtains object identity, may have related methods, becomes an object of a certain class
43
What type can an attribute value be in the object-relational model
list of values, reference to an object, a set of values, atomic value
44
A class diagram in ODL includes
attributes, compounds, methods
45
A class schema in ODL is defined using the keyword
interface, class
46
ODL language specifications include
inverse compounds, inheritance
47
Given the relational schema R={City, Street, Code}, F = {City,Street->Code
Code->City}. This schema
48
Given the relational schema R={City, Street, Postcode, Post}, F = {City, Street->Postcode
Postcode->City
49
Given the relational schema R={City, Street, Postcode, Post}, F = {City, Street->Postcode
Postcode->Post}. This schema
50
Given a relational schema R={City, Street, Code}, F = {City, Street->Code}. This schema
is in Boyce-Codd normal form, is in the third normal form
51
Given the relational schema R={Street, Code, Shop}, F = {Street->Code
Shop->Street}. This schema
52
Given the relational schema R={Street, Code, Shop, Number}, F = {Street->Code
Street, Number ->Shop}. This schema
53
Given the relational schema R={Student,Address,Dormitory}, F = {Student->Address
Dormitory->Address
54
Given the relational schema R={Student,University,Address,Club}, F = {Student->University
Club->Address}. This schema
55
Given the relational schema R={Student,University,Address,Club}, F = {Student->University
Club->Address
56
Given the relational schema R={Student,University,Address,Club}, F = {Student, University->Club
Club->Address}. This schema
57
Which of the following statements are true for a non-identifying relationship in Visio
the foreign key is not part of the primary key of the entity on the multiple side
58
Which statements are true for the identifying relationship in Visio
the foreign key is part of the primary key of the entity on the multiple side
59
Reference actions apply to Visio
performing INSERT, DELETE and UPDATE operations on related records
60
In Visio, the Cardinality property defines
how many instances of an entity on the one side can be associated with an instance of an entity on the many side
61
In Visio, the optionality property specifies
is the relationship optional
62
In Visio, the Relationship Type property specifies
is the relationship identifying
63
As a result of the transformation of a binary wildcard relationship, the number of entities created is
1
64
As a result of the transformation of a binary ambiguous relationship, the number of relationships created is
1
65
As a result of the transformation of a ternary ambiguous relationship, the number of entities created is
1
66
As a result of the transformation of a ternary ambiguous compound, the number of compounds created is
1
67
A cycle in an entity-relationship diagram means that
there may be a recursive relationship
68
An instance of a one-to-one relationship is always a function
"on"
69
In Chen modeling notation, the relationship is represented by
diamond
70
In Chen's modeling notation, an entity is represented by
rectangle
71
In Chen's modeling notation, an attribute is represented by
wheel
72
Students have ideas. Each idea is about something. Each idea comes to mind of exactly one student. The student can share the idea with fellow students. Which of the following schemes is most appropriate from the point of view of database design principles
Students(student_id, name, surname, address), Ideas(idea_id, thing, description, student_id), Colleagues(idea_id, colleague_id)
73
Students like each other, are indifferent to each other, or can't stand each other (there is no other way). Which of the following schemes is most appropriate from the point of view of database design principles
Students(student_id, name, surname), Likes(student_id, colleague_id), Dislikes(student_id, colleague_id), Indifferent(student_id, colleague_id)
74
Domestic animals live in the houses. Some animals eat each other. The houses can be located next to each other. Which schema, according to the principles of database schema design, is most appropriate for an animal welfare organization
Homes(house_id, address), Animals(animal_id, type_id, house_id), Types(type_id, type), Next_to_each_other(house_id1, house_id2), Eats(type_id, type_id_eaten)
75
Movies are played by actors. Each movie has exactly one director and one or more screenwriters. Which of the following schemes is most appropriate from the point of view of database design principles
Movies(movie_id, title, director_id, director_salary), People(person_id, last_name), Actors(actor_id, movie_id, role, salary), Screenwriters(screenwriter_id, movie_id, salary)
76
Politicians belong to political parties (sometimes they change them, sometimes they split them). Political parties, before elections, form electoral coalitions. Which of the following schemes is most appropriate from the point of view of database design principles
Politicians(policy_id, name, surname), Parties(party_id, name, from, to), Coalitions(coalition_id, election_date), Members(party_id, person_id, from, to), In_coalition(party_id, coalition_id, from, to)
77
Students plan what they would like to do in their future careers and what positions they would like to hold. Which of the following schemes is most appropriate from the point of view of database design principles
Students(student_id, name, surname), Classes(class_id, name), Positions(position_id, name), Who_what(student_id, position_id, class_id)
78
A database is to be created at PJWSTK to collect information about skills useful in professional work, subjects that teach these skills, and books in which the skills are described. Which of the following schemes is most appropriate from the point of view of database design principles
Skills(skill_id, name, description), Where(skill_id, ISBN, from_page, to_page), On(skill_id, subject_id), Subjects(subject_id, name, semester), Book_copies(call number, title, authors, shelf_number)
79
At PJWSTK a database is being created with information on what software is installed in each room - with a view to conducting classes in the appropriate subjects in them. Which of the following schemes is the most appropriate from the point of view of database design principles
Programs(program_id, company, name, version), Items(item_id, name), Rooms_programs(room_no., program_id, number_of_installations), Items_programs(item_id, program_id), Rooms(room_id, number, how_many_computers)
80
Which of the following database schemas is most appropriate for a library from the point of view of database design principles? The database should store information about customers, books, and loans (capital letters indicate the primary key)
Customer(CUSTOMER_ID, name, surname, address), Book(BOOK_ID, title, author), Loan(CUSTOMER_ID, BOOK_ID, LOAN_DATE, RETURN_DATE)
81
A database is needed to record students and their grades. Which of the database schemas is most appropriate from the point of view of database design principles
Student(student_id, name, surname), Assessment(assessment_id, assessment, date_issued, subject_id, student_id), Subject(subject_id, name)
82
Which methods concern maintaining data consistency during concurrent access
pessimistic blocking, optimistic locking
83
Which methods concern data protection against unauthorized access
entering accounts and passwords, granting permissions to perform operations on objects
84
Data dictionary data (metadata) is stored in the database
in special tables in the same database
85
Client-server architecture means
division of tasks performed by the application into two aspects
86
Client-server architecture means
that one program provides services to a group of other programs
87
Which of the following statements are true
There can be many servers and many clients on one computer
88
Which of the following statements are true
a program acting as a server can become a client of another server, the user interface is part of the client program, the client and server can be on different computers
89
Which of the following statements are true
a program acting as a server can become a client of another server, the user interface can be generated by the client program, the user interface can be generated by a server program
90
Which of the following objects appear in the MS Access database window
modules, forms, macros, reports
91
Which of the following objects appear in the MS Access database window
modules
92
Which of the following objects appear in the MS Access database window
forms, reports
93
Which of the following objects appear in the MS Access database window
modules, tables
94
Which of the following objects appear in the MS Access database window
tables, forms, macros
95
Which SQL standard operators are not available in MS Access
INTERSECT, EXCEPT
96
Which SQL standard operators appear in MS Access
UNION, DISTINCT
97
Which SQL standard operators are not available in MS Access
INTERSECT, EXCEPT
98
Which Access operators are not included in the SQL standard
DISTINCTIVE
99
Can a SELECT statement appear
in the query grid in the Field row, in the query grid in the Criteria row, as a source of rows for the form, as a row source for a list box on a form
100
A pass-through query consists of
sending SQL statements to the database server via ODBC
101
A pass-through query can be used to
creating a table in the SQLServer database, creating a view in the SQLServer database
102
A pass-through query can be used to
creating a table in the Oracle database, creating a view in the Oracle database
103
A pass-through query can be used to
fetching data from a remote database, executing SQL statements in a remote database
104
A pass-through query can be used to
executing SQL statements in a remote database
105
A pass-through query can be used to
fetching data from a remote database
106
A pass-through query can be used to
deleting a table in a remote database
107
What role do tables play in MS Access
physical structure of data storage, logical structure of data storage, data sources for forms
108
What operations can be performed on an MS Access table in datasheet view
add a new row, add a new column, delete a row, remove column
109
What operations can be performed on an MS Access table in table design view
add a new column, remove column
110
What operations can be performed on an MS Access table in datasheet view
sort rows by values in one of the columns, put on a filter, apply filter
111
What operations can be performed on an MS Access table in table design view
add a new column, remove column
112
The reference is defined for
foreign key columns
113
"Cascading Delete Related Records" option
enables the preservation of referential integrity constraints, is set in the edit properties window of the relationship between two tables
114
Row join type
is set in the properties pane of the relationship between two tables, has three options
115
Perspective in MS Access is
select query
116
Which of the following are query type names
updating
117
What are the possible forms of the form (Default View) in the form view
single form, data sheet, continuous form
118
The displayed form content can be divided into
pages, bookmarks, windows
119
A form field can be
related, unrelated, calculated
120
What value can the expression If(IsNull([Earnings]),0,[Earnings]) have?, 0, equal to the value of the expression [Earnings]
121
The natural logical structure for dividing data in a report is
groups, pages, columns
122
Cross-tabulation of data uses
cross-tab queries
123
Data stored in an MS Access database can be accessed over the web for display in browsers using
data access pages, ODBC and web server
124
Which of the following objects can appear on a standard Access form as its dialog items (controls)
list
125
Which of the following objects can be included in a module in Access
function, variable
126
Which of the following objects can be stored in a table field in an Access database
Word document, value YES/NO
127
What objects in Access can event procedures be linked to
field in the table
128
Using ODBC technology you can in an MS Access database
save data to Oracle database, define a table linked to a table in the SQL Server database
129
The link is
a field on a form containing a reference to a record position in a table
130
What does the term "Filter by form" mean
searching for records according to the conditions entered into the form by the user
131
Which events can be programmed for the form
at closing, after update
132
In the WHERE condition: Institutions![Institution ID]=Forms![Persons]![Institution ID] the Institutions, Persons objects can be respectively
table and form
133
Where can you use the expression Sum([Cost])
in the form footer, in the form details section, in the "Field" row of the query grid
134
The ActiveX control is
a form dialog element supported by a registered Windows application
135
MS Access allows you to use remote ODBC databases in the following ways
by linked tables, by forwarding queries, using the Connection object and record sets
136
The DLookUp function allows you to
bringing values from another table to the form
137
The IIf function allows you to
interpreting Null as an empty string
138
Replacing a foreign key field in an MS Access table with a lookup (LookUp)
allows you to edit a table field by selecting a value from an installed control - a combo box, allows you to view values also from fields other than the key fields of the parent table
139
The "autonumber" value that can be selected in the "data type" field of the MS Access table design view specifies the values of this field as
is a mechanism for automatically entering consecutive natural numbers or random numbers different from each other in subsequent table records into a field for which this type of value is specified
140
If for MS Access tables that are related to each other, the primary key of the parent table is implemented by "autonumbering", then the corresponding foreign key field of the child table should be declared as variable type
long integer
141
Deleting cascade-related records in an MS Access database can be accomplished by
selecting the "cascade delete related records" option when declaring integrity constraints for the relationship that connects these tables, then the database system will automatically delete the related records from the child table before deleting the record in the parent table
142
the data source for an Append query in MS Access can be
another table or query
143
After creating a new table in MS Access the database system
will suggest the user to define a primary key field and possibly select such a field and make it the primary key.
144
When creating a form with a subform to simultaneously view records from the parent table and their related records from the child table, the database application designer must ensure
the existence of fields in the record sources of both forms that will enable linking corresponding records.
145
The purpose of the TOR document is
a reference point for further design work, writing down the functions that the database application is to perform
146
Entity Relationship Diagram
is used by analysts, abstracts from the implementation details of the database, is used to determine user requirements
147
What processes are subjected to design objects stored in the CASE tool repository
transformation, versioning, generation (forward engineering), reverse engineering
148
What are the phases in the MSF risk model
analysis, planning, tracking, control
149
What elements is the MSF process model based on
checkpoints (milestones), managing the relationship between resources, schedule and features
150
Which phases are distinguished as basic in the MSF process model
Planning phase, Analysis phase, Design phase, Creation phase
151
Which roles are included in the MSF project team model
Project Manager, Product Manager, program manager
152
According to the MSF methodology, the following are responsible for delivering the product within the design constraints
Project Manager, program manager
153
According to the MSF methodology, the following persons are responsible for delivering a product that complies with the specification
Product Manager, tester
154
What are the fundamental aspects of the MSF enterprise architecture model
business, information, applications, technology
155
What design perspectives are highlighted in the MSF design process model
conceptual, logical, physical
156
What layers are distinguished in the MSF application model
presentation layer, business layer, data layer
157
Saving whether a select query returns an empty set in a Boolean variable can be done using
set of records
158
Synchronizing two unrelated lists on a form can be done using
DLookUp function, ApplyFilter method (of DoCmd object), OpenForm methods (of the DoCmd object)
159
Which of the constructs are used for validation and error handling in the application
action CancelEvent, "On Error" event procedure, On Error instruction, event procedure "When value is not in list"
160
For what objects can a record set be defined
form, report, table
161
Which of the following objects are part of the ADO hierarchy
record sets
162
Which of the following statements are used to synchronize values in two forms
DoCmd.ApplyFilter, DoCmd.Requery
163
Which of the following expressions are part of the SQL language
Select Distinct People.LastName From People, Update People Set Data = null
164
The collection is
an object representing a set of elements
165
A record set is
RecordSet type object
166
ADO is a library of objects and collections that allows access to
data
167
The root of the ADO hierarchy is the object
Connection
168
DoCmd is
an object whose methods are used to execute commands
169
Control is
an object belonging to the Controls collection
170
What does the Visual Basic runtime environment include
program analysis window, break points, class object navigator
171
Access administrative tools allow you to
database defragmentation, converting a database from an earlier version of Access, creating user accounts, data replication
172
Access administrative tools allow you to
database defragmentation, converting a database from an earlier version of Access, data replication
173
Access administrative tools allow you to
managing Access databases in a local network, converting a database from an earlier version of Access, repairing a corrupted database, data replication
174
Access administrative tools allow you to
database defragmentation, converting a database from an earlier version of Access, database encryption
175
Access administrative tools allow you to
separating data from the user interface, setting a password for the database, data replication
176
Which of the following actions can speed up the performance of a database application
using the Database Performance Analyzer, removing drawings from unbound frames, using the Database Table Analyzer
177
Which of the following actions can speed up the performance of a database application
using the Database Performance Analyzer, converting to .mde format, removing drawings from unbound frames, using the Database Table Analyzer
178
Which of the following actions can speed up the performance of a database application
using the Database Performance Analyzer, removing drawings from unbound frames, using the Database Table Analyzer
179
Which of the following actions can speed up the performance of a database application
using the Database Performance Analyzer, establishment of new indexes, removing some indexes, removing drawings from unbound frames
180
Which of the following actions can speed up the performance of a database application
using the Database Performance Analyzer, replacing queries as a row source for lists with SELECT statements
181
The java.sql package includes
interface responsible for establishing a connection to the database, a class that manages the list of available drivers, interface for managing the list of available drivers
182
The java.sql package includes
a class representing an SQL statement, a class representing a database connection, a class representing a set of query results
183
What are the methods of the Statement class
executeQuery, executeUpdate
184
What are the methods of the ResultSet class
next, getString
185
What are the methods of SQLException class
getSQLState
186
The commit method belongs to the class
Connection
187
To model an ambiguous relationship (many-to-many) in MS Visio you need to
Create an association entity and link it to the output entities with two one-to-many relationships, where the association entity will remain on the "one" side
188
The relationship STATE - RIVER ("flows through") is a relationship?
many - many
189
How many tables should a simple normalized database containing information about floors, rooms and "one-to-many" relationships between them consist of?
2
190
The entities PRESIDENT and STATE (with the dependency “directs”) are connected by the relationship
one - many
191
Which SQL statements will list employees working in a department named "DALLAS" or "CHICAGO" earning more than $1,200,, SELECT NAME,DEPT,SAL FROM EMP WHERE (DEPT='DALLAS' OR DEPT='CHICAGO') AND SAL>1200
192
In MS Visio, the circle separating the relationship is placed on the relationship line
ambiguous
193
Given a relational schema: R = {Student, University, Address, Club}, F = {Student -> University
Club -> Address
194
What is the value of the logical expression TRUE AND (Null OR FALSE)
False
195
The entities COUNTRY and RIVER (with the relationship "the river flows through many countries") are connected by a relationship, many - many
196
There are three tables Customers(Customer_ID, First_Name, Last_Name), Products(Product_ID, Name, Price) and Purchases(Customer_ID, Product_ID, Quantity). Indicate the correct SQL query that finds the names and surnames of customers who have purchased at least one product, SELECT DISTINCT FirstName, LastName FROM Customers LEFT OUTER JOIN Shopping ON Customers.Customer_Id = Shopping.Customer_Id
197
What will be the result of executing the following statement on a non-empty relation PERSON (PersonId, FirstName, LastName, AccountNo.): SELECT * FROM Person WHERE AccountNo. = AccountNo. OR AccountNo. = NULL?, relationship Person
198
There are domestic animals living in the houses. Some animals eat each other. The houses can be located next to each other. Indicate which of the following diagrams (primary key attributes are marked in capital letters) correctly (and without redundancy) model the problem, Homes(HOUSE_ID, address) Animals(ANIMAL_ID, type_id, house_id) Types(TYPE_ID, type) Next_to_each_other(HOUSE_ID1, HOUSE_ID2) Eats(TYPE_ID_EATS, TYPE_ID_EATEN)
199
If there is a GROUP BY clause in the query, then the SELECT can be followed by
column following GROUP BY
200
The CURRENCY entity and the COUNTRY entity (with the relationship "the country has one currency") are connected by a relationship, one - many
201
There are three tables Customers (Customer_ID, First_Name, Last_Name), Products (Product_ID, Name, Price and Purchases (Customer_ID, Product_ID, Quantity). Indicate the correct SQL query that finds the first and last names of customers who purchased the product named Washing Machine., SELECT FirstName, LastName FROM Customers INNER JOIN Shopping ON Customers.Customer_Id = Shopping.Customer_Id INNER JOIN Products ON Products.Product_Id = Shopping.Product_Id WHERE Name = 'Washing Machine'
202
Relation R has an attribute a. What number can be the result of executing the statement SELECT COUNT(*) FROM R WHERE a <> a
, always 0
203
What is the value of the logical expression TRUE OR Null OR FALSE
True
204
The concept of reference shares applies, Performing DELETE and UPDATE operations on related records, Possibilities of linking entities together with an unambiguous relationship
205
The tables STUDENT and SUBJECT (with the relationship "each student takes multiple subjects") are connected by the relationship
Requiring an additional association table, many - many
206
Specify the correct SQL query (ORACLE dialect) that finds the average earnings of only those departments that employ more than three employees
SELECT deptno, AVG(sal) FROM emp HAVING COUNT(*) > 3 GROUP BY deptno
207
Given two tables Osoby(Imię, Nazwisko, Zarobki, Id_działu)and Działy(Id_działu, Nazwa). Which of the following statements are valid SQL statements in the ORACLE dialect?, INSERT INTO Osoby (Imię, Nazwisko, Zarobki) VALUES ('Jan', 'Kowalski', 2000), DELETE FROM Osoby WHERE Id_działu = 10
208
A unique relationship is implemented in a relational database by
foreign key
209
If there is a GROUP BY clause in the query, then HAVING can be followed by
summary function
210
The requirements specification states: An album consists of a number of songs
a song is in one album. In which drawings is this requirement modeled correctly. (The arrow indicates the "one" side of the relationship)?, (The first image)
211
The logical value of the expression FALSE OR Null AND TRUE is
FALSE
212
Given the relational schema R={City, Street, Postcode, Post}, F = {City, Street->Postcode
Postcode->City
213
Given the relational schema R={Street, Code, Shop}, F = {Street->Code
Shop->Street}. This schema
214
What is the value of the logical expression TRUE OR Null OR FALSE
True
215
The IIf function allows you to
interpreting Null as an empty string
