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. |
Package of software that facilitate modeling of database and improved performance of database system is classified as |
| A. | Tools |
| B. | Tool developers |
| C. | Programmers |
| D. | System tools |
| Answer» B. Tool developers | |
| 2. |
Parts of an operation or function must includes |
| A. | Storage capacity |
| B. | Implementation |
| C. | Interface |
| D. | Both a and b |
| Answer» E. | |
| 3. |
Name of operation and type of data of parameters must be included in |
| A. | Interface or signature |
| B. | User friendly signature |
| C. | Conceptual signature |
| D. | Logical signature |
| Answer» B. User friendly signature | |
| 4. |
Function which causes retrieval of any kind of data from database is considered as |
| A. | Key |
| B. | Query |
| C. | Structure |
| D. | Storing cycle |
| Answer» C. Structure | |
| 5. |
Implications of database management approaches includes |
| A. | Flexibility |
| B. | Economies of scale |
| C. | Reduced development time |
| D. | All of theses |
| Answer» E. | |
| 6. |
Applications that are used for weather information or collection of maps for geographical information is classified as |
| A. | Scientific applications |
| B. | Logical applications |
| C. | Tracking applications |
| D. | Spatial applications |
| Answer» E. | |
| 7. |
Group of people whose job description requires updating database, generating reports or using queries is called |
| A. | Casual users |
| B. | Secondary users |
| C. | End users |
| D. | Primary users |
| Answer» D. Primary users | |
| 8. |
One of module in database management system which is responsible for choosing efficient execution plan considering queries is considered as |
| A. | Index and glossary optimization |
| B. | Query processing and optimization |
| C. | Structural optimization |
| D. | Content optimization |
| Answer» C. Structural optimization | |
| 9. |
System which provides active rules to initiate certain actions after meeting specific conditions is classified as |
| A. | Indexed structure system |
| B. | Triggered database system |
| C. | Active database system |
| D. | Graphical business structure |
| Answer» D. Graphical business structure | |
| 10. |
Process of designing new database or designing new application for database which already exists is classified as |
| A. | Storage design analysis |
| B. | Requirement definition |
| C. | Requirement analysis |
| D. | Both a and b |
| Answer» E. | |
| 11. |
Procedure of storing data on a medium of storage which is controlled by database management system is considered as |
| A. | Retrieving the database |
| B. | Controlling the database |
| C. | Constructing the database |
| D. | Manipulating the database |
| Answer» D. Manipulating the database | |
| 12. |
Planning program which consolidates functions of organizations such as sales, marketing, human resources and finance is classified as |
| A. | Enterprise resource planning |
| B. | Structural resource planning |
| C. | Spatial resource planning |
| D. | Logical resource planning |
| Answer» B. Structural resource planning | |
| 13. |
In database management system, business analysts, engineers and scientists are classified as |
| A. | Isolated users |
| B. | Occasional users |
| C. | Sophisticated end users |
| D. | Casual end users |
| Answer» D. Casual end users | |
| 14. |
In database management system, types of data structures used in indexes are |
| A. | Hash data structures |
| B. | Tree data structures |
| C. | Content and glossary structures |
| D. | Both a and b |
| Answer» E. | |
| 15. |
Phase considering documentation of analyzed requirements and can be represented with 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 | |
| 16. |
Application of database management system in air flight seat booking in a way that one seat is accessed by only one clerk for customer reservation is classified as |
| A. | Online transaction processing |
| B. | Offline transaction processing |
| C. | Online logical representation |
| D. | Offline modeling representation |
| Answer» B. Offline transaction processing | |
| 17. |
Person or group of people who is responsible for choosing appropriate structure for data representation and identifying data to be stored is called |
| A. | Database designer |
| B. | Logical structure designer |
| C. | Conceptual structure designer |
| D. | User interface designer |
| Answer» B. Logical structure designer | |
| 18. |
Collection of programs that helps users to create and maintain useful databases according to their need is classified as |
| A. | Processed facts system |
| B. | Traditional data group creation |
| C. | Maintained records |
| D. | Database management system |
| Answer» E. | |
| 19. |
Person who take account of requirements of parametric end users is considered as |
| A. | Execution analyst |
| B. | Occasional analyst |
| C. | System analyst |
| D. | Conceptual analyst |
| Answer» D. Conceptual analyst | |
| 20. |
Person who implements specifications of database programs is considered as |
| A. | Software engineers |
| B. | Application programmers |
| C. | Software developers |
| D. | All of above |
| Answer» E. | |
| 21. |
Problem arises because of incompatibility between data structures of programming language and database management structures is called |
| A. | Structural dependency problem |
| B. | Logical redundancy problem |
| C. | Structural specification problem |
| D. | Impedance mismatch problem |
| Answer» E. | |
| 22. |
Property of DBMS which ensures execution of all operations in transaction or none of operation is executed is classified as |
| A. | Isolation property |
| B. | Atomicity property |
| C. | Online execution property |
| D. | Offline execution property |
| Answer» C. Online execution property | |
| 23. |
Specification given to database management system regarding data whether it is string, integers or special characters is classified as |
| A. | Type of data stored |
| B. | Type of query asked |
| C. | Type of structure developed |
| D. | Sequence of data cycle |
| Answer» B. Type of query asked | |
| 24. |
Users that maintain databases with help of ready made program packages are considered as |
| A. | Standalone users |
| B. | Canned users |
| C. | Conceptual transactions |
| D. | Sophisticated end users |
| Answer» B. Canned users | |
| 25. |
In database management system, executing process or executing program which considers updating or reading of records stored in database is called |
| A. | Conceptualization |
| B. | Execution |
| C. | Implementation |
| D. | Transaction |
| Answer» E. | |
| 26. |
Control feature in database management system which ensures accuracy of data updated by multiple users is classified as |
| A. | Conceptual implementation control |
| B. | Concurrency control |
| C. | Interface modeling control |
| D. | User accessibility control |
| Answer» C. Interface modeling control | |
| 27. |
Structuring of database by specifying types and constraints of data is classified as |
| A. | Defining a database |
| B. | Creating a database |
| C. | Analyzing a database |
| D. | Filtering a database |
| Answer» B. Creating a database | |
| 28. |
Group of employees who are responsible for maintenance running hardware of system is classified as |
| A. | Well being personnel |
| B. | Operators and maintenance personnel |
| C. | System personnel |
| D. | Execution personnel |
| Answer» C. System personnel | |
| 29. |
Database catalog or dictionary defining descriptive information which is stored in database is called |
| A. | Constrained data |
| B. | Metadata |
| C. | Basic data |
| D. | Filtered data |
| Answer» C. Basic data | |
| 30. |
Property of DBMS which ensures whether hundreds of applications are executed, each transaction must be executed in isolation is classified as |
| A. | Online execution property |
| B. | Offline execution property |
| C. | Isolation property |
| D. | Atomicity property |
| Answer» D. Atomicity property | |
| 31. |
Multiple access users and access to database programs simultaneously is considered as |
| A. | Updating the database |
| B. | Protection of database |
| C. | Analysis of database |
| D. | Sharing of database |
| Answer» E. | |
| 32. |
Menu-driven interface of DBMS and forms-style interface of DBMS is classified as |
| A. | Conceptual user interface |
| B. | Controlled user interface |
| C. | Graphical user interface |
| D. | Structural user interface |
| Answer» D. Structural user interface | |
| 33. |
Access to an online purchasing procedures, airline ticket reservation systems and inventory management in local grocery stores are examples of |
| A. | Traditional database applications |
| B. | Record keeping |
| C. | Customer management |
| D. | Customer services |
| Answer» B. Record keeping | |
| 34. |
Systematic collection of data is classified as |
| A. | Customer services |
| B. | Database |
| C. | Updated records |
| D. | Customer data management |
| Answer» C. Updated records | |
| 35. |
Standardized types of database queries and methods of updating database are called |
| A. | Canned transactions |
| B. | Occasional transactions |
| C. | Conceptual transactions |
| Answer» C. Conceptual transactions | |
| 36. |
Type of constraints that specifies uniqueness of data stored in database are considered as |
| A. | Semantics |
| B. | Business rules |
| C. | Controlled rules |
| D. | Structural rules |
| Answer» B. Business rules | |
| 37. |
Collection of known and useful raw facts that has some meaning and can be processed in useful way is classified as |
| A. | Management oriented facts |
| B. | Updated facts |
| C. | Data |
| D. | Recorded facts |
| Answer» D. Recorded facts | |
| 38. |
Usage of operations with help of arguments without considering structure of operation implementation is classified as |
| A. | Program operation independence |
| B. | Program operation dependence |
| C. | Interface implementation independence |
| D. | Program structural independence |
| Answer» B. Program operation dependence | |
| 39. |
Type of application program which controls all task from order processing to customer support functions is classified as |
| A. | Enterprise record management |
| B. | Customer services application |
| C. | Customer relationship management |
| D. | Customer information management |
| Answer» D. Customer information management | |
| 40. |
Users who access database occasionally but need different information every time are classified as |
| A. | Isolated users |
| B. | Occasional users |
| C. | Logical users |
| D. | Casual end users |
| Answer» E. | |
| 41. |
Files used for speedy disk search by providing specialized structures of data are classified as |
| A. | Indexes |
| B. | Glossaries |
| C. | Content specification |
| D. | Listing documents |
| Answer» B. Glossaries | |
| 42. |
Type of function which allows performing additional operations and sending messages to other tables in database program is considered as |
| A. | Trigger |
| B. | Semantics |
| C. | Index |
| D. | Structure |
| Answer» B. Semantics | |
| 43. |
Characteristic of database management system which allows 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 | |
| 44. |
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled TableName, NumberOfColumns and PrimaryKey. You are looking at ________ |
| A. | User data |
| B. | Metadata |
| C. | A report |
| D. | Indexes |
| Answer» C. A report | |
| 45. |
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 | |
| 46. |
If here are no strict separation between internal and conceptual levels, language used by database designer is |
| A. | Data definition language |
| B. | Administering language |
| C. | Management language |
| D. | Mapping language |
| Answer» B. Administering language | |
| 47. |
If commands of data manipulation language are embedded in general programming language then that programming language is called |
| A. | Scheming language |
| B. | Host language |
| C. | Sublanguage |
| D. | Admitting language |
| Answer» C. Sublanguage | |
| 48. |
Type of data independence in which internal schema can be modified without modifying conceptual schema is classified as |
| A. | Logical data independence |
| B. | Physical data independence |
| C. | Conceptual level independence |
| D. | External level independence |
| Answer» C. Conceptual level independence | |
| 49. |
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. | |
| 50. |
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 | |