Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Correct Answer :
B. Binary Operator
Related Questions
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
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.
.................. 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
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
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
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.
i only
ii, only
ii, iii only
none of the above
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Noisy channel has ……… .. types of protocols
two
three
four
none
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
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)
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
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
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
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 functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Primary storage
magnetic disk
magnetic tape
juke box
cache
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