February 7, 2016

IBPS SO (IT Officer) Professional Knowledge DBMS Questions Set

Hello Readers,

We are presenting you the model practice questions set for the upcoming IBPS Specialist Officers (IT Officers) Exam.This questions set consists of questions from Database Management System (DBMS).As you know DBMS is one of the most important section of IBPS IT Officers Exam so you have to focus more on it.We have also included some important questions that are repeatedly asked in previous IBPS and SBI IT Officers exams.Hope this IT Officer questions set will help you in your preparation.

  • A Collection of interrelated files and a set of programs that allows user to access and modify these files - DBMS
  • A language used by the relational databse to fetch, update and manage data - Structured Query Language (SQL)
  • A process that helps analysts or database designers to design table structure for an application - Normalisation
  • The one or more column(s) in a table used to uniquely identify each row in the table - Primary Key
  • An ordered list of the content of a column of a table - Index
  • To reduce redundant data to the minimum possible, oracle allows the creation of an object called - View
  • A collection of all entities of particular entity type in the database is called - Entity Set
  • Entity - Relationship model (E - R model) is widely known - Object based logical model
  • All the information collected during database development is stored in a - Repository
  • In relational database row and column is called as - Tuple and Attribute
  • A person who has the central control over both data and application program - Database Administrator (DBA)
  • Entities having primary key are called - Strong entities
  • In SQL, a command is used to add new rows to a table - Append
  • The values for an attribute or a column are drawn from a set of values known as - Domain
  • In E - R diagram, the term cardinality is a synonym for the term - Degree
  • In DBMS, the basic structure to hold user data in a relational database is - Table
  • Students and courses are example of - many to many relationship
  • If an attribute of a composite key is dependent on an attribute of other composite key, a relation is in - Third Normal Form (3 NF)
  • A generalization of the Boyce Codd Normal Form to relation schemes which includes the multivalued dependencies is called - Fourth Normal Form (4 NF)
  • In Oracle, the tablespace is minimum required when creating a new database - Undo Tablespace
  • The language used by most of the DBMS's for helping their users to access data - Query Language
  • The directory within a directory is called - Sub Directory