Q3

pdf

School

Georgia Gwinnett College *

*We aren’t endorsed by this school

Course

4200

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

6

Uploaded by jam_1415

Report
1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 3 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Quiz Submissions - QUIZ BOWL CHAPTER 3 X Jamaima Endres (username: jendres) Attempt 6 Written: Jan 12, 2021 1:20 PM - Jan 12, 2021 1:27 PM Submission View Your quiz has been submitted successfully. Question 1 2 / 2 points Consider the ADDRESS table that has the following 3 columns and no rows: ID NUMBER NOT NULL, ZONE NUMBER, ZIP_CODE VARCHAR2(5) COMMIT; INSERT INTO ADDRESS VALUES (1, 1, '94506'); SAVEPOINT ZONE_ADDRESS_1; UPDATE ADDRESS SET ZONE = 2 WHERE ZIP_CODE ='94506'; ROLLBACK; ADDRESS will have 1 row with a value of 1 for ZONE. ADDRESS will have 1 row with a value of 2 for ZONE. v the ADDRESS table will have no rows. The statements will generate a syntax error. D View Feedback Question 2 2 / 2 points If a table T3 has four numeric columns (A, B, C, D) and no primary key, which of these statements will succeed? Choose all that apply. v LINSERT INTO T3 VALUES (3, 6, 7, NULL); v/l INSERT INTO T3 VALUES ('3} '9, 10, '12"); https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465969&ai=34550292&isInPopup=0&cfql=0&fromQB=0&ou... 1/6
1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 3 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College V[ ] INSERT INTO T3 SELECT * FROM T3; v NONE OF THESE INSERT STATEMENTS WILL SUCCEED. D View Feedback Question 3 2 / 2 points What is the result of: UPDATE cruises SET cruise_name = 'Bahamas', SET start_date = SYSDATE WHERE cruise _id = 1; An error will occur because two columns cannot be updated with one UPDATE For the first record in the CRUISES table whose cruise_id is 1, cruise_name will be set to '‘Bahamas' and start_date will be set to the current date v For the all records in the CRUISES table whose cruise_id is 1, cruise_name will be set to '‘Bahamas' and start_date will be set to the current date For the all records in the CRUISES table whose cruise_id is 1, cruise_name will be set to '‘Bahamas' and start_date will be set to the current date, as long as their original values were not NULL D View Feedback Question 4 0 / 2 points Which of these commands will remove every row in a table, but not delete the table itself? Choose one or more answers. = 3% (| | ADELETE command with no WHERE clause v A DROP TABLE command = I I ATRUNCATE command ) 4 UPDATE command, setting every column to NULL with no WHERE clause. https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465969&ai=34550292&isInPopup=0&cfql=0&fromQB=0&ou... 2/6
1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 3 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College D View Feedback Question 5 2 / 2 points CREATE TABLE STUDENT_LIST (STUDENT_ID NUMBER, STUDENT_NAME VARCHAR2(30), STUDENT_PHONE VARCHAR2(20)); INSERT INTO STUDENT_LIST VALUES (1, Joe Wookie', 3185551212); The table will create succesfully. What will result from the INSERT statement execution? It will fail because there is no column listing It will fail because the value for STUDENT_PHONE is numeric, and STUDENT_PHONE is a character datatype. v It will execute and the table will contain one row of data. It will fail because no primary key has been specified for the table. D View Feedback Question 6 2 / 2 points A user named SALLY updates some rows, and asks another user MELVIN to login and check the changes before she commits them. Which of the following statements is true about this situation? (Choose the best answer.) MELVIN can see SALLY's changes but cannot alter them until SALLY commits. v MELVIN cannot see SALLY's updates because she has not entered the COMMIT command. SALLY must commit the updates, so that MELVIN can view them, and if necessary roll them back. SALLY must commit the updates, so that MELVIN can view them, but only SALLY can roll them back. D View Feedback https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465969&ai=34550292&isInPopup=0&cfql=0&fromQB=0&ou...
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 3 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Question 7 2 / 2 points CREATE TABLE SHIPS ( Ship_ ID NUMBER, Ship_name VARCHARZ2(20), Home_port_id NUMBER(4)); What will be the result of the following DML statement: INSERT INTO SHIPS(Ship_name, Ship_ID) VALUES (‘Codd Vessel II', 4001); An error because Home_port_id was not given a value v One row will be inserted with ship_ID having a value of 4001, ship_name having value 'Codd Vessel II', and Home_port_id will be NULL. An error because the datatypes of the columns and values are misaligned An error because Ship_name and Ship_ID are in reverse order D View Feedback Question 8 2 / 2 points To delete the data values from one entire column in a table (but not remove the column from the table), you would use the __ command. DELETE COLUMN DROP COLUMN v UPDATE without a WHERE clause ALTER TABLE D View Feedback Question 9 2 / 2 points SALLY updates some rows but does not commit. MELVIN queries the rows that SALLY updated. Which of the following statements is true? (Choose the best answer.) MELVIN will not be able to see the rows that SALLY updated because they will be locked. https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465969&ai=34550292&isInPopup=0&cfql=0&fromQB=0&ou... 4/6
1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 3 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College MELVIN will be able to see the updated values. v MELVIN will see the old versions of the rows. - MELVIN will see the old data as it was before SALLY issued a SAVEPOINT command. D View Feedback Question 10 2 / 2 points Consider the following table called PARTS: PNO PART_TITLE STATUS 1 Processor V1.0 VALID 2 Encasement X770 PENDING 3 Board CPU XER A7 PENDING Which of the following SQL statements will remove the word VALID from row 1, resulting in that row with a status of NULL and two rows with a status of PENDING? DELETE FROM PARTS WHERE STATUS = 'VALID'; DELETE FROM PARTS WHERE PNO = 1; DELETE FROM PARTS SET STATUS = NULL WHERE PNO = 1; v None of these answers is correct D View Feedback Attempt Score: 18/20-90% Overall Grade (highest attempt): 20/ 20 - 100 % Done https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465969&ai=34550292&isInPopup=0&cfql=0&fromQB=0&ou... 5/6
1/14/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 3 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College https://ggc.view.usg.edu/d2l/ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465969&ai=34550292&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
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

final_exam.txt
Quiz5__CS434001-Advanced_Database_Systems.pdf
info102lab1questions.pdf
Barnacle Lab work.docx
Quiz 1.docx
Q9.pdf
CSCI N207 Quiz Five Answers.docx
CSCI N207 Quiz Three Answers.docx
CSCI N207 Quiz One Answers.docx
CSCI N207 Quiz Four Answers.docx
CSCI N207 Quiz Two Answers.docx
README.md.docx
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
SEE MORE TEXTBOOKS