MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Program interface which provides feature to client side programs to call 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 | |
| 2. |
Objects in database description is called |
| A. | Concept construct |
| B. | Entity construct |
| C. | Schema construct |
| D. | Attribution construct |
| Answer» D. Attribution construct | |
| 3. |
Collection of all 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 | |
| 4. |
In two-tier client server architecture, functions of transaction server and query server are controlled by |
| A. | Server side |
| B. | Host side |
| C. | Modulation side |
| D. | Client side |
| Answer» B. Host side | |
| 5. |
Data model, access path and number of users of database management system are criteria for |
| A. | Logical phase basis of DBMS |
| B. | Classification basis of DBMS |
| C. | Data cycle basis of DBMS |
| D. | Transaction phase basis of DBMS |
| Answer» C. Data cycle basis of DBMS | |
| 6. |
Computing model in which large number of printers, PCs, Web servers and database servers are connected to each other with 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 | |
| 7. |
Type of database management system in which all 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 | |
| 8. |
In a database of company, if employees are classified as entity then name of employees is called |
| A. | Logical entity detail |
| B. | Abstract detail |
| C. | Attribute |
| D. | Entity detail |
| Answer» D. Entity detail | |
| 9. |
All information about usage standards, decision of designs, user information and description of application programs is stored in |
| A. | Data repository |
| B. | Data utility |
| C. | Data compiler |
| D. | Data host |
| Answer» B. Data utility | |
| 10. |
In Three-Schema Architecture, schema which gives description about physical data model, access path and details of storage of data is called |
| A. | Logical schema |
| B. | Conceptual schema |
| C. | Internal schema |
| D. | External schema |
| Answer» D. External schema | |
| 11. |
Local concurrency control, storage of data on disk pages and buffering of disk pages are considered as tasks of |
| A. | Client level |
| B. | Server level |
| C. | Open programming level |
| D. | Database connectivity level |
| Answer» C. Open programming level | |
| 12. |
Features which allows users to update database and specifying retrievals are part of |
| A. | Basic set of operations |
| B. | Basic set of design |
| C. | Basic set of modules |
| D. | Basic set of instructions |
| Answer» B. Basic set of design | |
| 13. |
In network model, one to many relationship is denoted by |
| A. | 1:N |
| B. | 1:M |
| C. | 2:M |
| D. | 3:M |
| Answer» B. 1:M | |
| 14. |
High level query language used in relational database is considered as |
| A. | SQL |
| B. | SQT |
| C. | SQR |
| D. | ODBC |
| Answer» B. SQT | |
| 15. |
Standard used popularly for interchanging data over internet is classified as |
| A. | Extended markup language model |
| B. | Markup model |
| C. | Network markup model |
| D. | Functional markup language |
| Answer» B. Markup model | |
| 16. |
Data model which uses concepts such as attributes, relationships and entities is classified as |
| A. | Conceptual data model |
| B. | Representative data models |
| C. | Graphical data models |
| D. | Occasional data models |
| Answer» B. Representative data models | |
| 17. |
Language used to insert, delete, modify and retrieve data in DBMS is considered as |
| A. | Logical path language |
| B. | External mapping language |
| C. | Data manipulation language |
| D. | Internal mapping language |
| Answer» D. Internal mapping language | |
| 18. |
Machines which works as interface to use file servers, Web servers and printer servers are classified as |
| A. | Host machines |
| B. | Client machines |
| C. | Linking machines |
| D. | Transforming machines |
| Answer» C. Linking machines | |
| 19. |
In categories of data modeling, 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 | |
| 20. |
In database management system, current set of instance or database snapshot is also called |
| A. | Mathematical operators of schema |
| B. | Logical operators of schema |
| C. | Extension of schema |
| D. | Intension of schema |
| Answer» D. Intension of schema | |
| 21. |
In Three-Schema Architecture, schema in which part of database is described to 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. | |
| 22. |
If high level data manipulation language is used in standalone interface manner then this language is considered as |
| A. | Host language |
| B. | Sublanguage |
| C. | Query language |
| D. | Scheming language |
| Answer» D. Scheming language | |
| 23. |
DBMS in which systems involved are coupled together while having local autonomy is classified as |
| A. | Single usage DBMS |
| B. | Non-classical DBMS |
| C. | Classical DBMS |
| D. | Federated DBMS |
| Answer» E. | |
| 24. |
In data modeling, data constraints, data relationships and data types for stored data are classified as |
| A. | Logical design of database |
| B. | Structure of database |
| C. | Server module of database |
| D. | Client module of database |
| Answer» C. Server module of database | |
| 25. |
Types of database system utilities are |
| A. | Backup utility |
| B. | Performance monitoring utility |
| C. | Loading utility |
| D. | All of above |
| Answer» E. | |
| 26. |
In database management system, CAD is an abbreviation of |
| A. | Client devices access |
| B. | Compiler display application |
| C. | Control display application |
| D. | Computer aided design |
| Answer» E. | |
| 27. |
Same class objects are arranged and organized in a way called |
| A. | Acyclic structures |
| B. | Hierarchies |
| C. | Acyclic graphs |
| D. | Both b and c |
| Answer» E. | |
| 28. |
Type of legacy data model in which related records are represented by each hierarchy in tree structure is classified as |
| A. | Network relational models |
| B. | Legacy network model |
| C. | Hierarchy models |
| D. | Network model |
| Answer» D. Network model | |
| 29. |
Form of data model which focuses concepts in same way as data stored in computer system is classified as |
| A. | Low level data models |
| B. | High level data models |
| C. | Dynamic data models |
| D. | Medium level data models |
| Answer» B. High level data models | |
| 30. |
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. | |
| 31. |
Type of server in two-tier architectures which provides data to client stored on disk pages is called |
| A. | Transaction server |
| B. | Functional server |
| C. | Disk server |
| D. | Data server |
| Answer» E. | |
| 32. |
In categories of data modeling, low level data models are also called |
| A. | Conceptual data models |
| B. | Physical data models |
| C. | Triggered data models |
| D. | Logical data models |
| Answer» C. Triggered data models | |
| 33. |
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. | |
| 34. |
Non-procedural language and procedural language are classified as types of |
| A. | Data manipulation language |
| B. | Internal mapping language |
| C. | Logical path language |
| D. | External mapping language |
| Answer» B. Internal mapping language | |
| 35. |
In DBMS, record-at-a-time manipulation language is also called |
| A. | Low level data manipulation language |
| B. | High level data manipulation language |
| C. | Internal level data manipulation language |
| D. | External level data manipulation language |
| Answer» B. High level data manipulation language | |
| 36. |
Information stored in information repository can be accessed by |
| A. | Client servers |
| B. | Host computers |
| C. | Security managers |
| D. | Database administrators |
| Answer» E. | |
| 37. |
Application program interface in two tier architecture database management system is provided by the |
| A. | Close module connectivity |
| B. | Open module connectivity |
| C. | Close database connectivity |
| D. | Open database connectivity |
| Answer» E. | |
| 38. |
In database management system, term which is used to represent real world concept or object is classified as |
| A. | Entity |
| B. | Attribute |
| C. | Relationship |
| D. | Abstraction |
| Answer» B. Attribute | |
| 39. |
In database management system, module which is designed to be used on workstation and personal computer systems is classified as |
| A. | Local area module |
| B. | Client module |
| C. | Spatial module |
| D. | Wide are module |
| Answer» C. Spatial module | |
| 40. |
Module of database management system which controls access to database stored on disk is considered as |
| A. | Schema data manager |
| B. | Disk data manager |
| C. | Host data manager |
| D. | Stored data manager |
| Answer» E. | |
| 41. |
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 | |
| 42. |
Process of converting requests into results between three-schema architecture internal, external and conceptual levels is called |
| A. | Mapping |
| B. | Pitching |
| C. | Transforming |
| D. | Dependence |
| Answer» B. Pitching | |
| 43. |
Compiler which pull out commands written in host programming language from application program is classified as |
| A. | Graphic compiler |
| B. | Host compiler |
| C. | Precompiled |
| D. | Interface compiler |
| Answer» D. Interface compiler | |
| 44. |
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. | |
| 45. |
For a three-schema architecture, there is strict partition between external, internal and conceptual level and language used in this structure is |
| A. | View definition language |
| B. | Logic map language |
| C. | Concept mapping language |
| D. | Storage mapping language |
| Answer» B. Logic map language | |
| 46. |
User interface which uses both menus technique and forms is classified as |
| A. | Defined user interface |
| B. | Host user interface |
| C. | Query user interface |
| D. | Graphical user interface |
| Answer» E. | |
| 47. |
Feature of database management which makes it effortless to find any particular record from collection is called |
| A. | Structural path |
| B. | Entity path |
| C. | Attribute path |
| D. | Access path |
| Answer» E. | |
| 48. |
If there is separation between conceptual and internal levels then language used by database designers is |
| A. | Internal mapping language |
| B. | External mapping language |
| C. | Data definition language |
| D. | Storage definition language |
| Answer» E. | |
| 49. |
Predefined procedures to specify operations for each class is called |
| A. | Methods |
| B. | Hierarchy |
| C. | Behavior cycle |
| D. | Multi hierarchy |
| Answer» B. Hierarchy | |
| 50. |
Standard which allows access to DBMS by Java client programs is classified as |
| A. | JCBD standard |
| B. | JDBC standard |
| C. | BDJC standard |
| D. | CJBD standard |
| Answer» C. BDJC standard | |