1. A report generator is used to

2. Which of the following is not a logical data-base structure?

3. Which of the following is a database administrator’s function?

4. Primitive operations common to all record management systems include

5. Each of data files has a _____ that describe the way the data is stored in the file.

6. After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

7. What is the language used by most of the DBMSs for helping their users to access data?

8. Data item characteristics that are important in data management include

9. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

10. Periodically adding, changing and deleting file records is called file

11. Sort/report generators

12. The data dictionary tells the DBMS

13. In SQL, which command(s) is(are) used to enable/disable a database trigger?

14. If the record management system allows you to edit values before they are recorded on disk, you can

15. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

16. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

17. Which command is used to remove an index from the database in SQL?

18. An-owner-member set in the CODASYL specifications may have

19. What is the name given to the database management system which is able to handle full text data, image data, audio and video?

20. A top-to-bottom relationship among the items in a database is established by a

21. A database management system

22. Which of the following hardware components is the most important to the operation of a database management system?

23. The PROJECT command will create new table that has

24. To have a file hold a list, it is necessary to

25. Sophisticated report generators can

26. In a _____ a parent record type can be linked to one or more “child” record types, but a child record type can have only one parent.

27. Which two files are used during operation of the DBMS?

28. When using a database management system, the first thing that you must do is to

29. A network schema

30. Which of the following is not a relational database?

31. Which command is used to remove a table from the database in SQL?

32. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

33. A file produced by a spreadsheet

34. A form defines

35. Which of the following is true of a network structure?

36. In SQL, GRANT command is used to

37. The highest level in the hierarchy of data organization is called

38. The logical data structure with a one-to-many relationship is a :

39. Updating a database means

40. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

41. When you have finished entering information into a form

42. The main idea behind computer files is that it is convenient to

43. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

44. In SQL, which command is used to add new rows to a table?

45. A number of related records that are treated as a unit is called

46. If you want to group the records in the abc database, you could use the Jobcode as the _____.

47. The Management Information system (MIS) structure with one main computer system is called a

48. If a calculation is embedded in a form

49. Data security threats include

50. An operation that will increase the length of a list is

51. In SQL, which command is used to add a column/integrity constraint to a table

52. In SQL, which command(s) is(are) used to enable/disable a database trigger?

53. In a relational schema, each tuple is divided into fields called

54. In SQL, which command is used to changes data in a table?

55. What name is given to the collection of facts, items of information or data which are related in some way?

56. In a large DBMS

57. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

58. Internal auditors should review data system design before they are

59. A _____ means that one record in a particular record type may be related to more than one record of another record type.

60. Which command(s) is(are) used to redefine a column of the table in SQL ?

61. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

62. In SQL, the ALTER TABLESPACE command is used

63. The language used in application programs to request data from the DBMS is referred to as the

64. A database management system might consist of application programs and a software package called

65. An audit trail

66. A race condition occurs when

67. An indexing operation

68. The on-line, softcopy display a customer’s charge account to respond to an inquiry is an examples of a

69. In SQL, which command(s) is(are) used to create a synonym for a schema object?

70. If you want your database to include methods, you should use a _____ database.

71. In SQL, which of the following is not a data Manipulation Language Commands?

72. Which of the following is not characteristic of a relational database model?

73. A computer file contains several records. What does each record contain?

74. In SQL, the CREATE VIEW command is used

75. A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

76. In the DBM approach, application programs perform the

77. In SQL, which command is used to create a database user?

78. When performing a look-up operation using a form

79. A _____ means that one record in a particular record type is related to only one record of another record type.

80. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

81. In SQL, which command(s) is(are) used to redefine an index’s future storage allocation

82. Which of the following is a serious problem of file management systems?

83. With respect to data input, the most accurate description of batch control is

84. The model for a _____ resembles the hierarchical model in many respects.

85. A set of programs that handle a firm’s data base responsibilities is called a

86. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called

87. Long-range planning report produced in an MIS are primarily designed for

88. The model for a record management system might be

89. The designer of a form includes

90. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

91. Two files may be joined into a third file if

92. Characteristic(s) of a distributed MIS structure is

93. The data-base environment has all of the following components except:

94. The way a particular application views the data from the data base that the application uses is a :

95. A compound key

96. The distinguishable parts of a record are called

97. Large collections of files are called

98. The index consists of

99. In SQL, which command is used to select data in rows and column from one or more tables?

100. A scheme describes

101. A report form

102. A computer file can be best described as

103. A good query system

104. If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

105. The modify operation is likely to be done after

106. One data dictionary software package is called

107. One approach to standardizing storing of data

108. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?

109. A multiple-form file management system

110. The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.

111. A _____ Contains fields of data about one entity.

112. A condition that led to the development of databases was

113. The _____ command is used to allocates an extent for the table in SQL

114. Embedded pointer provide

115. Which of the following is a type of DBMS software?

116. Data items grouped together for storage purposes are called a

117. The activity of a file

118. Versatile report generators can provide

119. Related fields in a data base are grouped to form

120. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.

121. In SQL, the _____ command is used to recompile a view

122. A list in alphabetical order

123. If a piece of data is stored in two places in the database, then

124. A data dictionary is a special file that contains

125. A file that is organized in uniform format is formally referred to as a _____ or a database file.

126. A form can be used to

127. Which language has recently become the de-facto standard for interfacing application programs with relational database system?

128. In SQL, the CREATE TABLE is used

129. Which of the following is not true of the traditional approach to information processing?

130. Batch processing is appropriate if

131. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

132. Which of the following is not an advantage of the data-base approach?

133. A data dictionary doesn’t provide information about:

134. Data encryption techniques are particularly useful for

135. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

136. A logical schema

137. Queries to a database

138. In order to use a record management system

139. In SQL, which command is used to select only one copy of each set of duplicable rows

140. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

141. Which command is used to select distinct subject (SUB) from the table (BOOK)?

142. The master list of an indexed file

143. Which of the following is not the responsibility of the utilities component of DBMS software?

144. In SQL, the CREATE TABLESPACE is used

145. In SQL, which command is used to remove a stored function from the database?

146. The database administration function includes

147. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

148. A command that lets you change one or more fields in a record is

Previous ArticleNext Article

Leave a Reply

Your email address will not be published. Required fields are marked *