Related Questions
What is the correct answer?
4
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.
What is the correct answer?
4
Mail services are available to network users through the
What is the correct answer?
4
Which of the following Key is used to represent relationship between the tables?
What is the correct answer?
4
A relation which is in 3NF is
C. free from transitive dependencies
What is the correct answer?
4
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. A list of employees phone number
B. A list of all employees that have spouses, with phone number included in the list
C. A list of all employees names, including the phone number if they have one
D. Two lists : One list of employees, the other of phone numbers
What is the correct answer?
4
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
What is the correct answer?
4
…………… is responsible for using that the database remains in a consistent state despite system failure.
What is the correct answer?
4
Unwanted energy from source other than the transmitter.
What is the correct answer?
4
A transaction which completes successfully is called
What is the correct answer?
4
Which of the following is a classical approach to database design?
What is the correct answer?
4
In an Entity-Relationship Diagram Ellipses represents
D. Multi-valued attributes
What is the correct answer?
4
An advantage of the database management approach is
A. data is dependent on programs.
B. data redundancy increases.
C. data is integrated and can be accessed by multiple programs.
What is the correct answer?
4
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
What is the correct answer?
4
UML is stands for
A. Universal Modeling Language
B. Unified Modeling Language
C. United Modeling Language
What is the correct answer?
4
The race condition occurs when
A. Two concurrent processes attempt to interact with each other.
B. Two concurrent processes interact with different data files.
C. Two concurrent processes attempt to hold a data item .
What is the correct answer?
4
Technique(s) used for data recovery after any failure
D. Both A and B are false
What is the correct answer?
4
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
B. referential integrity constraint
What is the correct answer?
4
A data manipulation command the combines the records from one or more tables is called
What is the correct answer?
4
The physical path over which a message travels
What is the correct answer?
4
By default a user who has been granted some form of authorization
A. is allowed to pass them to others
B. is not allowed to pass them to others
C. may be or may not be allowed to pass them to others
What is the correct answer?
4
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
What is the correct answer?
4
The command used to delete a particular column in a relation
What is the correct answer?
4
In a Hierarchical model records are organized as
What is the correct answer?
4
Which of the following is also known as Offline storage ?
What is the correct answer?
4
The language used in application programs to request data from the DBMS is referred to as the
What is the correct answer?
4
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.
What is the correct answer?
4
Size of source and destination address in IP header
What is the correct answer?
4
DBMS helps achieve
B. Centralized control of data
What is the correct answer?
4
A fragmentation is categorized in
What is the correct answer?
4
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.