Q.1 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.
Ans: A
Q.2 In E-R Diagram
derived attribute are represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Triangle
Ans B
Q.3 Cross Product is
a:
(A) Unary Operator
(B) Ternary Operator
(C) Binary Operator
(D) Not an operator
Ans: C
Q.4 An instance of
relational schema R (A, B, C) has distinct values of A including NULL values.
Which one of the following is true?
(A) A is a candidate key
(B) A is not a candidate key
(C) A is a primary Key
(D) Both (A) and (C)
Ans: B
Q.5 Consider the join
of a relation R with relation S. If R has m tuples and S has n tuples, then the
maximum size of join is:
(A) mn
(B) m+n
(C) (m+n)/2
(D) 2(m+n)
Ans: A
Q.6 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
Ans: D
Q.7 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.
Ans: C
Q.8 A primary key if
combined with a foreign key creates
(A) Parent-Child relationship 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.
Ans: A
Q.9 In E-R Diagram
relationship type is represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Diamond
Ans: D
Q.10 Hierarchical
model is also called
(A) Tree structure
(B) Plex Structure
(C) Normalize Structure
(D) Table Structure
Ans: A
Q.11 To delete a
particular column in a relation the command used is:
(A) UPDATE
(B) DROP
(C) ALTER
(D) DELETE
Ans: C
Q.12 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
Ans: A
Q.13 A logical schema
A) is the entire database
B) is a standard way of organizing information into a accessible part
C) describe how data is actually stored on disk
D) none of these
Ans: D
Q.14 A B-tree of
order m has maximum of _____________ children
(A) m
(B) m+1
(C) m-1
(D) m/2
Ans: A
Q.15 _____________
function divides one numeric expression by another and returns the remainder.
(A) POWER
(B) MOD
(C) ROUND
(D) REMAINDER
Ans: B
Q.16 A data
manipulation command the combines the records from one or more tables is called
(A) SELECT
(B) PROJECT
(C) JOIN
(D) PRODUCT
Ans: C
Q.17 In E-R diagram
generalization is represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Triangle
Ans: D
Q.18 _________ is a
virtual table that draws its data from the result of an SQL SELECT statement.
(A) View
(B) Synonym
(C) Sequence
(D) TrAnsaction
Ans: A
Q.19 The method of
access which uses key trAnsformation is known as
(A) Direct
(B) Hash
(C) Random
(D) Sequential
Ans: B
Q.20 A table joined
with itself is called
(A) Join
(B) Self Join
(C) Outer Join
(D) Equi Join
Ans: B
Q.21 _________ data
type can store unstructured data
(A) RAW
(B) CHAR
(C) NUMERIC
(D) VARCHAR
Ans: A
Q.22 A storage device
that is connected directly to a netwok ia an example of ______________
a. network attached
storage
b. storage area network
c. direct attached storage
d. RAID
Ans: A
Q.23 A tape library
will use a robotic component called a(n) ___________ to change and store
multiple tape cartridges
a. RAID
B. Backup device
c. redundant system
d. Auto loader
Ans: D
Q.24 More than one of
the same component is an example of a ______________ system
a. Scalable
b. redundant
c. RAID
d. back up
Ans: B
Q.25 Which type of database
stores data in two – dimensional tables?
a. Network
b. Hierarchical
c. Table
d. Relational
ANSWER KEY
Ans: D
No comments:
Post a Comment