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

(D) Query transaction

[showhide type=”button7c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

2 Which refers to the process of restoring the data that has been stored in a computer?

(A) Retrieve

(B) Backup

(D) Deadlock

[showhide type=”button7c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

3 Query processing refers to technique of maintaining managing and manipulating data stored within the computer system by using____ queries:

(A) DBMS

(B) RDBMS

(D) None of these

[showhide type=”button7c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

4 How many major stages of query processing:

(A) 1

(B) 2

(D) 4

[showhide type=”button7c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

5 Which are the major stages of query processing?

(A) Query execution

(B) Query optimizer

(D) None

[showhide type=”button7c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

6 In query processor which ordering is related to hash joins by SQL server 7.0:

(A) Interesting ordering

(B) Index intersection

(D) Parallel queries

[showhide type=”button7c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(D) Microsoft SQL server7.5

[showhide type=”button7c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

8 Which is implement it to the index intersection in index joins?

(A) SQL server6.0

(B) SQL server6.5

(D) SQL server7.5

[showhide type=”button7c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

9 Which server can joins the indexes when only multiple indexes combined can cover the query:

(A) SQL

(B) DBMS

(D) All of these

[showhide type=”button7c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

10 How many types of disk I/O:

(A) 1

(B) 2

(D) 4

[showhide type=”button7c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

11 In which is types of I/O disk:

(A) Random I/O

(B) Sequential I/O

(D) None

[showhide type=”button7c11″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

12 Choosing for large and non-indexed tables, specifically for intermediate results can be termed as__________:

(A) Hashing

(B) Parallelism

(D) Deadlock

[showhide type=”button7c12″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

13 SMP stands for:

(A) System multi-processing

(B) Server multi-processing

(D) Securing multi-processing

[showhide type=”button7c13″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(D) Query transaction

[showhide type=”button7c14″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(D) Query transaction

[showhide type=”button7c15″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(D) Query transaction

[showhide type=”button7c16″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

17 Which is the method of processing the plan selected throughout query optimization?

(A) Query execution

(B) Query process

(D) Query transaction

[showhide type=”button7c17″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(D) Recovery

[showhide type=”button7c18″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(D) Recovery

[showhide type=”button7c19″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

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

(D) Recovery

[showhide type=”button7c20″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

21 Which is duplication of computer operations and routine backups to combat any unforeseen problems?

(A) Concurrency

(B) Deadlock

(D) Recovery

[showhide type=”button7c21″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

22 Optimization that is basically related to the rewriter module is termed as__________:

(A) Semantic query optimization

(B) Global query optimization

(D) None

[showhide type=”button7c22″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

23 Optimization basically related to the Rewrite module is termed as_______:

(A) Semantic query optimization

(B) Global query optimization

(D) None

[showhide type=”button7c23″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

24 Database security helps organizations to protect data from_____:

(A) Internal users

(B) External users

(D) Non internal users

[showhide type=”button7c24″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

25 Copying files to secondary or specific devices is known as______:

(A) Retrieve

(B) Backup

(D) Deadlock

[showhide type=”button7c25″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

26 How many types of recovery control techniques?

(A) 2

(B) 3

(D) 5

[showhide type=”button7c26″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

27 Which are types of recovery control techniques?

(A) Deferred update

(B) Immediate update

(D) None

[showhide type=”button7c27″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

28 Analysis of an existing system starts when a customer request for computerizing his ________:

(A) Non-computerized operations

(B) Computerized operations

(D) Database operation

[showhide type=”button7c28″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

29 Which is done by developers is centered on input and output expected by the customer:

(A) Requires interaction

(B) Analysis of starting

(D) None of these

[showhide type=”button7c29″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

30 What does a system design include?

(A) I/O devices

(B) CPU

(D) All of these

[showhide type=”button7c30″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

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

(D) Data analysis

[showhide type=”button8c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

32 A conceptual data model defines the structure of the data and method or processes that use:

(A) File

(B) Data

(D) Testing

[showhide type=”button8c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

33 Which is the forerunner of data analysis having close link with data visualization and data dissemination?

(A) Data analysis model

(B) Data structure

(D) Data integration

[showhide type=”button8c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

34 In preliminary and final designs the design of physical database focuses the way data is physically_____:

(A) Delete

(B) Start

(D) Read

[showhide type=”button8c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

35 Which refers to the process of installing programs/software in a system of information system?

(A) Requires interaction

(B) Analysis of starting

(D) Testing

[showhide type=”button8c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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

(D) Testing

[showhide type=”button8c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

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

(D) Maintenance

[showhide type=”button8c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

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

(D) All of these

[showhide type=”button8c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

39 Files that require immediate access must be stored on_____:

(A) Slow devices

(B) Faster devices

(D) All of these

[showhide type=”button8c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

40 The batch accesses may be stored on slow devices such as________:

(A) Optical disk

(B) Tape

(D) None

[showhide type=”button8c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

41 How many types of changeover methods:

(A) 1

(B) 2

(D) 4

[showhide type=”button8c11″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

42 How many types of maintenance:

(A) 1

(B) 2

(D) 4

[showhide type=”button8c12″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

43 Which are the not a type of maintenance:

(A) Corrective

(B) Adaptive

(D) None of these

[showhide type=”button8c13″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

44 Which is conducted for assessing the quality of the system produced by developer for customer?

(A) Maintenance

(B) Analysis of starting

(D) Testing

[showhide type=”button8c14″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

45 Which is basically an RDBMS in which object oriented features are implemented?

(A) Java

(B) C++

(D) DBMS

[showhide type=”button8c15″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

46 Which was the first commercial RDBMS?

(A) MS SQL

(B) DB2

(D) ORACLE

[showhide type=”button8c16″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

47 In which year RSI introduced oracle V2:

(A) 1978

(B) 1979

(D) 1981

[showhide type=”button8c17″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

48 Which version of oracle, released in 1983:

(A) V1

(B) V2

(D) V4

[showhide type=”button8c18″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

49 Which version of oracle supported multi-version read consistency?

(A) V1

(B) V2

(D) V4

[showhide type=”button8c19″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

50 In which year oracle v5 was released:

(A) 1977

(B) 1979

(D) 1985

[showhide type=”button8c20″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

51 Which version of oracle entered the market with more features?

(A) V2

(B) V3

(D) V6

[showhide type=”button8c21″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

52 Which has enhancements in the input/output operation of disk, scalability, locking of row, backup and recovery?

(A) Oracle V6

(B) Oracle V5

(D) Oracle V4

[showhide type=”button8c22″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

53 Oracle 8 is an object relational database that was released in:

(A) 1977

(B) 1979

(D) 1985

[showhide type=”button8c23″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

54 V6 of oracle also included the first version for_____:

(A) PL

(B) SQL

(D) None

[showhide type=”button8c24″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

55 Which was introduced stored procedures and triggers in PL/SQL:

(A) Oracle V6

(B) Oracle V5

(D) Oracle V7

[showhide type=”button8c25″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

56 Version 8i entered the market in______:

(A) 1979

(B) 1989

(D) None of these

[showhide type=”button8c26″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

57 Which version included RAC that enable multiple instances for accessing a database simultaneously?

(A) V2i

(B) V4i

(D) V9i

[showhide type=”button8c27″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

58 Oracle 9i was introduced in:

(A) 1999

(B) 2000

(D) 2002

[showhide type=”button8c28″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

59 Oracle database 11g was released in_________:

(A) 2001

(B) 2002

(D) 2007

[showhide type=”button8c29″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

60 The server process contains memory for a private session which is its own and is called_________:

(A) SGA

(B) PGA

(D) None

[showhide type=”button8c30″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

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

(D) All of these

[showhide type=”button9c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(D) All of these

[showhide type=”button9c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

63 Which is also known as redo records, recording whatever changes are made to data?

(A) Data files

(B) Control files

(D) All of these

[showhide type=”button9c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

64 The data in oracle database is stored in blocks known as ________:

(A) Data blocks

(B) Extents

(D) Tablespaces

[showhide type=”button9c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

65 Which contains many extents?

(A) Data blocks

(B) Extents

(D) Tablespaces

[showhide type=”button9c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

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

(D) Tablespaces

[showhide type=”button9c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

67 Which are logical storage units contained in a database and a logical container for some segment?

(A) Data blocks

(B) Extents

(D) Tablespaces

[showhide type=”button9c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

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

(D) Portable

[showhide type=”button9c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

69 Which refers to independent events of the main program flow of the systems that lacks concurrency?

(A) RDBMS

(B) Portable

(D) None of these

[showhide type=”button9c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

70 Which is a method provided by an operating system, running in a sequence of steps?

(A) Storage

(B) Process

(D) None of these

[showhide type=”button9c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

71 How many interfaces provided by oracle:

(A) 1

(B) 2

(D) 4

[showhide type=”button9c11″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

72 _______refers to the basic facts and entities, such as names and numbers.

(A) Data

(B) Information

(D) Output

[showhide type=”button9c12″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

73 Information is processed from __________

(A) Output

(B) Data

(D) None of these

[showhide type=”button9c13″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

74 MIS stands for:

(A) Management Information Server

(B) Management Information Service

(D) Master Information System

[showhide type=”button9c14″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

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.

(D) Data helps in making decisions.

[showhide type=”button9c15″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

76 Which is the data model?

(A) Relational

(B) Object-Relational

(D) All of these

[showhide type=”button9c16″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

77 Which is not the feature of database?

(A) Data redundancy

(B) Independence

(D) Data Integrity

[showhide type=”button9c17″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

78 Which is the type of data independence?

(A) Physical data independence

(B) Logical data independence

(D) None of these

[showhide type=”button9c18″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

79 Which is the feature of database?

(A) Query Language

(B) Multi user access

(D) All of these

[showhide type=”button9c19″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

80 Which is the database language?

(A) C

(B) C++

(D) None of these

[showhide type=”button9c20″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

81 Which person is responsible for overall activities for database?

(A) Database designer

(B) Database analyst

(D) Database manager

[showhide type=”button9c21″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

82 Which level of database is viewed by user?

(A) Internal level

(B) External Level

(D) All of these

[showhide type=”button9c22″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

83 Internal level has:

(A) Individual Users View of the database

(B) Community view of the database

(D) All of these

[showhide type=”button9c23″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

84 Which is the component of database management system?

(A) Query Language

(B) Database Manager

(D) All of these

[showhide type=”button9c24″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

85 _____is the structure of the database.

(A) Table

(B) Relation

(D) None of these

[showhide type=”button9c25″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

86 Schema is usually stored in____________.

(A) Tables

(B) Data Dictionary

(D) None of these

[showhide type=”button9c26″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

87 Schema is defined by:

(A) DML

(B) DDL

(D) DQL

[showhide type=”button9c27″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

88 DML language is used to:

(A) Define schema

(B) Define internal level

(D) All of these

[showhide type=”button9c28″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

89 DBMS is the bridge between operating system and ___________.

(A) User

(B) Database administrator

(D) None of these

[showhide type=”button9c29″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

90 Which is the most popular database model?

(A) Network Model

(B) Relational Model

(D) Object Oriented

[showhide type=”button9c30″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

91 Which is the schema object?

(A) Database links and clusters

(B) Packages and Indexes

(D) All of these

[showhide type=”button10c1″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: D [/showhide]

92 In database records are called:

(A) Attributes

(B) Entity

(D) Relations

[showhide type=”button10c2″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

93 An entity has a set of ___________ that describe it.

(A) Attributes

(B) Entity

(D) Relations

[showhide type=”button10c3″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: A [/showhide]

94 In ER model rectangle represents:

(A) Attributes

(B) Entity set

(D) None of these

[showhide type=”button10c4″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

95 Date is the type of attribute:

(A) Simple

(B) Composite

(D) Multi valued

[showhide type=”button10c5″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

96 __________is the attribute or group of attributes that uniquely identify occurrence of each entity.

(A) Foreign key

(B) Super Key

(D) All of these

[showhide type=”button10c6″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

97 _________is the real world object, such as a person, place etc.

(A) Attribute

(B) Entity

(D) All of these

[showhide type=”button10c7″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

98 Grant and revoke is the type of command:

(A) DDL

(B) DML

(D) DQL

[showhide type=”button10c8″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

99 A user that manages the files of application in DBMS is called:

(A) Administrator

(B) Database analyst

(D) None of these

[showhide type=”button10c9″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: C [/showhide]

100 ________is the information about data.

(A) Data

(B) Meta-Data

(D) Relations

[showhide type=”button10c10″ more_text=”Show Answer” less_text=”Hide Answer”] Answer: Option: B [/showhide]

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