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