MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 251 Mcqs, each offering curated multiple-choice questions to sharpen your Neural Networks knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
The type data abstraction which allows the conceptual representation of data in database management system is considered as |
| A. | logical design model |
| B. | data model |
| C. | interface model |
| D. | user friendly model |
| Answer» C. interface model | |
| 102. |
The complete description of database which is described in design phase and is changed rarely is called |
| A. | schema |
| B. | structure |
| C. | path of design |
| D. | data cycle scheme |
| Answer» B. structure | |
| 103. |
The type of data model which provide concepts in a way users of data recognize data models is considered as |
| A. | dynamic data models |
| B. | medium level data models |
| C. | low level data models |
| D. | high level data models |
| Answer» E. | |
| 104. |
In the two-tier architecture, the server is considered as |
| A. | host server |
| B. | client server |
| C. | transaction server |
| D. | module server |
| Answer» D. module server | |
| 105. |
In Three-Schema Architecture, the schema in which the part of database is described to the user group who is interested and other details are kept hide is called |
| A. | logical schema |
| B. | conceptual schema |
| C. | internal schema |
| D. | external schema |
| Answer» E. | |
| 106. |
The handling of user interface, data dictionary, concurrency control and global query optimization are tasks of |
| A. | open programming level |
| B. | database connectivity level |
| C. | client level |
| D. | server level |
| Answer» D. server level | |
| 107. |
The Conference on Data Systems Languages Database Task Group is a committee to |
| A. | approve network structure |
| B. | specify network model and language |
| C. | specify names of networks |
| D. | specify structure of networks |
| Answer» C. specify names of networks | |
| 108. |
In categories of data modeling, the high level data models are also called |
| A. | triggered data models |
| B. | logical data models |
| C. | conceptual data models |
| D. | physical data models |
| Answer» D. physical data models | |
| 109. |
In client / server architecture, the machine that have capability of providing user interface and local processing is called |
| A. | module |
| B. | client |
| C. | server |
| D. | host |
| Answer» C. server | |
| 110. |
The type of legacy data model in which data is represented as record types and limited one to many relationships is called |
| A. | network relational models |
| B. | legacy network model |
| C. | hierarchy models |
| D. | network model |
| Answer» E. | |
| 111. |
In DBMS, the property of interest which further describes the entity is classified as |
| A. | relationship |
| B. | abstraction |
| C. | entity |
| D. | attribute |
| Answer» E. | |
| 112. |
The collection of all the concepts that must be used to describe database structure is called |
| A. | structural model |
| B. | server model |
| C. | data model |
| D. | client model |
| Answer» D. client model | |
| 113. |
In the network model, the one to many relationship is denoted by |
| A. | 1:N |
| B. | 1:M |
| C. | 2:M |
| D. | 3:M |
| Answer» B. 1:M | |
| 114. |
In hierarchical structures, the can be nested to create |
| A. | simple data structures |
| B. | complex data structures |
| C. | functional data structures |
| D. | network logical structures |
| Answer» B. complex data structures | |
| 115. |
In DBMS, the set-at-a-time manipulation language is also called |
| A. | internal level data manipulation language |
| B. | external level data manipulation language |
| C. | low level data manipulation language |
| D. | high level data manipulation language |
| Answer» E. | |
| 116. |
The program interface which provides the feature to client side programs to call the database management system is classified as |
| A. | open programming interface |
| B. | closed programming interface |
| C. | application programming interface |
| D. | data programming language |
| Answer» D. data programming language | |
| 117. |
The type of data independence in which the schema can be altered on conceptual level without altering external level is classified as |
| A. | conceptual level independence |
| B. | external level independence |
| C. | logical data independence |
| D. | physical data independence |
| Answer» D. physical data independence | |
| 118. |
If here are no strict separation between internal and conceptual levels, the language used by database designer is |
| A. | data definition language |
| B. | administering language |
| C. | management language |
| D. | mapping language |
| Answer» B. administering language | |
| 119. |
Identify the class name for the following code:ABC123 course(); |
| A. | ABC123 |
| B. | course |
| C. | course() |
| D. | All of the above. |
| Answer» B. course | |
| 120. |
In the three-tier architecture, the intermediate layer between database and client servers is classified as |
| A. | functional server |
| B. | transaction server |
| C. | application server |
| D. | disk server |
| Answer» D. disk server | |
| 121. |
The process of suppression of details regarding storage and data type to highlight important features for better understanding is called |
| A. | data abstraction |
| B. | structural abstraction |
| C. | client abstraction |
| D. | server abstraction |
| Answer» B. structural abstraction | |
| 122. |
The graphical representation of database description is called |
| A. | dynamic schema diagram |
| B. | schema diagram |
| C. | structure diagram |
| D. | entity path diagram |
| Answer» C. structure diagram | |
| 123. |
The concepts of data models that are only useful to computer specialists rather than end users of programs are classified as |
| A. | triggered data models |
| B. | logical data models |
| C. | conceptual data models |
| D. | physical data models |
| Answer» E. | |
| 124. |
Logical Data independence is ability to modify ____________ without causing application program to rewrite. |
| A. | Physical Schema |
| B. | Logical Schema |
| C. | Conceptual Schema |
| D. | None of the above |
| Answer» C. Conceptual Schema | |
| 125. |
Data Models in DBMS are classified into ______ categories. |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 2 |
| Answer» B. 4 | |
| 126. |
Object which is distinguishable from other objects by specific set of attributes is called as ___________. |
| A. | Classes |
| B. | Entity |
| C. | Attributes |
| D. | None of these |
| Answer» C. Attributes | |
| 127. |
Ability to modify schema of database in one level without affecting the schema definition in higher level is called as __________. |
| A. | Data Independence |
| B. | Data Isolation |
| C. | Data Migration |
| D. | Data Abstraction |
| Answer» B. Data Isolation | |
| 128. |
Collection of tables to represent both data and relationship is described by _____________. |
| A. | Relational Model |
| B. | Entity Relation Model |
| C. | Network Model |
| D. | Entity Model |
| Answer» B. Entity Relation Model | |
| 129. |
Data Model is collection of conceptual tools for describing |
| A. | Data |
| B. | Data Schema |
| C. | Consistency Constaints |
| D. | All of these |
| Answer» E. | |
| 130. |
In data abstraction which is lowest level of abstraction ? |
| A. | View Level |
| B. | Physical Level |
| C. | Conceptual Level |
| D. | None of these |
| Answer» C. Conceptual Level | |
| 131. |
Part of entire database is shown by ________ level of abstraction. |
| A. | Conceptual |
| B. | Physical |
| C. | View |
| D. | None of these |
| Answer» D. None of these | |
| 132. |
"What data is stored ?" is described by __________ level of abstraction in DBMS. |
| A. | Physical |
| B. | View |
| C. | Conceptual |
| D. | None of the above |
| Answer» D. None of the above | |
| 133. |
Conceptual design |
| A. | is a documentation technique. |
| B. | needs data volume and processing frequencies to determine the size of the database. |
| C. | involves modelling independent of the DBMS. |
| D. | is designing the relational model. |
| Answer» D. is designing the relational model. | |
| 134. |
The view of total database content is |
| A. | Conceptual view |
| B. | Internal view |
| C. | External view |
| D. | Physical view |
| Answer» B. Internal view | |
| 135. |
A subschema expresses |
| A. | the logical view |
| B. | the physical view |
| C. | the external view |
| D. | all of the above |
| Answer» D. all of the above | |
| 136. |
Architecture of the database can be viewed as |
| A. | two levels |
| B. | four levels |
| C. | three levels |
| D. | one level |
| Answer» D. one level | |
| 137. |
The conceptual model is |
| A. | dependent on hardware |
| B. | dependent on software |
| C. | dependent on both hardware and software |
| D. | independent of both hardware and software |
| Answer» E. | |
| 138. |
The type of database management system in which all the application programs are executed and processes with one machine is classified as |
| A. | limited access DBMS |
| B. | hosted DBMS |
| C. | centralized DBMS |
| D. | decentralized DBMS |
| Answer» D. decentralized DBMS | |
| 139. |
The system which schedules the inputs or outputs of the disk in database is classified as |
| A. | operating system |
| B. | host system |
| C. | client system |
| D. | structured system |
| Answer» B. host system | |
| 140. |
The phase considering documentation of analyzed requirements and can be represented with the help of computerized tools is considered as |
| A. | logical data design |
| B. | storage cycle design |
| C. | conceptual design |
| D. | structural design |
| Answer» D. structural design | |
| 141. |
Association among several entities is called as _____________. |
| A. | Extraction |
| B. | Relationship |
| C. | Combination |
| D. | Association |
| Answer» C. Combination | |
| 142. |
There are _________ levels of data abstraction. |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 1 |
| Answer» C. 4 | |
| 143. |
If user doesn't know anything about the complexity of database application then that user is called as _____________. |
| A. | Naive User |
| B. | Database Manager |
| C. | Database Operator |
| D. | Database Administrator |
| Answer» B. Database Manager | |
| 144. |
The types of architectures of DBMS are |
| A. | single-tier architecture |
| B. | two-tier architecture |
| C. | three-tier architecture |
| D. | both b and c |
| Answer» E. | |
| 145. |
There are _________ levels of data independence. |
| A. | 2 |
| B. | 1 |
| C. | 4 |
| D. | 3 |
| Answer» B. 1 | |
| 146. |
The hierarchical models and network models are considered as types of |
| A. | logical structural models |
| B. | attributed structural models |
| C. | legacy data models |
| D. | entity recording model |
| Answer» D. entity recording model | |
| 147. |
In two-tier client - server architecture, the running of application programs and the user interface programs is in control of |
| A. | modulation side |
| B. | client side |
| C. | server side |
| D. | host side |
| Answer» C. server side | |
| 148. |
The characteristic of database management system which allows the program operation independence and program data independence is classified as |
| A. | conceptual abstraction |
| B. | implementation abstraction |
| C. | data abstraction |
| D. | interface abstraction |
| Answer» D. interface abstraction | |
| 149. |
The computing model in which the large number of printers, PCs, Web servers and database servers are connected to each other with the help of network is classified as |
| A. | client / server architecture |
| B. | host / compiler architecture |
| C. | client / module architecture |
| D. | application / terminal architecture |
| Answer» B. host / compiler architecture | |
| 150. |
The behavior which allows the database designer to specify user defined operations for databases is called |
| A. | dynamic behavior |
| B. | stationary behavior |
| C. | semantic behavior |
| D. | triggered behavior |
| Answer» B. stationary behavior | |