computer Knowledge Quiz

Q.1 To delete a particular column in a relation the command used is:
(A) UPDATE
(B) DROP
(C) ALTER
(D) DELETE


Q.2 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.3 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

Q.4 A B-tree of order m has maximum of _____________ children
(A) m
(B) m+1
(C) m-1
(D) m/2

Q.5 _____________ function divides one numeric expression by another and returns the
remainder.
(A) POWER
(B) MOD
(C) ROUND
(D) REMAINDER


Q.6 A data manipulation command the combines the records from one or more tables is called
(A) SELECT
(B) PROJECT
(C) JOIN
(D) PRODUCT

Q.7 In E-R diagram generalization is represented by
(A) Ellipse
(B) Dashed ellipse
(C) Rectangle
(D) Triangle

Q.8 _________ is a virtual table that draws its data from the result of an SQL
SELECT statement.
(A) View
(B) Synonym
(C) Sequence
(D) TrAnsaction

Q.9 The method of access which uses key trAnsformation is known as
(A) Direct
(B) Hash
(C) Random
(D) Sequential

Q.10 A table joined with itself is called
(A) Join
(B) Self Join
(C) Outer Join
(D) Equi Join

ANSWERS:

Ans1: C

Ans2: A

Ans3: D

Ans4: A

Ans5: B

Ans6: C

Ans7: D

Ans8: A

Ans9: B

Ans 10 : A