Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
Correct Answer :
C. Switch
Related Questions
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
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
The raw facts and figures are:
Data
Data field
DBMS
DBASE
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
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
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
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 exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
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
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
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