11. Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
- DML(Data Manipulation Language)
- Query
- Relational Schema
- DDL(Data Definition Language)
Answer : A Explanation: The term “DML” stands for the Data Manipulation Language used to perform the required changes in the relation’s values and hence, Option A is correct.
12. What are the different view to present a Table?
- Pivote TableView
- Design View
- Datasheet View
- All Of Above
Answer : D Explanation: Different view to present a table are: Pivote TableView, Design View, Datasheet View.
13. E-R model uses this symbol to represent weak entity set
- Diamond
- Dotted Rectangle
- Doubly Outlined Rectangle
- None Of These
Answer : C Explanation: E-R model uses Doubly Outlined Rectangle 13. E-R model uses this symbol to represent weak entity set.
14. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
- Candidate key
- Sub key
- Foreign key
- Super key
Answer : D Explanation: Super key is a set of one or more attributes taken collectively to uniquely identify a record. So option D is correct.
15. A top-to-bottom relationship among the items in a database is established by a
- Hierarchical schema
- Network schema
- Relational Schema
- All of the above
Answer : A Explanation: A top-to-bottom relationship among the items in a database is established by a Hierarchical schema. So option A is correct.
16. A transaction completes its execution is said to be
- Saved
- Committed
- Loaded
- Rolled
Answer : B Explanation: None.
17. ROLLBACK in a database is ____ statement.
- DDL
- DML
- TCL
- DCL
Answer : C Explanation: ROLLBACK in a database is TCL statement.
18. The data model which describes how the data is actually stored is:
- Internal Model
- Logical Model
- External Model
- None Of These
Answer : A Explanation: The data model which describes how the data is actually stored is reffered as internal model. So option A is correct.
19. A Database Management System is a type of ___________ software.
- It is a kind of application software
- It is a type of system software
- It is a kind of general software
- Both B and C
Answer : B Explanation: The DBMS (also called Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well and hence only statement B is correct.
20. The file organization that provides very fast access to any arbitrary record of a file is:
- Ordered file
- Unordered file
- B-Tree
- Hashed file
Answer : D Explanation: The file organization that provides very fast access to any arbitrary record of a file is hashed file. SO, option D is correct.
Pingback: Operating System MCQ (Multiple Choice Questions and Answers) - cozmocard
Pingback: JavaScript MCQ Questions and Answers - cozmocard
Pingback: Software Engineering MCQ Questions And Answers - cozmocard