An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Correct Answer :
A. insert
Related Questions
A fragmentation is categorized in
1 part
2 part
3 part
4 part
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Event condition action model is related to
Views
Cursors
Triggers
None of these.
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Noisy channel has ……… .. types of protocols
two
three
four
none
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
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
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
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
.................. 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
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Referential integrity
controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database
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
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
which of the following is a binary operation?
project
select
rename
none of the above
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
Noiseless channel has ……… types of protocols.
2
3
4
5
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
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
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
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT