Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Correct Answer :
A. Cartesian product
Related Questions
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
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
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
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
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
Primary storage
magnetic disk
magnetic tape
juke box
cache
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
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.
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
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
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital