A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
Correct Answer :
B. Sub query
Related Questions
Secondary storage
magnetic disk
magnetic tape
juke box
cache
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Noiseless channel has ……… types of protocols.
2
3
4
5
The index table has …… Columns.
1
2
3
4
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
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.
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
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.
A …………… is a memory area where data are processed.
view
trigger
cursor
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
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
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
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
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
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
View never contains derived columns.
True
False
Cant say
none
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
The raw facts and figures are:
Data
Data field
DBMS
DBASE
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above