The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Correct Answer :
C. size of memory area
Related Questions
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
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
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Query processing is
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
which of the following is a binary operation?
project
select
rename
none of the above
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
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
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 degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
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)
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Event condition action model is related to
Views
Cursors
Triggers
None of these.
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
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
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Which of the following is logical topology?
Bus
Ring
Star
None of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
View never contains derived columns.
True
False
Cant say
none
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field