2018-ibps-it.pdf - SQL DEL SOLVED ED VED P MODEL SOLV PAP R...

MODEL
SOLV
ED
PAP
DEL
SOLVED
VED
PAPER
VED
P
40
R
IBPS
SO
IT
CWE
(Main)
Exam
Exam
Date:
28.01.2018
Based
on
Memory
1,
In
SQL
which
of
the
following
commands
is
mainly
used
to
remove
a
user-defined
object
(4)
Information
Service
Rou-
(1)
application
tine
(2)
accessibility
(5)
None of
these
from
a
database?
5.
In
Oracle,
which
data
type
is
(3)
atomicity
(4)
Advanced
(1)
RemOve
used
to
store
unstructured
bi-
(5)
Automatic
(2)
Drop
nary
data?
10.
Unique
IP
address
is
assigned
(3)
Delete
(1) INT
to
each
host
in
which
of
the
(4)
Erase
(2)
VARCHAR
following
layer?
(5)
Rollback
(3)
DOUBLE
(1)
Network
Layer
2. Which
of
the
following
phases
does
not
belong
to
the
software
development
life
cycle?
(4)
BLOB
(2)
Data
Link
Layer
(5)
None
of
these
(3)
Transport
Layer
6.
Which
layer
of
the
OSI
model
defines
the
language
and
syn
tax
for
programs?
4)
Application
Layer
(1)
Testing
(5)
physical layer
(2)
Maintenance
11.
What
is
the
default
value
for
(3)
Marketing
(1)
Data
link
layer
Boolean
variable
in
an
array?
(4)
Coding
(2)
Presentation
layer
(1)
Null
(2)
Zero
(5)
None
of
these
(3)
Application layer
(3)
False
(4)
True
3.
Consider
the
following
encryp-
tion
alogorithms?
(4)
Session
layer
(5)
Transport
layer
(5)
Bit
I.
Data
Encryption
Standard
(DES)
7.
UDP
and
TCP
are
categorised
layer
of
the
12.
Which
of
the
following
library
function
is
used
to
concate-
under
the
I.
Advanced
Encryption
Standard
(AES)
nate
tw
strings
in
aC
pro
gram?
OSI
model.
(1)
physical
(1)
strcpy
(2)
strlwr
II.
Rivest
Shamir
Adleman
(RSA)
(2)
data
link
(3)
strcmp
(4)
strcat
Choose
the
option
that
cor
rectly
matches
the
given
algo
rithms
with
the
type
of
cryp
tography
(public-key
of
private
key)
utilised
by
them.
(1)
DES&
AES:
private-key:
RSA:
public-key
(2)
AES
&
RSA:
private-key
DES:
public-key
3)
DES
&
RSA
:
private-key
AES:
public-key
4)
RSA:
private-key;
DES
&&
AES
public-key
5)
AES
(3)
application
5)
strempP
13.
Which
of
the
following
func-
tions
is
used
to
copy
one
mem
ory
location
to
another
in
C++?
(4)
transport
(5)
network
8.
Which
of
the
following
topol
ogies
mainly
use
hub
for
in-
(1) memnmove
terconnection
of
resources?
(2)
memchr
(1)
Ring
topology
(3)
memcmp
(2)
Bus
topology
(4)
memcPy
(3)
Tree topology
(5)
memset
14.
Which
of
the
following
is
not
true
regarding
an
OLTP
sys
(4)
Star
topology
(5)
Mesh topology
tem?
9.
'ACID
is
a
set
of
properties
of
database
transactions
intend-
private-key;
DES &
(1)
OLTP
is
generally
regarded
RSA
public-key
4.
The
full
form
of
ISR
is
as
unsuitable
for
data
ed
to
guarantee
validity
even
in
the
event
of
errors,
power
failures.etc.
The
alphabet
'A'
in
the
abbreviation
'ACID'
stands
warehousing.
)Information
Service
Re
(2)
OLTP
systems
an
be
repoS-
quest
itories
of
facts
and
histori-
2)
Information
Select
Routine
3)
Interrupt
Service
Routine
cal
data
of
business
analy-
for
sis.
ISIT-513

KIRAN'S
IBPS
IT
OFFICER
PRACTICE
WORK
BOUR
is
the
execution
of
26.
series
of
programs
each
on
set
or
"batch"
of
nputs,
rath
er
than
a
single
input.