As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
Correct Answer :
C. a trigger
Related Questions
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
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
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
The raw facts and figures are:
Data
Data field
DBMS
DBASE
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
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 number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
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
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
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).
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
B-Tree is used for
searching data
storing data
both A and B
none of these
Noisy channel has ……… .. types of protocols
two
three
four
none
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
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)
A fragmentation is categorized in
1 part
2 part
3 part
4 part