32-File
organization that provides very fast access to any arbitrary record of a
file is -Hashed file
33-Which
of the following is correct:
(A) SQL query automatically eliminates
duplicates.
(B)
SQL permits attribute names to be repeated in the same relation.
(C) SQL query will not work if there are
no indexes on the relations
(D) None of these Ans-D
34- It
is better to use files than a DBMS when there are -Multiple users wish to access the data.
35-The conceptual
model is-independent of both hardware and software.
36-Which
of the following operation is used if we are interested in only certain
columns of a table?–projection
37-Which
of the following operations need the participating relations to be union
compatible?
(A) UNION (B) INTERSECTION (C) DIFFERENCE (D) All
of the above Ans-D
38-Which
of the following is an advantage of view?
(A) Data security (B) Derived
columns (C) Hiding of
complex queries (D) All Ans-D
39-The
user who use easy-to-use menu are called-Natïve
users
40-Which
database level is closest to the users?
(A) External (B) Internal
(C) Physical (D) Conceptual
Ans-A
41-Which
are the two ways in which entities can participate in a relationship?-Total and partial
42-The
result of the UNION operation between R1 and R2 is a relation that
includes-all the tuples of R1 and R2 which have
common columns
43-Which
of the following is a comparison operator in SQL?
(A) =
(B) LIKE
(C) BETWEEN
(D) All of
the above Ans-D
44-A
set of possible data values is called-Domain
45-Which
of the operation constitute a basic set of operations for manipulating
relational data?Relational algebra
46-Which
of the following is another name for weak entity? - Child
47-Which
of the following database object does not physically exist?-View
48-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
49-Which
of the following is record based logical model? - Network Model
50-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 the above. Ans:
D
51-A
file manipulation command that extracts some of the records from a file is
called - SELECT
52-The
physical location of a record is determined by a mathematical formula that
transforms a file key into a record location is :- B-Tree File
53-Using
Relational Algebra the query that finds customers, who have a balance of
over 1000 is - PCustomer_name(s balance
>1000(Deposit))
54-In
E-R Diagram derived attribute are represented by -Dashed ellipse
55-Cross
Product is a:- Binary Operator
56-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 is not a candidate
key
57-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: - mn
58-The
natural join is equal to :- Combination of projection and Cartesian product
59-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) View definition is permanently stored
as part of database
(D) View never contains derived columns. Ans-C
60-In
E-R Diagram relationship type is represented by -Diamond
61-To
delete a particular column in a relation the command used is:-Alter
62-The
______ operator is used to compare a value to a list of literals values
that have been specified.- BETWEEN
63-A
B-tree of order m has maximum of ______children
– m
64-In
E-R diagram generalization is represented by-Triangle
65-View is a virtual
table that draws its data from the result of an SQL SELECT
statement.
66-_________
data type can store unstructured data- RAW
67-Which
two files are used during operation of the DBMS-Data dictionary and transaction log
No comments:
Post a Comment