Data Base Management System
Paper 1
Questions and Answers
- 1.
What is the language used by most of the DBMSs for helping their users to access data?
- A.
High level language
- B.
SQL
- C.
Query Language
- D.
4GL
Correct Answer
C. Query LanguageExplanation
Most DBMSs use Query Language to help their users access data. Query Language is specifically designed for managing and manipulating data in a database. It allows users to retrieve, insert, update, and delete data using simple and standardized commands. SQL (Structured Query Language) is the most commonly used Query Language in DBMSs. It provides a set of commands and syntax that enable users to interact with the database, making it easier to retrieve and manipulate data efficiently. Therefore, Query Language is the correct answer for this question.Rate this question:
-
- 2.
Which of the following is a problem of file management system?
- A.
Difficult to update
- B.
Lack of data independence
- C.
Data redundancy
- D.
program dependence
- E.
All of above
Correct Answer
E. All of aboveExplanation
All of the options mentioned (difficult to update, lack of data independence, data redundancy, program dependence) are problems commonly associated with file management systems. File management systems often make it difficult to update files, as they may require manual intervention or lack efficient methods for modifying data. Lack of data independence refers to the reliance on specific file formats or structures, making it challenging to access or use the data in different systems. Data redundancy occurs when the same data is stored multiple times, leading to wasted storage space and potential inconsistencies. Program dependence means that applications are tightly coupled with the file management system, making it difficult to switch or upgrade systems without significant changes to the programs.Rate this question:
-
- 3.
Which of the following is true of a network structure?
- A.
t is a physical representation of the data
- B.
It allows a many-to-many relationship
- C.
It is conceptually simple
- D.
It will be dominant data base of the future
Correct Answer
B. It allows a many-to-many relationshipExplanation
A network structure allows a many-to-many relationship. This means that multiple entities can be connected to multiple other entities. Unlike other structures, such as hierarchical or relational structures, a network structure allows for more complex and flexible relationships between data elements. This makes it suitable for representing interconnected data in various domains, such as social networks or supply chains.Rate this question:
-
- 4.
One data dictionery software package is called
- A.
DB/DC dictionary
- B.
TOTAL
- C.
ACCESS
- D.
Data Manager
- E.
Datapac
Correct Answer
A. DB/DC dictionaryExplanation
The correct answer is DB/DC dictionary. This software package is commonly used as a data dictionary, which is a centralized repository for storing and managing metadata about data elements in a database system. The term "DB/DC" refers to Database/Data Communications, indicating that the software is designed to handle both database management and data communication functionalities. It helps in organizing and documenting data structures, relationships, and definitions, making it easier for users to understand and work with the database system.Rate this question:
-
- 5.
The function of a database is
- A.
To check all input data
- B.
To check all spelling
- C.
To collect and organize input data
- D.
To output data
Correct Answer
C. To collect and organize input dataExplanation
A database is designed to collect and organize input data. It serves as a structured system that efficiently stores and manages large amounts of data. By organizing the data, a database allows for easy retrieval, manipulation, and analysis. Additionally, it provides a centralized location for storing data, ensuring data integrity and consistency. Therefore, the function of a database is to collect and organize input data.Rate this question:
-
- 6.
The model for a record management system might be
- A.
Handwritten list
- B.
A Rolodex card file
- C.
A business form
- D.
All of above
Correct Answer
D. All of aboveExplanation
The model for a record management system can include a handwritten list, a Rolodex card file, and a business form. These different options represent various ways of organizing and storing records. A handwritten list can be a simple and accessible method, while a Rolodex card file allows for easy sorting and retrieval of information. A business form provides a structured template for recording data. Therefore, all of the mentioned options can be used as models for a record management system.Rate this question:
-
- 7.
Primitive operations common to all record management system include
- A.
Print
- B.
Sort
- C.
Look-up
- D.
All of above
Correct Answer
C. Look-upExplanation
The correct answer is "look-up" because this is a common operation in all record management systems. Look-up refers to the process of searching for a specific record or piece of information within a database or record system. It allows users to retrieve data based on certain criteria or keywords, making it an essential operation in managing records effectively.Rate this question:
-
- 8.
In a large DBMS
- A.
Each user can "see" only a small part of the entire database
- B.
Each subschema contains every field in the logical schema
- C.
Each user can access every subschema
- D.
All of the above
Correct Answer
A. Each user can "see" only a small part of the entire databaseExplanation
In a large DBMS, each user can "see" only a small part of the entire database. This means that each user is given access to a specific portion or subset of the database, rather than having access to the entire database. This is done to ensure data security and privacy, as well as to improve performance by distributing the workload among different users. By limiting each user's visibility to only a small part of the database, the system can control and manage the access rights and permissions for each user effectively.Rate this question:
-
- 9.
Which of the following fields in a student file can be used as a primary key?
- A.
Class
- B.
Social Security Number
- C.
GPA
- D.
Major
Correct Answer
B. Social Security NumberExplanation
The Social Security Number can be used as a primary key in a student file because it is a unique identifier for each individual. A primary key is a field or combination of fields that uniquely identifies each record in a database table. Since each student has a unique Social Security Number, it can be used as a primary key to ensure that each record in the student file is distinct and can be easily identified.Rate this question:
-
- 10.
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
- A.
Report writer
- B.
Data manipulation language
- C.
Transaction log
- D.
Query language
Correct Answer
C. Transaction logExplanation
A transaction log is a file that contains a complete record of all activity that affected the contents of a database during a certain period of time. It is used to track and record changes made to the database, such as insertions, updates, and deletions. The transaction log is essential for ensuring data integrity and for recovering the database in the event of a failure or error. It provides a detailed audit trail of all database transactions, allowing for analysis and troubleshooting if needed.Rate this question:
-
- 11.
In the DBMS approach, application programs perform the
- A.
Storage function
- B.
Processing functions
- C.
Access control
- D.
None of the above
Correct Answer
B. Processing functionsExplanation
In the DBMS approach, application programs are responsible for performing the processing functions. This includes tasks such as querying the database, manipulating data, generating reports, and executing transactions. The storage function, on the other hand, is handled by the DBMS itself, which manages the physical storage of data on disk or in memory. Access control, on the other hand, is the responsibility of the DBMS as well, as it ensures that only authorized users can access and modify the data. Therefore, the correct answer is processing functions.Rate this question:
-
- 12.
A set of programs that handle a firm's database responsibilities is called
- A.
Database management system (DBMS)
- B.
Database processing system (DBPS)
- C.
Data management system (DMS)
- D.
All of above
Correct Answer
D. All of aboveExplanation
The correct answer is "all of above". This means that all three options mentioned - database management system (DBMS), database processing system (DBPS), and data management system (DMS) - are correct terms used to describe a set of programs that handle a firm's database responsibilities.Rate this question:
-
- 13.
Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
- A.
Full media
- B.
Multimedia
- C.
Graphics media
- D.
Hypertext
Correct Answer
B. MultimediaExplanation
The correct answer is "multimedia". This term refers to a database management system that is capable of handling various types of data, including full text, images, audio, and video. It allows for the storage, retrieval, and manipulation of different media formats within a single system.Rate this question:
-
- 14.
A record management system
- A.
Can be used to extract information stored in a computer file
- B.
Always uses a list as its model
- C.
Can handle many files of information at a time
- D.
Both a and b
Correct Answer
A. Can be used to extract information stored in a computer fileExplanation
A record management system is designed to organize and store information in computer files. It provides a mechanism to extract or retrieve specific information from these files when needed. Therefore, it can be used to extract information stored in a computer file. The other options mentioned in the question, such as always using a list as its model or being able to handle many files of information at a time, are not necessarily true for all record management systems.Rate this question:
-
- 15.
A command that lets you change one or more fields in a record is
- A.
Lookup
- B.
Insert
- C.
Delete
- D.
Modify
Correct Answer
D. ModifyExplanation
The correct answer is "modify" because the command "modify" allows you to change one or more fields in a record. This command is commonly used in database management systems to update or alter the data stored in a specific record. By using the "modify" command, you can make changes to the existing values of fields within a record without needing to delete or insert a new record.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 17, 2012Quiz Created by
Imac2013
- Account Management Quizzes
- Business Management Quizzes
- Classification Quizzes
- Conflict Management Quizzes
- Coordination Quizzes
- Document Management System Quizzes
- ERP Quizzes
- Event Management Quizzes
- File Management Quizzes
- Financial Management Quizzes
- Integrated Solid Waste Management Quizzes
- Operation Management Quizzes
- Principles Of Management Quizzes
- Principles Of Supervision Quizzes
- Process Management Quizzes
- Procurement Quizzes
- Product Management Quizzes
- Property Management Quizzes
- QMS Quizzes
- Quality Management Quizzes
- Resource Management Quizzes
- Responsibility Quizzes
- Risk Management Quizzes
- Scope Management Quizzes
- Security Management Quizzes
- Strategic Management Quizzes
- Supervisory Management Quizzes
- Time Management Quizzes
Back to top