Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
Correct Answer :
A. i and ii only
Related Questions
View never contains derived columns.
True
False
Cant say
none
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
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 database environment has all of the following components except:
users.
separate files.
database.
database administrator.
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
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
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
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
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
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.
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Event condition action model is related to
Views
Cursors
Triggers
None of these.
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.
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
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
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps