Pearson eText for Starting out with Visual C# -- Instant Access (Pearson+)
5th Edition
ISBN: 9780137502783
Author: Tony Gaddis
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 21MC
In SQL, you use the __________ to retrieve the rows in a table.
- a. Select statement
- b. Like operator
- c. % symbol
- d. Where clause
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
in sql
The PL/SQL block starts with the _____ section.
Select one:
a. DECLARE
b. BEGIN
c. IS
d. OPEN
INFO 2303
Database Programming
Assignment # : PL/SQL Procedure & Function Practice
Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL.
Write a script to create a PL/SQL procedure called findSal that displays the doctor’s salary and bonus after passing in the doc_id into the procedure. For example, if you pass in doc_id 504, you will get the following output.
execute findSal(504)
The salary for Dr.Cotner (504) is: 11500
The bonus is: 7500
PL/SQL procedure successfully completed.
___________________ can be used to terminate a PL/SQL loop.
EXIT WHEN
CONTINUE WHEN
GOTO
KILL
Chapter 12 Solutions
Pearson eText for Starting out with Visual C# -- Instant Access (Pearson+)
Ch. 12.1 - Prob. 12.1CPCh. 12.1 - Why do most businesses use a DBMS to store their...Ch. 12.1 - When developing a C# application that uses a DBMS...Ch. 12.2 - Prob. 12.4CPCh. 12.2 - Prob. 12.5CPCh. 12.2 - What is the purpose of a primary key?Ch. 12.2 - Prob. 12.7CPCh. 12.2 - If a particular column is not allowed to be null,...Ch. 12.3 - List each of the .NET components that allow an...Ch. 12.3 - Prob. 12.10CP
Ch. 12.3 - What component is used to connect interface...Ch. 12.4 - Prob. 12.12CPCh. 12.4 - List the components that are automatically created...Ch. 12.4 - Prob. 12.14CPCh. 12.4 - What kind of information is displayed in the Data...Ch. 12.5 - How can you create a form that shows the columns...Ch. 12.5 - Prob. 12.17CPCh. 12.5 - Prob. 12.18CPCh. 12.6 - Prob. 12.19CPCh. 12.6 - When you create a Details view, what determines...Ch. 12.6 - Prob. 12.21CPCh. 12.6 - Prob. 12.22CPCh. 12.7 - In SQL, what is the purpose of the Select...Ch. 12.7 - What are the instructions for the DBMS to carry...Ch. 12.7 - How are the relational operators used in SQL...Ch. 12.7 - Prob. 12.26CPCh. 12.7 - Prob. 12.27CPCh. 12.7 - Prob. 12.28CPCh. 12.7 - Prob. 12.29CPCh. 12.7 - In an SQL statement, with what symbol does a query...Ch. 12 - Prob. 1MCCh. 12 - Prob. 2MCCh. 12 - A __________ holds a collection of related data...Ch. 12 - A __________ is a complete set of information...Ch. 12 - A(n) __________ holds an individual piece of...Ch. 12 - A __________ is a unique column value that can be...Ch. 12 - A(n) __________ is a column that contains unique...Ch. 12 - A __________ is a source of data with which the...Ch. 12 - A __________ connects to a data source and can...Ch. 12 - Prob. 10MCCh. 12 - A __________ is a component that can connect user...Ch. 12 - Prob. 12MCCh. 12 - A __________ can display an entire database table...Ch. 12 - A __________ is a set of individual controls that...Ch. 12 - Prob. 15MCCh. 12 - Prob. 16MCCh. 12 - Prob. 17MCCh. 12 - Prob. 18MCCh. 12 - __________, which stands for __________, is a...Ch. 12 - __________ are instructions for the DBMS to carry...Ch. 12 - In SQL, you use the __________ to retrieve the...Ch. 12 - A(n) __________ is an SQL statement that is stored...Ch. 12 - The __________ describes the contents of a...Ch. 12 - Prob. 1TFCh. 12 - The DBMS works directly with the data and sends...Ch. 12 - The data that is stored in a database is organized...Ch. 12 - Each column in a table must have a name.Ch. 12 - When you create a database table, the data types...Ch. 12 - When working with the data in a database table,...Ch. 12 - If a column in a database table contains no data,...Ch. 12 - An application works directly with a database,...Ch. 12 - Rather than showing multiple rows at once, a...Ch. 12 - Prob. 10TFCh. 12 - String comparisons in SQL are case sensitive.Ch. 12 - Prob. 1SACh. 12 - Briefly describe the layered nature of an...Ch. 12 - What is the data that is stored in a row of a...Ch. 12 - Are the data types used when creating a database...Ch. 12 - How do you create a primary key for a table with...Ch. 12 - Prob. 6SACh. 12 - Instead of working with the database directly,...Ch. 12 - What control can be used to display an entire...Ch. 12 - Prob. 9SACh. 12 - In SQL, what statement do you use to retrieve...Ch. 12 - Prob. 11SACh. 12 - Prob. 1AWCh. 12 - Write a Select statement that returns all the...Ch. 12 - Write a Select statement that returns only the...Ch. 12 - Write a Select statement that returns the...Ch. 12 - Write a Select statement that returns the...Ch. 12 - Write a Select statement that returns all the...Ch. 12 - Write a Select statement that returns the...Ch. 12 - Write a Select statement that returns the...Ch. 12 - Personnel Database Use Visual Studio to create a...
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
- SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings representing students names, and 2 integers representing the marks they received in DBS311. The function will determine which student had the higher mark and return the name of the student. If the marks were the same, then return the word "same" and return "error" if an error occurs or the calculation can not be determined.arrow_forwardPL/SQL Block DECLARE v_weight NUMBER (3) := 600; VARCHAR2 (255) v_message := 'Product 10012'; BEGIN DECLARE v_weight NUMBER ( 3) := 1; v_message VARCHAR2 (255) :- 'Product 11001'; v_new_locn VARCHAR2 (50) := 'Europe'; BEGIN v_weight := v_weight + 1; v_new_locn := 'Western ' || v_new_locn; 1) END; v_weight := v_weight + 1; v_message :- v_message || ' is in stock'; v_new_locn := 'Western ' || v_new_locn; 2) END; racle Academy nly 1. Evaluate the preceding PL/SQL block and determine the data type and value following variables according to the rules of scoping. a. The value of v_weight at position 1 is: each of the b. The value of v_new_locn at position 1 is: c. The value of v_weight at position 2 is: d. The value of v_message at position e. The value of v_new_locn at position .arrow_forwardSQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql Part I: Problem 1. Write a stored procedure that adds a new employee to lgemployee table. Pass the field values to the procedure as parameters. Problem 2. Use parameters and a DECLARE statement to display employees that were hired in every decade beginning 1970. The program should return the statements similar to this: 12 employees were hired between 1970 and 198019 employees were hired between 1980 and 1990etc. Part II: Problem 1. Write a cursor to print a report for each employee’s salary history. Display employee’s number, last and first name, and the salary with the starting date. Problem 2. Modify the previous problem code to make it a stored procedure that accepts employee’s last name asarrow_forward
- In SQL Server, character data types may be distinguished as follows: NVARCHAR, NVARCHAR, and NVARCHAR.arrow_forwardIn SQL, you use the __ statement to retrieve the rows in a table. Question 7 options: SELECT FROM WHERE QUERYarrow_forwardDatabase: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_allarrow_forward
- Please develop PL/SQL program that asks for a radius of a circle.After user enters a radius number, the program then calculates 1. Circumference and 2. Area of a circle, then prints both as follows: You entered radius as 5The circumference is 31.4159The area is 78.5398 If the area is less than 50 then print 'Please enter bigger radius'.Otherwise print 'Your radius is Ok'. Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dotarrow_forwardexample inn 100 sqlmstatementarrow_forward**In SQL** Write a SELECT statement that returns these columns: InstructorDept The DepartmentName column from the Departments table for a related instructor LastName The LastName column from the Instructors table FirstName The FirstName column from the Instructors table CourseDescription The CourseDescription column from the Courses table CourseDept The DepartmentName column from the Departments table for a related instructor Return one row for each course that’s in a different department than the department of the instructor assigned to teach that course. (Hint: You will need to join the Departments table to both the Instructors table and the Courses table, which will require you to use table aliases to distinguish the two tables.)arrow_forward
- Online shopping system & online book store: Rebuild View/Edit cart and checkout pages using PL/SQL like the following: Create a function/procedure to update the quantity of the product in the cart if the new quantity is available in the store. Create a trigger that deletes the product from the cart after updating the quantity to 0. Don't forget to return the old quantity to the store. Create a trigger that empties the customer cart after the customer clicks on the checkout.arrow_forwardISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%arrow_forwardin sql The DECLARE section in the trigger is used to declare any variables used inside the trigger code. Select one: a. True b. Falsearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
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