IBPS IT SO: Database Management System Questionsआईटी आईबीपीएस तो, डेटाबेस प्रबंधन प्रणाली सवाल

Answers are given in the end. 

Sit with a pen and paper and see how much you score: 

1. This is a type of program that lets one or more computer users create, manage, and

access data in a database.

a. B2B

b. DBMS

c. multidimensional database

d. None

 

2. In a relational database, this is a data structure that organizes the information about a

single topic into rows and columns.

a. block

b. record

c. tuple

d. table

 

3. This is a family of relational database management system products from IBM that

serve a number of different operating system platforms.

a. Cognos

b. DB2

c. ADO

d. Universal Data Access

 

4. This is a central repository for all or significant parts of the data that an enterprise's

various business systems collect.

a. data warehouse

b. business information warehouse

c. knowledge warehouse

d. None

 

5. This is the job title of someone who directs or performs all activities related to

maintaining a successful database environment.

a. DBA

b. MOLAP

c. PHP

d. RFC

 

6. This is a common standard language used to update and get information from a

database.

a. VB

b. TMQL

c. PHP

d. SQL

 

7. This is a file format that contains the values in a table in which column values are

separated by a comma and each row starts a new line.

a. ASCII

b. CSV file

c. virtual organization

d. None

 

8. In a relational database, this is the data structure that holds a single piece of data, such as first name or phone number.

a. catalog

b. field

c. entity

d. object

 

9. This is an organized selection of data from a database that allows you to look at it from

a particular perspective.

a. Venn diagram

b. Gantt chart

c. view

d. splay tree

 

10.This a program tool allows you to reorganize and summarize selected columns and

rows of data in a spreadsheet or database table to obtain a desired report.

a. pivot table

b. PERT chart

c. quad tree

d. ODBC

 

11.At this level of normalization, each column in a table that is not a determiner of the

contents of another column, must itself be a function of the other columns in the table.

a) 1NF

b) 2NF

c) 3NF

d) DKNF

 

12.This method of online analytical processing stores data in both a relational and a multi

dimensional database.

a) HOLAP

b) ROLAP

c) OLAP

d) DIMM

 

13.Which technology was Microsoft's first attempt at an object-oriented database

interface?

a) MQSeries

b) ADO

c) DAO

d) UDA

 

14.What concept would a data modeler NOT be expected to know?

a) class

b) object

c) UML

d) FMP

 

15.Which of the following tree structures is unique in that the tree organization varies

depending on which nodes are most frequently accessed?

a) B-tree

b) binary tree

c) quad tree

d) splay tree

 

16.The basic unit of this SQL variant is called a block.

a) PL/SQL

b) XQL

c) SQLJ

d) TMQL

 

17.The acronym ACID is typically used in reference to:

a) transactions

b) CRM analytics

c) data integrity

d) stubs

 

18.A Database Management System (DBMS) may be used by, or combined with, this type

of transaction manager.

a) DB2

b) CICS

c) Oracle

d) Cognos

 

19.Encapsulation, types, classes, inheritance, overriding combined with late binding, and

extensibility are all features of this type of database.

a) multidimensional database

b) relational database

c) object-oriented

d) open source

 

20.A programmer using this type of middleware might need the Interface Definition

Language (IDL).

a) RPC

b) ORB

c) MUD

d) EAI

 

21.This is a collection of data items organized as a set of formally-described tables from

which data can be accessed or reassembled in many different ways without having to

reorganize the database tables.

a. relational database

b. array

c. file allocation table

d. splay tree

 

22.This is a standard interactive and programming language for getting information from

and updating a database.

a. dynamic data exchange

b. Structured Query Language

c. ASCII

d. Erlang programming language

 

23.In creating a database, this is the process of organizing it into tables insuch a way that

the results of using the database are always unambiguous.

a. probability

b. normalization

c. data modeling

d. query by example

 

24.This family of products is IBM's cross-platform relational database management

system.

a. DBA

b. DB2

c. PHP

d. RDF

 

25.This is an open standard application programming interface (API) for accessing a

database.

a. Universal Data Access

b. Open Database Connectivity

c. Topic Map Query Language

d. Open Data-Link Interface

e. command line interface

 

26.This term, used to describe a database that occupies magnetic storage in the terabyte

range, describes a database that contains billions of table rows.

a. Very Large Database

b. holographic storage

c. Cold Fusion

d. giant

 

27.This is a collection of descriptions about data objects that is created for the benefit of

programmers and others who might need to refer to them.

a. data dictionary

b. stored procedure

c. Virtual File Allocation table

d. catalog

 

28.This term is used to describe the process of forecasting, or simply discovering patterns

in data that can lead to predictions about the future.

a. customer relationship management

b. PERT chart

c. data mining

d. enterprise risk management

 

29.In the relational modes, cardinality is termed as:

(A)Number of tuples.

(B)Number of attributes.

(C)Number of tables.

(D)Number of constraints

 

30.Relational calculus is a

(A)Procedural language.

(B)Non- Procedural language.

(C)Data definition language.

(D)High level language

 

