Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

7 (consider table A and table B) Which of the following command will return a new table that has one column with 3 records? *

image text in transcribed
image text in transcribed
7 (consider table A and table B) Which of the following command will return a new table that has one column with 3 records? * (2 Points) select studentid from A union select name from B; select studentid from A,B; select studentid from A union select studentid from B; select studentid from A,B where A.studentid=B.studentid; select A. studentid, name from A,B; 8 (consider table A and table B) What is the output of the following command? select distinct A.studentid from A, B where A. studentid=B.studentid; Note: Each answer represents a column * (2 Points) O 223 O 111222 333 0 123 23 7 (consider table A and table B) Which of the following command will return a new table that has one column with 3 records? * (2 Points) select studentid from A union select name from B; select studentid from A,B; select studentid from A union select studentid from B; select studentid from A,B where A.studentid=B.studentid; select A. studentid, name from A,B; 8 (consider table A and table B) What is the output of the following command? select distinct A.studentid from A, B where A. studentid=B.studentid; Note: Each answer represents a column * (2 Points) O 223 O 111222 333 0 123 23

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management System MCQs Multiple Choice Questions And Answers

Authors: Arshad Iqbal

1st Edition

1073328554, 978-1073328550

More Books

Students also viewed these Databases questions

Question

Have I incorporated my research into my outline effectively?

Answered: 1 week ago

Question

b. What are its goals and objectives?

Answered: 1 week ago