Consider the database tables: STUDENTS (with attributes ADMNO and SNAME) containing 3 rows, and GAMES (with attributes GAMEID and GNAME) containing 2 rows. Which SQL command will produce their Cartesian product (a combined table containing 6 rows with columns SNAME and GNAME)?

Question

Computer Science · Database Query Language

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SELECT SNAME, GNAME FROM STUDENTS, GAMES;

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Database Query Language?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Database Query Language

The 'Drain of Wealth' theory was propounded by which Indian nationalist leader?

Which event is considered the turning point in Mahatma Gandhi's leadership in the Indian independence movement?

Which African leader is known for his non-violent opposition to colonial rule?

Answer 1

SELECT SNAME, GNAME FROM STUDENTS, GAMES;

Answer 2

SELECT SNAME, GNAME FROM STUDENTS X GAMES;

Answer 3

SELECT SNAME FROM STUDENTS, GNAME FROM GAMES;

Answer 4

SELECT SNAME FROM STUDENTS, SELECT GNAME FROM GAMES;

Related Practice Questions