IBPS Specialist Officer III 2014 Exam Materials Online Exams 2014 |IBPS IT Officer 2014 Computer Awareness Study Material with Answers .Institute of Banking Personnel Selection (IBPS What is Meant by the Word is expected to conduct IBPS SO Exam 2014 in the month of February 2014, for the candidates who have applied for the position of Specialist Officers notified through IBPS Recruitment 2014 Notification.The candidates who have applied to the vacancies of Specialist Officer or IT Officer Positions may need to appear in the IBPS Common Written Exam 2014 containing the questions from Computer Awareness, Data Base Management Systems etc topics.IBPS Specialist Officer III 2014|IBPS IT Officer 2014 Computer Awareness Study Material with Answers are provided here.Verify IBPS Specialist Officer III 2014|IBPS IT Officer 2014 Computer Awareness Study Material with Answers.Download IBPS Specialist Officer III 2014|IBPS IT Officer 2014 Computer Awareness Study Material with Answers .
Based on the importance of IBPS CWE 2014 for Specialist Officer and IT Officer Vacancies. It is expected that Questions in Computer Awareness section in the IBPS CWE 2014 for Specialist Officer Positions may come from the topics of Computer Basics like software, hardware, operating system, Abbreviations related to computer, Founders and Inventors, along with questions on MS Office (MS Word, MS Excel, MS PPT, MS Outlook,Generations of computers, Storage Devices, Latest changes in Technology, Data Base Management Systems, Computer Networks, Shortcuts,Browsing, Keyboard etc topics. Based on these topics an attempt has been made to provide useful information on some of the important definitions of IBPS Specialist Officer III 2014 Computer Awareness Study Material for the benefit of the Specialist Officer and IT Officer Job aspirants.Interested candidates can follow the below provided study material for IBPS Specialist Officer Exam 2014.Computer Awareness Study Material with Answers,IBPS IT Officer 2014 Computers Material with Answers,IBPS SO Study Material with Answers,IBPS SO Material with Answers .
Latest BSF jobs 2014
Organization Name : Institute of Banking Personnel Selection (IBPS What is Meant by the Word
Official Website : www.ibps.in
Official Website : www.ibps.in
1 What is Meant by the Word Entity:
An object/thing in the real world
Eg: each person in a company is an entity.
2 What is Meant by the Word Entity set:
Group of entities of same type.
Eg: set of students who are athletes.
3 What is Meant by the Word Attribute: which determines the property of a field in a database.
Types:
- Single valued (can have only single value What is Meant by the Word
- Multi valued ( can have multiple values What is Meant by the Word
- Single ( cannot be divided into small parts What is Meant by the Word
- Composite ( can be divided into small parts What is Meant by the Word
- Derived ( value of one attribute can be derived from other related attributes What is Meant by the Word
4 What is Meant by the Word Relationship set:
Association among group of entities.
5 What is Meant by the Word Types of database:
- Hierarchical
- Relational
- Network
6 What is Meant by the Word Deadlock:
A situation where a transaction is in need of a resource which is held by some other transaction.
7 What is Meant by the Word Timestamp:
A tag which is used to denote the start of a transaction.(time at which the transaction was activated What is Meant by the Word
8 What is Meant by the Word Two phase locking protocol:
Contains 2 phases of transaction
Growing phase (transaction can acquire locks; cannot release What is Meant by the Word
Shrinking phase(transaction can only release locks; cannot acquire What is Meant by the Word
9 What is Meant by the Word Index:
Contains only two columns of a table. The first column contains a primary key and the other column has a set of pointers.
Types:
- Primary
- Secondary
- Multilevel
- Clustering
10 What is Meant by the Word Transaction states:
- Active
- Failed
- Aborted
- Committed
- Terminated
11 What is Meant by the Word Schedule:
Collection of transactions that are executed one at a time.
Types:
Serial (transactions are executed in a non primitive manner What is Meant by the Word
Concurrent ((transactions are executed in a primitive manner What is Meant by the Word
12 What is Meant by the Word Serializability:
The transactions should be arranged in a way such that there is problem in acquiring and releasing the data item.
Types:
- Conflict
- View
13 What is Meant by the Word Data warehouse architecture:
- Operational database layer
- Information access layer
- Data access layer
- Meta data layer
14 What is Meant by the Word Advantages of data warehousing:
Data can be retrieved without slowing down of operational data.
Easy analysis and reporting of data.
15 What is Meant by the Word JDBC: ( Java Database Connectivity What is Meant by the Word
Contains queries for querying and updating the data. It is contained in java.sql.
16 What is Meant by the Word JDBC driver:
Adaptors that convert java program request to a suitable form that can be understood by DBMS.
17 What is Meant by the Word Query optimizer:
Determines the efficient way to execute a query.
18 What is Meant by the Word Methods of concurrency control:
- Two phase locking
- Strict two phase locking
- Index locking
- Conservative two phase locking
- Multiple granularity locking
19 What is Meant by the Word Classifications of data mining:
Descriptive ( clustering,association rules What is Meant by the Word (supervised learning What is Meant by the Word
Predictive ( unsupervised learning What is Meant by the Word
20 What is Meant by the Word Tasks in data preprocessing:
- Data cleaning
- Data integration
- Data reduction
- Data transformation
- Data discreti sation
21 What is Meant by the Word System R:
Assumes that a relational database can be used in a real life environment to solve problems.
Types:
- Research storage
- System relational data system
22 What is Meant by the Word Degree of a relation:
Denotes the number of attributes of its relational schema.
23 What is Meant by the Word Query evaluation engine:
Executes compiler generated low level instructions.
24 What is Meant by the Word Phantom deadlock:
Delay in the propagation of information may cause the deadlock detection algorithms to identify false deadlocks.
25 What is Meant by the Word Transaction phases:
- Analysis
- Undo
- Redo
26 What is Meant by the Word Types of update:
- Simultaneous
- Pro active
- Retro active
27 What is Meant by the Word Data constraints:
- Domain
- Range
- Interrelation
- Intrarelation
28 What is Meant by the Word Dependence graph:
Used to describe the connections between different database elements.
29 What is Meant by the Word Data mart:
Collection of smaller data which is comparatively smaller than a data warehouse. i.e, a subset of larger data warehouse.
30 What is Meant by the Word Cold backup: work performed since the last backup is lost.
Hot backup: while making back up, some websites cannot shut down immediately
Latest BSF jobs 2014
No comments:
Post a Comment