Select operation in SQL is equivalent to

1.	Select operation in SQL is equivalent to
A.	the selection operation in relational algebra
B.	the selection operation in relational algebra, except that select in SQL retains duplicates
C.	the projection operation in relational algebra
D.	the projection operation in relational algebra, except that select in SQL retains duplicates
Answer» E.

Discussion

No Comment Found

Related MCQs

A liquid is placed in a hollow prism of angle 60o. If angle of the minimum deviation is 30o, what is the refractive index of the liquid?
Changes in population occur due to change in
What is the size of optical compact disk which is used for recording high quality music 
The function of program counter (PC) holds 
Consider two processors P1 and P2 executing the same instruction set. Assume that under identical conditions, for the same input, a program running on P2 takes 25% less time but incurs 20% more CPI (clock cycles per instruction) as compared to the program running on P1. If the clock frequency of P1 is 1GHz, then the clock frequency of P2 (in GHz) is _________.
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their respective departments in the location ID 1700. You issue the following query: SQL> SELECT last-name, hire-date FROM employees WHERE (dept-id, hire-date) IN (SELECT dept-id, MAX(hire-date) FROM employees JOIN departments USING(dept-id) WHERE location-id = 1700 GROUP BY dept-id); What is the outcome?
An ordered n-tuple (d1, d2, … , dn) with d1 >= d2 >= ⋯ >= dn is called graphic if there exists a simple undirected graph with n vertices having degrees d1, d2, … , dn respectively. Which of the following 6-tuples is NOT graphic
Consider an undirected graph G where self-loops are not allowed. The vertex set of G is {(i, j): 1
Let S denote the set of all functions f: {0,1}4 -> {0,1}. Denote by N the number of functions from S to the set {0,1}. The value of Log2Log2N is ______.
Four fair six-sided dice are rolled. The probability that the sum being 22 is X/1296. The value of X is ________

Select operation in SQL is equivalent to

Discussion

No Comment Found

Related MCQs

Reply to Comment