1001. A report generator is used to
Print files on paper
1002. Which of the following is not a logical data-base structure?
Chain
1003. Which of the following is a database administrator’s function?
Database design
Backing up the database
Performance monitoring
User coordination
1004. Primitive operations common to all record management systems include
Look-up
1005. Each of data files has a _____ that describe the way the data is stored in the file.
File structure
1006. After you _____ a record, many data management the environments require you to issue a command to save the changes you made. Delete
Update
1007. What is the language used by most of the dbmss for helping their users to access data?
Query language
1008. Data item characteristics that are important in data management include
Width
1009. In sql, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
Commit
1010. Periodically adding, changing and deleting file records is called file
Updating
1011. Sort/report generators
Require more disk space than index/report generators
1012. The data dictionary tells the dbms
What files are in the database
What attribute are possessed by the data
What these files contain
1013. In sql, which command(s) is(are) used to enable/disable a database trigger?
Alter trigger
1014. If the record management system allows you to edit values before they are recorded on disk, you can
Correct spelling changes before they are recorded
1015. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
Record
1016. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
Data field
1017. Which command is used to remove an index from the database in sql?
Drop index
1018. An-owner-member set in the codasyl specifications may have
Only one owner but many owner occurrences
1019. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Multimedia
1020. A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
1021. Which of the following hardware components is the most important to the operation of a database management system?
High speed, large-capacity disk
1022. Sophisticated report generators can
Print row-oriented reports
Perform arithmetic operations
Selectively retrieve and print portions of a list
1023. 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.
Hierarchical database
1024. Which two files are used during operation of the dbms?
Data dictionary and transaction log
1025. When using a database management system, the first thing that you must do is to
Load the software into your microâ¬computer
1026. A network schema
Permits many-to-many relationâ¬ships
1027. Which of the following is not a relational database?
Reflex
1028. Which command is used to remove a table from the database in sql?
Drop table
1029. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
Master file
1030. A file produced by a spreadsheet
Is generally stored on disk in an ascii text format
1031. A form defines
Where data is placed on the screen
The width of each field
1032. Which of the following is true of a network structure?
It allows a many-to-many relationship
1033. In sql, grant command is used to
Grant system privileges, roles, and object privileges to uses and roles
1034. The highest level in the hierarchy of data organization is called
Database
1035. The logical data structure with a one-to-many relationship is a :
Tree
1036. Updating a database means
Modifying or adding record occurrences
1037. In sql, which command(s) is (are) used to enable/disable all triggers on a table?
Alter table
1038. When you have finished entering information into a form
The contents of the form are written to the data file
1039. The main idea behind computer files is that it is convenient to
Store information together
1040. 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
A compound key consisting of the first name and the last name
1041. In sql, which command is used to add new rows to a table?
Insert
1042. A number of related records that are treated as a unit is called
File
1043. If you want to group the records in the abc database, you could use the jobcode as the _____.
Sort key
1044. The management information system (mis) structure with one main computer system is called a
Centralized mis structure
1045. If a calculation is embedded in a form
The result of the calculations are stored with the form
1046. In sql, the command(s) is(are) used to create an index for a table or cluster
Create index
1047. There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
Database management system (dbms)
1048. A _____ dbms distributes data processing tasks between the workstation and a network server. Network
Client server
1049. Information can be transferred between the dbms and a
Spreadsheet program
Word processor program
Graphics program
1050. Data integrity control
Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
1051. In order to use a dbms, it is important to understand
The physical schema
All sub-schemas that the system supports
1052. In sql, which command(s) is(are) used to recompile a stored function?
Alter function
1053. Report generators are used to
Retrieve information from files
Answer queries
1054. Administrate supervision of database activities is the responsibility of the
Database administrator
1055. Goals for the design of the logical schema include
Avoiding data inconsistency
Being able to construct queries easily
Being able to access data efficiently
1056. In sql, which command(s) is(are) used to change a table’s storage characteristics?
Alter table
1057. In sql, which of the following is not a data definition language commands?
Update
1058. Subschema can be used to
Create very different, personalized views of the same data
Present information in different formats
Hide sensitive information by omitting fields from the subâ¬schema’s description
1059. Database management systems are intended to:
Eliminate data redundancy
Establish relationships among records in different files
Manage file access
Maintain data integrity
1060. In sql, which command(s) is(are) used to issue multiple create table, create view, and grant statements in a single transaction?
Create schema
1061. In sql, which command is used to select data in rows and column from one or more tables?
Select
1062. A scheme describes
Data elements
Records and files
Record relationships
1063. A report form
Is used during report generation to format data
1064. A computer file can be best described as
An orderly collection of data items
1065. A good query system
Allows non-programmers to access information stored in a database
1066. If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it. Delete
Index
1067. The modify operation is likely to be done after
Look-up
1068. One data dictionary software package is called
Db/dc dictionary
1069. One approach to standardizing storing of data
Codasyl specifications
1070. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
Data management packages
1071. A multiple-form file management system
Lets you define different forms for different operations
Lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
1072. 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. Database
Flat file
1073. A _____ contains fields of data about one entity.
Record
1074. The _____ command is used to allocates an extent for the table in sql
Modify allocates
1075. Embedded pointer provide
A secondary access path
1076. Which of the following is a type of dbms software?
Database manipulation language
1077. Data items grouped together for storage purposes are called a
Record
1078. The activity of a file
Refers to how closely the files fits into the allocated
1079. Related fields in a data base are grouped to form
Data record
1080. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa. One-to-one relationship
Many-to-many relationship
1081. In sql, the _____ command is used to recompile a view
Alter view
1082. A data dictionary is a special file that contains
The names of all fields in all files
The data types of all fields in all files
The widths of all fields in all files
1083. A file that is organized in uniform format is formally referred to as a _____ or a database file. Document
Structured data file
1084. A form can be used to
Modify records
Delete records
Format printed output
1085. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
Sql
1086. In sql, the create table is used
To create a table, defining its columns, integrity constrains, and storage allocation
1087. Which of the following is not true of the traditional approach to information processing?
There is common sharing of data among the various applications
1088. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Dbms
1089. Which of the following is not an advantage of the data-base approach?
Elimination of the data redundancy
The size of the disk storage device
1090. Data encryption techniques are particularly useful for
Protecting data in data communication systems
1091. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
Database
1092. A logical schema
Is a standard way of organizing information into accessible parts
1093. Queries to a database
\can use aggregate functions like sum and count
1094. In order to use a record management system
You need to understand the model the record management system uses.
1095. In sql, which command is used to select only one copy of each set of duplicable rows
Select distinct
1096. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
A hashed file
1097. Which command is used to select distinct subject (sub) from the table (book)?
Select distinct sub from book
1098. Contains only a list of keys and record numbers
Has a number assigned to each record
1099. Which of the following is not the responsibility of the utilities component of dbms software?
Creating the physical and logical designs
1100. In sql, the create tablespace is used
To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
1101. In sql, which command is used to remove a stored function from the database?
Drop function
1102. The database administration function includes
Database access planning
1103. A command that lets you change one or more fields in a record is
Modify
1104. A function whose purpose is to send messages to other functions is known as a _____
Dispatcher
1105. With commercial classes, the function source code is usually________
Provided in object form
1106. The type of value that a function sends back to the function that calls it is known as its _____
Return value
1107. Assume that a program includes the short *ageptr = null; statement. The name of the pointer is _____
Ageptr
1108. Which of the following are never inherited?
Constructor functions
1109. The expression c = i++ causes
The value of i assigned to c and then i incremented by 1
1110. Which of the following creates a string named constant called partno, whose value is ab45?
Const char partno[5] = "ab45";
1111. The bitwise and operator is represented by the symbol
&
1112. The exclusive or operator gives the result 1 when
One bit is 0 and the other is 1
1113. A function’s purpose is to print customer data. Which of the following is the best name for this function?
Printcustomer(). It states the function’s purpose and is easy to read
1114. The function strcmp("jose", "jose") will return _____
1
1115. A pointer to void can hold pointers to
Any data type
1116. Which of the following is the extraction operator?
>>
1117. The function whose prototype is void getdata(item &thing); receives
A reference to a structure
1118. When a multidimensional array is accessed, each array index is
Surrounded by brackets
1119. To create a variable, you must assign _____ to it
Both a data type and a name
1120. You indicate a variable is a pointer variable by placing a(n) _____ in front of the variable’s name
Asterisk
1121. A function can make_________
As many throws of as many types as necessary
1122. A default exception block must be placed _____
Last among the catch blocks
1123. Which of the following control structures is used in every program?
Sequence
1124. In the c language, a string is assigned to the
Char type of variable
1125. A derived class may also be called a
Subclass
1126. The main() function is always
A calling function
1127. Variables that are known only to the function in which they are declared are called _____
Local
1128. In the expression p –> val,p is a(n)
Pointer
1129. In a template function, _____ argument is generic, or parameterized
At least one
1130. Object-oriented programmers primarily focus on _________
Objects and the tasks that must be performed with those objects
1131. You define a structure type globally because
You save many lines of code by not rewriting an identical structure definition in each function that uses it
1132. The standard output stream, which refers to the computer screen, is called
Cout
1133. In c++, you use _____ to perform standard input and output operations
Streams
1134. Values that are used to end loops are referred to as _____ values
Sentinel
1135. Which of the following flowchart symbols represents the if selection structure?
Diamond
1136. Two or more arrays whose elements are related by their position (subscript) in the arrays are called _____ arrays
Parallel
1137. Assume that a program creates and initializes a short integer variable named age and a pointer named ageptr, to which it assigns the address of the age variable. Which of the following statements will assign the number 21 to the age variable?
Age = 21;
*age = 21;
1138. The statement fwrite ( (char*)&objl, sizeof(objl) );
Writes the data in objl to fl
1139. The body of a c++ function is surrounded by _____
Curly brackets
1140. Which of the following type casts will convert an integer variable named amount to a double type?
(double) amount
1141. The loosest type of coupling is
Data coupling
1142. A child class _____ exist if there is no parent class
Cannot
1143. The main difference in operation between an ‘if statement and a ‘while’ statement is the ‘while’ loop body is executed
The body of the ‘while’ statement may be executed many times, the body of the ‘if statements only once
1144. If a class object is thrown with a throw statement, then a subsequent catch block has a usable match if the type of the catch argument is_________
A parent class of the thrown class
1145. The weakest form of cohesion is
Coincidental
1146. The ‘break’ statement is used to exist from
A do loop
A for loop
A switch statement
1147. You have assigned the address of value to the pointer p, which statement will display the value stored in value?
Cout<<*p;
1148. A constructor initialization list is preceded by
A colon
1149. In c++, a function contained within a class is called
A member function
1150. Which of the following statements will create and initialize a feelnfo array named fee?
Feeinfo fee = {0,0};
1151. Which of the following is the scope resolution operator?
->>
1152. If the description of function is “input the quantity, validate that the quantity is greater than 1, subtract 1 from the quantity, and print the quantity,” the function is
Logically cohesive
1153. A function that changes an object’s state belongs to the category of
Mutator functions
1154. Which of the following pairs of identifier name(s) are(is) considered to be identical?
Identifier 1, identifier_2
1155. When you create a derived class and instantiate on object
The parent class object must be constructed first
1156. The int type of constants are whole numbers in the range
– 32768 to 32767
1157. When the function char somefunction(int x) is executed,
It may or may not throw anything
1158. One way in which a structure differs from an array is that
A structure may have members of more than one type
1159. Variables that hold memory addresses are called _____
Pointers
1160. The general form of do-while statement is
Do statement while (expression);
1161. The measure of how well the operations in a function relate to one another is _____
Cohesion
1162. If you want to override constructor default values for an object you are instantiating, you must also override
All parameters to the left of that value
Can have only positive values
1163. The extraction operator >> is a(n) _____
Overloaded function
Functions
1164. If an exception is thrown and no catch block matches the type of the thrown parameter, then _____
The program terminates
1165. The comma operator (,) is used to
Permit two different expressions to appear in situations where only one expression would ordinarily be used
1166. A function that is called automatically each time an object is created is a(n)
Constructor
1167. Which of the following statements creates a named constant called driverage whose value is 16?
Const short driverage = 16;
1168. Which functions do not have a this pointer?
Static functions
1169. When a program calls a function that has default parameters, if you omit an argument, you must _____
Omit all arguments to the right of that argument
1170. Each generic type in a template function definition is preceded by the keyword _________
Template
1171. The declaration section holds
Data members and function prototypes
1172. A derived class _____ override attributes of a parent class
May
1173. In object-oriented terms, an exception may be considered a(n) _____
Message
1174. A(n) _____ is a numeric variable used for counting something
Counter
1175. The element of an array is
A member of an array
1176. When the function void somefunction(int x) throw(char) is executed,_____
It may throw a character
1177. Which of the following is not included in the header of a function?
The name of the program or function that calls the function
1178. If you want only one memory location to be reserved for a class variable, no matter how many objects are instantiated, you should declare the variable as________
Static
1179. The logical not operator represented by is a
Unary operator
1180. When variables refer to attributes of an entity (such as name, address, and phone number of a person), those attributes form a _____
Record
1181. A derived class _____ override attributes of a parent class
May
1182. Which of the following is false?
The function header is considered a c++ statement, so it must end in a semicolon.
1183. A function’s single most important role is to
Help organize a program into conceptual units
1184. The delete operator returns ______ to the operating system
Memory that is no longer needed
1185. The major advantage of data hiding is that _____
Your data will be used correctly
1186. The letter v is a _____
Character literal constant
1187. Separating parts of a program into units that remain unaffected by other parts of a program is the concept known as _____
Encapsulation
1188. Programmer-defined functions can be
Void functions only
1189. A class d can be derived from a class c, which is derived from a class b, which is derived from a class a
True
1190. To use the strcpy function, you must include the _____ header file in your program
String.h
1191. The number of the relational operators in the c language is
Six
1192. Which of the following tells c++ to display numbers with two decimal places?
Setprecision(2)
1193. A function that is called automatically each time an object is destroyed is a
Destructor
1194. We can output text to an object of class ofstream using the insertion operator â« because
The insertion operator is overloaded in ofstream
1195. The operator that allocates new memory is _____
New
1196. A comment
Is a note that can be put into the source code
Is ignored by the compiler. Starts with the /* character pair
1197. Which of the following is(are) valid identifier(s)?
Record_1
1198. The functions go in the _____ section of a class definition
Implementation
1199. You can throw _____
A scalar variable
A constant
A programmer-defined class object
1200. You invoke a function with a function
Call
1201. Which is a good guideline for creating function names?
Avoid the use of digits because they are easily confused with letters
1202. Reserving memory during program execution is known as reserving it
Dynamically
1203. “rohan motors” is a _____
String literal constant
1204. A programming structure that contains data and a pointer to the next object is a
Linked list
1205. A variable declared in a function is called a(n) _____ variable
Local
1206. When you write to a file rather than the screen, you use the c++ class _____
Fstream
1207. Which of the following numerical value(s) is(are) invalid constant(s)?
27512
1208. To use the this pointer with a member function, you _____
Do nothing; it is automatically supplied for you
1209. A function that is prototype as int calculate(int num); may
Receive an integer variable named num from the main() program
1210. A do-while loop contains
Several statements between the do statement and the while statement
1211. The braces that surround the code in a ‘c program
Delimit a section of code
1212. The indirection operator is the
Asterisk
1213. Local variables _____are created outside a block
Are known only to that block
1214. # directives must be present
Before the main() function
1215. Programmers prefer to declare almost all variables _____
At the beginning of each function
1216. A(n) _____ is always incremented by a constant amount, whereas a(n) _____ is incremented by an amount that varies
Counter, accumulator
1217. The c++ _____ function generates random numbers
Srand
1218. You have declared an integer pointer called point you have also declared an integer called number. Which statement is the correct format?
Point = &number;
1219. If you wanted to sort many large objects or structures, it would be most efficient to
Place pointers to them in an array and sort the array
1220. The printer can be accessed using the predefined filename _____
Prn, lpt1, etc
1221. The best functions have _____
High cohesion and loose coupling
1222. One of the valid escape sequences used in the c language is
\t
1223. A default constructor
Takes no arguments
1224. Which of the following will increase the value stored in the first element of the fee array by 2?
Fee[0].amount = fee[0].amount + 2;
1225. Which loop always processes its instructions at least once?
Do-while
1226. When a new class is derived from an existing class, the derived class member functions _____ have names that differ from base class function names
May
1227. A static data member is given a value
Outside the class definition
1228. _____ refers to the process of locating and removing the errors in a program
Debugging
1229. Static variables are sometimes called
Class variables
1230. You can pass _____ to functions
Copies of individual structure members
Copies of entire structures
Pointers to structures
1231. Element doublearray[7] is which element of the array?
The eighth
1232. Which of the following statements opens a file named temp.dat for output?
Outfile.open(“temp .dat”);
1233. Which of the following will store the letter h in a character variable named initial?
Initial = ‘h’;
1234. Compared with the classes from which they are derived, inherited classes may have _____
Additional data members
Additional member functions
1235. A class named student must have a constructor whose name is
Student
1236. To write data that contains variables of type float, to an object of type ofstream, you should use
Writeq
1237. Variables that are declared in a block are known as _____ variables to that block
Local
1238. The pow and sqrt functions return a(n) _____ type number
Double
1239. Declaring variables is advantageous because it
Avoids errors from misspelled variable names
Helps the linker work efficiently
Simplifies the writing of very short programs
1240. The generic name used for unexpected errors that occur during the execution of a program is
Exceptions
1241. You add the desired type to a specific template class instantiation by placing the type’s name ______
Between angle brackets
1242. The switch variable can be of
Both int as well as char type
1243. Reference variables and const class members _____
Must be initialized, rather than assigned values
1244. You can code a default exception handler by creating a catch block
With an ellipsis as its argument
1245. Which of the following are void functions?
Main
1246. Hiding individual components of an entry is _____
Encapsulation
1247. When all of the operations in a function contribute to the performance of only one task, a function has
Functional cohesion
1248. A function that uses variable types is called __________
A template function
1249. Having more than one function with the same name is called
Overloading
1250. An object is _____
An instance of a class