The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
Correct Answer :
C. Entity instance
Related Questions
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
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.
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Database
Data
Transaction
Record
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
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 relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
The one guideline to be followed while designing the database is
A database design may be ambiguous.
It should avoid/reduce the redundancy.
Unrelated data should be in the same table so that updating the data will be easy.
An entity should not have attributes.
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
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
The common column is eliminated in
theta join
outer join
natural join
composed join
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays