DBMS Software (MS-Access) MCQs > FREE SET - 4

	1. Administrate supervision of database activities is the responsibility of the
	A Database administrator B DP Manager C DB Manager D DP administration Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	2. Which of the following is not a logical data-base structure?
	A tree B relational C network D chain Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	3. Which of the following is a database administrator's function?
	A Database design B Backing up the database C Performance monitoring D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	4. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
	A record B field C file D data item Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	5. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
	A Specialized file B Log file C Master file D Update file Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	6. Data security threats include
	A hardware failure B privacy invasion C fraudulent manipulation of data D All of the above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	7. Which of the following is not characteristic of a relational database model?
	A tables B treelike structure C complex logical relationships D records Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	8. Long-range planning report produced in an MIS are primarily designed for
	A top management B middle management C lower management D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	9. One data dictionary software package is called
	A DB/DC dictionary B TOTAL C ACCESS D any of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	10. A form can be used to
	A modify records B delete records C format printed output D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	11. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
	A a tree file B an indexed file C a hashed file D a sequential file Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	12. Goals for the design of the logical schema include
	A avoiding data inconsistency B being able to construct queries easily C being able to access data efficiently D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	13. A report generator is used to
	A update files B print files on paper C data entry D All of the above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	14. The files stored on a secondary storage device are composed of a hierarchy of data. What does a record in a file contain?
	A Bits B Characters C Data field D Schema Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	15. A file produced by a spreadsheet
	A is generally stored on disk in an ASCII text format B can be used as it by the DBMS C can be used for graphic D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	16. What name is given to the collection of facts, items of information or data which are related in some way?
	A Database B Directory information C Information tree D Information provider Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	17. In a large DBMS
	A each user can "see" only a small part of the entire database B each user can access every sub schema C each subschema contains every field in the logical schema D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	18. A computer file contains several records. What does each record contain?
	A Bytes B Words C Fields D Database Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	19. Characteristics of a distributed MIS structure is
	A interactive sharing of the workload B a multiprocessing environment C computers supporting local DP operations D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	20. One approach to standardizing storing of data
	A MIS B structured programming C CODASYL specifications D All of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	21. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
	A Oracle B SQL C dBASE D 4GL Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	22. The master list of an indexed file
	A is sorted in ascending order B contains only a list of keys and record numbers C has a number assigned to each record D None of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	23. Primitive operations common to all record management systems include
	A Print B Sort C Look-up D All of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	24. What is the language used by most of the DBMSs for helping their users to access data?
	A High level language B Query language C SQL D 4GL Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	25. If the record management system allows you to edit values before they are recorded on disk, you can
	A correct spelling changes before they are recorded B change the name of a field C change the width of a field D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	26. In a ________ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
	A Network database B Relational database C Distributed database D Hierarchical database Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	27. Which two files are used during operation of the DBMS?
	A query language and utilities B data manipulation language and query language C data dictionary and transaction log D data dictionary and query language Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	28. The highest level in the hierarchy of data organization is called
	A data bank B database C data file D data record Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	29. In SQL, which command is used to changes data in a table?
	A UPDATE B INSERT C BROWSE D APPEND Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	30. Which command is used to enable/disable/drop an integrity constraint in SQL?
	A DEFINE TABLE B MODIFY TABLE C ALTER TABLE D All of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	31. When performing a look-up operation using a form
	A you enter the search value into the form B you look at each form sequentially until you see the one you want C you type the key in an entry line, and the correct form is displayed D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	32. The model for a record management system might be
	A handwritten list B a Rolodex card file C a business form D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	33. A scheme describes
	A data elements B records and files C record relationships D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	34. Data items grouped together for storage purposes are called a
	A record B title C list D string Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	35. A file that is organized in uniform format is formally referred to as a ________ or a database file.
	A Document B Database C Record D Structured data file Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	36. Data encryption techniques are particularly useful for
	A reducing storage space requirements B improving data integrity C protecting data in data communication systems D All of the above Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	37. In SQL which command is used to remove a stored function from the database?
	A REMOVE FUNCTION B DELETE FUNCTION C DROP FUNCTION D ERASE FUNCTION Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	38. Subschema can be used to
	A create very different, personalized views of the same data B present information in different formats C hide sensitive information by omitting fields from the sub D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	39. Each of data files has a ________ that describe the way the data is stored in the file.
	A File structure B Records C Fields D Database Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	40. Sort/report generators
	A are faster than index/report generators B require more disk space than index/report generators C do not need to sort before generating a report D None of the above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	41. A top-to-bottom relationship among the items in a database is established by a
	A Hierarchical schema B Network schema C Relational schema D All of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	42. Sophisticated report generators can
	A print row-oriented reports B perform arithmetic operations C selectively retrieve and print portions of a list D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	43. The logical data structure with a one-to-many relationship is a :
	A network B tree C chain D relational Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	44. A number of related records that are treated as a unit is called
	A file B field C data D batch Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	45. Which of the following command is used to recompile a stored procedure in SQL?
	A COMPILE PROCEDURE B ALTER PROCEDURE C MODIFY PROCEDURE D None of the above Free MCQs www.sharemcq.com     Answer: Option B Explanation: Available Soon. Workspace View Answer Workspace

---

	46. A race condition occurs when
	A Two concurrent activities interact to cause a processing error B two users of the DBMS are interacting with different files at the same time C both (A) and (B) D None of the above Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	47. If you want your database to include methods, you should use a ________ database.
	A Network B Distributed C Hierarchical D Object-Oriented Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

	48. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
	A File structure B Records C Fields D Database Free MCQs www.sharemcq.com     Answer: Option C Explanation: Available Soon. Workspace View Answer Workspace

---

	49. A ________ means that one record in a particular record type is related to only one record of another record type.
	A One-to-one relationship B One-to-many relationship C Many-to-one relationship D Many-to-many relationship Free MCQs www.sharemcq.com     Answer: Option A Explanation: Available Soon. Workspace View Answer Workspace

---

	50. Which of the following is a serious problem of file management systems?
	A difficult to update B lack of data independence C data redundancy D All of the above Free MCQs www.sharemcq.com     Answer: Option D Explanation: Available Soon. Workspace View Answer Workspace

---

---