Quizbowl 4

pdf

School

Georgia Gwinnett College *

*We aren’t endorsed by this school

Course

4200

Subject

Accounting

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by jam_1415

1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 4 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Quiz Submissions - QUIZ BOWL CHAPTER 4 X Jamaima Endres (username: jendres) Attempt 4 Written: Sep 9, 2020 5:14 PM - Sep 92, 2020 5:15 PM Submission View Your quiz has been submitted successfully. Question 1 1/ 1 point Consider the following SELECT statement: SELECT ship_id FROM ships WHERE 10 =5 + 5; Which of the following is true of this statement? it will execute and return no rows ) It will produce a syntax error because the WHERE clause does not refer to any columns in the table Vv It will execute and return the ship_id for each row in the table It will produce a syntax error because the WHERE clause always returns a TRUE value D View Feedback Question 2 1/ 1 point Consider the following table named "ports": PORT_ID PORT_NAME CAPACITY 1 Galveston 4 2 San Diego 4 3 San Francisco 3 4 Los Angeles 4 5 San Juan 3 6 Grand Cayman 3 https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465970&ai=31568742&isInPopup=0&cfql=0&romQB=0&ou... 1/6

1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 4 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Now consider the following SELECT statement: SELECT * FROM ports WHERE port_name LIKE 'San%’ OR port_name LIKE 'Grand%' OR capacity = 3; How many rows from the data in the table will be returned? None v )4 D View Feedback Question 3 1/ 1 point ACCT_ID CRUISE_NAME START_DATE END_DATE 1 Hawaii 11-JUL-12 24-JUL-12 2 Hawaii 10-OCT-12 23-0OCT-12 3 Mexico 04-OCT-12 17-0OCT-12 4 Mexico 06-DEC-12 19-DEC-12 What will be the value of the ACCT_ID for the first row displayed, given the following ORDER BY clause: ORDER BY cruise_name DESC, start_date; D View Feedback https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465970&ai=31568742&isInPopup=0&cfql=0&romQB=0&ou... 2/6

1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 4 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Question 4 1/ 1 point The ACCOUNT table contains these columns: ACCOUNT_ID NUMBER(12) NEW_BALANCE NUMBER(7,2) PREV_BALANCE NUMBER(7,2) FINANCE_CHARGE NUMBER(7,2) You need to accomplish these requirements: 1. Display accounts that have a new balance that is less than the previous balance. 2. Display accounts that have a finance charge that is less than $25.00 3. Display accounts have no finance charge. Which of the 3 requirements will this SELECT statement accomplish? SELECT account_ID FROM account WHERE new_balance < prev_balance OR NVL(finance_charge, 0) < 25; none of them one two v all three D View Feedback Question 5 1/ 1 point SELECT order num, '&order_date' FROM Orders WHERE order_date_placed = '&order_date’; Which statement regarding the execution of this statement is true? ) The user will be prompted for the order_date once each time the statement is executed in a session The user will be prompted for the order_date twice, but only the first time the statement is executed in a session v’ ) The user will be prompted for the order_date twice, each time the statement is executed in a session The statement will not run due to putting apostrophes around &order_date https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465970&ai=31568742&isInPopup=0&cfql=0&fromQB=0&ou... 3/6

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 4 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College D View Feedback Question 6 1/ 1 point Which of the following are true of the WHERE clause? Select all that apply. v W The WHERE clause comes after the FROM clause v/ (| WHEREidentifies which rows are to be included in the result set of the SELECT statement v TWHERE may be used by SELECT, UPDATE, and DELETE statements v The WHERE clause is optional D View Feedback Question 7 1/ 1 point Review the following data listing for a table VENDORS: VENDOR ID CATEGORY 1 Supplier 2 Teaming Partner Now review the following SQL statement: SELECT VENDOR ID FROM VENDORS WHERE CATEGORY IN ('Supplier', 'Subcontractor', '$Partner'); How many rows will the SELECT statement return? 0 None, because it will fail due to a syntax error in the WHERE clause https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465970&ai=31568742&isInPopup=0&cfql=0&fromQB=0&ou... 4/6

1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 4 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College D View Feedback Question 8 1/ 1 point A substitution variable can be used to replace: (select all that apply) <! | atable hame VI lacolumn name Vv Ja WHERE clause v ORDER BY options D View Feedback Question 9 1/ 1 point What does the following command do? Choose all that apply. ACCEPT vDept_ID PROMPT 'Enter a department ID code: ' v ) ltppausesmuntil the user enters a value and presses RETURN v It causes an error because there is no ampersand (&) in front of vDept_ID v ) It displays the text Enter a department ID code: | | It checks to see if the user entered a valid Dept_ID D View Feedback Question 10 1/ 1 point Which of the following will complete this SELECT statement to return EXACTLY 50% of the resulting rows? SELECT * FROM ORDERS FETCH FIRST 50 ROWS ONLY https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465970&ai=31568742&isInPopup=0&cfql=0&fromQB=0&ou... 5/6

1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 4 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College FETCH FIRST 50% ROWS ONLY V() FETCH FIRSTH50 PERCENT ROWS ONLY FETCH FIRST 50 PERCENT ROWS WITH TIES D View Feedback Attempt Score: 10/ 10-100 % Overall Grade (highest attempt): 10/ 10 - 100 % Done https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465970&ai=31568742&isInPopup=0&cfql=0&fromQB=0&ou... 6/6

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version