Professional Knowledge Quiz for IBPS SO (I.T.)
Dear readers,
This quiz consists of questions from
various Banking entrance exams held during the last few years. Leave your
answers/ responses in the comments section below and we’ll soon let you know
the correct answers!
Directions
(Q. 1-10)
1.
In SQL, which command(s) is (are) used to remove rows from a table,
(A) Delete
(B) Remove
(C) Truncate
(D) Both (1) and (3)
2.
In SQL, the CREATE TABLE is used
(A) To create a table, defining its
columns, integrity constraints, and storage allocation
(B) To add a column/integrity constraint to
a table.
(C) To redefine a column
(D) To change a table’s storage
characteristics
3.
What is the abbreviation is used for a software package that permits the user
to create, retrieve and maintain records in a database?
(A) DASD
(B) CRMD
(C) DBMS
(D) All of these
4.
Choose the right sequence of virus stages−
(A) Triggering, Damage, Dormancy,
propagation
(B) Damage, Triggering, Dormancy,
propagation
(C) Damage, Triggering, propagation,
Dormancy
(D) Dormancy, Propagation, Triggering,
Damage
5.
In SQL, which command is used to add new rows to a table?
(A) Alter Table
(B) Add row
(C) Insert
(D) Append
6.
In SQL, which of the following is not a data Manipulation Language Commands?
(A) Delete
(B) Select
(C) Update
(D) Create
7.
The value for an attribute or a column are drawn from a set of values known as−
(A) Tuples
(B) Attributes
(C) Domain
(D) Column
8.
Entities having primary key are called−
(A) Primary Key
(B) Strong entities
(C) Weak entities
(D) Primary Key
9.
Which of the following is not a type of SQL statement?
(A) Data Manipulation Language (DML)
(B) Data Definition Language (DDL)
(C) Data Control Language (DCL)
(D) Data Communication Language (DCL)
10.
Which of the following is not included in DML (Data Manipulation Language)
(A) INSERT
(B) UPDATE
(C) DELETE
(D) CREATE
`
To follow our
Banking portal on Facebook and Twitter, click on the following links:
Facebook: https://www.facebook.com/pagalguybankpo
Twitter: https://twitter.com/PaGaLGuYBankPO
Answers
1(d) 2(a) 3(c)
4(d) 5(d) 6(d)
7(c) 8(b) 9(d)
10(d)