The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Correct Answer :
C. 24 bits
Related Questions
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
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
The index table has …… Columns.
1
2
3
4
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
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
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
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)
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
A fragmentation is categorized in
1 part
2 part
3 part
4 part
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
Secondary storage
magnetic disk
magnetic tape
juke box
cache
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these