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),
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
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
Q3 | Choose the RDBMS which supports full fledged client server application development
- dbase v
- oracle 7.1
- foxpro 2.1
- ingress
Q4 | One approach to standardization storing of data?
- mis
- structured programming
- codasyl specification
- none of the mentioned
Q5 | The highest level in the hierarchy of data organization is called
- data bank
- data base
- data file
- data record
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
Q7 | Large collection of files are called
- fields
- records
- database
- sectors
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
Q9 | The information about data in a database is called
- metadata
- hyper data
- tera data
- none of the mentioned
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
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
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
Q13 | Relational schemas and other metadata about relations are stored in a structure called the
- metadata
- catalog
- log
- data dictionary
Q14 | is the collection of memory structures and Oracle background processes that operates against an Oracle database.
- database
- instance
- tablespace
- segment
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
Q16 | A tablespace is further broken down into
- tablespace
- segments
- extents
- blocks
Q17 | is a contiguous group of
- instance
- segment
- database
- dictionary
Q18 | is the smallest unit of allocation in an Oracle database.
- database
- instance
- tablespace
- 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
Q20 | The is that part of main memory available for storage of copies of disk blocks.
- buffer
- catalog
- storage
- secondary storage
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
Q22 | The subsystem responsible for the allocation of buffer space is called the
- buffer
- buffer manager
- storage
- secondary storage
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
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
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