Database in Computers MCQ Questions with Answers

Question. What is there in record ?
(a) Collection of field
(b) collection of Number
(c) Collection of rows
(d) All of above
(e) None of these

Answer : A

Question. What is a relationship called when it is maintained between two entities?
(a) Unary
(b) Binary
(c) Ternary
(d) Quaternary
(e) 1 and 2

Answer : B

Question. Which is not related to database ?
(a) Table
(b) Query
(c) Form
(d) Macro
(e) None of these

Answer : C

Question. Which of the following operations need the participating relations to be union compatible?
(a) UNION
(b) INTERSECTION0
(c) DIFFERENC
(d) All of the above
(e) None of these

Answer : D

Question. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
(a) Relational
(b) Structural
(c) Network
(d) All of the above
(e) None of these

Answer : B

Question. Type of a file is identified by -
(a) File
(b) Attribute
(c) Extension
(d) Properties
(e) None of these

Answer : C

Question. Entities having primary key are called?
(a) Primary Entities
(b) Strong Entities
(c) Weak Entities
(d) Primary Key
(e) None of these

Answer : B

Question. Which of the following is NOT a type of Microsoft Access database object?
(a) Queries
(b) Workbooks
(c) Forms
(d) Tables
(e) None of these

Answer : B

Question. The raw facts and figures are:
(a) Program
(b) Information
(c) Snapshot
(d) Reports
(e) None of these

Answer : E

Question. ________ is a process when relation between two entity is treated as a single entity.
(a) Normalization
(b) Aggregation
(c) Generalization
(d) Specialization
(e) Simplification

Answer : B

Question. A subset of characters within a data field is known as
(a) Record
(b) File
(c) Data string
(d) Byte
(e) None of these

Answer : C

Question. The result of the UNION operation between R1 and R2 is a relation that includes _______.
(a) All the tuples of R1
(b) All the tuples of R2
(c) All the tuples of R1 and R2
(d) All the tuples of R1 and R2 which have common columns
(e) None of these

Answer : D

Question. Data items grouped together for storage purposes are called-
(a) Record
(b) Title
(c) List
(d) string
(e) None of these

Answer : A

Question. The RDBMS terminology for a row is _______?
(a) Tuple
(b) Relation
(c) Attribute
(d) Degree
(e) Field

Answer : A

Question. Which of the following is not Unary operation?
(a) Select
(b) Project
(c) Rename
(d) Union
(e) None of these

Answer : D

Question. What is the function of relationship ?
(a) Relate multiple table
(b) Relate multiple form
(c) Relate table and form
(d) Relate queries and forms
(e) None of these

Answer : A

Question. The primary key must be ____.
(a) Unique
(b) Not null
(c) Both 1 and 2
(d) Either 1 or 2
(e) None of these

Answer : C

Question. Which database level is closest to the users?
(a) External
(b) Internal
(c) Physical
(d) Conceptual
(e) None of these

Answer : A

Question. Logical design of the database is called ______.
(a) Database Snapshot
(b) Database Instance
(c) Database Schema
(d) All of the above
(e) None of these

Answer : C

Question. The language used by application programs to request data from the DBMS is referred to the-
(a) DML
(b) DDL
(c) query language
(d) All of the above
(e) None of these

Answer : A

Question. In Data base , properties of any entity are represented by its -
(a) Setting
(b) Tuples
(c) Attributes
(d) Degree
(e) None of these

Answer : C

Question. Snapshot of the data in the database at a given instant of time is called _____.
(a) Database Schema
(b) Database Instance
(c) Database Snapshot
(d) All of the above
(e) None of these

Answer : B

Question. Which of the following is not binary operation?
(a) Union
(b) Project
(c) Set Difference
(d) Cartesian Product
(e) None of these

Answer : E

Question. In an ER Diagram, ellipse with underlying lines is used to represent _________?
(a) attribute
(b) Key attribute
(c) Composite attribute
(d) Multivalued attribute
(e) Entity

Answer : B

Question. A command to remove a relation from an SQL database is ____.
(a) Delete table <table name>
(b) Drop table <table name>
(c) Erase table <table name>
(d) Alter table <table name>
(e) None of these

Answer : B

Question. Which of the following is a type of DBMS Software?
(a) Data
(b) My SQL
(c) MS-office
(d) utility
(e) None of these

Answer : B

Question. In the E-R diagrams, the term cardinality is a synonym for the term?
(a) Attribute
(b) Degree
(c) Entities
(d) Cartesian
(e) None of these

Answer : D

Question. Set of permitted values of each attribute is called ______.
(a) Domain
(b) Relation
(c) Tuple
(d) Schema
(e) None of these

Answer : A

Question. TRUNCATE statement in SQL is a ____
(a) DML statement
(b) DDL statement
(c) DCL statement
(d) TCL statement
(e) None of above

Answer : B

Question. In which object sql is used ?
(a) Query
(b) Form
(c) Report
(d) Macro
(e) None of these

Answer : A

Question. Which of the following option appropriate is a comparison operator in SQL?
(a) =
(b) LIKE
(c) BETWEEN
(d) All of the above
(e) None of these

Answer : D

Question. The complete picture of data stored in database is known as
(a) System flowchart
(b) Schema
(c) record
(d) DBMS
(e) None of these

Answer : B

Question. The default date format in SQL is?
(a) DD-MON-YY
(b) DD-MM-YY
(c) DD-MM-YYY
(d) DD-MM-YYYY
(e) None of these

Answer : D

Question. Database utility exist in —————— menu ?
(a) Format
(b) tools
(c) File
(d) Edit
(e) None of these

Answer : B

Question. A command that lets you change one or more fields of a record is?
(a) Insert
(b) Modify
(c) Look-up
(d) All of above
(e) None of above

Answer : B

Question. In a table of data base, degree refers
(a) total numer of row
(b) row in a table
(c) column in a table
(d) total number of column in a table
(e) none of these

Answer : D

Question. Which of the following is a valid SQL type?
(a) CHARACTER
(b) NUMERIC
(c) FLOAT
(d) DATE
(e) All of the above

Answer : E

Question. In a large DBMS?
(a) Each user can see only a small part of the entire database
(b) Each user can access every sub schema
(c) Each sub schema contains every field in the logical schema
(d) All of above
(e) None of above

Answer : A

Question. COMMIT and ROLLBACK in DBMS are the example of -
(a) DDL
(b) DML
(c) TQL
(d) DQL
(e) None of these

Answer : C

Question. Which of the following operation is used if we are interested in only certain columns of a table?
(a) PROJECTION
(b) SELECTION
(c) UNION
(d) JOIN
(e) Intersect

Answer : A

Question. Which operation is not permitted by query?
(a) delete
(b) entry
(c) Modify
(d) create table
(e) None of these

Answer : B

Question. It is better to use files than a DBMS when there are _______ .
(a) Stringent real-time requirements
(b) Multiple users who wish to access the data
(c) Complex relationships among data
(d) All of the above
(e) None of these

Answer : B

Question. A data dictionary is a special file that contains?
(a) the data types of all fields in all files
(b) the names of all fields in all files
(c) the widths of all fields in all files
(d) All of above
(e) None of above

Answer : D

Question. The feature that database allows to access only certain records in database is:
(a) Forms
(b) Reports
(c) Queries
(d) Tables
(e) None of these

Answer : C

Question. The conceptual model is _______ .
(a) dependent on hardware
(b) dependent on software
(c) dependent on both hardware and software
(d) independent of both hardware and software
(e) None of these

Answer : D

Question. Which of the following is an advantage of a View?
(a) Data security
(b) Derived columns
(c) Hiding of complex queries
(d) All of the above
(e) None of these

Answer : D

Question. For adding number of hours to a date, which of the following statement is used ?
(a) Date + Number
(b) Date + Number/24
(c) Date+Number of Hours
(d) Date +Hour/30
(e) None of above

Answer : B

Question. 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 the above
(e) None of these

Answer : B

Question. _________ constraint is used to restrict actions that would destroy links between tables?
(a) Primary key
(b) Foreign Key
(c) Check
(d) Not Null
(e) Unique

Answer : B

Question. The full form of DDL is _______?
(a) Dynamic Data Language
(b) Detailed Data Language
(c) Data Definition Language
(d) Data Derivation Language
(e) Data Dimensional Language

Answer : C