Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
Correct Answer :
D. NRZ-L
Related Questions
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Noiseless channel has ……… types of protocols.
2
3
4
5
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
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
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
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
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
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
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
B-Tree is used for
searching data
storing data
both A and B
none of these
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
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
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
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
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
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
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET