Read important Data Base Management Science MCQS For Exam.These General Knowledge Mcqs Contain of World technology, Science & Literature, events Mcqs, Data Base Management Science Mcqs and International Organizations. These general knowledge questions are very important for all type of exams.
Note: The bold option is the right answer for the given MCQ’S:
Q.1 It is better to use files than a DBMS when there are
(A) Stringent real-time requirements.
(B) Multiple users wish to access the data.
(C) Complex relationships among data.
(D) All of the above.
Q.2 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.
Q.3 The RDBMS terminology for a row is
(A) tuple.
(B) relation.
(C) attribute.
D) degree.
Q.4 Which of the following operations need the participating relations to be union compatible?
(A) UNION
(B) INTERSECTION
(C) DIFFERENCEqq
(D) All of the above
Q.5 The full form of DDL is
(A Dynamic Data Language
(B) Detailed Data Language
(C) Data Definition Language
(D) Data Derivation Language
Q.6 Which of the following is an advantage of view?
(A) Data security
(B) Derived columns
(C) Hiding of complex queries
(D) All of the above
Q.7 The users who use easy-to-use menu are called
(A) Sophisticated end users.
(B) Naïve users.
(C) Stand-alone users.
(D) Casual end users.
Q.8Which database level is closest to the users?
(A) External
(B) Internal
(C) Physical
(D) Conceptual
Q.9 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
Q.10 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
Q.11A set of possible data values is called
(A) attribute.
(B) degree.
(C) tuple.
(D) domain.
Q.12 Which of the operations constitute a basic set of operations for manipulating relational
data?
(A) Predicate calculus
(B) Relational calculus
(C) Relational algebra
(D) None of the above
Q.13 Which of the following is another name for weak entity?
(A) Child
(B) Owner
(C) Dominant
(D) All of the above
Q.14 Which of the following database object does not physically exist?
(A) base table
(B) index
(C) view
(D) none of the above
Q.15A 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 the above.
Q.16 A file manipulation command that extracts some of the records from a file is called
(A) SELECT
(B) PROJECT
(C) JOIN
(D) PRODUCT
Ans: A
Q.17 A primary key is combined with a foreign key creates
(A) Parent-Child relation ship between the tables that connect them.
(B) Many to many relationship between the tables that connect them.
(C) Network model between the tables that connect them.
(D) None of the above.
Q.18 In E-R Diagram derived attribute are represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Triangle
Q.19 Cross Product is a:
(A) Unary Operator
(B) Ternary Operator
(C) Binary Operator
(D) Not an operator
Q.20 The natural join is equal to :
(A) Cartesian Product
(B) Combination of Union and Cartesian product
(C) Combination of selection and Cartesian product
(D) Combination of projection and Cartesian product
Q.21 Which one of the following is not true for a view:
(A) View is derived from other tables.
(B) View is a virtual table.
(C) A view definition is permanently stored as part of the database.
(D) View never contains derived columns.
Q.22 To delete a particular column in a relation the command used is:
(A) UPDATE
(B) DROP
(C) ALTER
(D) DELETE
Q.23 The ______ operator is used to compare a value to a list of literals values that have been
specified.
(A) BETWEEN
(B) ANY
(C) IN
(D) ALL
Q.24DAta manipulation command the combines the records from one or more tables is called
(A) SELECT
(B) PROJECT
(C) JOIN
(D) PRODUCT
Q.25 In E-R diagram generalization is represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Triangle
Q.26 The method of access which uses key trAnsformation is known as
(A) Direct
(B) Hash
(C) Random (D) Sequential
Q.27 A table joined with itself is called
(A) Join
(B) Self Join
(C) Outer Join
(D) Equi Join
Leave a Comment