Related Questions

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
A Equi-join
B Natural join
C Outer join
D Cartesian join
A special lottery is to be held to select the student who will live in the only deluxe room in a dormitory . There are 100 seniors, 150 juniors and 200 sophomres who applied. Each senior's junior's name , 2 times; and each sophomres who applied. Each senior's name is placed in the lottery 3 times; each junior's name ,2 times name, 2 times ; and each sphomore's name , 1 time . What is the probability that a senior's name will be chosen?
A 18
B 38
C 48 
D 28
From a total of six men and four ladies a committee of three is to be formed. If Mrs. X is not willing to join the committee in which Mr. Y is a member, whereas Mr.Y is willing to join the committee only if Mrs Z is included, how many such committee are possible?
A 91
B 104
C 109
D 98
In a sample of 50 people, 19 had type O blood, 22 had type A blood, 7 had type B blood and 2 had type AB blood. If a person is selected randomly, find the probability that the person has neither type A nor type O blood?
A 15/25
B 31/50
C 11/25
D 9/50
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
A True
B False
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
A Open
B Show
C Alter
D Edit
Type 1 workers can do three times the work of Type 2 workers. Twelve Type 1 workers can complete a task in 10 days. How many days would it have taken 4 Type 1 and 8 Type 2 workers to complete the same task?
A 16
B 17
C 20
D 18
An empty fuel tank of a car was filled with A type petrol. When the tank was half-empty, it was filled with B type petrol. Again when the tank was half-empty, it was filled with A type petrol. When the tank was half-empty again, it was filled with B type petrol. What is the percentage of A type petrol at present in the tank?
A 33.5%
B 37.5%
C 40%
D 50%
An empty fuel tank of a car was filled with A type petrol. When the tank was half-empty, it was filled with B type petrol. Again when the tank was half-empty, it was filled with A type petrol. When the tank was half-empty again, it was filled with B type petrol. What is the percentage of A type petrol at present in the tank ?
A 33.5%
B 37.5%
C 40%
D 50%
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
A SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
B SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
C SELECT NAME IN CUSTOMER WHERE STATE = 'V';
D SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Next steps