Database Management System Set 20

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Practice Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 20

Q1 | Each tablespace in an Oracle database consists of one or more files called
  • files
  • name space
  • datafiles
  • pfile
Answer: datafiles
Q2 | The management information system (MIS) structure with one main computer system is called a
  • hierarchical mis structure
  • distributed mis structure
  • centralized mis structure
  • decentralized mis structure
Answer: centralized mis structure
Q3 | Choose the RDBMS which supports full fledged client server application development
  • dbase v
  • oracle 7.1
  • foxpro 2.1
  • ingress
Answer: oracle 7.1
Q4 | One approach to standardization storing of data?
  • mis
  • structured programming
  • codasyl specification
  • none of the mentioned
Answer: codasyl specification
Q5 | The highest level in the hierarchy of data organization is called
  • data bank
  • data base
  • data file
  • data record
Answer: data base
Q6 | An audit trail                        
  • is used to make backup copies
  • is the recorded history of operations performed on a file
  • can be used to restore lost information
  • none of the mentioned
Answer: is the recorded history of operations performed on a file
Q7 | Large collection of files are called
  • fields
  • records
  • database
  • sectors
Answer: database
Q8 | Which of the following is not true of the traditional approach to information processing
  • there is common sharing of data among the various applications
  • it is file oriented
  • programs are dependent on the file
  • it is inflexible
Answer: there is common sharing of data among the various applications
Q9 | The information about data in a database is called                
  • metadata
  • hyper data
  • tera data
  • none of the mentioned
Answer: metadata
Q10 | A data dictionary is a special file that contains?
  • the names of all fields in all files
  • the data types of all fields in all files
  • the widths of all fields in all files
  • all of the mentioned
Answer: all of the mentioned
Q11 | The DBMS acts as an interface between what two components of an enterprise-class database system?
  • database application and the database
  • data and the database
  • the user and the database application
  • database application and sql
Answer: database application and the database
Q12 | A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
  • metadata
  • catalog
  • log
  • dictionary
Answer: metadata
Q13 | Relational schemas and other metadata about relations are stored in a structure called the                          
  • metadata
  • catalog
  • log
  • data dictionary
Answer: data dictionary
Q14 |                        is the collection of memory structures and Oracle background processes that operates against an Oracle database.
  • database
  • instance
  • tablespace
  • segment
Answer: instance
Q15 | A                  is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
  • tablespace
  • segments
  • extents
  • blocks
Answer: tablespace
Q16 | A tablespace is further broken down into
  • tablespace
  • segments
  • extents
  • blocks
Answer: segments
Q17 |                      is a contiguous group of
  • instance
  • segment
  • database
  • dictionary
Answer: database
Q18 |                  is the smallest unit of allocation in an Oracle database.
  • database
  • instance
  • tablespace
  • database block
Answer: database block
Q19 | An Oracle                      is a set of tables and views that are used as a read-only reference about the database.
  • database dictionary
  • dictionary table
  • data dictionary
  • dictionary
Answer: data dictionary
Q20 | The                is that part of main memory available for storage of copies of disk blocks.
  • buffer
  • catalog
  • storage
  • secondary storage
Answer: buffer
Q21 | A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by
  • buffer
  • catalog
  • storage
  • secondary storage
Answer: buffer
Q22 | The subsystem responsible for the allocation of buffer space is called the
  • buffer
  • buffer manager
  • storage
  • secondary storage
Answer: buffer manager
Q23 | In the buffer where there is no space for another block, the block can be inserted using
  • pinned block strategy
  • forced output block
  • buffer replacement strategy
  • all of the mentioned
Answer: buffer replacement strategy
Q24 | Which of these is not a feature of Hierarchical model?
  • organizes the data in tree-like structure
  • parent node can have any number of child nodes
  • root node does not have any parent
  • child node can have any number of parent nodes
Answer: child node can have any number of parent nodes
Q25 | Which of these data models is an extension of the relational data model?
  • object-oriented data model
  • object-relational data model
  • semi structured data model
  • none of the mentioned
Answer: object-relational data model
Previous Next