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. |
Type of data manipulation language which is embedded in programming and used to retrieve individual objects from database is classified as |
| A. | Procedural language |
| B. | External mapping language |
| C. | Internal mapping language |
| D. | Non procedural language |
| Answer» B. External mapping language | |
| 2. |
Levels in which three schema architecture can be defined includes |
| A. | Internal schema |
| B. | Conceptual schema |
| C. | External schema |
| D. | All of above |
| Answer» E. | |
| 3. |
Type of data independence in which 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 | |
| 4. |
Middle computer system which is accessed to access database server is classified as |
| A. | Host server |
| B. | Application server |
| C. | Database server |
| D. | Client server |
| Answer» C. Database server | |
| 5. |
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 | |
| 6. |
In a particular time, data available in database at specific moment is called |
| A. | Database time interval |
| B. | Database concept |
| C. | Database construct |
| D. | Database state |
| Answer» E. | |
| 7. |
Module of DBMS which focuses on eliminating redundancies, operations reordering and rearrangements is classified as |
| A. | Schema optimizer |
| B. | Query optimizer |
| C. | Interface optimizer |
| D. | Graphical optimizer |
| Answer» C. Interface optimizer | |
| 8. |
In database management system, module which support handling of data search, data access and data storage is classified as |
| A. | Structural module |
| B. | Logical module |
| C. | Client module |
| D. | Server module |
| Answer» E. | |
| 9. |
In two-tier client server architecture, running of application programs and user interface programs is in control of |
| A. | Modulation side |
| B. | Client side |
| C. | Server side |
| D. | Host side |
| Answer» C. Server side | |
| 10. |
Type of application used to store large amount of data regarding scientific experiments is classified as |
| A. | Flexible applications |
| B. | Scientific application |
| C. | Logical application |
| D. | Structural application |
| Answer» C. Logical application | |
| 11. |
Property which states that files of data stored in database management system does not belong to application programs is called |
| A. | Program data dependence |
| B. | Program data dependence |
| C. | Structural independence |
| D. | Conceptual independence |
| Answer» C. Structural independence | |
| 12. |
Process which includes functions such as retrieving particular data with help of specific queries and generating reports of that data is classified as |
| A. | Constructing the database |
| B. | Manipulating the database |
| C. | Retrieving the database |
| D. | Controlling the database |
| Answer» C. Retrieving the database | |
| 13. |
System used by database administrators to specify restrictions of accounts and creation of new accounts is classified as |
| A. | Controlled redundancy subsystem |
| B. | Program dependence subsystem |
| C. | Security and authorization subsystem |
| D. | Program independence subsystem |
| Answer» C. Security and authorization subsystem | |
| 14. |
Type of program which sends queries to database management system for access to database is classified as |
| A. | Application program |
| B. | System program |
| C. | Interactive program |
| D. | Limited access programs |
| Answer» B. System program | |
| 15. |
Software used by database administrators to create new accounts are considered as |
| A. | Standalone creation software |
| B. | Redundancy software |
| C. | Privileged software |
| D. | Occasion software |
| Answer» D. Occasion software | |
| 16. |
State in database management system which satisfies constraints and specified schema structure is classified as |
| A. | Valid state |
| B. | Extension state |
| C. | Intension state |
| D. | Attribution state |
| Answer» B. Extension state | |
| 17. |
Database system which supports majority of concurrent users is classified as |
| A. | Multiuser system |
| B. | Multi-function system |
| C. | Multi transaction system |
| D. | Client and disk server system |
| Answer» B. Multi-function system | |
| 18. |
In three-tier architecture, 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 | |
| 19. |
Software whose main function is to provide access database from remote location with help of work stations, local PCs and computer terminals is called |
| A. | Module software |
| B. | Communications software |
| C. | Host software |
| D. | Client software |
| Answer» C. Host software | |
| 20. |
Form of data model in which concepts provided are useful for end users and are also close to way it is stored in computer system is called |
| A. | Representational data models |
| B. | Implementation data models |
| C. | Clientele data models |
| D. | Both a and b |
| Answer» E. | |
| 21. |
Objects in DBMS belongs to same structure and behaves in same way are considered as |
| A. | Same class objects |
| B. | Different structure objects |
| C. | Behavioral structure objects |
| D. | Classical structure objects |
| Answer» B. Different structure objects | |
| 22. |
In relational database management system, server is classified as |
| A. | SQL server |
| B. | SQT server |
| C. | SQR server |
| D. | ODBC server |
| Answer» B. SQT server | |
| 23. |
Architecture of database in which characteristics such as program insulations, multiple user support and use of catalogs are achieved is classified as |
| A. | Multiple-schema architecture |
| B. | Single-schema architecture |
| C. | Two-schema architecture |
| D. | Three-schema architecture |
| Answer» E. | |
| 24. |
Data communication system and database management system is also considered as |
| A. | DB DC |
| B. | MS DC system |
| C. | BM CS system |
| D. | All of above |
| Answer» E. | |
| 25. |
In database schema, database snapshot is also called |
| A. | Current set of entity |
| B. | Current set of instances |
| C. | Current set of entity |
| D. | Current set of objects |
| Answer» C. Current set of entity | |
| 26. |
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 | |
| 27. |
Behavior which allows 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 | |
| 28. |
Association between two or more entities in a database system is classified as |
| A. | Dynamic association |
| B. | Relationship |
| C. | Network model |
| D. | Record models |
| Answer» C. Network model | |
| 29. |
Popular technique in Web-based user interfaces are |
| A. | Unstructured host manner |
| B. | Pull-down menus |
| C. | Pull-up options |
| D. | Structured host manner |
| Answer» C. Pull-up options | |
| 30. |
Capacity to alter database schema at one level without altering any other schema level is classified as |
| A. | Data mapping |
| B. | Data independence |
| C. | Data dependence |
| D. | Data transformation |
| Answer» C. Data dependence | |
| 31. |
Database management architecture in which there is middle level between database server and client server is classified as |
| A. | Three-tier architecture |
| B. | Two-tier architecture |
| C. | Single-tier architecture |
| D. | Three way DBMS module |
| Answer» B. Two-tier architecture | |
| 32. |
While designing database management system, if performance is main issue to be considered then DBMS designed is called |
| A. | Special purpose DBMS |
| B. | General purpose DBMS |
| C. | Non-classical DBMS |
| D. | Classical DBMS |
| Answer» B. General purpose DBMS | |
| 33. |
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 | |
| 34. |
Type of relational database which incorporate concepts of object database is classified as |
| A. | Functional object system |
| B. | Behavioral relational system |
| C. | Extended relational system |
| D. | Extended objects system |
| Answer» D. Extended objects system | |
| 35. |
In client server architecture, machine that have capability of providing user interface and local processing is called |
| A. | Module |
| B. | Client |
| C. | Server |
| D. | Host |
| Answer» C. Server | |
| 36. |
In DBMS, property of interest which further describes entity is classified as |
| A. | Relationship |
| B. | Abstraction |
| C. | Entity |
| D. | Attribute |
| Answer» E. | |
| 37. |
Type of data manipulation language which is used to describe complex operations in more precise way is classified as |
| A. | Internal mapping language |
| B. | Non procedural language |
| C. | Procedural language |
| D. | External mapping language |
| Answer» C. Procedural language | |
| 38. |
In DBMS, 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. | |
| 39. |
System which schedules inputs or outputs of disk in database is classified as |
| A. | Operating system |
| B. | Host system |
| C. | Client system |
| D. | Structured system |
| Answer» B. Host system | |
| 40. |
Hierarchical models and network models are classified as |
| A. | Non-classical models |
| B. | Legacy data models |
| C. | Classical models |
| D. | Historic models |
| Answer» C. Classical models | |
| 41. |
In Three-Schema Architecture, schema which gives details about data types, constraints and entities is classified as |
| A. | Internal schema |
| B. | External schema |
| C. | Logical schema |
| D. | Conceptual schema |
| Answer» E. | |
| 42. |
In hierarchical structures, 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 | |
| 43. |
In DBMS, description of database in form of schema is also called |
| A. | Extension of schema |
| B. | Intension of schema |
| C. | Mathematical operators of schema |
| D. | Logical operators of schema |
| Answer» C. Mathematical operators of schema | |
| 44. |
In two-tier architecture, server is considered as |
| A. | Host server |
| B. | Client server |
| C. | Transaction server |
| D. | Module server |
| Answer» D. Module server | |