Database MCQ (DBMS Most Important Question)

Database MCQ. DBMS Most important objective multiple choice quiz questions and answers PDF for computer related competitive exams and interview.

1. Database MCQ

1. Data Manipulation language is used to create_____.
Ans. Object

2. Every record of Relation is called ______.
Ans. Tuple

3. Architecture of the database can be viewed as ______.
Ans. Three levels

4. MVP architecture is followed in ____
Ans. CMS

5. What does “CIA” stands for in information security?
Ans. Confidentiality, integrity and availability

6. What is Privacy?
Ans. It ensure that individual has the right to use the information and allow to use that information.

7. A database contains ________ to help management of information.
(a) schemes
(b) tables
(c) queries/ views
(d) all of them
Ans. d

8. Creation and modification of databases and tables is called______ .
(a) update
(b) retrieval
(c) data definition
(d) administration
Ans. c

9. Querying and selecting data from a table is called ______ .
(a) data update
(b) data retrieval
(c) data definition
(d) database administration
Ans. b

10. Defining the users, passwords and roles for users to control a database is called _______.
(a) data update (b) data retrieval
(c) data definition (d) database administration
Ans. d

11. Oracle, IBM DB2, SAP HANA, MySQL, PostgreSQL, Microsoft SQL server, Sybase,
MongoDB, MariaDB& SQLite are the most popular ______ tools.
(a) graphics& animation
(b) image editing
(c) document typesetting
(d) database management
Ans. d

2. 12. Oracle, IBM DB2, SAP HANA & Microsoft SQL server are database management _____ tools.
(a) professional (paid)
(b) free/ open source
(c) outdated
(d) unsuitable
Ans. a

13. MySQL, PostgreSQL, MariaDB& SQLite are ______ database management tools.
(a) professional (paid)
(b) free/ open source
(c) outdated
(d) unsuitable
Ans. b

14. Among the professional (paid) databasemanagement systems, ____is themost popular.
(a) IBM DB2
(b) SAP HANA
(c) Oracle
(d) Microsoft SQL Server
Ans. c

15. ____is the most popular database management system in the embedded (mobile phones/
tablets) category.
(a) MySQL (b) SQLite
(c) Oracle (d) PostgreSQL
Ans. b

16. A database management system requires to fulfill ______ to be called a relational database
system.
(a) Codd's 12 Rules
(b) 10 commandments of Moses
(c) 3 laws of Isac Newton
(d) 2 laws of Kirchoff
Ans. a

17. Codd's Rule 0 defines a relational database system as the one which manages data through
________ capabilities.
(a) hierarchical database (b) network database
(c) relational database (d) none of them
Ans. c

18. Codd's Rule 1 is otherwise called _______rule and specifies that all information should be held
in tables.
(a) information (b) access
(c) null value (d) database description
Ans. a

19. Codd's Rule 2 is otherwise called ______rule and it guarantees that each and every
information stored in a database is accessible.
(a) information (b) access
(c) null value (d) database description
Ans. b

3. 20. Codd's Rule 3 is otherwise called _______rule and it specifies that there should be unique
NULL value to denote missing information.
(a) information
(b) access
(c) null value
(d) database description
Ans. c

21. Codd's Rule 4 is otherwise called ______ rule and it states that metadata should also be
stored as normal data.
(a) information
(b) access
(c) null value
(d) database description
Ans. d

22. Codd's Rule 5 is otherwise called ______ rule and it permits commands for creating,
managing, rollingback and authorizing data access.
(a) data sublanguage
(b) view updating
(c) insert, update, delete
(d) independence from physical storage
Ans. a

23. Codd's Rule 6 is otherwise called ______rule and it specifies that every view which is
theoretically updateable should be updateable through thesystem.
(a) data sublanguage
(b) view updating
(c) insert, update, delete
(d) independence from physical storage
Ans. b

24. Codd's Rule 7 is otherwise called ________rule and it specifies that insertion, delete and
update of datashould also be based on relational principles.
(a) data sublanguage
(b) view updating
(c) insert, update, delete
(d) independence from physical storage
Ans. c

25. Codd's Rule 8 is otherwise called _______rule and it specifies that thetype of physical storage
media should not affect the access methods of datathrough the database management system.
(a) data sublanguage
(b) view updating
(c) insert, update, delete
(d) independence from physical storage
Ans. d

26. Codd's Rule 9 is otherwise called ______rule and application programs are una_ected by
changes to thedata unless it impairs the results of theapplication program.
(a) logical data independence (b) integrity independence
(c) distribution independence (d) non-subversion
Ans. a

4. 27. Codd's Rule 10 is otherwise called ________rule and it specifies thatdata integrity conditions
should be defined in the database management system and not in the application program.
(a) logical data independence
(b) integrity independence
(c) distribution independence
(d) non-subversion
Ans. b

28. Codd's Rule 11 is otherwise called _____rule and it specifies that the end user should feel that
the data isstored at one place, although the storage may be distributed on several computers.
(a) logical data independence
(b) integrity independence
(c) distribution independence
(d) non-subversion
Ans. c

29. Codd's Rule 12 is otherwise called ______ rule and it specifies that data access should be
provided onlythrough the relational model, withoutexposing the low level storage APIs tothe end
user.
(a) logical data independence
(b) integrity independence
(c) distribution independence
(d) non-subversion
Ans. d

30. Object oriented databases are based onthe concept of ______ , similar to object oriented
programming.
(a) SQL (b) table
(c) objects (d) column
Ans. c

31. Relational databases are ______ oriented.
(a) method (b) table
(c) objects (d) program
Ans. b

32. OODB is more accessible from ______
(a) SQL .
(b) Object Oriented Programming Languages like C++, Java, Smalltalk, Delphi, etc.
(c) pen drive
(d) wired connection
Ans. b

33. OODB with support for SQL (like relational database) is called_______.
(a) hybrid object relational database (b) programming
(c) pure relational database (d) NOSQL database
Ans. a

34. Objects of OODB may be accessed using ______ .
(a) NOSQL
(b) SQL
(c) Object Query Language (OQL)
(d) none of them
Ans. c

5. 35. Object schema in OODB use data types ______ to object oriented programming languages.
(a) unrelated
(b) unconnected
(c) similar
(d) not connected
Ans. c

36. ODMG stands for _____, which isthe consortium in charge of the standardizing the
development of ObjectOriented Data Base.
(a) Object Data Management General
(b) Object Data Management Group
(c) Object Digital Management Group
(d) Object Data Maintenace Group
Ans. b

37. XQuery is ______ language.
(a) XML based Query
(b) Structured Query
(c) programming
(d) object oriented programming
Ans. a

38. Object Oriented Data Base is suitablefor cases in which relational tables are ______to design
and manipulate.
(a) too complex (b) too easy
(c) too simple (d) too plain
Ans. a

39. The system of managing databases using models other than tables and retrieving data using
methods other than or related to SQL is called ______ datamanagement system.
(a) relational database
(b) table oriented
(c) Query oriented
(d) NOSQL
Ans. d

40. NOSQL databases permit updates which _______ and are prone to data loss.
(a) may be incomplete
(b) are complete
(c) which are immediately effected
(d) which are subject to strict rules of integrity
Ans. a

41. A good database table has ______naming.
(a) inconsistent (b) consistent
(c) unrelated (d) haphazard
Ans. b

42. The name of table and column should be in ______.
(a) plural (b) vernacular
(c) incoherent words (d) singular
Ans. d

6. 43. In a well defined database, names of database, table and column ______ contain space.
(a) do (b) may
(c) should not (d) should
Ans. c

44. As a good practice in design of database tables, it is advisable to have_______ for indexing.
(a) Integer ID column
(b) no column
(c) all columns
(d) none of them
Ans. a

45. As a good practice, select queries should have contain ______column names.
(a) * for
(b) blank for
(c) required field names
(d) none of them
Ans. c

46. In defining a database table, it is a good practice to define frequently searched columns with
_______.
(a) primary key
(b) foreign key
(c) either a or b
(d) neither a nor b
Ans. c

47. When a column value cannot be null, it is a good practice to include ______ declaration for
that column when creating the table.
(a) DEFAULT 0
(b) DEFAULT < SOME V ALUE >
(c) NULL
(d) NOT NULL
Ans. d

48. When a column value should be filled with a default of 0 or any other value, it is a good
practice to include _______ declaration for that column when creating the table.
(a) DEFAULT 0
(b) DEFAULT < SOME V ALUE >
(c) either a or b
(d) NOT NULL
Ans. c

49. The process of dividing the data in suitable tables to avoid repetition of data is called _____ .
(a) normalization (b) data insertion
(c) data deletion (d) data updation
Ans. a

50. The databaserule which permits inserting a row without any specific value for
a column is called ______.
(a) null rule (b) unique column rule
(c) primary key rule (d) referential integrity rule
Ans. a

7. 51. _______in database management permits inserting a new value only if there is no previous
entry having the same value.
(a) null rule
(b) unique column rule
(c) primary key rule
(d) referential integrity rule
Ans. b

52. ______in database management permits unique values to be used for searching and indexing
of data.
(a) null rule
(b) unique column rule
(c) primary key rule
(d) referential integrity rule
Ans. c

53. ______in database management ensures that key values in one table are referenced in a
related table.
(a) null rule
(b) unique column rule
(c) primary key rule
(d) referential integrity rule
Ans. d

54. ______ in database management ensures that user defined constraints are enforced to restrict
deletion or updating of rows.
(a) Complex integrity checking rule
(b) unique column rule
(c) primary key rule
(d) referential integrity rule
Ans. a

55. _____ rule in data reference integrity ensures that referred data is not deleted or updated.
(a) restrict
(b) set to null
(c) set to default
(d) cascade
Ans. a

56. ______ rule in data reference integrity ensures that whenever data is deleted, all
dependencies to deleted data are set to null value.
(a) restrict
(b) set to null
(c) set to default
(d) cascade
Ans. b

57. ______ rule in data reference integrity ensures that whenever data isdeleted, all dependencies
are set to their default value.
(a) restrict (b) set to null
(c) set to default (d) cascade
Ans. c

8. 58. _____ rule in data reference integrity ensures that whenever data is updated or deleted, all
dependency rows are correspondingly updated or deleted.
(a) restrict
(b) set to null
(c) set to default
(d) cascade
Ans. d

59. ______rule in data reference integrity ensures that no action is takenwhen attempt is made to
delete or update referenced data.
(a) No action
(b) Set to null
(c) Set to default
(d) Cascade
Ans. a

60. The practice of specifying only specified values are entered in particular column (like NOT
NULL, DEFAULT 0) is called ______.
(a) integrity rule
(b) integrity constraint
(c) updation rule
(d) relational rule
Ans. b

61. Creating relationship for data in one table with that in another table in database is called ____.
(a) integrity (b) constraint
(c) relationship (d) none of them
Ans. c

62. _______is used to relate data in one table to that in another table.
(a) key (b) column
(c) row (d) table
Ans. a

63. A key which helps to connect data in one secondary table to that in a primary table is called
(a) primary key (b) foreign key
(c) unique (d) none of them
Ans. b

64. A key which can be used as a prospective primary key (in the future) is called ______.
(a) primary key
(b) foreign key
(c) alternate key or candidate key
(d) none of them
Ans. c

65. A query which creates database, table, inserts rows, deletes rows & updates existing values is
called ______ .
(a) update query
(b) select query
(c) both a & b
(d) neither a nor b
Ans. a

9. 66. A query which selects values based from a table is called ______.
(a) update query
(b) select query
(c) both a & b
(d) neither a nor b
Ans. b

67. The clause which specifies constraints for selecting or updating data is called _____clause.
(a) GROUP BY (b) HAVING
(c) ORDER BY (d) WHERE
Ans. d

68. The clause which specifies rule for data aggregation is called ______clause.
(a) GROUP BY (b) HAVING
(c) ORDER BY (d) WHERE
Ans. a

69. The clause which specifies rule for selecting data needed for aggregation is called ___clause.
(a) GROUP BY (b) HAVING
(c) ORDER BY (d) WHERE
Ans. b

70. The clause which specifies the rule for sorting of data is called _____ clause.
(a) GROUP BY (b) HAVING
(c) ORDER BY (d) WHERE
Ans. c

71. The clause which specifies that data should be sorted in descending order is called __ clause.
(a) DESC (b) HAVING
(c) ORDER BY (d) WHERE
Ans. a

72. Adding _____ keyword to an integer field permits automatic increment to the record number.
(a) primary key
(b) key
(c) auto increment
(d) automatic
Ans. c

73. In the relational model, cardinality is termed as:
a) A number of tuples b) A number of attributes
c) A number of tables d) A number of constraints
Ans. a

74. Relational calculus is a
a) Procedural language b) Non-Procedural language
c) Data definition language d) High-level language
Ans. b

75. The view of total database content is____
a) Conceptual view b) Internal view
c) External view d) Physical view
Ans. a

10. 76. DML is provided for _____
a) Description of the logical structure of a database
b) The addition of new structure in the database system
c) Manipulation & Processing of the database
d) Definition of a physical structure of the database system
Ans. c

77. The Database Schema is written in____
a) HLL b) DML c) DDL d) DCL
Ans. c

78. In the architecture of a database system external level is the
a) Physical level b) Logical level
c) Conceptual level d) View level
Ans. d

79. An entity set that does not have sufficient attributes to form a primary key is a
a) Strong entity set b) weak entity set
c) simple entity set d) primary entity set
Ans. b

80. In Hierarchical model records are organized as ___
a) Graph b) List c) Links d) Tree
Ans. d

81. In case of entity integrity the primary key may be
a) not Null b) Null c) Both Null & not Null d) Any value
Ans. a

82. The language used in application programs to request data from the DMBS is referred to as
a) HLL b) DML c) DDL d) DCL
Ans. b

83. A logical schema
a) is the entire database
b) is a standard way of organizing information into accessible parts
c) describes how data is actually stored on disk
d) Both A and C
Ans. a

84. Related fields in a database are grouped to form a
a) data file b) data record c) menu d) bank
Ans. b

85. The database environment has all of the following components except:
a) users b) separate files c) database d) database administrator
Ans. a

86. The language which has recently become the defacto standard for interfacing application
programs with relational database system is
a) Oracle b) SQL
c) Dbase d) 4GL
Ans. b

11. 87. A Report generator is used to
a) update files b) Print files on paper c) data entry d) delete files
Ans. b

88. The property/properties of a database is/are:
a) It is an integrated collection of logically related records
b) It consolidates separate files into a common pool of data records
c) Data stored in a database is independent of the application programs using it
d) All of the above
Ans. d

89. The DBMS language component which can be embedded in a program is
a) The data definition language (DDL)
b) The data manipulation language (DML)
c) The database administrator (DBA)
d) A query language
Ans. b

90. A relational database developer refers to a records as _____
a) Criteria b) A relation c) A tuple d) An attribute
Ans. c

91. The relational model feature is that there
a) is no need for primary key data
b) is much more data independence than some other database models.
c) are explicit relationships among records
d) are tables with many dimensions
Ans. b

92. Conceptual design
a) is a documentation technique.
b) needs data volume and processing frequencies to determine the size of the database
c) involves modeling independent of the DBMS
d) is designing the relational model
Ans. c

93. A subschema expresses
a) the logical view b) the physical view
c) the external view d) all of these
Ans. c

94. Count function in SQL returns the number of
a) values
b) distinct values
c) groups
d) columns
Ans. a

95. Which of the following statements is false?
a) The data dictionary is normally maintained by the database administrator
b) Data element in the database can be modified by changing the data dictionary
c) The data dictionary contains the name and description of each data element.
d) A data dictionary is a tool used exclusively by the database administrator
Ans. b

12. 96. An advantage of the database management approach is
a) data is dependent on programs.
b) data redundancy increases
c) data is integrated and can be accessed by multiple programs.
d) None of these
Ans. c

97. A DBMS query language is designed to
a) support end-users who use English-like commands
b) support in the development of complex applications software
c) specify the structure of a database
d) all of these
Ans. d

98. The statement in SQL which allows changing the definition of a table is
a) Alter b) Update c) Create d) select
Ans. a

99. Relational Algebra is
a) Data Definition language
b) Meta language
c) Procedural Query Language
d) None of these
Ans. c

100. Key to represent the relationship between tables is called
a) Primary key b) Secondary key c) Foreign key d) None of these
Ans. c

101. The file organization that provides very fast access to any arbitrary record of a file is
a) Ordered file b) Unordered file c) Hashed file d) B-tree
Ans. c

102. DBMS helps achieve
a) Data independence b) Centralised control of data
c) Neither A or B d) Both A and B
Ans. d

103. Which of the following are the properties of entities?
a) Groups b) Tables c) Attributes d) Switchboards
Ans. c

104. The conceptual model is
a) dependent on hardware
b) dependent on software
c) dependent on both hardware and software
d) independent on both hardware and software
Ans. d

105. Which of the following is a valid SQL type?
a) CHARACTER b) NUMERIC c) FLOAT d) All of these
Ans. d

13. 106. The RDBMS terminology for a row is
a) tuple b) relation c) attribute d) degree
Ans. a

107. The full form of DDL is
a) Dynamic Data language b) Detailed Data language
c) Data Definition language d) Data Derivation language
Ans. c

108. Which are the two ways in which entities can participate in a relationship?
a) Passive and active b) Total and partial
c) Simple and Complex d) All of these
Ans. b

109. A set of possible data value is called
a) Attribute. B) degree. C) tuple. D) domain.
Ans. d

110. Which of the following is another name for the weak entity?
a) Child b) Owner c) Dominant d) All of these
Ans. a

111. NULL is____
a) the same as 0 for integer
b) the same as blank for character
c) the same as 0 for integer and blank for character
d) not a value
Ans. d

112. Which of the following is a record based logical model?
a) Network Model b) Object oriented model
c) E-R Model d) None of these
Ans. a

113. A data dictionary is a special file that contains:
a) The name of all fields in all files
b) The width of all fields in all files
c) The data type of all fields in all files
d) All of these
Ans. d

114. Primary key is combined with a foreign key creates
a) Parent-Child relationship between the tables that connect them
b) Many to many relationships between the tables that connect them
c) Network model between the tables that connect them
d) None of these
Ans. a

115. OODB stands for _____ .
(a) Object Oriented Digital Base
(b) Offset Oriented Data Base
(c) Object Oriented Data Binary
(d) Object Oriented Data Base
Ans. d

14. 116. DBA stands for ______.
Ans. Database Administrator

117. SQL stands for ______.
(a) Synchronized Query Language
(b) Structured Query Language
(c) Simplified Query Language
(d) Structured Question Language
Ans. b

118. DBMS stands for ______ .
(a) Database Maintenance System (b) Database Management Syntax
(c) Database Management System (d) Digital Management System
Ans. c

119. RDBMS stands for _______.
(a) Relational Digital Base Management System
(b) Restricted Data Base Management System
(c) Relational Data Base Management System
(d) Relational Data Binary Management System
Ans. c

120. API stands for ______ .
(a) Applied Programming Interface
(b) Application Programming Interface
(c) Application Programming Integration
(d) Application Provider Interface
Ans. b

121. What is a database mcq
a) Organized collection of information that cannot be accessed, updated, and managed
b) Collection of data or information without organizing
c) Organized collection of data or information that can be accessed, updated, and managed
d) Organized collection of data that cannot be updated
Ans. c

122. Which of the following cannot be used to modify the data in a database
a) delete b) update c) drop d) insert
Ans. c

123. what is an instance of a database
a) The logical design of the database system
b) The entire set of attributes of the database put together in a single relation
c) The state of the database system at any given point of time
d) The initial values inserted into the database immediately after its creation
Ans. c

124. database catalog or dictionary defining descriptive information which is stored in database is
called
a) Constrained data b) Metadata
c) Basic data d) filtered data
Ans. b

15. 125. Which type of data can be stored in the database?
a) Image oriented data
b) Text, files containing data
c) Data in the form of audio or video
d) All of these
Ans. d

126. Select the correct definition of relation in database
a) Subnet of a Cartesian product of list of domains
b) Subset of a Cartesian product of list of tuple
c) Subset of a Cartesian product of list of attributes
d) Subset of a Cartesian product of list of relations
Ans. a

127. Which one of these is not included in acid property of database
1. Atomicity
2. Consistency
3. Isolation
4. Deadlock-freedom
Ans. 4

128. Which of the following command do we use to delete a relationship from a database
a) Delete
b) Drop
c) Remove
d) All of these
Ans. b

129. Advantages of nosql database
a) Open Source
b) Backup
c) High scalability
d) GUI is not available
Ans. c

130. Which one of these is an advantage of database?
a) Storage Space duplication is eliminated
b) All application share centralized files
c) Data are stored once in database and are easily accessible when needed
d) All of these
Ans. d

131. Which of the following is not a type of database
a) Hierarchical
b) network
c) Distributed
d) Decentralized
Ans. d

132. Which language can be used to get information from database?
a) ASP.NET b) Java
c) SQL d) C++
Ans. c

16. 133. Which clause is required in an sql query for getting information from a database
a) Update
b) Display
c) Select
d) Create
Ans. c

134. Which sql statement is used to insert a new data in a database
a) Add New
b) Insert New
c) Insert into
d) Add record
Ans. c

135. How can you execute dml statements in the database?
a) By making use of the insertStatement, DeleteStatement or UpdateStatement classes
b) By inoking the execute(…) or executeUpdate(…) method of a normal Statement object
c) By invoking the executeInsert(…), executeDelete(…) or executeUpdate(…) methods of
d) By making use of the execute(…) statement of the DataModificationStatement object
Ans. b

136. Which of the following is not a modification of the database
a) deletion
b) insertion
c) sorting
d) updating
Ans. c

137. When is it best to use a nosql database?
a) When providing confidentiality, integrity, and availability is crucial
b) When the data is predictable
c) When the retrieval of large quantities of data is needed
d) When the retrieval speed of data is not critical
Ans. c

138. Which database concept describes the structure inside the database
a) Primary key
b) Cell
c) View
d) Schema
Ans. d

139. A _____ name must be unique within a database
a) Table
b) Field
c) Record
d) Character
Ans. a

140. Which of the following is the example of network database ?
a) IDBS b) Ingress
c) Oracle d) DBMS
Ans. a

17. 141. In the client / server model the database
a) is downloaded to the client upon request
b) is shared by both the client and server
c) Resides on the client side
d) Resides on the server side
Ans. d

142. What method can you use to add a new table to your database ?
a) Use Design view to create table
b) Enter data directly by using a database
c) Both of above
d) All of these
Ans. c

143. How much maximum file can be there in one database ?
a) 65536
b) 16384
c) 32764
d) 32767
Ans. d

144. The android component that works like database
a) Services
b) Activities
c) Broadcast Receivers
d) Content Providers
Ans. d

145. Which of the following is not a database
a) MySQL
b) Base
c) SQL Server
d) Spreadsheet
Ans. b

146. Which of the following is not a function of the database ?
a) Managing stored data
b) Manipulating data
c) Security for stored data
d) Analysing code
Ans. d

147. Database _____ which is the logical design of the database, and the database ______ which
is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema b) Relation, Schema
c) Relation, Domain d) Schema, Instance
Ans. d

148. Which data adaptor query type can be used with the access database?
a) Use SQL statements
b) Create new stored procedure
c) Use existing stored procedure
d) Both a and b
Ans. a

