Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
Correct Answer :
C. The input to the aggregate function avg can be non numeric data types
Related Questions
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Which of the following is logical topology?
Bus
Ring
Star
None of these
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Authorization command in SQL
Allow
Access
Grant
none of the above
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
Noisy channel has ……… .. types of protocols
two
three
four
none
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Which of the following is not a database object?
index
sequence
cursor
trigger
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
The raw facts and figures are:
Data
Data field
DBMS
DBASE
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
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
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
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.
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
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
.................. 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 command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE