Starting out with Visual C# (4th Edition)
4th Edition
ISBN: 9780134382609
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, 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
___________________ can be used to terminate a PL/SQL loop.
EXIT WHEN
CONTINUE WHEN
GOTO
KILL
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.
Chapter 11 Solutions
Starting out with Visual C# (4th Edition)
Ch. 11.1 - Prob. 11.1CPCh. 11.1 - Why do most businesses use a DBMS to store their...Ch. 11.1 - When developing a C# application that uses a DBMS...Ch. 11.2 - Prob. 11.4CPCh. 11.2 - Prob. 11.5CPCh. 11.2 - What is the purpose of a primary key?Ch. 11.2 - Prob. 11.7CPCh. 11.2 - If a particular column is not allowed to be null,...Ch. 11.3 - List each of the .NET components that allow an...Ch. 11.3 - Prob. 11.10CP
Ch. 11.3 - What component is used to connect interface...Ch. 11.4 - Prob. 11.12CPCh. 11.4 - List the components that are automatically created...Ch. 11.4 - Prob. 11.14CPCh. 11.4 - What kind of information is displayed in the Data...Ch. 11.5 - How can you create a form that shows the columns...Ch. 11.5 - Prob. 11.17CPCh. 11.5 - Prob. 11.18CPCh. 11.6 - Prob. 11.19CPCh. 11.6 - When you create a Details view, what determines...Ch. 11.6 - Prob. 11.21CPCh. 11.6 - Prob. 11.22CPCh. 11.7 - In SQL, what is the purpose of the Select...Ch. 11.7 - What are the instructions for the DBMS to carry...Ch. 11.7 - How are the relational operators used in SQL...Ch. 11.7 - Prob. 11.26CPCh. 11.7 - Prob. 11.27CPCh. 11.7 - Prob. 11.28CPCh. 11.7 - Prob. 11.29CPCh. 11.7 - In an SQL statement, with what symbol does a query...Ch. 11 - Prob. 1MCCh. 11 - Prob. 2MCCh. 11 - A __________ holds a collection of related data...Ch. 11 - A __________ is a complete set of information...Ch. 11 - A(n) __________ holds an individual piece of...Ch. 11 - A __________ is a unique column value that can be...Ch. 11 - A(n) __________ is a column that contains unique...Ch. 11 - A __________ is a source of data with which the...Ch. 11 - A __________ connects to a data source and can...Ch. 11 - Prob. 10MCCh. 11 - A __________ is a component that can connect user...Ch. 11 - Prob. 12MCCh. 11 - A __________ can display an entire database table...Ch. 11 - A __________ is a set of individual controls that...Ch. 11 - Prob. 15MCCh. 11 - Prob. 16MCCh. 11 - Prob. 17MCCh. 11 - Prob. 18MCCh. 11 - __________, which stands for __________, is a...Ch. 11 - __________ are instructions for the DBMS to carry...Ch. 11 - In SQL, you use the __________ to retrieve the...Ch. 11 - A(n) __________ is an SQL statement that is stored...Ch. 11 - The __________ describes the contents of a...Ch. 11 - Prob. 1TFCh. 11 - The DBMS works directly with the data and sends...Ch. 11 - The data that is stored in a database is organized...Ch. 11 - Each column in a table must have a name.Ch. 11 - When you create a database table, the data types...Ch. 11 - When working with the data in a database table,...Ch. 11 - If a column in a database table contains no data,...Ch. 11 - An application works directly with a database,...Ch. 11 - Rather than showing multiple rows at once, a...Ch. 11 - Prob. 10TFCh. 11 - String comparisons in SQL are case sensitive.Ch. 11 - Prob. 1SACh. 11 - Briefly describe the layered nature of an...Ch. 11 - What is the data that is stored in a row of a...Ch. 11 - Are the data types used when creating a database...Ch. 11 - How do you create a primary key for a table with...Ch. 11 - Prob. 6SACh. 11 - Instead of working with the database directly,...Ch. 11 - What control can be used to display an entire...Ch. 11 - Prob. 9SACh. 11 - In SQL, what statement do you use to retrieve...Ch. 11 - Prob. 11SACh. 11 - Prob. 1AWCh. 11 - Write a Select statement that returns all the...Ch. 11 - Write a Select statement that returns only the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Write a Select statement that returns all the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - 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
- 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.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_forwardIn SQL Server, character data types may be distinguished as follows: NVARCHAR, NVARCHAR, and NVARCHAR.arrow_forward
- SQL 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_forwardIn SQL, you use the __ statement to retrieve the rows in a table. Question 7 options: SELECT FROM WHERE QUERYarrow_forwardIf the DOCTORS table has the following columns, and you want to write a SELECT statement to return the Doctors name and join_year who were joined before 2000, and after 2018. Column Name Data type Size Doctor_id Number Doctor_name Varchar2 30 Degree Varchar2 25 Join_year Number 4 Salary Number which of the following SQL statements should you use?arrow_forward
- 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 block to retrieve the doctor’s ID and name which in charge of certain patient. Allow the user to enter the patient’s ID.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_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_forwardIn PL/SQL, Create a recursive store function called add_numbers to calculate the total of all consecutive positive integers from 1 to the number entered by the user. The number that will stop the function must be entered by the user when running the function and be passed to the function. If the user enters a zero or a negative number, display the total as 0. You can use the function in a SELECT statement to execute it. See sample outputs below. ADD_NUMBERS(5)---------------------------- 15 ADD_NUMBERS(3)----------------------------- 6arrow_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