t3

pdf

School

Georgia Gwinnett College *

*We aren’t endorsed by this school

Course

4200

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by jam_1415

1/15/2021 : Quiz Submissions - CHAPTER 3 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Quiz Submissions - CHAPTER 3 TBV X Jamaima Endres (username: jendres) Attempt 1 Written: Aug 23, 2020 2:24 PM - Aug 23, 2020 3:18 PM Submission View Your quiz has been submitted successfully. Question 1 1/ 1 point The ALTER command is used to make changes to the data in a table. True v False W Hide Feedback The UPDATE command is used to make changes to the data. ALTER is used to make changes to the columns, constraints, tables, etc. that make up the schema. Question 2 1/ 1 point A provides a value to be inserted when one is not explicitly given in the INSERT statement. v DEFAULT PLACE HOLDER SAVEMARK SAVEPOINT W Hide Feedback https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465943&ai=30908084 &isInPopup=0&cfql=0&romQB=0&ou... 1/5

1/15/2021 : Quiz Submissions - CHAPTER 3 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College A default value given in the table's CREATE TABLE statement will fill in a value when one is not given in an INSERT statement. Question 3 1/ 1 point Which of the following are true concerning inserting multiple rows at a time? Select 2 correct answers. v ] the source table must already exist v g thescolumns and datatypes of the source and destination tables must correspond v This version of the INSERT statement has an implicit COMMIT v the destination table must be empty Question 4 1/ 1 point If all of the records in a table need to be removed, a TRUNCATE is faster than a DELETE, especially if the table is large and contains many rows. v True False W Hide Feedback Trucation is faster than DELETE. A deletion can take seconds, minutes, or even hours, depending on how large the table is. A TRUNCATE is instantaneous. Question 5 1/ 1 point Which of the following are considered "Transaction control" (select all that apply) v | DELETE v | SAVEPOINT v UPDATE https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465943&ai=30908084 &isInPopup=0&cfql=0&romQB=0&ou... 2/5

1/15/2021 : Quiz Submissions - CHAPTER 3 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College v | COMMIT vau ROLLBACK Question 6 1/ 1 point The following statement will remove all rows from the vendors table, but leave the table and index structure intact: TRUNCATE TABLE vendors; v True False Question 7 1/ 1 point Which of the following is not a considered to be DML.: INSERT DELETE v/ ) COMMIT UPDATE MERGE Question 8 0.75 / 1 point What versions of the INSERT statement are valid? o 3 An INSERT without the word VALUES = \/[ ] An INSERT where all the column names are omitted = #| | an INSERT that lists all of the columns in the table = [ | An INSERT with partial listing of the columns W Hide Feedback All of these are valid versions of the INSERT statement. https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465943&ai=30908084 &isInPopup=0&cfql=0&fromQB=0&ou... 3/5

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/15/2021 : Quiz Submissions - CHAPTER 3 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Question 9 1/ 1 point An SQL TRUNCATE statement can be undone. True v False W Hide Feedback TRUNCATE is actually a DDL statement, and therefore has an implicit COMMIT. This means it cannot be undone (ROLLBACK). Question 10 1/ 1 point If you create a SEQUENCE, then you must use it to generate primary key values. True v False W Hide Feedback Although a sequence is most often used to generate Primary Key values; it is not required that they be primary keys. Attempt Score: 9.75/10-975% Overall Grade (highest attempt): 9.75/10-97.5% Done https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465943&ai=30908084 &isInPopup=0&cfql=0&romQB=0&ou... 4/5

1/15/2021 : Quiz Submissions - CHAPTER 3 TBV - 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=246594 3&ai=30908084&isInPopup=0&cfql=0&fromQB=0&ou... 5/5

Related Documents

COP3353_HW03.docx

COP3353_HW02.docx

COP3353_HW04.docx

IT-FPX2230_LastFirst_Assessment4-Attempt1.docx

Ch 1 writing assignment.docx

CYB 210 Module Five Activity Packet Tracer Michael Lara.docx

CYB 210 Network Configuration Scavenger Hunt Michael Lara.docx

CYB 240 Module Five Lab Worksheet Michael Lara.docx

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Course Technology Ptr

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher: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

Enhanced Discovering Computers 2017 (Shelly Cashm...

Computer Science

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher: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
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning