Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following statements DOES NOT delete the last value in the list lst?
a) 1st.pop(
b) 1st.remove(-1)
c) 1st = lst[:-1]
d) 1st.pop(len(lst)-1)
CREATE TABLE MOVIE(
mov_id int NOT NULL,
mov_title varchar(255) NOT NULL,
mov_releaseDate date,
gen_id int NOT NULL,
PRIMARY KEY (mov_id),
FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id)
);
CREATE TABLE GENRE(
gen_id int NOT NULL,
PRIMARY KEY (gen_id),
gen_name varchar(255) NOT NULL
);
Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.please use MySQL Workbench with screenshots of it for the explanation.
CREATE TABLE MOVIE(
mov_id int NOT NULL,
mov_title varchar(255) NOT NULL,
mov_releaseDate date,
gen_id int NOT NULL,
PRIMARY KEY (mov_id),
FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id)
);
CREATE TABLE GENRE(
gen_id int NOT NULL,
PRIMARY KEY (gen_id),
gen_name varchar(255) NOT NULL
);Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.
Chapter 5 Solutions
Oracle 12c: SQL
Ch. 5 - Which command should you use to copy data from one...Ch. 5 - Which command can you use to change the existing...Ch. 5 - Which of the following is a correct statement? a....Ch. 5 - Which of the following is a valid SQL...Ch. 5 - Which of the following statements deletes all rows...Ch. 5 - What is the maximum number of records that can be...Ch. 5 - Add a new row in the ORDERS table with the...Ch. 5 - Prob. 2HOACh. 5 - Save the changes permanently to the database.
Ch. 5 - Add a new row in the ORDERS table with the...
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
- Which of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.arrow_forwardQ9:- Which data-type .maketrans() return? Table List Tuple Dictionary Q 10:- How to loop over the float range? Arange Enumerate Range None of these Q4:- Which of the following is correct ? deafaultdict throws a KeyErrror when the key is not present in it. Sorting dictionary by the key has more runtime accessing than the sorting by the value. c)Sorting dictionary by the key has less runtime accessing than the sorting by the value. d).None of these. Q5:- Choose the correct statement:- getattr() and setattr() are used to retrieve and set class attributes. pow() and ** will always produce the same value. getattr() and setattr() are used to retrieve and set Constructor attribute. None of these.arrow_forwardWhich of the following statement is true?a) DELETE does not free the space containing the table and TRUNCATE free the space containing the tableb) Both DELETE and TRUNCATE free the space containing the tablec) Both DELETE and TRUNCATE does not free the space containing the tabled) DELETE free the space containing the table and TRUNCATE does not free the space containing the tablearrow_forward
- 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.arrow_forwardWhich of the following is true? All data in a table can be recovered if the table is dropped with the PURGE option. All data in a table can be recovered from the recycle bin if the table is dropped. All data in a table is lost if the table is dropped. All of the above statements are true.arrow_forwardWhich object in the data dictionary enables you to verify DEFAULT column settings? DEFAULT_COLUMNS DEF_TAB_COLUMNS USER_TAB_COLUMNS None of the abovearrow_forward
- Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;arrow_forwardWhich of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.arrow_forwardWhich of the following commands creates a new table containing a virtual column? a. CREATE TABLE newt able AS (SELECT order#, title, quantity, retail FROM orders); b. CREATE TABLE newt able (price NUMBER (3), total NUMBER (8, 2)); c. CREATE TABLE newt able (calc1 NUMBER (4), calc2 NUMBER (4); d. CREATE TABLE newt able (cola NUMBER (3), colb NUMBER (3), cole AS (cola+colb));arrow_forward
- Which of the following is not a valid SQL statement? CREATE TABLE anothernewtable (newtableid VARCHAR2 (2)); CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate, shipdate FROM orders); CREATE TABLE anothernewtable (firstdate, seconddate) AS (SELECT orderdate, shipdate FROM orders); All of the above are valid statements.arrow_forwardFill in the blank to complete the CREATE TABLE command below so that the type for customerzip would be fixed length 5-character string. CREATE TABLE customer ( customerid CHAR(7) NOT NULL, customername VARCHAR(15) NOT NULL, customerzip _______ NOT NULL, PRIMARY KEY (customerid) );arrow_forwardWhich of the following statements is correct? (refer to the tables in the JustLee Books database) a. A table can contain a maximum of only one column marked as unused. b. You can delete a table by removing all columns in the table. c. Using the SET UNUSED clause allows you to free up storage space used by a column. d. None of the above statements are correct.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY