SBI Specialist Officer Professional Knowledge

My brother going to participate in State Bank of India (SBI) Specialist Officer recruitment examination, so he needs SBI Specialist Officer Professional Knowledge exam syllabus & question paper, so will you please provide here???

[Quick Sam]

State Bank of India (SBI) Specialist Officer recruitment examination Professional Knowledge section syllabus & question paper, here I am giving:

Syllabus contains following sections:

Computer Networks and Basic Programing Languages (C, C++, Java),
Data Base Management Systems (DBMS),
Basic concepts of Software and Hardware,
Data Structures,
Computer Organization,
Computer Networks,
Network Programming,
Algorithms,
Digital Electronics,
Web Technologies,
Information Systems and
Software Engineering etc

Question paper:
Q1. Another name for the data dictionary in a database is the:
A. validation data.
B. relational data.
C. database management system.
D. database schema.

Q2. Field attributes (such as data type and field size) in a database are also known as:
A. metadata.
B. default values.
C. field names.
D. primary keys.

Q3. When entering data, violations of ____________ usually result in error messages.
A. data entry
B. validation rules
C. arithmetic operators
D. computation

Q4. ____________ are the values the database will automatically use for the field unless the user enters another value.
A. Data types
B. Default values
C. Validated data
D. Metadata

Q5. Common types of validation checks include all of the following, EXCEPT:
A. range.
B. completeness.
C. redundancy.
D. consistency.

Q6. Range checks ensure that the data entered falls within the set ____________, which are properties that must be satisfied for an entry to be accepted into a field.
A. field constraints
B. default values
C. validations
D. descriptions

Q7. In addition to keying data directly into the database, data entry can be done from a(n):
A. input form.
B. table.
C. field.
D. data dictionary.

Q8. ____________ is the process within the database design of ensuring that data entered into a database meets validation rules.
A Proofreading
B. Authorization
C. Validation
D. Computation

Q9. The phrase “>5.50 And <20” is an example of a(n) ____________ check to validate data in a database.
A. requirements
B. completeness
C. range
D. insurance

Q10. A(n) ____________ check confirms that only text characters are entered in a field.
A. alphabetic
B. numeric
C. completeness
D. range

Q11. A(n) ____________ check ensures that all fields in a database defined as “required” have data entered into them.
A. requirements
B. completeness
C. consistency
D. alphabetic and numeric

Q12. A ____________ check compares the values of data in two or more fields to see if these values are reasonable.
A. constraint
B. completeness
C. consistency
D. range

Q13. Making a field ____________ means that it cannot be left blank.
A. numeric
B. required
C. calculated
D. validated

Q14. ____________ organizes a database into the order you need.
A. Browsing
B. Scrolling
C. Sorting
D. Querying

Q15. SQL is based on a branch of mathematics called:
A. structured algebra.
B. data-driven calculus.
C. artificial intelligence.
D. relational algebra.

Q16. A(n) ____________ query displays a subset of data from one table based on specified criteria.
A. select
B. variable
C. operational
D. join

Q17. A ____________ query displays a subset of data from two or more tables using a common field.
A. select
B. complex
C. table
D. join

Q18. A(n) ____________ enables users to have the database select and display records that match a certain criteria.
A. query
B. sort
C. operation
D. join

Q19. The process of reducing redundancy in a database is called:
A. a consistency check.
B. normalization.
C. metadata.
D. schema.

Q20. The primary key must be a(n) ____________ field.
A. numeric
B. object
C. unique
D. related

Q21. A ____________ is a large-scale electronic repository of data that is time-variant.
A. data warehouse
B. data mine
C. knowledge-based system
D. decision support system

Q22. The premise behind a relational database is that ____________ are established among the tables.
A. relationships
B. schema
C. consistencies
D. normalizations

Q23. ____________ is the term used for extracting data from source databases, transforming or reformatting the data, and storing it in the data warehouse.
A. Data staging
B. Validation
C. Normalization
D. Clickstream data

Q24. All of the following are types of reports generated by a management information system, EXCEPT:
A. summary
B. detail
C. exception
D. validation

Q25. Which of the following items is NOT a major component of a decision support system (DSS)?
A. internal and external data sources
B. data warehousing
C. model management systems
D. knowledge-based systems

ANSWERS:
1. D 11. B 21. A
2. A 12. C 22. A
3. B 13. B 23. A
4. B 14. C 24. D
5. A 15. D 25. B
6. B 16. A
7. A 17. D
8. C 18. A
9. C 19. B
10. A 20. C