31.The view of total database content is

(A)Conceptual view.

(B) Internal view.

(C)External view

(D)None

 

32.Which type of file is part of the Oracle database?

(A)Control file

(B)Password file

(C)Parameter files

(D)Archived log files

 

33. Which statements are use to UNLOCK the user?

(A)Alter user Scott account lock;

(B)Modified user Scott account unlock;

(C)Alter user Scott account unlock;

(D)Alter user Scott unlock

 

34.For which two constraints are indexes created when the constraint is added?

(A)Primary key

(B)Unique

(C)Not null

(D)Both (A) & (B)

 

35.What type of failure occurs when Oracle fails due to an operating system or computer

hardware failure?

(A)Application failure

(B) Instance Failure

(C)Media Failure

(D)Rollback failure

 

36.When is the SGA created in an Oracle database environment?

(A)When the database is created

(B)When a user process is started

(C)When the database is mounted

(D)When the instance is started

 

37.Which password management feature ensures a user cannot reuse a password for a

specified time interval?

(A)Account Locking

(B)Password History

(C)Password Verification

(D)Password Expiration and Aging

 

38.Which privilege is required to create a database?

(A)SYSDBA

(B)DBA

(C)SYSOPER

(D)RESOURCE

 

39.What is the type of Oracle backup in which all uncommitted changes have been

removed from the Data files?

(A)Full backup

(B)Consistent backup

(C)Inconsistent backup

(D)Differential backup

 

40.Which are the physical structures that constitute the Oracle database?

 (A)control file

 (B) Data file

(C) Log file

 (D) All of the above

 

41.DML is provided for

(A)Description of logical structure of database.

(B)Addition of new structures in the database system.

(C)Manipulation & processing of database.

(D)Definition of physical structure of database system.

 

42.‘AS’ clause is used in SQL for

(A)Selection operation.

(B)Rename operation.

(C)Join operation.

(D)Projection operation

 

43.ODBC stands for

(A)Object Database Connectivity.

(B)Oral Database Connectivity.

(C)Oracle Database Connectivity.

(D)Open Database Connectivity.

 

44.In an E-R diagram attributes are represented by

(A) rectangle.

(B)Square.

(C)Ellipse.

(D)Triangle.

 

45.The database environment has all of the following components except:

(A)Users.

(B)Separate files.

(C)Database.

(D)Database administrator

 

46.The language which has recently become the de-facto standard for interfacing

application programs with relational database system is

(A)Oracle.

(B)SQL.

(C)DBase.

(D)None

 

47.In an E-R diagram an entity set is represent by a

(A)Rectangle.

(B)Ellipse.

(C)Diamond box.

(D)Circle.

 

48.The DBMS language component which can be embedded in a program is

(A)The data definition language (DDL).

(B)The data manipulation language (DML).

(C)The database administrator (DBA).

(D)A query language.

 

49.A relational database developer refers to a record as A)A criteria.

(B)A relation.

(C)A tuple.

(D)An attribute.

 

50.The method in which records are physically stored in a specified order according to a key field in each record is

(A)Hash.

(B)Direct.

(C)Sequential.

(D)all of the above.

 

51.Count function in SQL returns the number of

(A)Values.

(B)Distinct values.

(C)Groups.

(D)Columns.

 

52.An advantage of the database management approach is

(A)Data is dependent on programs.

(B)Data redundancy increases.

(C)Data is integrated and can be accessed by multiple programs.

(D)None of the above.

 

53.A DBMS query language is designed to

(A)Support end users who use English-like commands.

(B)Support in the development of complex applications software.

(C)Specify the structure of a database.

(D)None

 

54.The method of access which uses key transformation is known as

A) Direct.

B) Hash.

C) Random.

D) Sequential.

 

55.The statement in SQL which allows to change the definition of a table is

A) Alter.

B) Update.

C) Create.

D) Select.

 

56.Relational Algebra is

A) Data Definition Language.

B) Meta Language

C) Procedural query Language

D) None of the above

 

57.Key to represent relationship between tables is called

A) Primary key

B) Secondary Key

C) Foreign Key

D) None of these

 

58.DBMS helps to achieve

A) Data independence

B) Centralized control of data

C) Both (A) and (B)

D) None

 

59.Which of the following are the properties of entities?

A) Groups

B) Table

C) Attributes

D) Switchboards

 

60.Which of the following is a valid SQL type?

A) CHARACTER

B) NUMERIC

C) FLOAT

D) All of the above

 

Answers: 1 B

2 D

3 B

4 A

5 A

6 D

7 B

8 B

9 C

10 A

11 B

12 A

13 C

14 D

15 D

16 A

17 A

18 B

19 C

20 B

21 A

22 B

23 B

24 B

25 B

26 A

27 A

28 C

29 A

30 B

31 A

32 A

33 C

34 D

35 B

36 A

37 B

38 A

39 B

40 D

41 C

42 B

43 D

44 C

45 A

46 B

47 A

48 B

49 C

50 A

51 A

52 C

53 C

54 B

55 A

56 C

57 C

58 C

59 C

60 D