Database Management System and Design

 SET-1 Questions 1: The ascending order of a data hirerchy is: a. bit-byte-record-field-file- database b. byte-bit-field-reco...

 SET-1

Questions 1:

The ascending order of a data hirerchy is:
a. bit-byte-record-field-file-database
b. byte-bit-field-record-file-database
c. bit-byte-field-record-file-database
d. bit-byte-file-record-field-database
Collection on http://www.cs-mcqs.blogspot.com

Question 2:

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
Collection on http://www.cs-mcqs.blogspot.com

Question 3:

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
Collection on http://www.cs-mcqs.blogspot.com

Question 4:

One data dictionery software package is called
a. DB/DC dictionary
b. TOTAL
c. ACCESS
d. Datapac
e. Data Manager
Collection on http://www.cs-mcqs.blogspot.com

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
Collection on http://www.cs-mcqs.blogspot.com

Question 6:

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
Collection on http://www.cs-mcqs.blogspot.com

Question 7:

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
Collection on http://www.cs-mcqs.blogspot.com

Question 8:

Primitive operations common to all record management system include
a. print
b. sort
c. look-up
d. all of above
Collection on http://www.cs-mcqs.blogspot.com

Question 9:

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
Collection on http://www.cs-mcqs.blogspot.com

Question 10:

Information can be transferred between the DBMS and a
a. spreadsheet program
b. word processor program
c. graphics program
d. all of the above
Collection on http://www.cs-mcqs.blogspot.com


Answers:

1. c    2. b    3. e     4. a     5. c    6. c     7. d    8. c     9. a     10. d

SET-2

Questions 1:

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

Question 2:

Which of the following is not an advantage of the database approach
a. Elimination of data redundancy
b. Ability of associate deleted data
c. increased security
d. program/data independence
e. all of the above 

Question 3:

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. query language
c. data manipulation language
d. transaction log
e. none of the above

Question 4:

In the DBMS approach, application programs perform the 
a. storage function
b. processing functions
c. access control
d. all of the above
e. none of the above

Question 5:

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

Question 6:

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. graphics media
c. multimedia
d. hypertext 

Question 7:

A record management system
a. can handle many files of information at a time
b. can be used to extract information stored in a computer file
c. always uses a list as its model
d. both a and b 

Question 8:

A command that lets you change one or more fields in a record is
a. insert
b. modify
c. lookup
d. none of above 

Question 9:

A transparent DBMS
a. can not hide sensitive information from users
b. keeps its logical structure hidden from users
c. keeps its physical structure hidden from users
d. both b and c 

Question 10:

A file produced by a spreadsheet 
a. is generally stored on disk in an ASCII text fromat
b. can be used as is by the DBMS
c. both a and b
d. none of the above



Answers:

1.b     2.e     3.d      4.b      5.d     6.c      7.b     8.b      9.c      10.a 

SET-3

Questions 1:

Which of the following is not true of the traditional approach to information processing
a. there is common sharing of data among the various applications
b. it is file oriented
c. programs are dependent on the file
d. it is inflexible
e. all of the above are true

Question 2:

Which of the following hardware component is the most important to the operation of database management system?
a. high resolution video display
b. printer
c. high speed, large capacity disk
d. plotter
e. mouse

Question 3:

Generalized database management system do not retrieve data to meet routine request
a. true
b. false

Question 4:

Batch processing is appropriate if
a. large computer system is available
b. only a small computer system is avilbale
c. only a few transactions are involved
d. all of the above
e. none of the above

Question 5:

Large collection of files are called
a. fields
b. records
c. database
d. sectors

Question 6:

Which of the following is not a relational database?
a. dBase IV
b. 4th Dimension
c. FoxPro
d. Reflex

Question 7:

In order to use a record management system 
a. you need to understand the low level details of how information is stored
b. you need to understand the model the record management system uses
c. bother a and b
d. none of the above

Question 8:

Sort/Report generators
a. are faster than index/report generators
b. require more disk space than indexed/report generators
c. do not need to sort before generating report
d. both a and b

Question 9:

If a piece of data is stored in two places in the database, then 
a. storage space is wasted
b. changing the data in one spot will cause data inconsistency
c. in can be more easily accessed
d. both and b

Question 10:

An audit trail
a. is used to make backup copies
b. is the recorded history of operations performed on a file
c. can be used to restore lost information
d. none of the aobve



Answers:

1.a     2.c     3. b     4.e      5.c     6.d      7.b      8.b      9.d      10.b 


SET-4

Questions 1:

The relational database environment has all of the following components except
a. users
b. separate files
c. database
d. query languages
e. database

Question 2:

Database management systems are intended to 
a. eliminate data redundancy
b. establish relationship among records in different files
c. manage file access
d. maintain data integrity
e. all of the above 

Question 3:

One approach to standardization storing of data?
a. MIS
b. structured programming
c. CODASYL specification
d. none of the above

Question 4:

The language used application programs to request data from the DBMS is
referred to as the
a. DML
b. DDL
c. query language
d. any of the above
e. none of the above

Question 5:

The highest  level in the hierarchy of data organization is called
a. data bank
b. data base
c. data file
d. data record

Question 6:

Choose the RDBMS which supports full fledged client server application development
a. dBase V
b. Oracle 7.1
c. FoxPro 2.1
d. Ingress

Question 7:

Report generators are used to 
a. store data input by a user
b. retrieve information from files
c. answer queries
d. both b and c

Question 8:

A form defined 
a. where data is placed on the screen
b. the width of each field
c. both a and b
d. none of the above

Question 9:

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

Question 10:

The management information system (MIS) structure with one main computer
system is called a
a. hierarchical MIS structure
b. distributed MIS structure
c. centralized MIS structure
d. decentralized MIS structure



Answers:

1.b     2.e     3.c      4.a      5.b     6. b     7.d     8.a      9.a      10.c 



COMMENTS

BLOGGER: 2

TECH$type=three$author=hide

Name

5G Technology,1,Abbreviations,2,Agent AI,1,Agentic Ai,1,AI in Education,1,AI in Healthcare,1,AI in surgery,1,AI Reasoning,1,Algorithm,1,Algorithms,4,android,2,Artemis Mission,1,Artificial Intelligence,5,Artificial Intelligence AI,2,Artificial Neural Networks,1,ASCI and UNI),1,Augmented Reality,1,Automata,3,Blockchain,1,Blockchain Technology,1,C Language,2,C Programming,1,c#,1,C++,2,C++ Programming,1,CakePhp,1,Carbon Neutrality,1,CCNA,1,Cellular Communication,1,Chatgpt,1,Cloud Computing,4,Compiler Construction,1,Compiler Construction Solved MCQs,1,Compiler Design,1,Computer,18,Computer Applications,1,Computer Architecture,3,Computer Arithmetics,1,Computer Basics,1,Computer Codes (BCD,1,Computer Fundamentals,5,Computer Graphics,4,Computer Networking,2,Computer Networks,4,Computer Organization,1,Computer Science,2,Computer Short Cut Keys,1,Computer Short Keys,1,CPU Sceduling,1,Cryptocurrency,1,CSS,1,CSS PMS,1,Current Trends and Technologies,1,Custom Hardware,1,Cyber Security,6,Cybercrimes,1,DALL-E,1,Data Communication,1,Data Privacy,1,Data structures,3,Database Management System,4,DBMS,4,Deadlock,1,DeepSeek,1,Digital Systems,1,Digital Systems Solved MCQs - Part 2,1,Discrete Mathematics,2,Discrete Structure,1,dot Net,1,EBCDIC,1,Edge Computing,2,English,1,Ethical AI and Bias,1,Ethics,1,Explainable AI (XAI),1,File System,1,Flowcharts,1,General Data Protection Regulation GDPR,1,General Knowledge,1,Generative AI,2,Gig Economy,1,Graphics Designing,1,Helping Materials,1,HTML,1,HTML 5,1,hybrid work model,1,Inference Optimization,1,Information Systems,1,Information Technology,1,Inpage,1,intelligence,1,Internet,1,Internet Basics,1,Internet of Things,1,Internet of things IOT,2,IT,1,JavaScript,1,jQuery,1,Language,11,Languages Processor,1,Languge,1,Li-Fi,1,Linux/Unix,2,Magento,1,Memory Management,1,Microprocessor,1,Microsoft PowerPoint,1,MidJourney,1,mindfulness apps,1,MS Access,1,MS DOS,1,MS Excel,1,MS Word,2,Multimodal AI,1,NASA,1,Number System,1,Object Oriented Programming (OOP),1,Object Oriented Programming(OOP),1,Operating System,9,Operating System Basics,1,oracle,2,Others,1,Pakistan,1,PCS,1,PHP,1,PMS,1,Process Management,2,Programming,3,Programming Languages,1,Python,2,python language,1,Quantitative Aptitude,2,Quantum Computing,2,R Programming,1,Ransomware,1,Robotic Process Automation RPA,1,Robotics,2,Ruby Language,1,search engine optimization,1,Semester III,2,seo,1,Sloved MCQs on Microsoft Power Point - updated,1,Software Engineering,3,Solved MCQs of MS Access - Updated,1,Solved MCQs on Computer Fundamentals,1,SpaceX Starship,1,SQL,1,System Analysis and Design,1,Theory of Computation,1,Trends and Technologies,1,Virtual Reality,1,web,1,web Fundamental,1,Web Technologies,2,Web3,1,WEB3 Technology,1,x8086,1,zoology,1,
ltr
item
COMPUTER SCIENCE SOLVED MCQS: Database Management System and Design
Database Management System and Design
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8oyS4jPn6NuAGYzIrDDGedQs4CcuhqSd1KENV4qKZQUCW4y7HARgVLPWgl6CR4sF35VAb8jV75qHQJYZxRQfdS6V5UgvIdq-NeEKOHCC64STxSDTQ-ElN2gknvLuQk0lsDTeOLs_SQP8/s200/dbms.png
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8oyS4jPn6NuAGYzIrDDGedQs4CcuhqSd1KENV4qKZQUCW4y7HARgVLPWgl6CR4sF35VAb8jV75qHQJYZxRQfdS6V5UgvIdq-NeEKOHCC64STxSDTQ-ElN2gknvLuQk0lsDTeOLs_SQP8/s72-c/dbms.png
COMPUTER SCIENCE SOLVED MCQS
https://cs-mcqs.blogspot.com/2012/06/database-management-system-and-design.html
https://cs-mcqs.blogspot.com/
https://cs-mcqs.blogspot.com/
https://cs-mcqs.blogspot.com/2012/06/database-management-system-and-design.html
true
1616963833964386058
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content