Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
Correct Answer :
A. Relation dependencies
Related Questions
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
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
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
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)
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Which of the following is not an Aggregate function?
Min
Max
Select
Avg