Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

urgent please help Assuming before any code is run, there are 12 rows in the employees table: How many rows will be returned by the

urgent please help

image text in transcribed
Assuming before any code is run, there are 12 rows in the employees table: How many rows will be returned by the last statement? (1 mark) Explain in your own words how you came to the number you stated and why! loaded a new session in SSMS connected to our database SET IMPLICIT TRANSACTIONS ON; COMMIT ; INSERT INTO employees (employeeNumber, lastName, first Name, email) VALUES (13, ' Smith', 'John', 'jsmith@mydomain.com' ) ; CREATE VIEW vwShowEmps AS SELECT * FROM employees; INSERT INTO employees (employeeNumber, lastName, firstName, email) VALUES (14, 'Patel', 'Ronnie', 'rpatel(mydemain.com' ) ; ROLLBACK; SELECT * FROM wwShowEmps; For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). B I Y S Paragraph Arial 10pt

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

Modern Dental Assisting

Authors: Doni Bird, Debbie Robinson

13th Edition

978-0323624855, 0323624855

Students also viewed these Programming questions

Question

What is community?

Answered: 1 week ago

Question

What are the features of the community?

Answered: 1 week ago

Question

1. What are Associations ?

Answered: 1 week ago

Question

1. What is socialization?

Answered: 1 week ago

Question

1. State how schools help in socialization?

Answered: 1 week ago