t2

pdf

School

Georgia Gwinnett College *

*We aren’t endorsed by this school

Course

4200

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

5

Uploaded by jam_1415

Report
1/15/2021 : Quiz Submissions - CHAPTER 2 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Quiz Submissions - CHAPTER 2 TBV X Jamaima Endres (username: jendres) Attempt 1 Written: Aug 16, 2020 2:09 PM - Aug 16, 2020 2:57 PM Submission View Released: Jan 18, 2012 10:06 AM Question 1 0.75 / 1 point What are the ways that constraints can be created? Choose 3. w3 ALTER TABLE command =« Out-of-line v UPDATE TABLE command D View Feedback Question 2 1/ 1 point The data type that would be used for a column that will be storing employee photographs for a large, multi-national company is: v BLOB NCLOB CLOB GLOB D View Feedback https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465942&ai=30679942&isInPopup=0&cfql=0&romQB=0&ou... 1/5
1/15/2021 : Quiz Submissions - CHAPTER 2 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Question 3 1/ 1 point Which of the following is the recommended constraint name for the SHIPS table having Primary key SHIP_ID? ship_id_PK ships_id_PK PRIMARY KEY(Ship_id) v Ships_Ship_ID_PK D View Feedback Question 4 1/ 1 point The default time for a date is: v 12:00 a.m. 12:00 p.m. 11:59 PM 18:00 Question 5 1/ 1 point Which of the following are true for 'RR' year designation? v | 50 can either mean 1950 or 2050 v/ | 68 means 1968 3 U 45 means 2045 \/\_J 25 means 2025 D View Feedback https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465942&ai=30679942&isInPopup=0&cfql=0&romQB=0&ou... 2/5
1/15/2021 : Quiz Submissions - CHAPTER 2 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Question 6 1/ 1 point A collection of the database objects, such as tables, sequences, views, and indexes, that are owned by a single user account is called a(n) Role ERD v schema database partition Question 7 0.75 / 1 point What component of SQL is used to build and manage the database objects and define the structure of the database? v | theschema v | DLD s [ | DML = | Dbk D View Feedback Question 8 1/ 1 point Which datatype adds fractional seconds to a date/time? DATEPLUS DATESECONDS v TIMESTAMP DATESTAMP https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=24659428&ai=30679942&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 2 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College D View Feedback Question 9 1/ 1 point Which line number illustrates an "in-line constraint"? Choose all that apply. 01 CREATE TABLE PORTS 02 ( Port_ ID NUMBER(3) PRIMARY KEY, 03 Port_ Name VARCHAR2(30) NOT NULL, 04 Region ID CHAR(4), 05 CONSTRAINT ports_region_id FK FOREIGN KEY (Region_ID) REFERENCES Region(Region_ID)); v 01 vl |02 v' 103 v 04 v 05 D View Feedback Question 10 0.75 / 1 point Which of the following options can be used with the keyword CREATE to form a syntactically correct SQL statement to create a table? w3 the keyword CONSTRAINT v | the keyword SEQUENCE = V| | the keyword TABLE = ) at least one column-definition D View Feedback https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465942&ai=30679942&isInPopup=0&cfql=0&romQB=0&ou... 4/5
1/15/2021 : Quiz Submissions - CHAPTER 2 TBV - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Attempt Score: 9.25/10-925% Overall Grade (highest attempt): 9.25/10-925% Done https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465942&ai=30679942&isInPopup=0&cfql=0&fromQB=0&ou... 5/5

Related Documents

COP3353_HW04.docx
IT-FPX2230_LastFirst_Assessment4-Attempt1.docx
Ch 1 writing assignment.docx
ModuleOneCS405.docx
t3.pdf
Ass01.docx
Ass03 (1).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
PROG8651-FALL 2023-SECTION 3-Lakshay Bhati (1).pdf
README.md
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
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
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
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
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
SEE MORE TEXTBOOKS