Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Correct Answer :
B. permanently
Related Questions
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
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
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
A fragmentation is categorized in
1 part
2 part
3 part
4 part
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
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.
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
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)
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions
i only
ii only
Both A and B
None of the above
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
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
B-Tree is used for
searching data
storing data
both A and B
none of these
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
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
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these