question

Password

answer

34. A string of characters assigned by the DBA to a database that the user must enter to access the database is known as a database ___.

question

...

answer

35. The catalog is maintained by __.

question

SELECT-FROM-WHERE...

answer

36. The basic form of an SQL retrieval command is ___.

question

TUNING

answer

37. Changing the database design to improve the performance is called __ the design.

question

DBMS...

answer

38. A good __ should provide an opportunity for users to incorporate integrity constraints when they design the database.

question

repeating groups...

answer

39.A table is in first normal form if it does not contain __.

question

...GROUP BY

answer

40. The __ clause can be used to create groups of records.

question

...

answer

41.In MySQL , you use the ____ command to produce a list of tables.

question

Attribute

answer

42.An __ is a characteristic or property of an entity.

question

...

answer

43.

question

...

answer

44.

question

Product

answer

45. The __ operator is used to concatenate every row in the first table with every row in the second table.

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

question

Client

answer

47. A __ is a computer that is connected to a network and has access through the server to the database.

question

Data Archive

answer

48. A __ is a place where a record of certain corporate data is kept.

question

Make-table

answer

49. A __ query creates a new table using query results.

question

...

answer

50.___ integrity constraints help to ensure the accuracy and consistency of individual field values.

question

DBA

answer

51. The __ is responsible for providing training in the use of the DBMS.

question

One line of output is produced for each group.

answer

52. When rows are grouped, __.

question

NULL

answer

53. Essentially, setting the value in a given field to

question

...

answer

54.

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.

question

...

answer

56.

question

DBMS

answer

57.After a DBMS detects a deadlock, the __ should break the deadlock

question

redundancy...

answer

58. Storing the same data in more than one place is called __.

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.

question

INSERT

answer

60.To add new data to a table, use the __ command

question

Enclose it in square brackets

answer

61.When you use a name containing a space in Access SQL, you must __.

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.

question

...

answer

63.

question

...

answer

64.

question

Data type

answer

65.__ integrity implies that the value entered for any field should be consistent with the data type for that field.

question

DELETE

answer

66.Which SQL statement is used to delete data from a database?

question

CREATE TRIGGER

answer

67.To create a trigger in MySQL, use the __ command.

question

NULL

answer

68.. __ value is used to represent unknown or undefined values

question

REVOKE

answer

69.The __ statement will take away user privileges to the database.

question

SELECT * FROM Persons

answer

70.With SQL, how do you select all the columns form a table named Persons?

question

Decrypting

answer

71.__ a database reverses encryption.

question

Database design

answer

72.. During the __ process , a database expert determines the structure of the required database.

question

Column that could be a primary key but was not chosen

answer

73.An alternate key is a __.

question

A -> B

answer

74.The fact that column B is functionally dependent on column A can be written as __.

question

Server

answer

75.A trigger is stored and compiled on the __.

question

Metadata

answer

76.Data about the data in a database is known as __.

question

Integrity

answer

77.. A database has __ if the data in it satisfies all established integrity constraints.

question

.DBMS

answer

78.The __ establishes the naming conventions for tables, fields, and indexes in the data dictionary.

question

...

answer

79.Which of the following statements is correct?

question

locking

answer

80.In order to accomplish serial processing of updates , many DBMSs use __.

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?

question

relationship

answer

82. An association between entities is known as a __.

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.

question

...

answer

84.____ contains a repeating group.

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.

question

DROP TABLE LargeCust...

answer

86. The statement ___ , removes the table LargeCust from a DBMS.

question

Structured Query Language...

answer

87. What does SQL stand for?

question

ALTER TABLE Part DROP COLUMN Warehouse...

answer

88. The SQL command for deleting the Warehouse field for the Part table is __.

question

PROJECT...

answer

89.The __ command within relational algebra takes a vertical subset of a table.

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?

question

primary sort key

answer

91. If you are sorting records by more than one field, the more important field is called the __.

question

Second

answer

92. __ normal form has an additional condition that the only determinants the table contains are candidate keys.

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.

question

A functionally determines B

answer

94.If B (an attribute) is functionally dependent on A, we can also say that ___.

question

...

answer

95.When a subquery is used ,______ is (are) evaluated first.

question

Referential

answer

96. __ integrity is the constraint that says that the values in foreign keys must match values already in the database.

question

authentication

answer

97. The technique for identifying the person who is attempting to access the DBMS is known as __.

question

Cartiesian

answer

98. The product of two tables is also called the __ product.

question

DBA

answer

99. After the DBMS is purchased, the __ has primary responsibility for installation and maintenance.

question

semicolon

answer

100. Many versions of SQL require you to end a command with a __.

question

victim

answer

101. To break a deadlock, the DBMS chooses one deadlocked user to be the __.

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".

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 __.

question

arguments

answer

104. In Access, many macro actions require additional information, called __ to complete the action.

question

Join

answer

105. Which operation will allow you to extract data from more than one table?

question

