Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Q5) The following table has been created: CREATE TABLE student_table ( Stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ) ; which one of the following INSERT statements will work successfully? a) INSERT INTO student_table (stud_id, last_name, first_name, lunch_name) VALUES (143354, Roberts','Cameron',654378); b) INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352678,6543,'Cameron','Roberts'); c) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543, 1); d) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543) atabase_MG_2010.pur 10 Tom 31 Jack 11 12 14 26 Q6) Based on the Employees table how many rows will result from the following SQL query: ID Name Grade Age Select grade, min(age) from employee where age > 22 group by grade having Sam Sally Sarah Silvia a) 6 rows b) 3 rows c) 2 rows 1 2 3 1 8 3 273222 20 21 24 01010 11101101 0101010111111 1010101010101 111010101010 01011001 25 26 min(age) > 23 1010101 021.pur 101010101 1011001

Q5) The following table has been created: CREATE TABLE student_table ( Stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ) ; which one of the following INSERT statements will work successfully? a) INSERT INTO student_table (stud_id, last_name, first_name, lunch_name) VALUES (143354, Roberts','Cameron',654378); b) INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352678,6543,'Cameron','Roberts'); c) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543, 1); d) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543) atabase_MG_2010.pur 10 Tom 31 Jack 11 12 14 26 Q6) Based on the Employees table how many rows will result from the following SQL query: ID Name Grade Age Select grade, min(age) from employee where age > 22 group by grade having Sam Sally Sarah Silvia a) 6 rows b) 3 rows c) 2 rows 1 2 3 1 8 3 273222 20 21 24 01010 11101101 0101010111111 1010101010101 111010101010 01011001 25 26 min(age) > 23 1010101 021.pur 101010101 1011001

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
100%
Q5) The following table has been created: CREATE TABLE student_table ( Stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ) ; which one of the following INSERT statements will work successfully? a) INSERT INTO student_table (stud_id, last_name, first_name, lunch_name) VALUES (143354, Roberts', 'Cameron',654378); b) INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352678,6543,'Cameron', 'Roberts'); c) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543, 1); d) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543) atabase_MG_2010.pur 10 Tom 31 Jack 11 Sam 12 Sally 14 Sarah 26 Silvia Q6) Based on the Employees table how many rows will result from the following SQL query: ID Name Grade Age Select grade, min(age) from employee where age > 22 group by grade having 1 2 3 1 8 3 a) 6 rows b) 3 rows E c) 2 rows d) 5 rows e) 4 rows 0001010 11101101 010101011111 1010101010101 111010101010 01011001 20 21 23 24 25 26 Te Labase_ min(age) > 23 11010101010 1010101 01011001
Transcribed Image Text:Q5) The following table has been created: CREATE TABLE student_table ( Stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ) ; which one of the following INSERT statements will work successfully? a) INSERT INTO student_table (stud_id, last_name, first_name, lunch_name) VALUES (143354, Roberts', 'Cameron',654378); b) INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352678,6543,'Cameron', 'Roberts'); c) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543, 1); d) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543) atabase_MG_2010.pur 10 Tom 31 Jack 11 Sam 12 Sally 14 Sarah 26 Silvia Q6) Based on the Employees table how many rows will result from the following SQL query: ID Name Grade Age Select grade, min(age) from employee where age > 22 group by grade having 1 2 3 1 8 3 a) 6 rows b) 3 rows E c) 2 rows d) 5 rows e) 4 rows 0001010 11101101 010101011111 1010101010101 111010101010 01011001 20 21 23 24 25 26 Te Labase_ min(age) > 23 11010101010 1010101 01011001
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS