12th class (Fsc) computer unit 1 MCQs
51. A filed is to a record as:
a. Files are to tables
b. Data are to files
c. Attributes are to columns
d. A column is to a row
52. A database containing all students in a class would store Roll No of a student in:
a. Cell
b. Record
c. File
d. Field
53. A database containing all students in a class would store the information of individual students in:
a. Cell
b. Record
c. File
d. Field
54. Which of the following represents a collection of concepts that are used to describe the structure of a database?
a. Data structure
b. Data warehouse
c. Data type
d. Data model
55. Which of the following data model is more flexible?
a. Relational data model
b. Network data model
c. Object data model
d. Hierarchical data model
56. A database is an organized collection of ……… related data.
a. Loosely
b. Logically
c. Badly
d. Physically
57. Which of the following database model is also referred an inverted tree?
a. Relational
b. Hierarchical
c. Object
d. Network
58. Which one refers to the correctness and consistency of data?
a. Data integrity
b. Data independence
c. Data model
d. Data integration
59. Data inconsistency is a caused by:
a. Independent data
b. Organized data
c. Redundant data
d. Integrated data
60. Multiple copies of the same data is referred to as:
a. Data redundancy
b. Data integrity
c. Data isolation
d. Data inconsistency
61. All records in a file have the same:
a. Contents
b. Structure
c. Both A & B
d. None
62. A set of related files created and managed by a (DBMS)is called:
a. Database
b. Filed
c. None
d. Record
63. Which of the following is an example of a database?
a. Student records
b. Phone book
c. Library catalog
d. All
64. The most commonly used database model in current database development is:
a. Network
b. Rotational
c. Object oriented
d. Hierarchical
65. Which of the following data model has general shape of an organization chart?
a. Relational model
b. Hierarchical model
c. Object model
d. Network model
66. Data that causes inconsistency lacks:
a. Data redundancy
b. Good data
c. Data anomaly
d. Data integrity
67. Which of the following database models is often referred to as an Inverted Tree?
a. Relational
b. Hierarchical
c. Object oriented
d. Network
68. SQL is a(n):
a. Object oriented language
b. Unstructured language
c. Software
d. Structured language
69. SQL stands for:
a. Structured Query language
b. Sort-Query- List
c. Self Quantative language
d. Self- Quantifying- Language
70. SQL can be used to:
a. Modify database data only
b. Create database structures only
c. Query database data only
d. All
71. Which of the following is handled by DBMS?
a. Data independence
b. Data integrity
c. Data security
d. All
72. DBMS stands for:
a. Data Business Model System
b. Database Modeling System
c. Data Business Management Service
d. Database Management System
73. Which of the following is not an advantage of database systems?
a. Backup/recovery
b. Redundant data
c. Better data quality
d. Data independence
74. Which of the following enables the user to modify data structures without affecting existing programs that use them?
a. Data integration
b. Data dependence
c. Data relationships
d. Data independence
75. Database application contain procedures for:
a. Processing queries
b. Adding records
c. Deleting records
d. All
76. Which of the following is related to a component of DBMS known as personal?
a. Database administrator
b. Application programmer
c. End users
d. All
77. The major component of DBMS is called:
a. Data Manager
b. Database Manager
c. File Manager
d. All
78. Duplicate data in multiple data files is:
a. Data integrity
b. Data redundancy
c. Data multiplication
d. None
79. The description of structure and organization of data in a database is contained in:
a. Structured query language
b. Data dictionary
c. Data mine
d. None
80. A request for information from a database in database terminology is called:
a. Table
b. Report
c. Screen
d. Letter
81. A printed or onscreen display of data or information in the database is called a(n):
a. Query
b. Entity
c. Screen
d. Report
82. Which of the following is not a database management system?
a. Oracle
b. MS Access
c. MS SQL
d. None
Click here to go directly on chapter no.2