The bit-field values are prefixed with __________
 

SELECT on a MERGE table is like _____________ 

 Which among the following can also be included with “SELECT” clause while writing query in Mysql? 

The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________ 

Will this query produce any error?

 INSERT INTO person (person_id, fname,lname) VALUES (1,’S’,’U’), VALUES (2,’T’,’U’); /* where person_id is a primary key */ 

What will be the output of the following query?

 SELECT *  FROM person WHERE emp_id IS NULL; 

What will be the output of the following query?

 SELECT fname FROM person WHERE emp_id != 6; 

Find the error, if any, in the following SQL query:

SELECT cust_id, fed_id

FROM customer

WHERE cust_id = 'I'

AND fed_id BETWEEN '5000-00-000' AND '9999-999-000';

What pids are returned by the following SQL query for the above instance of the tables?

SELECT pid
FROM Reservation
WHERE class = 'AC' AND
EXISTS (SELECT *
FROM Passenger
WHERE age > 65 AND
Passenger.pid = Reservation.pid)

What will be the result of the following query?

WHERE TITLE=’teller’ OR start_date=’2007-01-01’