Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
Correct Answer :
D. reduced data redundancy
Related Questions
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Noiseless channel has ……… types of protocols.
2
3
4
5
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
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
Tertiary storage
magnetic tape
juke box
optical disk
All 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
.................. 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 not a constraint on a single relation?
check
unique
not null
is duplicate
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
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none 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
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction