Professional Knowledge Quiz for IBPS SO IT Officer 2017


Q1.A banking system consist of user accounts, money transfers, withdrawal, deposits, etc. These all represent tables or entities that can be manipulated with SQL. What is full form of SQL?
(a)Shortcut query language
(b)Structured query language
(c)Simple query language
(d)Sorted query language
(e)None of the above

Q2.A relational database consists of a collection of:
(a)Tables
(b)Fields
(c)Records
(d)Keys
(e)None of the above

Q3.OLAP stands for:
(a)Online analytical processing
(b)Online analysis processing
(c)Online transaction processing
(d)Online aggregate processing
(e)None of the above

Q4.Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
(a)DML(Data Manipulation Langauge)
(b)DDL(Data Definition Langauge)
(c)Query
(d)Relational Schema
(e)None of the above

Q5.Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
(a)DML(Data Manipulation Langauge)
(b)DDL(Data Definition Langauge)
(c)Query
(d)Relational Schema
(e)None of the above

Q6.To remove a relation from an SQL database, we use the ______ command.
(a)Delete
(b)Purge
(c)Remove
(d)Drop table
(e)None of the above

Q7.What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
(a)Relation
(b)Instance
(c)Table
(d)Column
(e)None of the above

Q8.An entity set that does not have sufficient attributes to form a primary key is termed a __________ .
(a)Strong entity set
(b)Variant set
(c)Weak entity set
(d)Variable set
(e)None of the above

Q9.Which of the following gives a logical structure of the database graphically ?
(a)Entity-relationship diagram
(b)Entity diagram
(c)Database diagram
(d)Architectural representation
(e)None of the above

Q10.A window into a portion of a database is
(a)Schema
(b)View
(c)Query
(d)Data dictionary
(e)None of the above

Q11. In E-R diagram generalization is represented by
(a)Ellipse
(b)Dashed ellipse
(c)Rectangle
(d)Triangle
(e)Diamond

Q12. In the __________ normal form, a composite attribute is converted to individual attributes.
(a)First
(b)Second
(c)Third
(d)Fourth
(e)Fifth

Q13. Tables in second normal form (2NF):
(a)Eliminate all hidden dependencies
(b)Eliminate the possibility of a insertion anomalies
(c)Have a composite key
(d)Have all non key fields depend on the whole primary key
(e)All of the above

Q14. Which form has a relation that possesses data about an individual entity:
(a)2NF
(b)3NF
(c)4NF
(d)5NF
(e)1NF

Q15.Which forms are based on the concept of functional dependency:
(a)1NF
(b)2NF
(c)3NF
(d)4NF
(e)5NF



About Course:

"Did you Know? In this pack you will get All new content we launch in the next 3 months"
 

This is the most recommended and NRA-CET ready Pack!
 

Use Code 'DREAM' to avail at best price today

This package Includes IBPS PO Study Material -  Subscribe Now

About Bank Mahapack
If you are preparing for more than 1 Banking & Insurance exams then this is the pack we recommend you buy.

It is most cost effective and you get access to 100% digital content for Bank & Insurance exams on Adda247.

Banking & Insurance Exams Covered in this Pack

Additionally, you can crack any private bank job exam with content in this pack.

 

Bank & Insurance Mahapack Highlights 

  • Structured course content
  • Recorded classes available if you miss any live class
  • Previous Years’ Papers of all upcoming exams.
  • Full Length Mocks based on the latest pattern with detailed solutions (video solutions for certain topics)
  • Topic level knowledge tests
  • Strategy sessions, time management & Preparation tips from the experts

 

Validity: 3 Months

Note: This package is not a part of Double Validity Offer

Bank Maha Pack
  1. Unlimited Live Classes & Recorded Video Courses
  2. Unlimited Tests and eBooks
  3. 1 Lakh+ Selections
Validity
  1. 24 Months
  2. 1 Month
  3. 3 Months
6199 516/month
BUY NOW