19. The following code refers to the sample data in the table people. What is the result of each selectstatement?* FROM people WHERE spouse id IS NULL WITH CHECK OPTION;CREATE VIEW new people AS SELECT(a) SELECT COUNT (*) FROM people;(b) SELECT COUNT(*) FROM new_ people;INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown');(c) SELECT COUNT(*) FROM people;(d) SELECT COUNT (*) FROM new people;INSERT INTO new_people (firstname, lastname, spouse_id) VALUES ('Clara', 'Clayton', 6) ;(e) SELECT COUNT(*) FROM people;(f) SELECT COUNT (*) FROM new_people; For the remaining questions, use the following table of people:people (id (pk), firstname, lastname, spouse_id (fk))The table was created as:CREATE TABLE people (id INT NOT NULL AUTO INCREMENT PRIMARY KEY,firstname VARCHAR(30), lastname VARCHAR (30), spouse id INT,CONSTRAINT spouse fk FOREIGN KEY (spouse id) REFERENCES people (id));This is some sample data:Participation Activity 9+----| id | firstname | lastname | spouse_id |+1 | Marty2 | Jennifer| McFly| Parker| McFly| Tannen| McFly||3 | Lorraine4 | Biff5 | GeorgeNULL |NULL |5 |NULL |3 |+----+--

Note: - As per the guidelines we can only answer one specific question at a time. Please resubmit…

19. The following code refers to the sample data in the table people. What is the result of each select statement? FROM people WHERE spouse_id IS NULL WITH CHECK OPTION; CREATE VIEW new people AS SELECT * (a) SELECT COUNT(*) FROM people; (b) SELECT COUNT(*) FROM new_people; INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown'); (c) SELECT COUNT(*) FROM people; (d) SELECT COUNT(*) FROM new_people; INSERT INT0 new_people (firstnameę, lastname, spouse_id) VALUES ('Cclara', 'Clayton', 6); (e) SELECT COUNT(*) FROM people; (f) SELECT COUNT(*) FROM new_people;

