In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Correct Answer :
D. Tree.
Related Questions
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Event condition action model is related to
Views
Cursors
Triggers
None of these.
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
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
Which of the following is not a database object?
index
sequence
cursor
trigger
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
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
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 ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
Data stored in cursor is called ……………
record
active data set
object
none of the above
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
The index table has …… Columns.
1
2
3
4
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
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).
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above