Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Correct Answer :
C. Application layer
Related Questions
Primary storage
magnetic disk
magnetic tape
juke box
cache
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all 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
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
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.
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
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
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
Secondary storage
magnetic disk
magnetic tape
juke box
cache
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
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)
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
A fragmentation is categorized in
1 part
2 part
3 part
4 part
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
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
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
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
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these