Which of the following is also called an INNER JOIN?
a) self-join
b) equal join
c) non-equal join
d) none of these
………. clause creates temporary relation for the query on which it is defined.
a) WITH
b) FROM
c) WHERE
d) SELECT
………command makes the updates performed by the transaction permanent in the database.
a) ROLLBACK
b) COMMIT
c) TRUNCATE
d) DELETE
Which type of JOIN is used to returns rows that do not have matching values?
a) natural join
b) outer join
c) equal join
d) all of these
Which of the following is/are the basic approache/s for joining tables?
a) natural join
b) union join
c) subqueries
d) all of these
Group of operations that form a single logical unit of work is known as……
a) view
b) network
c) transaction
