Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Refer to the sample tables and sample data below. Then answer questions (a), (b), (c), and (d).
Tables:
adult (id(pk), name, spouse_id (fk))
-- foreign key (spouse_id) references adult(id)
child (id(pk), name)
parent_child (parent (pk, fk), child (pk, fk))
-- foreign key (parent) references adult(id)
-- foreign key (child) references child(id)
mysql> SELECT * FROM adult;
id | name
1 Homer Simpson
2 | Marge Simpson
3
Fred Flintstone
4 Wilma Flintstone |
mysql> SELECT * FROM child;
|id|name
11 Bart
12
Lisa
13
Maggie
14 Pebbles
1
2
| spouse_id
mysql> SELECT * FROM parent_child;
parent | child |
2
1
2
3 |
41
11 |
11
12
12
13
13
14
14
1
4
How many times will the names Bart and Homer Simpson appear in the result set from the following command?
SELECT c.name, a.name
FROM child c JOIN parent_child pc ON c.id = pc.child
JOIN adult a ON a.id = pc.parent;
(a) Bart appears [Select]
(b) Homer Simpson appears [Select]
times.
✓times.
Which syntax is correct for removing a public synonym?a. DROP SYNONYM synonymname;b. DELETE PUBLIC SYNONYM synonymname;c. DROP PUBLIC SYNONYM synonymname;d. DELETE SYNONYM synonymname;
7. Create a private synonym that enables you to reference the MY_FIRST_SEQ object asNUMGEN.
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 types of restrictions can be viewed with the DESCRIBE command? NOT NULL FOREIGN KEY UNIQUE CHECKarrow_forwardWrite a script that creates and calls a stored procedure named spInsertInstructor that inserts a row into the Instructors table. This stored procedure should accept one parameter for each of these columns: LastName, FirstName, Status, DepartmentChairman, AnnualSalary, and DepartmentID. This stored procedure should set the DateAdded column to the current date. If the value for the AnnualSalary column is a negative number, the stored procedure should raise an error that indicates that this column doesn’t accept negative numbers. Code at least two EXEC statements that test this procedure.arrow_forwardwhich of the following operator is not specified in triggers? 1. insert 2. Alter 3. update 4. Deletearrow_forward
- You issue the following command: INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, NULL, ‘C’). The command will fail if which of the following statements is true?a. Col1 has a PRIMARY KEY constraint enabled.b. Col2 has a UNIQUE constraint enabled.c. Col3 is defined as a DATE column.d. None of the above would cause the command to fail.arrow_forwardWrite a script that creates and calls a stored procedure named spInsertDepartment. First, code a statement that creates a procedure that adds a new row to the Departments table. To do that, this procedure should have one parameter for the department name. Code at least two EXEC statements that test this procedure. (Note that this table does not allow duplicate department names.)arrow_forwardThe script: $Services = Read-Host "Please provide the name of the service you want to see Get-Services "$Services" | Select-Object Name, Status, DependentServices Format-Table AutoSize Objectives: Find the four errors and correct this script so that it will run correctly to get a name of the service from the user, and get the properties, Name, Status, DependentServices, of the service, and format it as a table with the use of the AutoSize SwitchParameter. There is exactly one error per line for a total of four errors to identify.arrow_forward
- Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? a. Me.CompanyDataSet.Fill(Me.Sales) b. Me.SalesBindingSource.Fill(Me.CompanyDataSet) c. Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) d. Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)arrow_forwardPlease create provide the command to create a new user with the following parameters: Name = your first or middle name Group = users Shell = /bin/zsh Fill in all the other fields as neededarrow_forwardFor all questions, you can assume that the following $() function is available:const $ = selector => document.querySelector(selector); Which of the following statements is NOT true? To display changes made to the DOM, you must refresh the web page. The DOM for a web page is built as the page is loaded by the web browser. The DOM is a hierarchical collection of nodes in the web browser’s memory. You can modify the DOM using the properties and methods that are defined by the DOM Core specification.arrow_forward
- In the formula below, which references will update when copied? =$C$3+$E7 a. Row 3 b. Row 7 c. Column C d. Column Earrow_forwardWhich of the following statements retrieves data from the Friends database and stores it in the FriendsDataSet?a. Me.FriendsDataSet.Fill(Friends.accdb)b. Me.TblNamesBindingSource.Fill(Me.FriendsDataSet)c. Me.TblNamesBindingNavigator.Fill(Me.FriendsDataSet.tblNames)d. Me.TblNamesTableAdapter.Fill(Me.FriendsDataSet.tblNames)arrow_forwardWhat is the difference between DELETE and TRUNCATE commands?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Microsoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
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