What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Correct Answer :
B. Degree
Related Questions
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
Data stored in cursor is called ……………
record
active data set
object
none of the above
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
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
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data.
programs are not dependent on the logical attributes of data.
both B) and C).
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
Noisy channel has ……… .. types of protocols
two
three
four
none
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
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
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
View never contains derived columns.
True
False
Cant say
none