Database Final Study Guide – Flashcards
150 test answers
Unlock all answers in this set
Unlock answers 150question
DBMS...
answer
38. A good __ should provide an opportunity for users to incorporate integrity constraints when they design the database.
Unlock the answer
question
repeating groups...
answer
39.A table is in first normal form if it does not contain __.
Unlock the answer
question
...GROUP BY
answer
40. The __ clause can be used to create groups of records.
Unlock the answer
question
...
answer
41.In MySQL , you use the ____ command to produce a list of tables.
Unlock the answer
question
Attribute
answer
42.An __ is a characteristic or property of an entity.
Unlock the answer
question
...
answer
43.
Unlock the answer
question
...
answer
44.
Unlock the answer
question
Product
answer
45. The __ operator is used to concatenate every row in the first table with every row in the second table.
Unlock the answer
question
Data File
answer
46. A __ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger
Unlock the answer
question
Client
answer
47. A __ is a computer that is connected to a network and has access through the server to the database.
Unlock the answer
question
Data Archive
answer
48. A __ is a place where a record of certain corporate data is kept.
Unlock the answer
question
Make-table
answer
49. A __ query creates a new table using query results.
Unlock the answer
question
...
answer
50.___ integrity constraints help to ensure the accuracy and consistency of individual field values.
Unlock the answer
question
DBA
answer
51. The __ is responsible for providing training in the use of the DBMS.
Unlock the answer
question
One line of output is produced for each group.
answer
52. When rows are grouped, __.
Unlock the answer
question
NULL
answer
53. Essentially, setting the value in a given field to
Unlock the answer
question
...
answer
54.
Unlock the answer
question
SELECT CustomerNum, CustomerName, Balance, FROM Customer WHERE CreditLimit > Balance;...
answer
55.Based on the code above list the number, name , credit limit, and balance for all customers with credit limits that excced their balances.
Unlock the answer
question
...
answer
56.
Unlock the answer
question
DBMS
answer
57.After a DBMS detects a deadlock, the __ should break the deadlock
Unlock the answer
question
redundancy...
answer
58. Storing the same data in more than one place is called __.
Unlock the answer
question
Union
answer
59.Two tables are considered to be __ compatible if they have the same number of columns and their corresponding columns represent the same type of data.
Unlock the answer
question
INSERT
answer
60.To add new data to a table, use the __ command
Unlock the answer
question
Enclose it in square brackets
answer
61.When you use a name containing a space in Access SQL, you must __.
Unlock the answer
question
Data Independence
answer
62.. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.
Unlock the answer
question
...
answer
63.
Unlock the answer
question
...
answer
64.
Unlock the answer
question
Data type
answer
65.__ integrity implies that the value entered for any field should be consistent with the data type for that field.
Unlock the answer
question
DELETE
answer
66.Which SQL statement is used to delete data from a database?
Unlock the answer
question
CREATE TRIGGER
answer
67.To create a trigger in MySQL, use the __ command.
Unlock the answer
question
NULL
answer
68.. __ value is used to represent unknown or undefined values
Unlock the answer
question
REVOKE
answer
69.The __ statement will take away user privileges to the database.
Unlock the answer
question
SELECT * FROM Persons
answer
70.With SQL, how do you select all the columns form a table named Persons?
Unlock the answer
question
Decrypting
answer
71.__ a database reverses encryption.
Unlock the answer
question
Database design
answer
72.. During the __ process , a database expert determines the structure of the required database.
Unlock the answer
question
Column that could be a primary key but was not chosen
answer
73.An alternate key is a __.
Unlock the answer
question
A -> B
answer
74.The fact that column B is functionally dependent on column A can be written as __.
Unlock the answer
question
Server
answer
75.A trigger is stored and compiled on the __.
Unlock the answer
question
Metadata
answer
76.Data about the data in a database is known as __.
Unlock the answer
question
Integrity
answer
77.. A database has __ if the data in it satisfies all established integrity constraints.
Unlock the answer
question
.DBMS
answer
78.The __ establishes the naming conventions for tables, fields, and indexes in the data dictionary.
Unlock the answer
question
...
answer
79.Which of the following statements is correct?
Unlock the answer
question
locking
answer
80.In order to accomplish serial processing of updates , many DBMSs use __.
Unlock the answer
question
...
answer
81.Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?
Unlock the answer
question
relationship
answer
82. An association between entities is known as a __.
Unlock the answer
question
*
answer
83. When used after the word SELECT , the __ sybol indicates that you want to include all fields in the query resuts in the order in which you described them to the DBMS when you created the table.
Unlock the answer
question
...
answer
84.____ contains a repeating group.
Unlock the answer
question
DBMS...
answer
85.A __ frees programmers who write database access programs form having to engage in mundane data manipulation activities, such as adding new data and deleting existing data.
Unlock the answer
question
DROP TABLE LargeCust...
answer
86. The statement ___ , removes the table LargeCust from a DBMS.
Unlock the answer
question
Structured Query Language...
answer
87. What does SQL stand for?
Unlock the answer
question
ALTER TABLE Part DROP COLUMN Warehouse...
answer
88. The SQL command for deleting the Warehouse field for the Part table is __.
Unlock the answer
question
PROJECT...
answer
89.The __ command within relational algebra takes a vertical subset of a table.
Unlock the answer
question
Replication and distributed databases...
answer
90.Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas?
Unlock the answer
question
primary sort key
answer
91. If you are sorting records by more than one field, the more important field is called the __.
Unlock the answer
question
Second
answer
92. __ normal form has an additional condition that the only determinants the table contains are candidate keys.
Unlock the answer
question
aggregate
answer
93. Count, Sum, Avg, Max, and Min are few of the built in statistics or __ functions that can be used in a query.
Unlock the answer
question
A functionally determines B
answer
94.If B (an attribute) is functionally dependent on A, we can also say that ___.
Unlock the answer
question
...
answer
95.When a subquery is used ,______ is (are) evaluated first.
Unlock the answer
question
Referential
answer
96. __ integrity is the constraint that says that the values in foreign keys must match values already in the database.
Unlock the answer
question
authentication
answer
97. The technique for identifying the person who is attempting to access the DBMS is known as __.
Unlock the answer
question
Cartiesian
answer
98. The product of two tables is also called the __ product.
Unlock the answer
question
DBA
answer
99. After the DBMS is purchased, the __ has primary responsibility for installation and maintenance.
Unlock the answer
question
semicolon
answer
100. Many versions of SQL require you to end a command with a __.
Unlock the answer
question
victim
answer
101. To break a deadlock, the DBMS chooses one deadlocked user to be the __.
Unlock the answer
question
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' ...
answer
102.WIth SQL , how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and Including) "Hansen" and "Pettersen".
Unlock the answer
question
...
answer
103.In order to develop new programs , the programmers need access to the information in the DBMS. They are given access to the __.
Unlock the answer
question
arguments
answer
104. In Access, many macro actions require additional information, called __ to complete the action.
Unlock the answer
question
Join
answer
105. Which operation will allow you to extract data from more than one table?
Unlock the answer
question
attributes
answer
106. The __ of an entity become the columns in the database table.
Unlock the answer
question
primary key
answer
107. The __ is a column(or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.
Unlock the answer
question
...
answer
108.Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export?
Unlock the answer
question
...
answer
109.
Unlock the answer
question
...
answer
110.Which of the following statement fragments will only allow a Credit Limit of $7,500 , $10,000 , or $15,000?
Unlock the answer
question
SELECT COUNT (*) FROM Persons...
answer
111.With SQL , how can you return the number of records in the 'Persons' table?
Unlock the answer
question
candidate
answer
112. From all the __ keys, one is chosen to be the primary key.
Unlock the answer
question
Deadlock...
answer
113. If two or more usrs are waiting for the other user to release a lock before they can proceed , this is known as a __.
Unlock the answer
question
legal-values
answer
114. In SQL, you use the CHECK clause to enforce __ integrity.
Unlock the answer
question
Backward recovery...
answer
115.The DBMS accomplishes ___ by reading the log for the problem transactions and applying the before images to undo their updates.
Unlock the answer
question
1
answer
116.
Unlock the answer
question
Biometrics
answer
117. __ identify users by physical characteristics such as fingerprints , voiceprints, handwritten signatures, and facial characteristics.
Unlock the answer
question
...SELECT FirstName FROM Persons
answer
118. With SQL , how do you select a column named 'FirstName' from a table named 'Persons'?
Unlock the answer
question
...
answer
119.
Unlock the answer
question
entity
answer
120. An __ is a person, place, object, event, or idea for which you want to store and process data.
Unlock the answer
question
CREATE VIEW...
answer
121. The __ command will create an application programs or individual usrs picture of the database.
Unlock the answer
question
...
answer
122.
Unlock the answer
question
...
answer
123.
Unlock the answer
question
Data Dictionary...
answer
124. Is it a simple catalog or can it contain more content such as information about programs and the various data items these programs access?
Unlock the answer
question
TRUE
answer
125.The OR operator displays a record if any conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true.
Unlock the answer
question
...
answer
126.
Unlock the answer
question
...
answer
127.
Unlock the answer
question
...
answer
128.
Unlock the answer
question
stored procedure
answer
129. If you anticipate running a particular query often, you can improve overall performance by saving the query in a special file called a __.
Unlock the answer
question
data must follow in the database
answer
130. An integrity constraint is a rule that __.
Unlock the answer
question
Security.
answer
131. __ is the prevention of unauthorized access to the database.
Unlock the answer
question
...
answer
132.
Unlock the answer
question
a larger file size....
answer
133.One disadvantage of a database system is __.
Unlock the answer
question
...
answer
134.
Unlock the answer
question
workgroups...
answer
135. The DBA usually creates groups of users called ____.
Unlock the answer
question
...
answer
136.
Unlock the answer
question
...
answer
137.
Unlock the answer
question
Denormalization...
answer
138. ______ converts a table that is in third normal form to a table no longer in third normal form.
Unlock the answer
question
...
answer
139. ____ locks forbid any other user from accessing the data in any way.
Unlock the answer
question
Catalogs
answer
140. __ contain information about table relationships , views, indexes, users, privileges, and replicated data.
Unlock the answer
question
TRUE
answer
1. The following command will enable jones to retrieve data from the customer table, but not to take any other action: GRANT SELECT ON Customer TO Jones
Unlock the answer
question
TRUE
answer
2. In two phase locking the second phase is the shrinking phase.
Unlock the answer
question
TRUE...
answer
3. A spreadsheets data sharing features allows multiple employees to update data in one spreadsheet at the same time.
Unlock the answer
question
TRUE
answer
4. A relation is essentially just a two dimensional table.
Unlock the answer
question
TRUE
answer
5. QBE is an example of a nonprocedural language.
Unlock the answer
question
FALSE
answer
6.Once you add an index to a database , you cannot delete it.
Unlock the answer
question
FALSE...
answer
7. To implement and enforce security, the DBA uses such features as jo;urnaling and metadata.
Unlock the answer
question
FALSE
answer
8. A relationship is an association between attributes.
Unlock the answer
question
FALSE
answer
9. The most common security features used by DBMSs are locking, journaling, and timestamping.
Unlock the answer
question
TRUE
answer
10. Additional disk and memory space are not required to store timestamp values.
Unlock the answer
question
FALSE...
answer
11.Views cannot be used to examine table data
Unlock the answer
question
TRUE
answer
12. The DBA is responsible for DBMS maintenance, data dictionary management, and training.
Unlock the answer
question
TRUE...
answer
13. The following command will revoke the ability to retrieve Customer records from user Jones : REVOKE GRANT ON Customer FROM Jones;
Unlock the answer
question
TRUE...
answer
14.The command DELETE INDEX CustList; would remove the index named CustList
Unlock the answer
question
FALSE
answer
15. Legal values is a type of key integrity constraint.
Unlock the answer
question
FALSE
answer
16. In a SELECT statement, the WHERE clause is mandatory.
Unlock the answer
question
TRUE
answer
17. Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.
Unlock the answer
question
TRUE...
answer
18.To protect an organizations data against physical damage , the DBA creates and implements backup and recovery procedures as part of a disaster recovery plan.
Unlock the answer
question
TRUE...
answer
19.Programs created with visual basic , Java, Perl, PHP, or C++ can access the database directly, rather than having access it through the DBMS.
Unlock the answer
question
TRUE ...
answer
20.An attribute is a characteristic or property of an entity.
Unlock the answer
question
TRUE
answer
21. There are two versions of the "not equal to" operator .and !=.
Unlock the answer
question
FALSE...
answer
22.Another term for procudtion system is the sandbox.
Unlock the answer
question
TRUE
answer
23. Converting to third normal form always avoids the problems related to dependencies.
Unlock the answer
question
TRUE...
answer
24.One guideleine for writing programs for concurrent updates in a pc based DBMS states that if an update transaction must lock more than one row in the same table , the whole table must be locked.
Unlock the answer
question
...
answer
25.
Unlock the answer
question
TRUE...
answer
26. Information about tables in the database is kept in the systme catalog.
Unlock the answer
question
TRUE
answer
27. Removal of repeating groups is the starting point in the quest to create tables that are a free of problems as possible.
Unlock the answer
question
TRUE
answer
28. Instead of listing all the field names in the SELECT clause, you can use the* symbol
Unlock the answer
question
TRUE...
answer
29.A relational database handles entities, attributes, and relationships by storing each entity in its own table.
Unlock the answer
question
FALSE
answer
30. CHAR data types are numbers without a decimal point.
Unlock the answer
question
TRUE
answer
31. A DBMS must provide ways to ensure that only authorized users can access the database.
Unlock the answer
question
TRUE...
answer
32.When rows are grouped , one lne of output is produced for each group
Unlock the answer
question
TRUE...
answer
33.Sharing data is one advantage of database processing
Unlock the answer
question
COMPLETION
answer
141. To find the total of all customers balances, use the ___ function.
Unlock the answer
question
MAJOR
answer
142. When you need to sort data on two fields, the less important key is called the ____ sort ket.
Unlock the answer
question
OR
answer
143.When you connect simple connections using the ____ operator, the compound condition will be true whenever any of the simple conditions are true.
Unlock the answer
question
LINES
answer
144.In an E-R diagram ______ represents relationships between connected entities.
Unlock the answer
question
...
answer
145.
Unlock the answer
question
...
answer
146.
Unlock the answer
question
subquery
answer
147. When you place one query inside another, the inner query is called a _____.
Unlock the answer
question
rollback
answer
148. A backward recovery is also called a _______.
Unlock the answer
question
...
answer
149.
Unlock the answer
question
DBA
answer
150. WIthin the organization , the _____ determines the types of access various users can have to the database.
Unlock the answer
