The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Correct Answer :
B. 7
Related Questions
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
Noiseless channel has ……… types of protocols.
2
3
4
5
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
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
m+n
m+n)/2
2 m+n)
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above