Computer Questions Quiz - 10 for SBI & IBPS Exam 2015

1. Which of the following is a valid SQL type?

• (1) CHARACTER
• (2) NUMERIC
• (3) FLOAT
• (4) DATE
• (5) All of the above

Ans. (5) 

2. Which of the following operations need the participating relations to be union compatible?

• (1) UNION
• (2) INTERSECTION
• (3) DIFFERENCE
• (4) All of the above
• (5) None of these

Ans. (4) 

3. Which of the following is a legal expression in SQL?

• (1) Admission scheduler
• (2) Dispatcher scheduler
• (3) Swapping scheduler
• (4) Process scheduler
• (5) Path scheduler

Ans. (2) 

4. Which of the following operation is used if we are interested in only certain columns of a table?

• (1) PROJECTION
• (2) SELECTION
• (3) UNION
• (4) JOIN
• (5) INTERSECT

Ans. (1) 

5. It is better to use files than a DBMS when there are _______ .

• (1) Stringent real-time requirements
• (2) Multiple users who wish to access the data
• (3) Complex relationships among data
• (4) All of the above
• (5) None of these

Ans. (2) 

6. The RDBMS terminology for a row is _______?

• (1) Tuple
• (2) Relation
• (3) Attribute
• (4) Degree
• (5) Field

Ans. (1) 

7. The conceptual model is _______ .

• (1) dependent on hardware
• (2) dependent on software
• (3) dependent on both hardware and software
• (4) independent of both hardware and software
• (5) None of these

Ans. (4) 

8. The full form of DDL is _______?

• (1) Dynamic Data Language
• (2) Detailed Data Language
• (3) Data Definition Language
• (4) Data Derivation Language
• (5) Data Dimensional Language

Ans. (3)

9. Which of the following is an advantage of a View?

• (1) Data security
• (2) Derived columns
• (3) Hiding of complex queries
• (4) All of the above
• (5) None of these

Ans. (4) 

10. What is a relationship called when it is maintained between two entities?

• (1) Unary
• (2) Binary
• (3) Ternary
• (4) Quaternary
• (5) 1 and 2 

Ans. (2)