attributes

answer

106. The __ of an entity become the columns in the database table.

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.

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?

question

...

answer

109.

question

...

answer

110.Which of the following statement fragments will only allow a Credit Limit of $7,500 , $10,000 , or $15,000?

question

SELECT COUNT (*) FROM Persons...

answer

111.With SQL , how can you return the number of records in the 'Persons' table?

question

candidate

answer

112. From all the __ keys, one is chosen to be the primary key.

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 __.

question

legal-values

answer

114. In SQL, you use the CHECK clause to enforce __ integrity.

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.

question

1

answer

116.

question

Biometrics

answer

117. __ identify users by physical characteristics such as fingerprints , voiceprints, handwritten signatures, and facial characteristics.

question

...SELECT FirstName FROM Persons

answer

118. With SQL , how do you select a column named 'FirstName' from a table named 'Persons'?

question

...

answer

119.

question

entity

answer

120. An __ is a person, place, object, event, or idea for which you want to store and process data.

question

CREATE VIEW...

answer

121. The __ command will create an application programs or individual usrs picture of the database.

question

...

answer

122.

question

...

answer

123.

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?

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.

question

...

answer

126.

question

...

answer

127.

question

...

answer

128.

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 __.

question

data must follow in the database

answer

130. An integrity constraint is a rule that __.

question

Security.

answer

131. __ is the prevention of unauthorized access to the database.

question

...

answer

132.

question

a larger file size....

answer

133.One disadvantage of a database system is __.

question

...

answer

134.

question

workgroups...

answer

135. The DBA usually creates groups of users called ____.

question

...

answer

136.

question

...

answer

137.

question

Denormalization...

answer

138. ______ converts a table that is in third normal form to a table no longer in third normal form.

question

...

answer

139. ____ locks forbid any other user from accessing the data in any way.

question

Catalogs

answer

140. __ contain information about table relationships , views, indexes, users, privileges, and replicated data.

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

question

TRUE

answer

2. In two phase locking the second phase is the shrinking phase.

question

TRUE...

answer

3. A spreadsheets data sharing features allows multiple employees to update data in one spreadsheet at the same time.

question

TRUE

answer

4. A relation is essentially just a two dimensional table.

question

TRUE

answer

5. QBE is an example of a nonprocedural language.

question

FALSE

answer

6.Once you add an index to a database , you cannot delete it.

question

FALSE...

answer

7. To implement and enforce security, the DBA uses such features as jo;urnaling and metadata.

question

FALSE

answer

8. A relationship is an association between attributes.

question

FALSE

answer

9. The most common security features used by DBMSs are locking, journaling, and timestamping.

question

TRUE

answer

10. Additional disk and memory space are not required to store timestamp values.

question

FALSE...

answer

11.Views cannot be used to examine table data

question

TRUE

answer

12. The DBA is responsible for DBMS maintenance, data dictionary management, and training.

question

TRUE...

answer

13. The following command will revoke the ability to retrieve Customer records from user Jones : REVOKE GRANT ON Customer FROM Jones;

question

TRUE...

answer

14.The command DELETE INDEX CustList; would remove the index named CustList

question

FALSE

answer

15. Legal values is a type of key integrity constraint.

question

FALSE

answer

16. In a SELECT statement, the WHERE clause is mandatory.

question

TRUE

answer

17. Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.

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.

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.

question

TRUE ...

answer

20.An attribute is a characteristic or property of an entity.

question

TRUE

answer

21. There are two versions of the "not equal to" operator .and !=.

question

FALSE...

answer

22.Another term for procudtion system is the sandbox.

question

TRUE

answer

23. Converting to third normal form always avoids the problems related to dependencies.

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.

question

...

answer

25.

question

TRUE...

answer

26. Information about tables in the database is kept in the systme catalog.

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.

question

TRUE

answer

28. Instead of listing all the field names in the SELECT clause, you can use the* symbol

question

TRUE...

answer

29.A relational database handles entities, attributes, and relationships by storing each entity in its own table.

question

FALSE

answer

30. CHAR data types are numbers without a decimal point.

question

TRUE

answer

31. A DBMS must provide ways to ensure that only authorized users can access the database.

question

TRUE...

answer

32.When rows are grouped , one lne of output is produced for each group

question

TRUE...

answer

33.Sharing data is one advantage of database processing

question

COMPLETION

answer

141. To find the total of all customers balances, use the ___ function.

question

MAJOR

answer

142. When you need to sort data on two fields, the less important key is called the ____ sort ket.

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.

question

LINES

answer

144.In an E-R diagram ______ represents relationships between connected entities.

question

...

answer

145.

question

...

answer

146.

question

subquery

answer

147. When you place one query inside another, the inner query is called a _____.

question

rollback

answer

148. A backward recovery is also called a _______.

question

...

answer

149.

question

DBA

answer

150. WIthin the organization , the _____ determines the types of access various users can have to the database.

Database Final Study Guide – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards