Professional Knowledge Quiz for IBPS SO IT Officer 2017 |

Q1. The relationship between DEPARTMENT and EMPLOYEE is a

(a) One-to-one relationship

(b) One-to-many relationship

(d) Many-to-one relationship

(e) none of the above

Q2.The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

(a) BEGIN

(b) SET TRANSACTION

(d) COMMIT

(e) none of the above

Q3. ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

(a) Consistency

(b) Atomicity

(d) Isolation

(e) None of the above

Q4.__________ states that only valid data will be written to the database.

(a) Consistency

(b) Atomicity

(d) Isolation

(e) none of the above

Q5.The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as

(a) Atomicity

(b) Durability

(d) All of the mentioned

(e) consistency

Q6. A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.

(a) Idle

(b) Waiting

(d) Ready

(e) none of the above

Q7. What are the ways of dealing with deadlock?

(a) Deadlock prevention

(b) Deadlock recovery

(d) All of the mentioned

(e) Deadlock breakup.

Q8. SQL can be used to:

(a) Create database structures only.

(b) Query database data only.