Data Base Previous Question Answers PSC, UPSC, SSC, IBPS

Home Questions & Answers Previously asked question Technology Data Base

Data Base Previous Questions from PSC, UPSC and SSC

Which one of the following control steps is usually not performed in data warehousing applications
Asked : SBI SO (IT officer) January 2016
AMonitor summary tables for regular use

BCleaning meta data from being used interactively.
CControl meta data from being used interactively.
DReconcile data moved between the operations environment and data warehouse
EMonitor the data purging plan

Map entities, attributes and relations in Oracle is represented by ………….
Asked : SBI SO (IT officer) January 2016
ASpecial Schema
BConceptual and Physical Schema

CLogical Schema
DPhysical Schema
EConceptual Schema

The oracle environment of database is called as ……..
Asked : SBI SO (IT officer) January 2016
AData type
BData structure
CDatabase instances
DDatabase schema

EData values

The oracle environment of database is called as ……..
Asked : SBI SO (IT officer) January 2016
AData type
BData structure
CDatabase instances
DDatabase schema

EData values

Which of the following codes must be granted to an Oracle 9x to perform a full database import
Asked : SBI SO (IT officer) January 2016
ACONNECT
BRESOURCE
CFULL_REPORT_PREVS
DFULL_REPORT_PRINS
EIMP_FULL_DATABASE

SQL commands do not include which of the following
Asked : SBI SO (IT officer) January 2016
ADelete, Insert
BSelect, Updata
CSelect, Revoke
DGrant, Revoke

ESelect, Revoke

Which of the following is best characterized by unauthorized modification of data before or during systems data entry
Asked : SBI SO (IT officer) January 2016
AData modeling
BSalami attack
CData corruption
DData diddling

ESkimming

Who is more concerned about the conceptual level at DBMS
Asked : SBI SO (IT officer) January 2016
AThe system programmer
BDatabase viewer
CThe end user
DClient
EDBA

Online banking transactions are being posted to the database when processing suddenly comes to a hat. The integrity of the transaction processing is best ensured by ………
Asked : SBI SO (IT officer) January 2016
Aaccuracy checks
Bdatabase integrity checks
Cinput controls
DValidation checks
EDatabase commits and rollbacks

Which of the following accesses the database and data dictionary in a database as they exist on a storage device
Asked : SBI SO (IT officer) January 2016
ADBMS engine

BData administration system
CApplication generation subsystem
DData definition subsystem
EData manipulation subsystem

Which script you must query in Oracle to display the code associated with RMAN stored scripts

A. RC_STORED_SCRIPT_LINE

B. RC_STORED_SCRIPT

C. RC_STORED_LINE_SCRIPT

D. RC_SCRIPTS

E. RC_SCRIPTS in RC_STORED_SCRIPT
Asked : SBI SO (IT officer) January 2016
ABoth A and C
BBoth A and B

Which of the following is a CASE SQL statement
Asked : SBI SO (IT officer) January 2016
AA way to establish a data definition in SQL.
BA way to establish an IF-THEN-ELSE in SQL.
CEstablish a loop in SQL or establish an IF-THEN-ELSE in SQL.

DA way to establish a loop in SQL.
EA way to establish a data definition in SQL or establish a loop in SQL.

Which method of database recovery involves frequent simultaneous copying of the database to maintain two or more to complete copies of the database
Asked : SBI SO (IT officer) January 2016
ARollback

BMirroring
CReprocessing
DRollforward
ERolling

To define what columns should be displayed in an SQL, SELECT statement ………..
Asked : SBI SO (IT officer) January 2016
Ause USING to name the source table(s)
Buse SELECT to name the source table(s) and list the columns to be shown after USING.
Cuse USING to name the source table(s) and list the columns to be shown after SELECT.
Duse FROM to name the source table(s) and list the columns to be shown after SELECT.

Euse USING to name the source table(s) and list the columns to be shown after WHERE.

SQL security issues include which of the following
Asked : SBI SO (IT officer) January 2016
AThe complexity of key structures
BThe number of records
CThe size of databases
DThe number of candidate key elements
EGranularity of administration

Which of the following is true of three-tier data worehouses
Asked : SBI SO (IT officer) January 2016
AOnce created, the data marts will directly receive their new data from the operational databases.
BThe data mart combines all the tables of the data warehouse.
CThe data marts are different groups of tables in the data warehouse.
DOnce created, the data marts will keep on being updated from the data warehouse at periodic times.

EA data mart becomes a data warehouse when it reaches a critical size.

Which of the following is not a Web App interface mechanism
Asked : SBI SO (IT officer) January 2016
ACookies
BForms

CBrowser
DCookies and Links
ELinks

Directions (145-150) : Study the following Pie charts and answer the questions given below them.

Percentage of Six different types of garments in store I

Total number of garments in store I = 12600

Percentage of six different types of garments in store II

Total number of garments in store II = 14500

Applicable only to next question

What is the average of A, Band C type of garments in store I?
Asked : SBI PO November 2014
A2016

B4126
C1648
D1028
E6058
Explanation:

In store I, number of A,B and C type of garments = 19+21+8/100 × 12600 = 6048

∴ Required average = 6048/3 = 2016

The number of E type of garments in store I is approximately what percent of the number of B type of garments in store II?
Asked : SBI PO November 2014
A46%
B32%
C68%

D58%
E42%
Explanation:

