Query processing is
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
Correct Answer :
C. range of activities involved in extracting data from a database
Related Questions
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
B-Tree is used for
searching data
storing data
both A and B
none of these
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
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
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.
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
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
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD