Programming with Microsoft Visual Basic 2017
8th Edition
ISBN: 9781337102124
Author: Diane Zak
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 12, Problem 3RQ
Program Description Answer
The statement to select and to sort the records in descending order by the field SSN from the table PayInfo is SELECT SSN FROM PayInfo ORDER BY SSN DESC.
Hence, the correct answer is option “B”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following will select the SSN field from the PayInfo table and then sort the records in descending order by the SSN field? a. SELECT SSN FROM PayInfo DESC b. SELECT SSN FROM PayInfo ORDER BY SSN DESC c. SELECT SSN FROM PayInfo WHERE SSN DESC d. SELECT SSN FROM PayInfo SORT SSN DESC
Which of the following statements represents a correctly structured transaction?
a.)
BEGIN;COMMIT;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11;
b.)
BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11;COMMIT;
c.)
BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348)insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip')UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11COMMIT
d.)
BEGIN;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert…
which DML keyword is used to make change to existing records in a table?
a) Insert
b) Select
c) Update
d) Delete
Chapter 12 Solutions
Programming with Microsoft Visual Basic 2017
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 has no partial or transitive dependencies? unnormalized data 1NF 2NF 3NFarrow_forwardWhich of the following has no partial dependencies but can contain transitive dependencies? a. unnormalized data b. 1NF c. 2NF d. 3NFarrow_forwardConsider the following command:UPDATE order_details SET quantity = quantity --10 What happens if we run this command in MySQL? a.) An error is thrown due to the --. b.) The quantity in the order_details table for all records is decremented by 10. c.) The order_details table has all of the quantity set to the same value as it previously had. d.) The quantity in the order_details table for all records is incremented by 10.arrow_forward
- 134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);arrow_forwardIn Kali, login to DVWA, set security level to low , then click SQL Injection on left pane .Write sqlmap commands to answer the following questions, and paste the result underneath each of your sqlmap commands. 1 . Find all database names 2. Find the current database name 3.find all table names under a database named DVWA 4.find column named in the table named users in database dvwa 5. find all values in the table users in database dvwa (when your command runs and prompts questions, you just enter n for no)arrow_forwardAssuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);d. UPDATE homework10 SET col1 = col3;arrow_forward
- Which of the following will select the Id and Status fields for records whose Status field contains only the letter F? a. SELECT Id, Status FROM tblEmp WHERE Status = 'F' b. SELECT Id, Status FROM tblEmp ORDER BY Status = 'F' c. SELECT Id, Status FROM tblEmp FOR Status = 'F' d. SELECT Id, Status FROM tblEmp SELECT Status = 'F'arrow_forwardWhich of the following will select the Id and Status fields for records whose Status field contains only the letter F? a. SELECT Id, Status FROM Employ WHERE Status = 'F' b. SELECT Id, Status FROM Employ ORDER BY Status = 'F' c. SELECT Id, Status FROM Employ FOR Status = 'F' d. SELECT Id, Status FROM Employ SELECT Status = 'F'arrow_forwardWhich of the following is an inmemory copy of data pulled from one or more database tables? 1. Table adapter 2. Table relation 3. Dataset 4. Data recordarrow_forward
- It doen't show output, fix the code -- Create the Clients table CREATE TABLE Clients ( ClientID VARCHAR2(10) PRIMARY KEY, ClientName VARCHAR2(255), ZipCode VARCHAR2(10), ClientCode VARCHAR2(1), Contact VARCHAR2(255), OrderDate DATE );-- Commit the changes to save the table structureCOMMIT; -- Populate the Clients table with data from Figure 2 INSERT INTO Clients (ClientID, ClientName, ZipCode, ClientCode, Contact, OrderDate) VALUES ('B5182', 'Basic Broadcasting', '60631', 'A', 'Sammy', TO_DATE('08/03/2019', 'MM/DD/YYYY')), ('C1825', 'Computer Capers', '60656', 'A', 'Sammy', TO_DATE('01/18/2020', 'MM/DD/YYYY')), ('D8125', 'David D. Davies', '60625', 'B', 'George', TO_DATE('02/02/2020', 'MM/DD/YYYY')), ('E5051', 'Edward\'s Enterprise', '60604', 'A', 'Paula', TO_DATE('02/28/2020', 'MM/DD/YYYY')), ('F5150', 'Frank\'s Fixtures', '60629', 'C', 'Paula', TO_DATE('01/07/2019', 'MM/DD/YYYY')), ('J4712', 'Jerry\'s Journals', '60634', 'F', 'Pete', TO_DATE('01/22/2020', 'MM/DD/YYYY')), ('M1758',…arrow_forwardCreate a MySQL database with a minimum of 4 tables. Use the DDL commands. The tables must be related using the primary and foreign keys. Add at least 5 records per table using the Insert command. Delete 1 record in any of the tables. Edit 1 record in any of the tables. Write and execute at least 5 queries to retrieve records using the Select command. Select limited columns, filter records using where, sort records using order by, and link two or more tables using an inner join.arrow_forwardWhich of the following is a task performed by the driver according to the ODBC standard? Select one: a. Determines the appropriate DBMS b. Converts the data source into an SQL-compliant data structure c. Validates the format of the ODBC command received from the application d. Verifies the application to the data source e. Converts data source error codes into ODBC standard error codes Additional DBA responsibilities do not include ________. Select one: a. controlling database configuration b. requests of changes to existing systems c. maintaining appropriate documentation d. editing E-R diagrams e. problem and error reporting The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________. Select one: a. rollforward b. transaction logging c. reprocessing d. checkpointing e. rollback Which of the following is the correct technique for representing a 1:N relationship in the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY