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