19. The following code refers to the sample data in the table people. What is the result of each select statement? FROM people WHERE spouse_id IS NULL WITH CHECK OPTION; CREATE VIEW new people AS SELECT * (a) SELECT COUNT() FROM people; (b) SELECT COUNT() FROM new_people; INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown'); (c) SELECT COUNT() FROM people; (d) SELECT COUNT() FROM new_people; INSERT INT0 new_people (firstnameę, lastname, spouse_id) VALUES ('Cclara', 'Clayton', 6); (e) SELECT COUNT() FROM people; (f) SELECT COUNT() FROM new_people;

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: CREATE TABLE employees ( employee_number int NOT NULL, last_name char(50) NOT NULL, first_name…

A: Create table employee and insert given values to the table.

Q: Second normal form says: a. No nonkey columns depend on another nonkey column. b. Every…

A: The second normal form says: a. No nonkey columns depend on another non-key column. b. Every…

Q: (31, '978-1-11111-145-1', 1, '2019-11-06', '27.95', NULL, NULL), (32, '978-1-11111-145-1', 1,…

A: SQL PARTITION BY By using partition by clause we get all the records in the table. It gives…

Q: CREATE TABLE EMPLOYEE( ENUM DECIMAL(12) NOT NULL,/* Employee number */ FNAME VARCHAR(50) NOT NULL,/*…

A: the answer is:

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: CREATE TABLE STATS( Deaths_per_100000 INTEGER(50), AGE INTEGER(20), GENDER VARCHAR(10), RATIO…

A: CREATE : In the database, a new table is created using the CREATE TABLE command. INSERT : New…

Q: Database Q1: Which one of the following INSERT statements will successfully insert a single row?…

A: Find the appropriate answer for the sql database questions.

Q: Consider the following TWO relations: Instructor(ID, name, dept_name, salary) Teaches (ID,…

A: SQL stands for Structured Query Language.

Q: CREATE TABLE DONORS ( donor_id INT NOT NULL, donor_name varchar(255) NOT NULL, donor_age int,…

A: INSERT INTO DONORS VALUES(1,'SAI',20); INSERT INTO DONORS VALUES(2,'PAVAN',21); INSERT INTO DONORS…

Q: 9. Write a trigger that prohibits duplicate values except for nulls in the NoDupName column of the…

A: Note: As triggers are not supported by online compilers, you can test them yourself. Given table:…

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…

A: The answer is

Q: Question 15 Suppose that you have the following table created as: CREATE TABLE TAB1 (NAME VARCHAR2…

A: For this question we can decompose the name by using parsename. Parsename will decompose a full name…

Q: Jump to level 1 CREATE TABLE Country ( Name VARCHAR (60), Population INTEGER, Over 65 PopPct FLOAT,…

A: The question is asking about the values of certain columns in a database table named 'Country' for a…

Q: Create table customer1( Customer# number primary key, First_name varchar2(25, Last_name…

A: Please find the answer below :

Q: PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female…

A: It is defined as a powerful general-purpose programming language. It is used in web development,…

Q: DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY…

A: Answer in step 2

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION:…

A: A) : create function Return_region_name { @region_id num, } returns varchar as begin (select name…

Q: Show their content after: 1) Update student set sid = 9999 where sid = 5275 2) Update student set…

A: Below is the complete solution with explanation in detail for the given question about updating…

Q: Create table Medicine (MInventory_Id int primary key, M_Name varchar (40), Manufacturer varchar…

A: In sql the following queries must be entered to create two tables "Medicine" and…

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Attached handwritten Image of the procedure to add a row to the INVOICES table.

Q: Write a SELECT statement that returns one row for each customer that has orders with these columns:…

A: The code you made:- SELECT email_address, COUNT(*) AS num_orders, SUM(quantity*(price-discount)) AS…

Q: 1. Write a SELECT statement that returns four columns from the Products table: ProductCode,…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for…

Q: firstthree (my_seqid in varchar2) as cursor c1 is select sname, grade from student s join…

A: Below are the steps needed

Q: with it, paste your code in a text file named Student.txt and save it in your task folder. Write the…

A: This is a SQL question, here first we have to create a table student with a given parameter, then we…

Q: Which group function can be used to perform a count that includes NULL values?

A: Group by functions are : SUM ( [ALL | DISTINCT ] expression ) AVG ( ALL | DISTINCT ] expression )…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

19. The following code refers to the sample data in the table people. What is the result of each select
statement?
* FROM people WHERE spouse id IS NULL WITH CHECK OPTION;
CREATE VIEW new people AS SELECT
(a) SELECT COUNT (*) FROM people;
(b) SELECT COUNT(*) FROM new_ people;
INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown');
(c) SELECT COUNT(*) FROM people;
(d) SELECT COUNT (*) FROM new people;
INSERT INTO new_people (firstname, lastname, spouse_id) VALUES ('Clara', 'Clayton', 6) ;
(e) SELECT COUNT(*) FROM people;
(f) SELECT COUNT (*) FROM new_people;

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.

Similar questions

Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.
T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT. HINT use cursor instructions as a template for the problem. Instructions goes as follows CREATE PROCEDURE usp_DISP_REP_CUST @repnum char(2) AS DECLARE@custnum char(3) DECLARE@custname char(35) DECLARE mycursor CURSOR READ_ONLY FOR SELECT CUSTOMER_NUM, CUSTOMER_NAME FROM CUSTOMER WHERE REP_NUM = @repnum OPEN mycursor FETCH NEXT FROM mycursor INTO @custnum, @custname WHILE @@FETCH_STATUS=0 BEGIN PRINT@custnum+' '+@custname FETCH NEXT FROM mycursor INTO @custnum, @custname END CLOSE mycursor DEALLOCATE mycursor
SQL CODE FOR For the players who show up in Batting, Bowling, and Fielding tables, create a list that shows their names, runs they have scored, wickets they have taken, and catches they have taken? table is in picture (bowling table is same as batting and fielding )
Write a ASQ statement to return to see all of the first names in the People table. SELECT first name FROM people; WHERE FROM People first name; FROM People SELECT first_name; First name WHERE FROM People;
Create a stored procedure that will return the number of customers in a given state. The parameter for your stored procedure should accept the state abbreviation ('UT') and return the results of a query that returns the number of customers in that state.
WEEK 3 ASSIGNMENT Complete the following exercise: Using the student table you created in week two insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that lists the titles of films with the fewest rows in the inventory table. This query requires a subquery that computes the minimum of counts by film_id: SELECT MIN(count_film_id) FROM ( SELECT COUNT(film_id) AS count_film_id FROM inventory GROUP BY film_id ) AS temp_table; This subquery is provided in the template.
Third normal form says: a. No nonkey columns depend on another nonkey column. b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above.
SQL A table Products have: a name (TEXT) a description (TEXT) a unit cost stored in cents (INTEGER) and of course we also add an id column to identify them. Separately, we'd like to track the number of items in stock for each product. To do so we'll have a store and an inventory table. Stores have just an id and a name. Then, our inventory table should combine stores and products, listing how much of each product each store has in stock. a product_id (INTEGER) a store_id (INTEGER) a quantity (INTEGER) in stock Now we can insert some stores, products and inventory into our database. There are 2 stores -- one called NY and one called NJ. There are 2 products we are concerned with. Their names are sneakers, costing $220 (remember this is dollars!) and boots costing $350. Use any description for each that you'd like. NY has 4 sneakers in stock and 3 boots. NJ has 5 sneakers in stock and no boots. Insert the above data into the tables you have created.
INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.
First normal form says: a. No nonkey columns depend on another nonkey column b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above
4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null.