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
Correct Answer :
C. n-1
Related Questions
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
Triggers are also called
active rules
passive rules
inferences
none of the above
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.
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
Authorization command in SQL
Allow
Access
Grant
none of the above
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
Noiseless channel has ……… types of protocols.
2
3
4
5
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Event condition action model is related to
Views
Cursors
Triggers
None of these.
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above