Triggers are also called
active rules
passive rules
inferences
none of the above
Correct Answer :
A. active rules
Related Questions
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
Triggers are also called
active rules
passive rules
inferences
none of the above
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
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
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.
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
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above