QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Correct Answer :
B. Query By Example
Related Questions
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Event condition action model is related to
Views
Cursors
Triggers
None of these.
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
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
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
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
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
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
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
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
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
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none