Data from how many columns is listed when the following query is run? SELECT * FROMA NATURAL JOIN B Assume tables A and B contain 10 columns each and there are 5 columns with identical names in both tables. 25 columns 20 columns O 15 columns 100 columns

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 59P
icon
Related questions
Question

7

Data from how many columns is listed when the following query is run?
SELECT * FROM A NATURAL JOIN B
Assume tables A and B contain 10 columns each and there are 5 columns with
identical names in both tables.
25 columns
20 columns
15 columns
100 columns
O FINE
O STUDENT
S_ID INT(11)
PS ID INT(11)
OF_COUNT INT(11)
OS FNAME VARCHAR(20)
OF_FINE DECIMAL(8,2)
OS LNAME VARCHAR(20)
Indexes
OS TYPE VARCHAR(10)
Indexes
I CHECKOUT
воок
C NUM INT(11)
B_NUM INT(11)
OB_NUM INT(11)
OB_TITLE VARCHAR(120)
OS ID INT(11)
OB_YEAR INT(4)
OC OUT DATE DATE
OB COST DECIMAL(8,2)
OC DUE DATE DATE
OB_SUBJECT VARCHAR(120)
OC_IN_DATE DATE
Indexes
Indexes
BOOK
FINE
B_NUM B_TITLE
B_YEAR
B_COST
B_SUBJECT
S_ID
F_COUNT
FFINE
5235
Cloud Computing
2018
99.95
Cloud
1163
3
4.00
5236
Conceptual Programming
2012
79.95
Programming
1164
2
12.00
5237
Beginner's Guide to JAVA
2013
89.95
Programming
1167
2.50
5238
Database in the Cloud
2013
59.95
Database
5239
Mastering the database environment
2012
59.95
Database
CHECKOUT
STUDENT
C_NUM B_NUM S_ID
C_OUT DATE C_DUE DATE C_IN_DATE
S ID
S_FNAME S LNAME
S_TYPE
91001
5237
1163
2015-03-31
2015-04-14
2015-04-09
1163
Kelsey
Baldwin
UG
91002
5235
1164
2015-03-31
2015-04-07
2015-04-10
1164
Robert
Alvarado
PG
91003
5239
1167
2015-03-31
2015-04-14
2015-04-09
1167
Vera
Carter
PG
91004
5236
1168
2015-04-10
2015-04-24
2015-04-12
1168
Cedric
Koch
UG
Transcribed Image Text:Data from how many columns is listed when the following query is run? SELECT * FROM A NATURAL JOIN B Assume tables A and B contain 10 columns each and there are 5 columns with identical names in both tables. 25 columns 20 columns 15 columns 100 columns O FINE O STUDENT S_ID INT(11) PS ID INT(11) OF_COUNT INT(11) OS FNAME VARCHAR(20) OF_FINE DECIMAL(8,2) OS LNAME VARCHAR(20) Indexes OS TYPE VARCHAR(10) Indexes I CHECKOUT воок C NUM INT(11) B_NUM INT(11) OB_NUM INT(11) OB_TITLE VARCHAR(120) OS ID INT(11) OB_YEAR INT(4) OC OUT DATE DATE OB COST DECIMAL(8,2) OC DUE DATE DATE OB_SUBJECT VARCHAR(120) OC_IN_DATE DATE Indexes Indexes BOOK FINE B_NUM B_TITLE B_YEAR B_COST B_SUBJECT S_ID F_COUNT FFINE 5235 Cloud Computing 2018 99.95 Cloud 1163 3 4.00 5236 Conceptual Programming 2012 79.95 Programming 1164 2 12.00 5237 Beginner's Guide to JAVA 2013 89.95 Programming 1167 2.50 5238 Database in the Cloud 2013 59.95 Database 5239 Mastering the database environment 2012 59.95 Database CHECKOUT STUDENT C_NUM B_NUM S_ID C_OUT DATE C_DUE DATE C_IN_DATE S ID S_FNAME S LNAME S_TYPE 91001 5237 1163 2015-03-31 2015-04-14 2015-04-09 1163 Kelsey Baldwin UG 91002 5235 1164 2015-03-31 2015-04-07 2015-04-10 1164 Robert Alvarado PG 91003 5239 1167 2015-03-31 2015-04-14 2015-04-09 1167 Vera Carter PG 91004 5236 1168 2015-04-10 2015-04-24 2015-04-12 1168 Cedric Koch UG
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning