Home >> DATABASE SYSTEM VERY IMPORTANT MCQ
1. In a relational schema , each tuple is divided into fields called ?
Correct Answer is: Domains
2. A top to bottom relationship among the items in a database is established by a ?
Correct Answer is: Hierarchical Schema
3. What is the full form of DBMS ?
Correct Answer is: Database Management System
4. What is a database ?
Correct Answer is: Organized collection of data or information that can be accessed, updated, and managed
5. Who created the first DBMS ?
Correct Answer is: Charles Bachman
6. What is Database management system ?
Correct Answer is: DBMS stores, modifies and retrieves data
7. In which of the following formats data is stored in the database management system ?
Correct Answer is: Table
8. Which of the following is not a feature of DBMS ?
Correct Answer is: Single-user Access only
9. Which of the following is a component of the DBMS ?
Correct Answer is: all
10. A good query system ?
Correct Answer is: Allows non programmers to access information stored in a database
11. A logical schema ?
Correct Answer is: is a standard way of organizing information into accessible parts
12. Which of the following is known as a set of entities of the same type that share same properties, or attributes ?
Correct Answer is: Entity set
13. What is information about data called ?
Correct Answer is: Meta data
14. Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation ?
Correct Answer is: Data Definition Language
15. A Database Management System is a type of _________software ?
Correct Answer is: It is a type of system software
16. Which of the following can be considered as the maximum size that is supported by FAT ?
Correct Answer is: 4GB
17. The term "NTFS" refers to which one of the following ?
Correct Answer is: New Technology File System
18. Which of the following can be considered as the maximum size that is supported by NTFS ?
Correct Answer is: 4GB
19. A huge collection of the information or data accumulated form several different sources is known as ?
Correct Answer is: Data Warehouse
20. Which of the following can be used to extract or filter the data & information from the data warehouse ?
Correct Answer is: Data mining
21. What does an RDBMS consist of ?
Correct Answer is: Collection of Tables
22. _____________ is a hardware component that is most important for the operation of a database management system ?
Correct Answer is: High speed, large capacity disk to store data
23. The ability to query data, as well as insert, delete, and alter tuples, is offered by ?
Correct Answer is: Data Manipulation Langauge
24. __________ is a set of one or more attributes taken collectively to uniquely identify a record ?
Correct Answer is: Super key
25. Which command is used to remove a relation from an SQL ?
Correct Answer is: Drop table
26. Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places ?
Correct Answer is: Data Redundancy
27. Which one of the following refers to the "data about data" ?
Correct Answer is: Meta Data
28. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored ?
Correct Answer is: Physical Level
29. To which of the following the term "DBA" referred ?
Correct Answer is: Database Administrator
30. In general, a file is basically a collection of all related ?
Correct Answer is: Records
31. Which of the following set should be associated with weak entity set for weak entity to be meaningful ?
Correct Answer is: Identifying set
32. Which of the following command is correct to delete the values in the relation teaches ?
Correct Answer is: Delete from teaches
33. Procedural language among the following is ?
Correct Answer is: Relational algebra
34. ________ operations do not preserve non-matched tuples ?
Correct Answer is: Inner join
35. The term "Data" refers to ?
Correct Answer is: Row Facts and figures
36. Which of the following refers to the number of tuples in a relation ?
Correct Answer is: Cardinality
37. Which one of the following is a type of Data Manipulation Command ?
Correct Answer is: Delete
38. A form defines ?
Correct Answer is: Both a and b
39. A form defines ?
Correct Answer is: Both a and b
40. A command that lets you change one or more fields in a record is ?
Correct Answer is: Modify
41. The modify operation is likely to be done after ?
Correct Answer is: look up
42. What is the abbreviation used for a software package that permits the user to create , retrieve and maintain records in a database ?
Correct Answer is: DBMS
43. Which of the following command is a type of Data Definition language command ?
Correct Answer is: Create
44. In a relation database, every tuples divided into the fields are known as the ?
Correct Answer is: Domains
45. The term "TCL" stands for ?
Correct Answer is: Transaction Control Language
46. In the relational table, which of the following can also be represented by the term "attribute"?
Correct Answer is: Column
47. Which of the following refers to the number of attributes in a relation ?
Correct Answer is: Degree
48. Which of the following is used in the application programs to request data from the database management system ?
Correct Answer is: Data Manipulation language
49. Which of the following commands is used to save any transaction permanently into the database ?
Correct Answer is: Commit
50. Which one of the following commands is used to restore the database to the last committed state?
Correct Answer is: Rollback
51. The database management system can be considered as the collection of ______ that enables us to create and maintain the database ?
Correct Answer is: Programs
52. The term "DFD" stands for ?
Correct Answer is: Data flow diagram
53. Which of the following is the best way to represent the attributes in a large db ?
Correct Answer is: Concatenation
54. Which of the following is the subset of SQL commands used to manipulate Oracle Structures, including tables ?
Correct Answer is: Data Definition Language
55. Which of the following is known as the process of viewing cross-tab with a fixed value of one attribute ?
Correct Answer is: Slicing
