IBPS RRB SO IT Professional Knowledge Quiz: 28th August |

Dear Aspirants,

IBPS RRB SO IT Professional Quiz

IBPS RRB SO IT Officer Scale-II is amongst the most reputed jobs in the Banking Sector. We will provide you with a quiz based on Information Technology which will cover topics like Networking, Information Security, DBMS, Data Structure, Programming, etc. Practice with the questions based on the most updated pattern. We already rolled the study plan for IBPS RRB MAINS 2019.

Q1. Partial dependency is removed in which normal form of normalization?

(a) First

(b) Second

(d) Fourth

(e) None of these

S1. Ans.(b)

Sol.

Second normal form eliminates partial dependencies. The database is said to be in 2NF (Second Normal Form) if the following conditions are satisfied.

(i)-Should be in first normal form.

(ii)-Partial dependencies are removed, i.e., all non-key attributes are fully functional dependent on the primary key. In other words, non-key attributes cannot depend on a subset of the primary key.

Q2. Which SQL function returns the total sum of a numeric column?

(a)COUNT()

(b)AVG()

(c)SUM()

(d)In

(e)None of these

S2.Ans.(c)

Sol.

The SUM() function returns the total sum of a numeric column.

Syntax:

SELECT SUM(column_name)

FROM table_name

WHERE condition;

Q3.Which of the following is true about composite attributes?

(a)Composite attribute are those attributes which cannot be further divided into other attributes

(b)Composite attribute are those attributes which can further be divided into other attributes

(c)Composite attribute are those attributes which are essentially the primary keys of the relation

(d)All are true about composite attributes

(e)None is true

S3. Ans.(b)
Sol.

Composite attribute can be further divided into more attributes.

Q4. Which operator is used to project particular columns from a relation?

(a)Projection Operator (∏)

(b)Selection operator (σ)

(c)Cross Product(X)

(d)Union (U)

(e)None of these

S4.Ans.(a)

Sol.

Projection operator is used to project particular columns from a relation.

Syntax:

∏(Column 1,Column 2….Column n)(Relation Name)

Q5.Relationship in E-R diagram is represented by which of the following?

(a) Rectangle box

(b) Ellipse

(d) Double Ellipse

(e) None of the above

S5.Ans.(c)

Sol.

Relationships are represented by diamond-shaped box. Name of the relationship is written inside the diamond-box.

Q6.Which clause is used to extract only those records that fulfill a specified condition?

(a) where

(b) like

(d) create

(e) between

S6.Ans.(a)

Sol.

The WHERE clause is used to filter records. The WHERE clause is used to extract only those records that fulfill a specified condition.

Syntax:

SELECT column1, column2, …

FROM table_name

WHERE condition;

Q7.Which of the following is used to remove all records from a table, including all spaces allocated for the records are removed?

(a)Revoke

(b)Alter

(c)Truncate

(d)Delete

(e)Update

S7.Ans.(c)

Sol.

TRUNCATE is used to remove all records from a table, including all spaces allocated for the records are removed.

Q8. Which of the following is not a TCL(transaction Control Language) command?

(a)COMMIT

(b)SAVEPOINT

(c)REVOKE

(d)ROLLBACK

(e)SET TRANSACTION

S8. Ans.(c)

Sol.

REVOKE is DCL(Data Control Language) command. DCL includes commands such as GRANT and REVOKE which mainly deals with the rights, permissions and other controls of the database system.

Q9. Which of the following is the correct syntax of UPDATE Command?

(a) UPDATE table_name where condition SET column_name = <value>

(b) UPDATE table_name SET column_name = <value> WHERE <condition>

(d) UPDATE IN table_name WHERE condition set column_name = <value>

(e) UPDATE IN table_name LIKE condition set column_nam =<value>

S9. Ans.(d)

Q10.The following SQL Query is which type of join:

SELECT * from Employ, Employe_info where Employe.id = Employe_info.id

(a) Inner Join

(b) Natural Join

(d) Outer Join

(e) Left Outer Join

S10. Ans.(a)

Sol.

The INNER JOIN selects all rows from both participating tables as long as there is a match between the columns. An SQL INNER JOIN is same as JOIN clause, combining rows from two or more tables.

Q11. Which of the following is not an application layer protocol?

(a)HTTP

(b)SMTP

(c)SNMP

(d)ICMP

(e)POP3

S11.Ans.(d)

Sol.

ICMP is a network layer protocol. ICMP (Internet Control Message Protocol) is an error-reporting protocol network devices like routers use to generate error messages to the source IP address when network problems prevent delivery of IP packets.

Q12.Proxy firewall works on which layer

(a) Application layer

(b) network layer

(d) datalink layer

(e) none of these

S12. Ans.(a)

Sol.

A proxy firewall is a network security system that protects network resources by filtering messages at the application layer. A proxy firewall may also be called an application firewall or gateway firewall.

Q13.What is the default subnet mask for a class B network?

(a) 255.255.255.0

(b) 255.0.0.0

(d) 255.255.0.0

(e) None of these

S13.Ans.(d)

Sol.

Subnet Masks are used to divide a given network in to 2 or more subnets. Default subnet mask of class B network is: 255.255.0.0.

Q14. A web client sends a request to a web server. The web server transmits a program to that client as is executed at client. It creates a web document. What are such web documents called?

(a) Active

(b) Static

(d) Passive

(e) None of these

S14. Ans.(a)

Sol.

Active web document consists of a software program sent by a server to interact with the client and answer the query of the client.

Q15. Which protocol will be used to automate the IP configuration mechanism which includes IP address, subnet mask, default gateway, and DNS information?

(a) SMTP

(b) DHCP

(d) TCP/IP

(e) RARP

S15. Ans.(b)
Sol.

DHCP (Dynamic Host Configuration Protocol) is a network management protocol used to dynamically assign an Internet Protocol (IP) address to any device, or node, on a network so they can communicate using IP.

Check out more Computer Knowledge Videos Here

You may also like to Read: