Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
Correct Answer :
A. Chain
Related Questions
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
Data items grouped together for storage purposes are called a
record
string
title
list
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Union
Intersection
Difference
Join
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
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
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
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
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
RAM
Flash
Hard Disk
Secondary
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
inner join
Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
What is a disjoint less constraint?
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client