Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
Correct Answer :
A. It is a physical representation of the data.
Related Questions
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
m - 1
m + 1
m * m
m
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key
Maximum height of a B+ tree of order m with n key values is
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
jamming
password
documentation
record lock
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
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
Change Staff table by removing default of Assistant for position column
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
Which two files are used during operation of the DBMS?
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation