Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
5.8k views
in Information Technology by (71.3k points)

Consider the tables given below while attempting the following questions:

Train

Reservation

(i) Identify the primary key column of Train and Reservation.

(ii) Help Mr. Sajal in identifying the wrong statement with reference to UNION clause: 

a. Each SELECT statement within UNION must have the same number of columns 

b. The columns must also have similar data types 

c. The columns in each SELECT statement must also be in the same order 

d. By default, the UNION operator selects all the values.

1 Answer

+1 vote
by (76.5k points)
selected by
 
Best answer

(i) Train-TrainId 

Reservation-RefNo

(ii) (d) By default, the UNION operator selects all the values.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...