An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
Correct Answer :
C. Strong entity set
Related Questions
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
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
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
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
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
Triggers are also called
active rules
passive rules
inferences
none of the above
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
The index table has …… Columns.
1
2
3
4
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
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
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
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
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
Noisy channel has ……… .. types of protocols
two
three
four
none
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only