18. 149. Command to open a particular database file is
a) Open
b) Use
c) Both
d) None
Ans. b

150. A database procedure is stored in the database
a) In compiled form
b) As Source code
c) Both A & B
d) Not stored
Ans. c

151. Top providers of nosql database
a) Microsoft
b) Oracle
c) IBM
d) All of these
Ans. d

152. Copyright in a database:
a) only exists if the database is the author’s own intellectual creation
b) required that skill and labour is used in the selection or arrangement of the contents of the
database
c) Protect against the extraction of data from the database
d) does not protect databases where the intellectual creation went towards creating the data,
rather than selecting or arranging it
Ans. d

153. Which of the following statements does not apply to relational database
a) Relational databases are simple to understand
b) Tables are one of the basic components of relational databases
c) Relational databases have a strong procedural oriented
d) Relational databases have a strong mathematical foundation
Ans. c

154. Which of the following is not the advantage of database Management System?
a) Controls Data Inconsistency
b) Facilitates Sharing Data
c) Increases Data Redundancy
d) Maintains Integrity
Ans. c

155. Which keyword is used to create a database ?
a) Create b) SET c) SETUP d) LINK
Ans. a

156. Unlike filters queries can be saved as _____ in a database.
a) Filters b) Objects
c) Database d) Any of these
Ans. b

19. 157. How will using a middle tier typically affect the number of connections to a database ?
a) Increase the Number
b) Have no effect on the number
c) Decrease the number
d) It depends on the type of client
Ans. c

158. In which of the following states the data is still not saved in the database ?
a) Active
b) Partially Committed
c) Both A and B
d) None of these
Ans. c

1. Line chart is used to show the ______.

2. In a database table, the category of information is called _____.
a) Field b) record c) report d) table

3. ____ is the Process of Checking the data.
a) Data Validation b) data checking c) date review d) data manipulation

4. ______ refers to collection, storage, manipulation, reporting and mining of available information.
(a) Database management (b) Presentation
(c) Charting (d) Document preparation

5. Inserting data and modifying values in previously inserted data in tables of a database is called
(a) data update (b) data retrieval
(c) data definition (d) database administration

6. Maintaining data in error free manner is called data ______ .
(a) integrity (b) duplicity
(c) multiplicity (d) atomicity

7. Among the open source and free database management systems, ______is the most popular.
(a) MySQL (b) PostgreSQL
(c) MariaDB (d) SQLite

8. Relational database model was proposed by ______.
(a) Bill Gates (b) Steve Jobs
(c) Dennis Ritchie (d) Edgar F Codd

9. OMG in object oriented database stands for ________ .
(a) Object Maintenance Group (b) Oh My God
(c) Object Management Group (d) Object Management Gimmick

10. As a good practice in the design of database tables, passwords should be stored in___ format.
(a) numeric (b) random
(c) plain text (d) encrypted

11. As a good practice, each user should have _____ user id and password.
(a) same (b) different
(c) root (d) admin

20. 12. For missing critical databases, ______ should be created to avoid data loss.
(a) backup (b) program
(c) SQL (d) table

13. A key which is unique to a table is called _____.
(a) primary key (b) foreign key
(c) unique (d) none of them

14. ORM in database management stands for _______.
(a) Object Reverse Mapping (b) Offset Relational Mapping
(c) Object Relational Mapping (d) Object Restricted Mapping

15. ODBC stands for _____
a) Object Database Connectivity b) Oral Database Connectivity
c) Oracle Database Connectivity d) Open Database Connectivity

Click here for Answers


Computer Best MCQ Book in Just Rs.29/- [7000+ Question in English]
https://bharatskills.in/best-computer-mcq-book-for-competitive-exams/

Computer Best MCQ Book in Just Rs.25/- (2100+ Question in Hindi)
https://bharatskills.in/computer-mcq-book-in-hindi-pdf/

HEETSON

Telegram https://t.me/Heetson_Official
WhatsApp Channel

@heetsoniti