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)
Correct Answer :
A. mn
Related Questions
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
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)
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
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
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Which of the following is not a database object?
index
sequence
cursor
trigger
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
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).
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
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Secondary storage
magnetic disk
magnetic tape
juke box
cache
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.