Database Management System-7

Multiple Choice Questions (MCQs)

Go To pages -> 0/1/2/3/4/5/6/7

1   Which is one of the major important components of the relational database?
    (A)   Query execution
    (B)   Query process
    (C)   Query optimizer
    (D)   Query transaction

2   Which refers to the process of restoring the data that has been stored in a computer?
    (A)   Retrieve
    (B)   Backup
    (C)   Recovery
    (D)   Deadlock

3   Query processing refers to technique of maintaining managing and manipulating data stored within the computer system by using____ queries:
    (A)   DBMS
    (B)   RDBMS
    (C)   SQL
    (D)   None of these

4   How many major stages of query processing:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

5   Which are the major stages of query processing?
    (A)   Query execution
    (B)   Query optimizer
    (C)   Both
    (D)   None

6   In query processor which ordering is related to hash joins by SQL server 7.0:
    (A)   Interesting ordering
    (B)   Index intersection
    (C)   Index joins
    (D)   Parallel queries

7   Which Microsoft SQL server makes selection of the most appropriate index every table even if there are many predicates in the query?
    (A)   Microsoft SQL server6.0
    (B)   Microsoft SQL server6.5
    (C)   Microsoft SQL server7.0
    (D)   Microsoft SQL server7.5

8   Which is implement it to the index intersection in index joins?
    (A)   SQL server6.0
    (B)   SQL server6.5
    (C)   SQL server7.0
    (D)   SQL server7.5

9   Which server can joins the indexes when only multiple indexes combined can cover the query:
    (A)   SQL
    (B)   DBMS
    (C)   RDBMS
    (D)   All of these

10   How many types of disk I/O:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

11   In which is types of I/O disk:
    (A)   Random I/O
    (B)   Sequential I/O
    (C)   Both
    (D)   None

12   Choosing for large and non-indexed tables, specifically for intermediate results can be termed as__________:
    (A)   Hashing
    (B)   Parallelism
    (C)   Disk
    (D)   Deadlock

13   SMP stands for:
    (A)   System multi-processing
    (B)   Server multi-processing
    (C)   Symmetric multi-processing
    (D)   Securing multi-processing

14   Which in the database which is a software component in the RDBMS that carries out analysis of SQL statement for finding the best way for its execution:
    (A)   Query execution
    (B)   Query process
    (C)   Query optimizer
    (D)   Query transaction

15   Which can be defined as the method in which the selected plan is executed at the query optimization stages?
    (A)   Query execution
    (B)   Query process
    (C)   Query optimizer
    (D)   Query transaction

16   Which refers to technique of maintaining, managing and manipulating data store within the computer system by using SQL queries?
    (A)   Query execution
    (B)   Query processing
    (C)   Query optimizer
    (D)   Query transaction

17   Which is the method of processing the plan selected throughout query optimization?
    (A)   Query execution
    (B)   Query process
    (C)   Query optimizer
    (D)   Query transaction

18   Which refers to a property of computer to run several operations simultaneously and possible as computers await response of each other:
    (A)   Concurrency
    (B)   Deadlock
    (C)   Backup
    (D)   Recovery

19   Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
    (A)   Concurrency
    (B)   Deadlock
    (C)   Backup
    (D)   Recovery

20   Which is a duplicate copy of a file program that is stored on a different storage media than the original location?
    (A)   Concurrency
    (B)   Deadlock
    (C)   Backup
    (D)   Recovery

21   Which is duplication of computer operations and routine backups to combat any unforeseen problems?
    (A)   Concurrency
    (B)   Deadlock
    (C)   Backup
    (D)   Recovery

22   Optimization that is basically related to the rewriter module is termed as__________:
    (A)   Semantic query optimization
    (B)   Global query optimization
    (C)   Both
    (D)   None

23   Optimization basically related to the Rewrite module is termed as_______:
    (A)   Semantic query optimization
    (B)   Global query optimization
    (C)   Both
    (D)   None

24   Database security helps organizations to protect data from_____:
    (A)   Internal users
    (B)   External users
    (C)   Non-external users
    (D)   Non internal users

25   Copying files to secondary or specific devices is known as______:
    (A)   Retrieve
    (B)   Backup
    (C)   Recovery
    (D)   Deadlock

26   How many types of recovery control techniques?
    (A)   2
    (B)   3
    (C)   4
    (D)   5

27   Which are types of recovery control techniques?
    (A)   Deferred update
    (B)   Immediate update
    (C)   Both
    (D)   None

28   Analysis of an existing system starts when a customer request for computerizing his ________:
    (A)   Non-computerized operations
    (B)   Computerized operations
    (C)   Relational operation
    (D)   Database operation

29   Which is done by developers is centered on input and output expected by the customer:
    (A)   Requires interaction
    (B)   Analysis of starting
    (C)   Analysis of existing
    (D)   None of these

30   What does a system design include?
    (A)   I/O devices
    (B)   CPU
    (C)   Storage unit
    (D)   All of these

31   Which are used by developers to extrapolate complexities of real world into a computer based model:
    (A)   Data analysis techniques
    (B)   Data analysis model
    (C)   Data structure
    (D)   Data analysis

32   A conceptual data model defines the structure of the data and method or processes that use:
    (A)   File
    (B)   Data
    (C)   Operation
    (D)   Testing

33   Which is the forerunner of data analysis having close link with data visualization and data dissemination?
    (A)   Data analysis model
    (B)   Data structure
    (C)   Data analysis
    (D)   Data integration

34   In preliminary and final designs the design of physical database focuses the way data is physically_____:
    (A)   Delete
    (B)   Start
    (C)   Stored
    (D)   Read

35   Which refers to the process of installing programs/software in a system of information system?
    (A)   Requires interaction
    (B)   Analysis of starting
    (C)   Implementation
    (D)   Testing

36   Which refers to the process of executing new and revised programs to check whether the process and running properly:
    (A)   Maintenance
    (B)   Analysis of starting
    (C)   Implementation
    (D)   Testing

37   Which refers to the proper upkeep of data, hardware, and software and in general of the entire system?
    (A)   Tuning
    (B)   Analysis of starting
    (C)   Implementation
    (D)   Maintenance

38   Which refers to the use of various techniques for the adjustments and change made to help the system work efficiently?
    (A)   Tuning
    (B)   Analysis of starting
    (C)   Implementation
    (D)   All of these

39   Files that require immediate access must be stored on_____:
    (A)   Slow devices
    (B)   Faster devices
    (C)   Medium devices
    (D)   All of these

40   The batch accesses may be stored on slow devices such as________:
    (A)   Optical disk
    (B)   Tape
    (C)   Both
    (D)   None

41   How many types of changeover methods:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

42   How many types of maintenance:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

43   Which are the not a type of maintenance:
    (A)   Corrective
    (B)   Adaptive
    (C)   Perfective
    (D)   None of these

44   Which is conducted for assessing the quality of the system produced by developer for customer?
    (A)   Maintenance
    (B)   Analysis of starting
    (C)   Implementation
    (D)   Testing

45   Which is basically an RDBMS in which object oriented features are implemented?
    (A)   Java
    (B)   C++
    (C)   Oracle
    (D)   DBMS

46   Which was the first commercial RDBMS?
    (A)   MS SQL
    (B)   DB2
    (C)   MY SQL
    (D)   ORACLE

47   In which year RSI introduced oracle V2:
    (A)   1978
    (B)   1979
    (C)   1980
    (D)   1981

48   Which version of oracle, released in 1983:
    (A)   V1
    (B)   V2
    (C)   V3
    (D)   V4

49   Which version of oracle supported multi-version read consistency?
    (A)   V1
    (B)   V2
    (C)   V3
    (D)   V4

50   In which year oracle v5 was released:
    (A)   1977
    (B)   1979
    (C)   1983
    (D)   1985

51   Which version of oracle entered the market with more features?
    (A)   V2
    (B)   V3
    (C)   V5
    (D)   V6

52   Which has enhancements in the input/output operation of disk, scalability, locking of row, backup and recovery?
    (A)   Oracle V6
    (B)   Oracle V5
    (C)   Oracle V3
    (D)   Oracle V4

53   Oracle 8 is an object relational database that was released in:
    (A)   1977
    (B)   1979
    (C)   1983
    (D)   1985

54   V6 of oracle also included the first version for_____:
    (A)   PL
    (B)   SQL
    (C)   Both
    (D)   None

55   Which was introduced stored procedures and triggers in PL/SQL:
    (A)   Oracle V6
    (B)   Oracle V5
    (C)   Oracle V3
    (D)   Oracle V7

56   Version 8i entered the market in______:
    (A)   1979
    (B)   1989
    (C)   1999
    (D)   None of these

57   Which version included RAC that enable multiple instances for accessing a database simultaneously?
    (A)   V2i
    (B)   V4i
    (C)   V6i
    (D)   V9i

58   Oracle 9i was introduced in:
    (A)   1999
    (B)   2000
    (C)   2001
    (D)   2002

59   Oracle database 11g was released in_________:
    (A)   2001
    (B)   2002
    (C)   2006
    (D)   2007

60   The server process contains memory for a private session which is its own and is called_________:
    (A)   SGA
    (B)   PGA
    (C)   Both
    (D)   None

61   Tables and indexes that are data of logical database structure that is stored physically in the form of______:
    (A)   Data files
    (B)   Control files
    (C)   Online redo log files
    (D)   All of these

62   Which files has metadata that specifies database structure that includes database name along with database files names and locations:
    (A)   Data files
    (B)   Control files
    (C)   Online redo log files
    (D)   All of these

63   Which is also known as redo records, recording whatever changes are made to data?
    (A)   Data files
    (B)   Control files
    (C)   Online redo log files
    (D)   All of these

64   The data in oracle database is stored in blocks known as ________:
    (A)   Data blocks
    (B)   Extents
    (C)   Segments
    (D)   Tablespaces

65   Which contains many extents?
    (A)   Data blocks
    (B)   Extents
    (C)   Segments
    (D)   Tablespaces

66   _____ shows a specified number of data blocks that are logically contiguous and keeps a particular type of information in its storage:
    (A)   Data blocks
    (B)   Extents
    (C)   Segments
    (D)   Tablespaces

67   Which are logical storage units contained in a database and a logical container for some segment?
    (A)   Data blocks
    (B)   Extents
    (C)   Segments
    (D)   Tablespaces

68   Which refers to software that can be executed on two or more kinds of computer containing two or more kinds of operating system?
    (A)   Data blocks
    (B)   Extents
    (C)   Segments
    (D)   Portable

69   Which refers to independent events of the main program flow of the systems that lacks concurrency?
    (A)   RDBMS
    (B)   Portable
    (C)   Asynchronously
    (D)   None of these

70   Which is a method provided by an operating system, running in a sequence of steps?
    (A)   Storage
    (B)   Process
    (C)   Computing
    (D)   None of these

71   How many interfaces provided by oracle:
    (A)   1
    (B)   2
    (C)   3
    (D)   4

72   _______refers to the basic facts and entities, such as names and numbers.
    (A)   Data
    (B)   Information
    (C)   Input
    (D)   Output

73   Information is processed from __________
    (A)   Output
    (B)   Data
    (C)   Memory
    (D)   None of these

74   MIS stands for:
    (A)   Management Information Server
    (B)   Management Information Service
    (C)   Management Information System
    (D)   Master Information System

75   Which is the false statement?
    (A)   A database is ordered collection of data.
    (B)   A database is systematic compilation of records in a computer.
    (C)   DBMS manages the database
    (D)   Data helps in making decisions.

76   Which is the data model?
    (A)   Relational
    (B)   Object-Relational
    (C)   Network
    (D)   All of these

77   Which is not the feature of database?
    (A)   Data redundancy
    (B)   Independence
    (C)   Flexibility
    (D)   Data Integrity

78   Which is the type of data independence?
    (A)   Physical data independence
    (B)   Logical data independence
    (C)   Both
    (D)   None of these

79   Which is the feature of database?
    (A)   Query Language
    (B)   Multi user access
    (C)   Data Dictionary
    (D)   All of these

80   Which is the database language?
    (A)   C
    (B)   C++
    (C)   SQL
    (D)   None of these

81   Which person is responsible for overall activities for database?
    (A)   Database designer
    (B)   Database analyst
    (C)   Database Administrator
    (D)   Database manager

82   Which level of database is viewed by user?
    (A)   Internal level
    (B)   External Level
    (C)   Conceptual Level
    (D)   All of these

83   Internal level has:
    (A)   Individual Users View of the database
    (B)   Community view of the database
    (C)   Physical Representation of the database
    (D)   All of these

84   Which is the component of database management system?
    (A)   Query Language
    (B)   Database Manager
    (C)   File manager
    (D)   All of these

85   _____is the structure of the database.
    (A)   Table
    (B)   Relation
    (C)   Schema
    (D)   None of these

86   Schema is usually stored in____________.
    (A)   Tables
    (B)   Data Dictionary
    (C)   Both
    (D)   None of these

87   Schema is defined by:
    (A)   DML
    (B)   DDL
    (C)   DCL
    (D)   DQL

88   DML language is used to:
    (A)   Define schema
    (B)   Define internal level
    (C)   Access Data
    (D)   All of these

89   DBMS is the bridge between operating system and ___________.
    (A)   User
    (B)   Database administrator
    (C)   Application program
    (D)   None of these

90   Which is the most popular database model?
    (A)   Network Model
    (B)   Relational Model
    (C)   Hierarchical Model
    (D)   Object Oriented

91   Which is the schema object?
    (A)   Database links and clusters
    (B)   Packages and Indexes
    (C)   Procedures and functions
    (D)   All of these

92   In database records are called:
    (A)   Attributes
    (B)   Entity
    (C)   Tuples
    (D)   Relations

93   An entity has a set of ___________ that describe it.
    (A)   Attributes
    (B)   Entity
    (C)   Tuples
    (D)   Relations

94   In ER model rectangle represents:
    (A)   Attributes
    (B)   Entity set
    (C)   Relationships
    (D)   None of these

95   Date is the type of attribute:
    (A)   Simple
    (B)   Composite
    (C)   Single values
    (D)   Multi valued

96   __________is the attribute or group of attributes that uniquely identify occurrence of each entity.
    (A)   Foreign key
    (B)   Super Key
    (C)   Primary Key
    (D)   All of these

97   _________is the real world object, such as a person, place etc.
    (A)   Attribute
    (B)   Entity
    (C)   Records
    (D)   All of these

98   Grant and revoke is the type of command:
    (A)   DDL
    (B)   DML
    (C)   DCL
    (D)   DQL

99   A user that manages the files of application in DBMS is called:
    (A)   Administrator
    (B)   Database analyst
    (C)   File Manager
    (D)   None of these

100   ________is the information about data.
    (A)   Data
    (B)   Meta-Data
    (C)   Entity
    (D)   Relations

Go To pages -> 0/1/2/3/4/5/6/7

Back to Top