Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
Correct Answer :
D. column functions
Related Questions
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Noisy channel has ……… .. types of protocols
two
three
four
none
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
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 data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions
i only
ii only
Both A and B
None of the above
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
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.
Data stored in cursor is called ……………
record
active data set
object
none of the above
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
The index table has …… Columns.
1
2
3
4
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
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
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
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure