IBPS SO IT DBMS

#Model_Paper_1_fb_com_bankibpssoit

Student(ID, name, dept name, tot_cred) In this query which attribute form the primary key? a) Name b) Dept c) Tot_cred d) ID [https://bankibpssoit.blogspot.in]

Which one of the following is a procedural language ? a) Domain relational calculus b) Tuple relational calculus c) Relational algebra [https://bankibpssoit.blogspot.in] d) Query language

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple. a) Select b) Join [https://bankibpssoit.blogspot.in] c) Union d) Intersection

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match. a) Join b) Cartesian product [https://bankibpssoit.blogspot.in] c) Intersection d) Set difference

The _______operation performs a set union of two “similarly structured” tables a) Union [https://bankibpssoit.blogspot.in] b) Join c) Product d) Intersect

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is a) Join b) Projection c) Select [https://bankibpssoit.blogspot.in] d) Union

The _______ operator takes the results of two queries and returns only rows that appear in both result sets. a) Union b) Intersect [https://bankibpssoit.blogspot.in] c) Difference d) Projection

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys. a) Schema diagram [https://bankibpssoit.blogspot.in] b) Relational algebra c) Database diagram d) Schema flow

The _________ provides a set of operations that take one or more relations as input and return a relation as an output. a) Schematic representation b) Relational algebra [https://bankibpssoit.blogspot.in] c) Scheme diagram d) Relation flow

IBPS SO IT - DBMS - SOLVED

1. Mechanism developed to enforce users to enter data in required format is:
a. Data validation
b. Input mask
c. Criteria
d. Data verification

2. The raw facts and figures are:
a. Data
b. Information
c. Snapshot
d. Reports

3. The feature that database allows to access only certain records in database is:
a. Forms
b. Reports
c. Queries
d. Tables

4. Which filter method lets you filter the records that match the selected field?
a. Filter by form
b. Filter by selection
c. Auto filter
d. Advanced filter

5. Which filter method lets you filter records based on criterion you specify?
a. Filter by form
b. Filter by selection
c. Auto filter
d. Advanced filter

6. You can find Sort & Filter group of commands in
a. Home ribbon
b. Create ribbon
c. Database tools ribbon
d. Fields ribbon

7. Which of the following filter method is not available in Access?
a. Filter by selection
b. Filter by form
c. Advanced filter
d. None of above

8. By Grouped Report you understand
a. Type of report generated by the Report Wizard
b. Type of report that present records sorted in ascending or descending order as you specify
c. Type of report that displays data grouped by fields you specified
d. None of above

9. The text you typed in Description column in Table Design View is displayed on
a. Description bar in forms
b. Report Footer when printed
c. Title bar of MS Access while entering data
d. Status bar while entering data

10. What is the maximum allowed field size for Boolean (Yes/No) fields?
a. 1
b. 8
c. 50
d. 255

11. What is the size of Data & Time field type?
a. 1
b. 8
c. 255
d. 50

12. Which of the following field type can store maximum data?
a. Yes/No fields
b. Date/Time fields
c. Text fields
d. Memo fields

13. To display associated record from related table in datasheet view, you can
a. Double click the record
b. Apply filter by form command
c. Single click on expand indicator (+) next to the record
d. Double click on expand indicator (+) next to the record

14. Arrange according to the size
a. Record, field, byte, bit
b. Bit, field, byte, record
c. Field, byte, record, bit
d. Byte, bit, record, field

15. What type of relationship exists between a Student table and Fees table?
a. One to one
b. One to many
c. Many to many
d. One to many and many to many

16. Identify the relationship between a Movie table and Stars table:
a. One to one
b. One to many
c. Many to many
d. None of above

17. What type of relationship exists between a Teacher table and Class table?
a. One to many
b. Many to many
c. One to one
d. Two to two

18. Which of following relationship type is not possible to realize in Access Database directly?
a. One to one
b. One to many
c. Many to many
d. None of above

19. For which kind of relationship you need a junction table to reflect real world situation?
a. One to one
b. One to many
c. Many to many
d. None of above

20. What do you need if you should enforce many-to-many relationship between two tables?
a. Parent table
b. Child table
c. Junction table
d. Many-to-many relationship can't be created in database

21. You can display data from multiple tables by using
a. Page break
b. Sub form
c. Columnar form
d. Tabular form

22. What is the best data type for a field that stores mobile numbers?
a. Text
b. Number
c. Date/Time
d. Memo

23. What field type is best to store serial numbers?
a. Number
b. AutoNumber
c. Text
d. Memo

24. Which of the following field type is used to store photograph of employees?
a. Memo
b. Picture
c. OLE
d. Photo

25. Which of the following method can be used to add more tables in a database?
a. Design View
b. Table Wizard
c. By Entering Data
d. All of above

26. From which version Microsoft introduced Backstage View for Access Interface?
a. Access 2003
b. Access 2007
c. Access 2010
d. Access does not have Backstage View

27. You can display Backstage View by clicking on
a. File menu
b. Home tab
c. Control box
d. Quick Access Toolbar

28. Why do you pin an item in list?
a. To mark it to delete from list
b. To move it up and make it always available
c. To make it default database when you open Access
d. None of above

29. The options like Save, Open Database, Print are available in
a. Home tab
b. Backstage View tab
c. File menu
d. Database Tools tab

30. What is relational database?
a. A place to store relational information
b. A database that is related to other databases
c. A database to store human relations
d. None of above

31. The advantage of computerized database over manual database is
a. We can get the information our quick
b. We can put in information quick
c. Solve the repeated information and consistency problem
d. All of above

32. Circular button with Office icon in it is
a. Control box
b. Office box
c. Company box
d. Control menu box

33. Group names in ribbon can be helpful to
a. Group the commands so that when you move one, you can move all of them together
b. Give a name for buttons on ribbon
c. Find the required option by inspecting through them
d. All of above

34. The options like Relationship, SQL Server etc. are found in
a. External data tab
b. Database tools tab
c. Create tab
d. Home tab

35. Navigation pane is placed on
a. The left of Access workspace
b. The right of Access workspace
c. Just below the Access workspace
d. Just above the status bar

36. You can filter the display of different Access objects in navigation pane from
a. View tab in ribbon
b. Drop down menu at the top of navigation pane
c. Sort & Filter group in Home menu
d. Database tab

IBPS - IT - SO - 2016-14 February Shift - 2 - Question Answers - with - Book Link - Explanation - Tricks

1. In ______all records contain the same data items with the same amount of space assigned to each data item. 
(A) Finite records 
(B) Fixed length records 
(C) Indexed records 
(D) Variable length records 
(E) Uniform records 

2. Databases are managed with–
(A) Roles
 (B) Hardware
 (C) Hardware and Roles 
(D) Programming 
(E) Software

3. Which action is used to display the context menu and the mini toolbar ? 
(A) Double-click
 (B) Move pointer 
(C) Scroll 
(D) Left-click 
(E) Right-click

4. The file extension for an office 2013 Word Template is–
(A) .doc 
(B) .docx
(C) .dotx
(D) .nf 
(E) .temp 

5. TCP and UDP reside at which layer of the OSI model ? 
(A) Data link 
(B) Session 
C) Network 
(D) Transport 
(E) Presentation 

6. A computer containing programs that collectively serve the needs of a large group rather than that of a single user or specialized application is termed ………. 
(A) Complex instruction set computer
 (B) Terminal server 
(C) Web server 
(D) Central Processing Unit 
E) Enterprise server 

7. The virus that attaches itself to macros is called– 
(A) Email virus 
(B) Micro virus 
(C) Trojan horse
 (D) Time bomb 
(E) Macro virus 

8. Which of the following is considered a connection- oriented protocol ? 
(A) ARP 
(B) ICMP 
(C) UDP
 (D) UDP and ARP
 (E) TCP 


9. ………. settings for each user of the database are held within the data dictionary.
(A) View 
(B) Language
(C) Data manipulation 
(D) Browser 
(E) Schema object

10. What is a MAC address in an Ethernet network? 
(A) The address assigned by DHCP 
(B) A TCP/IP address 
(C) A logical address created by the network administrator 
(D) A logical address which is subnet specific 
(E) The physical address assigned by the NIC manufacturer 

11. Malicious software is known as– 
(A) Malware 
(B) Badware 
(C) Maliciousware
 (D) Illegalware 
(E) Disasterware

12. Which of the following refers to a group of terminals or workstations attached to a common control unit or server(s) that share work and may be able to back each other up if one server fails ? 
(A) Cluster 
(B) Serverless backup 
(C) Logical unit 
(D) Attached resource computer network 
(E) Channel bank 

13. The network database model allows each data element to have–
(A) Multiple parent and child records 
(B) Multiple parents records and multiple children records 
(C) Single parent record 
(D) Multiple parents records 
(E) Multiple children records 

14. What value must a C++ destructor return ? 
(A) Destructors do not return a value 
(B) An object of the class 
(C) A status code determining whether the class was destructed correctly 
(D) A pointer or status code 
(E) A pointer to the class 

15. When two people collaborate on an online document at the same time, they are collaborating–
(A) Synchronously 
(B) By Tracking 
(C) In Cloud Edit 
(D) Asynchronously 
(E) Independently 

16. A ………. is a field that links all the data within a record to a unique value. 
(A) Cell
 (B) Attribute 
(C) Primary key 
D) Tuple 
(E) Foreign key 

17. The term internetworking is related to which layer . of the OSI model? 
(A) Presentation layer 
(B) Network layer 
(C) Session layer 
(D) Data link layer 
(E) Application layer 

18. ………. provides a formal method of representing data in a conceptual form and provides the necessary means of manipulation the data held within the database. 
(A) Domain main server 
(B) Web base model 
(C) Operating system 
(D) Database model 
(E) Client server model
[ A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized, and manipulated.]

19. Which among the following is used to write small programs to control Unix functionalities ? 
(A) Shell Commands 
(B) C Language 
(C) Shell script 
(D) Filters 
(E) Special script
[A shell script is a text file that contains a sequence of commands for a UNIX-based operating system.]

20. What is PPP used for? 
(A) It is used to provided communication between two computers. 
(B) It is used to assign IP address. 
(C) It is used to send packets of data from one. "computer system to the other. 
(D) It is used to provide communication between two computers over a serial cable. 
(E) It is used to join two networks over a serial port. 

[ The point-to-point protocol was developed specifically for network connections via serial channels and has asserted itself as the standard for connections between routers.]

21. Which class IP addresses were designed for large networks ? 
(A) B 
(B) A 
(C) D 
(D) C 
(E) E 

22. A round button that you click to select one option from a list of options is called–
(A) A submit button
(B) A radio button 
(C) A tab 
(D) A hyperlink 
(E) A checkpoint 

23. Hierarchical databases are useful for mapping–
(A) Other than those given as options 
(B) One to one 
(C) Many to many 
(D) One to one and many to many 
(E) One to many 
[the hierarchical model uses Parent Child Relationships. These are a 1:N mapping between record types.]

24. Which of the following protocols is an example of TCP/IP data link layer protocols? 
(A) IP 
(B) HTTP 
(C) SMTP 
(D) Ethernet 
(E) UDP

25. In Java, when overriding a predefined method, both the original method and the new method must have the same–
(A) method inheritance 
(B) method body 
(C) method signature 
(D) parameter names 
(E) method signature and inheritance 

26. The feature that opens a window on your desktop where you can browse for file stored on your computer is called– 
(A) The Display Option 
(B) The Start page 
(C) The Control Panel 
(D) The Desktop Portal 
(E) The File Explorer 

27. A value a field will assume unless an explicit value is entered for that field best defines–
(A) designated value 
(B) normalized value
(C) default value 
(D) replicated value 
(E) assigned value

28. A computer host or small network inserted as a 'neutral zone' between a company's private network and the outside public network is called–
(A) sheep dip computer 
(B) VPN 
(C) firewall 
(D) man in the middle 
E) DMZ

29. In object-oriented databases, when your application queries for some data, what is returned is–
(A) data only 
(B) codes 
(C) output 
(D) data and code (CISSP All-in-One Exam Guide)
(E) objects and classes 

30. Data dictionary is a tool used to centrally manage parts of a database by controlling ………. within the database. 
(A) Portion of data 
(B) Programming 
(C) Keys 
(D) Metadata 
(E) Figures 

31. Which of the following is the least secure communications protocol? 
(A) EAP and PAP
 (B) CHAP 
(C) EAP 
(D) IPsec 
(E) PAP

32. Which among the following interacts directly with system hardware? 
(A) Applications 
(B) Kernel 
(C) Shell 
(D) Commands 
(E) Core space 


33. Partition defined by non-overlapping ranges of values for a specified attribute best describes–
(A) continuous partitioning 
(B) composite partitioning 
(C) hash partitioning 
(D) range partitioning 

(E) transitive partitioning 

34. Which method of conversion to a new system is, the highest risk and the lowest cost (assuming all goes well) ? 
(A) Phased
(B) Direct 
(C) Parallel 
(D) Focused 
(E) Pilot 

35. To select multiple non-contiguous folders or files to copy or move them, which key is used in Windows? 
(A) Ctrl 
(B) Alt 
(C) Scroll Lock 
(D) Tab 
(E) Shift 

36. One way to open the Help menu quickly is to press ………. shortcut key. 
(A) F2
(B) F12 
(C) Windows 
(D) F6 
(E) F1

37. Java software was designed–

(A) to make writing Web pages easy for the new user. 
(B) to run on any computer or computing device regardless of its operating system. 
(C) to make software development appear complex. 
(D) as a new platform for the Internet. 
(E) to be downloaded from the Internet as required.


38. Which of the following is not one of the four types of database access? 
(A) Compressed
 (B) Public 
(C) Distributed
 (D) Shared 
(E) Individual


39. Which of the following statements is false? 
(A) Unix supports multiple users.
 (B) Shell takes care of inter process communication. 
(C) Unix and Linux are operating systems. 
(D) Linux is an open-source operating system and the source code is shared 
(E) Shell provides the feature of I/O redirection. 


40. Which of the following enables multi-tasking in UNIX ? 

(A) Multi programming 
(B) Time sharing 
(C) Modularity 
(D) Multi-utility 
(E) Multi-user 

41. Which is the core of the operating system? 
(A) Script 
(B) Commands 
(C) Shell 
(D) Core space
(E) Kernel 

42. If every non-primary key attribute is functionally dependent on the whole primary key, then the relation is in at least–
(A) first normal form 
(B) third normal form 
(C) second normal form 
(D) fourth normal form 
(E) fifth normal form 

43. A virtual relation defined by the database administrator in order to keep subjects from viewing certain data is known as– 
(A) Attribute 
(B) Cell 
(C) View 
(D) Primary key
 (E) Data dictionary 

44. Which of the following is the phase when everyone involves attempt to understand why the project is needed and what the scope of the project entails? 
(A) Project development 
(B) Project documentation and standards 
(C) Project initiation 
(D) Project completion
(E) Project proposal 

45. What is the name for the system of hardware and software that blocks unauthorised users inside and outside the organization from entering? 
(A) Firewall
(B) Backbone 
(C) Register 
(D) Gate 
(E) Choke

46. Which feature provides a cloud storage' area where you can store files in a private and secure online location that you can access from any computer? 
(A) Sky Drive 
(B) Wireless Drop 
(C) Network 
(D) Over Drive 
(E) Cloud Connect 

47. The scrambling of code is known as–
(A) Firewalling 
(B) Deception 
(C) Password-proofing 
(D) Encryption 
(E) Permuting 

48. Which phase of the SDLC involves acquiring any new hardware that might be required? 
(A) Systems design 
(B) Systems development 
(C) Systems implementation 
(D) Systems analysis 
(E) Systems maintenance 

49. Software programs that close potential security breaches in an operating system are known as–
(A) refresh patches 
(B) security breach fixes 
(C) security patches
(D) security repairs 
(E) fresh patches 

50. ………. sets a relationship between two tables that has a matching or same attribute. 
(A) Foreign key 
(B) Primary key 
(C) Schema objects 
(D) Data dictionary 
(E) Report generator 

SBI IBPS SO IT 2016- 17 - DBMS Question Solve

1. An attribute whose value is unique across all occurrences of a relation best describes a:
a) primary key
b) data marker
c) recursive key
d) join attribute
2. A relation that contains a minimum amount of redundancy and allows users to insert, modify, and delete the rows without errors or inconsistencies best describes a:
a) denormalized relation
b) well-structured relation
c) sequentially organized relation
d) physical file
3. If every nonprimary key attribute is functionally dependent on the whole primary key, then the relation is in at least:
a) third normal form
b) fifth normal form
c) fourth normal form
d) second normal form
4. If there are no functional dependencies between two (or more) nonprimary key attributes, this describes:
a) second normal form
b) fifth normal form
c) fourth normal form
d) third normal form
5. Which of the following E-R structures places the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side?
a) regular entity
b) binary or unary 1:1 relationship
c) binary 1:N relationship
d) binary or unary M:N relationship
6. The creation of a relation with the primary key associated with the relationship, plus any nonkey attributes of the relationship and the primary keys of the related entities is the relational representation associated with a:
a) regular entity
b) binary or unary 1:1 relationship
c) binary 1:N relationship
d) binary or unary M:N relationship
7. A coding scheme recognized by system software for representing organizational data best defines a:
a) hashing algorithm
b) data type
c) hyperlink
d) tuple
8. Which of the following is not an Oracle8i data type?
a) BLOB
b) DATE
c) VARCHAR2
d) EXP7
9. A value a field will assume unless an explicit value is entered for that field best defines:
a) default value
b) assigned value
c) replicated value
d) normalized value
10. A special field value, distinct from 0, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown best defines:
a) BLOB value
b) null value
c) nonspecific value
d) hashed value
11. The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:
a) denormalization
b) intermediation
c) transition
d) hashing
12. Partitions are defined by nonoverlapping ranges of values for a specified attribute best describes:
a) composite partitioning
b) range partitioning
c) hash partitioning
d) transitive partitioning
13. A named set of table rows stored in a contiguous section of secondary memory best describes a(n):
a) pointer
b) entity
c) relation
d) physical file
14. When the rows are stored either sequentially or nonsequentially and a table is created that allows software to locate individual rows, this method is called:
a) sequential file organization
b) hashed file organization
c) indexed file organization
d) direct addressing
15. Each of the following is a true statement concerning hashed file organization except:
a) concerning storage space, extra space may be needed to allow for addition and deletion of records
b) sequential retrieval on the primary key is impractical
c) the deletion of rows is not very easy
d) random retrieval on the primary key is moderately fast