![DBMS gk questions eduhyme](https://eduhyme.com/wp-content/uploads/2021/11/DBMS-gk-questions-eduhyme.jpg)
A database management system (DBMS) is the software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data. Relational database management systems (RDBMS) implement the relational model of tables and relationships.
Also Read:
- DBMS G.K. Multiple Choice Questions With Answers – Part 1
- DBMS G.K. Multiple Choice Questions With Answers – Part 2
Below is the list of DBMS related G.K. Questions:
1. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database ?
- DASD
- FMS
- EMMS
- DBMS
Correct Answer: D
2. a repository for data, usually covering some specific topic is called
- Data acquisition
- Data bank
- Real time
- Database
Correct Answer: B
3. Which command is used to replace ?
- REPLACE
- REPLACE ALL
- Add record from edit menu
- All of above
Correct Answer: C
4. The following part of a database that holds only one type of information :
- Report
- Query
- Record
- Field
Correct Answer: D
5. All of the following terms are related to computerized databases except which one ?
- Search
- Sort
- Field names
- Record grab
Correct Answer: A
6. COPY STRUCTURE command is used to
- copy contents of an active database to a new file
- copy all records of an active database to disk
- copy contents of an active database to disk
- copy structure of an active database to a new file
Correct Answer: D
7. COUNT command’s used to
- count the number of data fields in an active database file
- count the number of data files which are active
- count the records which are updated
- count the number of records in an active database file
Correct Answer: D
8. What is a largest collection of data stored in a computer ? You might use this type of program to keep a record of all the friends in your address book :
- Information Processing
- Spreadsheet
- Operating system
- Database
Correct Answer: D
9. DBMS is
- Collection of data
- Set of programs to access those data
- Set of programs to update those data
- All of the above
Correct Answer: D
10. What did the first Table Analyzer do ?
- Analyze the data in a set of flat files and automatically create a relational
- Provide a graphic way to design relational database
- Automate process of connecting tables to SQL Server
- None of the above
Correct Answer: A
11. The following command is used for sorting :
- List
- Browse
- Index
- Sort
Correct Answer: C
12. The use of integrated collections of database records and files for data storage and processing. The best suitable for answer :
- Database management approach
- DBMS uses
- Database administrator
- Query language
Correct Answer: D
13. The navigation buttons enable you to
- move from record to record in a table or form
- move from page to page in report
- (a) and (b) both
- none of the above
Correct Answer: C
14. The following devices can be used to input data into a database :
- Keyboard, fax roller ball
- Mouse, keyboard, monitor
- Mouse, keyboard, touch screen
- None of the above
Correct Answer: C
15. Which of the following columns cannot be found in the macro design window ?
- Arguments column
- Comment column
- Conditions column
- Actions column
Correct Answer: B
16. This DBMS feature allows users to easily interrogate a database. Select the best correct answer :
- Database management approach
- DBMS uses
- Database administrator
- Query language
Correct Answer: C
17. The_______presents data in a way similar to an excel spreadsheet :
- Datasheet view
- Design view
- Print preview
- Layout preview
Correct Answer: C
18. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
- Relational
- Structural
- Network
- All of the above
Correct Answer: B
19. It is used to build and modify database objects and also to create new queries :
- Datasheet view
- Design view
- Print preview
- Layout preview
Correct Answer: C
20. You can enter data in a table in
- design-view
- datasheet view
- format view
- none of the above
Correct Answer: C
21. Corrupted index file is corrected using
- Modifyindex
- Recreateindex
- Reindex
- None of the above
Correct Answer: C
22. The following statement is not valid about indexing :
- It stores the index fields
- It stores the corresponding record number
- It maintains the alphabetically order
- It duplicate the database file
Correct Answer: D
23. A field that uniquely identifies a record is called a
- Main field
- Header
- Key field
- None of above
Correct Answer: C
24. APPEND command is used to
- add record to the end of active database file and start full screen data entry
- add record to the start of active database file
- add records to the start of active database file and start full screen data entry
- add record to the end of database file
Correct Answer: A
25. DBMS allows you to create, interrogate, and maintain a database,create reports and develop application programs, select the best fit answer :
- Database management approach
- DBBMS uses
- Database administrator
- Query language
Correct Answer: D
26. A repository for data, usually covering specific topic is
- Database
- Data requisition
- Data bank
- Data collection
Correct Answer: C
27 A database that contains tables linked by common fields is called a
- Centralized database
- Flat file database
- Relational database
- None of above
Correct Answer: C
28. Examples of centralized multi-user database are
- Barclays Bank customer accounts
- Supermarket stock control, organ donor database, client database
- Airline reservations and other national global booking systems
- None of above
Correct Answer: C
29. When a customer makes an online hotel booking, the database is updated in
- Batch mode
- Pseudo real-time
- One month
- All of above
Correct Answer: B
30. New records is added using
- Append record from browse menu
- Append record into browse menu
- Add record from edit menu
- All of above
Correct Answer: A
31. The following language used by most of the DBMS for helping their users to access data :
- High level language
- Query language
- SQL
- 4GL
Correct Answer: A
32. It shows the appearance and layout of a report, table or form in order to confirm what will be printed :
- Datasheet view
- Design view
- print preview
- Layout preview
Correct Answer: B
33. Need to see all the information from two tables on one form Insert
- a page break
- a subform
- a linked command button
- none of the above
Correct Answer: B
34. A treelike structure of records in a database. Select the best suitable for answer:
- Hierarchical database structure
- Relational database structure
- Multidimensional database structure
- Sequential database access
Correct Answer: A
35. What’s the best Access object for an invoice you’ll mail to customers ?
- A report
- A form
- A table
- All of the above
Correct Answer: A
36. What is the maximum character field size you can set for a field that has a text data type ?
- 64
- 255
- 512
- All of above
Correct Answer: B
37. Within Table Datasheet view, how can you display associated records from another table ?
- Click the expand indicator (+) next to a record
- Double click the record
- Apply the filter by from command
- None of the above
Correct Answer: A
38. How do you freeze a field a column or field in Microsoft Access ?
- Click anywhere in the column and select Edit > Freeze column from the menu
- Place an ice cube in the column
- Click anywhere in the column and click the freeze button on the toolbar
- Right click the column and select freeze columns from the shortcut menu
Correct Answer: D
39. Which of the following terms refers to the degree to which data in database system are accurate
and correct ?
- Data security
- Data validity
- Data independence
- Data integrity
Correct Answer: D
40. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file ? As
- Tables
- Relations
- Tuple
- Both (a) and (b)
Correct Answer: D
41.A good query system
- can accept English language commands
- allows non-programmers to access information stored in a database
- can be accessed only by data pressing professionals
- both (A) and (B)
Correct Answer: B
42. Users, who store data about real people for marketing purpose must register the data and its potential use with
- The computer misuse controller
- The data protection controller
- HM customs and excise
- None of above
Correct Answer: B
43. Which of the following fields would not make a suitable primary key ?
- A data field
- An invoice number
- An auto number field
- A customer’s social security number
Correct Answer: A
44. A notation for defining the form and structure of data is known as
- Data description language
- Binary language
- Data channels
- Data definition language
Correct Answer: D
45. A data which is not broken down into smaller units,is
- Data element
- Elementary data item
- Data entry
- Database management
Correct Answer: B
46. What is the primary difference between a pivot table report and a cross tab query ?
- A pivot table report can contain sums,counts, and averages while a cross tab query
- You can’t pivot a cross tab query
- A cross tab query lets you group similar items. A pivot table report does not
- None of above
Correct Answer: B
47. A report form
- appears on the computer monitor during data entry
- is used during report generation to format data
- both (a) and (b)
- all of above
Correct Answer: B
48. The data in a record is of the following types :
- four text fields and three numeric fields
- two integer fields and five text fields
- three text fields and four numeric fields
- none of the above
Correct Answer: B
49. RDBMS stands for
- Relational Database Management System
- Relation Data Mobile System
- Right Data Base Management System
- None of the above
Correct Answer: A
50. Pack command is used to
- remove records permanently
- remove records temporarily
- restore records permanently
- restore records temporarily
Correct Answer: A
51. A set of programs that handle firm’s database responsibilities is called a
- Database Management System (DBMS)
- Database Processing System (DBPS)
- Data Management System (DMS)
- All of above
Correct Answer: D
52. Which of the following is not a relational database ?
- dbase IV
- 4th Dimension
- FoxPro
- Reflex
Correct Answer: D
53.Which is used to provide the sight information to the right person at the right time for proper decision making?
- DBMS
- MIS
- ISO
- PSO
Correct Answer: B
54. Dbase-III was developed by
- Dec
- IBM
- Ashton-tate
- All of the above
Correct Answer: C
55. Which access feature do you use to develop applications that host access data on the web ?
- Dynamic web data
- Data access pates
- Html data pages
- None of the above
Correct Answer: B
You may also like:- Code/Decode – Practice Test Questions With Answers
- Common Interview Questions and How to Tackle Them
- Mastering 25 Common Job Interview Questions
- Biology MCQ Quiz Questions with Answers
- [Human Physiology] Gastro-Intestinal Tract – MCQ Questions with Answers
- [Human Physiology] Respiratory System – MCQ Questions with Answers
- [Human Physiology] Cardiovascular System – MCQ Questions with Answers
- [Human Physiology] Nerve and Muscle – MCQ Questions with Answers
- [Human Physiology] Blood – MCQ Questions with Answers
- [Human Physiology] General Physiology – MCQ Questions with Answers