In store I, number of E type of garments = 11/100× 12600 =1386

In store II, number of B type of garments = 14/100 × 14500 = 2030

∴ Required percentage = 1386/2030 ×100

= 68.2 = 68%

Number of D type of garments in store I is more than that in store II by what percent approximately?
Asked : SBI PO November 2014
A25%
B35%
C40%
D20%
E15%

Explanation:

In store I, number of D type of garments = 16/100 ×12600 = 2016

In store II, number of D type of garments = 12/100 × 14500 =1740

∴ Required percentage 2016-1740/1740 ×100

= 15.86%

=15%

The difference in number of which type of garments in two stores is maximum?
Asked : SBI PO November 2014
AE
BD
CB
DC

What is the total number of C type of garments in both the stores together?
Asked : SBI PO November 2014
A3770
B2610
C3276
D1008
E3618

Explanation:

In store I, number of C type garments

= 8/100 × 12600 = 1008

In store II, number of C type garments

= 18/100 ×14500

=2610

∴ Required total = 1008 +2610

= 3618

Total number of D and A type of garments in store I is approximately double the number of which type of garments in store II?
Asked : SBI PO November 2014
AF
BA

CC
DE
EB
Explanation:

In Store I, number of A type of garments = 19/100×12600

In Store II, number of D type garments = 16/100 ×12600 = 2016

∴ Total number of A and Dtype of garments in store I = 2394+2016

= 4410

In store II, number of A type of garments = 15/100 × 14500

= 2175

Directions (Next six quesions) : Study the following information carefully to answer the questions.

Details of population as recorded in a census

Population of state ‘P’ is 150% of population of state ‘T’ and 80% of the population of state ‘U’. Population of State ‘Q’ is 60% of the population of state ‘V’. population of state ‘S’ is 125% of population o state ‘R’. Population of state ‘U’ is 75 lakhs which is 80% of the population of state ‘V’ and 120%of the population of state ‘S’.

Applicable only to next question

Population of state S is more than the population of state R by what percent?
Asked : SBI PO November 2014
A20%
B25%

C30%
D28%
E22%
Explanation:

Population of State U = 75 lakh

Population of state V = 75 ×100/80

=375/4 lakh

Population of state S = 75 × 100/120

= 125/2 lakh

Population of State R = 125/2 ×100/125 = 50lakh

Population of State Q = 375/4 × 60/100

=225/4 Lakh

Population of state P = 75 × 80/100 = 60 lakh

Population of State T = 60×100/150 = 40 lakh

Required Percentage = (125/2-50/50 ×100)%

=25%

Directions (Next Six Questions) : in these questions, a number of series is given. After the series a number is given followed by (1), (2), (3), (4) and (5). You have to complete the series starting with the given numbers following the sequence of original series and answer the question that follows the series.

Applicable only to next question

15 14 20 33 68 215

21 (1) (2) (3) (4) (5)

What will come in place of (3)?
Asked : SBI PO November 2014
A63
B51
C56
D69

E76
Explanation:

15(X1-(1)³) 14(X2-(2)³) 20(X3-(3)³) 33(X4-(4)³) 68(X5-(5)³) 215

21(X1-(1)³) 20(X2-(2)³) 32(X3-(3)³) 69(X4-(4)³) 212(X5-(5)³) 935

8 7 12 33 128 635

6 (1) (2) (3) (4) (5)

What will come in place of (3) ?
Asked : SBI PO November 2014
A24
B21

C34
D26
E32
Explanation:

8(X1-1) 7(X2-2) 12(X3-3) 33(X4-4) 128(X5-5)635

6(X1-1) 5(X2-2) 12(X3-3) 21(X4-4) 80(X5-5)395

7 13 31 97 391 1957

13 (1) (2) (3) (4) (5)

What will come in place of (4) ?
Asked : SBI PO November 2014
A584
B535

C596
D586
E574
Explanation:

7(X1+6) 13(X2+5) 31((X3+4) 97(X4+3) 391(X5+2)1957

13(X1+6) 19(X2+5) 43(X3+4) 133(X4+3) 535(X5+2)2677

5 31 159 645 1951 3927

3 (1) (2) (3) (4) (5)

What will come in place of (2) ?
Asked : SBI PO November 2014
A92
B91
C93
D99

E96
Explanation:

5(X6+1) 31(X5+4) 159(X4+9) 645(X3+16) 1951(X2+25)3927

3(X6+1) 19(X5+4) 99(X4+9) 405(X3+16) 1231(X2+25)2487

9 18 54 216 1080 6480

7 (1) (2) (3) (4) (5)

What will come in place of (3) ?
Asked : SBI PO November 2014
A156
B128
C152
D132
E168

Explanation:

9(X2) 18(X3) 54(X4) 216(X5) 1080(X6) 6480

7(X2) 14(X3) 42(X4) 168(X5) 840(X6) 5040

11 5 4 4.5 7 15

15 (1) (2) (3) (4) (5)

What will come in place of (2) ?
Asked : SBI PO November 2014
A6

B9
C8
D11
E7
Explanation:

11(X0.5-0.5) 5 (X1-1) 4 (X1.5-1.5 ) 4.5 (X2-2) 7(X2.5-2.5) 15

15(X0.5-0.5) 7(X1-1) 6 (X1.5-1.5) 7.5 (X2-2) 13(X2.5-2.5) 30