Quiz 3.docx.pdf-Attempt 1 Written: Oct 1...
Quiz_3.docx.pdf-Attempt 1 Written: Oct 1, 2021
Showing 1-8 out of 17
Quiz 3.docx.pdf-Attempt 1 Written: Oct 1, 2021
Quiz_3.docx.pdf-Attempt 1 Written: Oct 1, 2021
Quiz 3.docx.pdf-Attempt 1 Written: ...
Quiz_3.docx.pdf-Attempt 1 Written: Oct 1, 2021
Page 1
Attempt 1
Written: Oct 1, 2021 3:01 PM - Oct 1, 2021 3:18 PM
Submission View
Your quiz has been submitted successfully.
Question 1
1 / 1 point
Which syntax is used to create a database?
HAVE DATABASE
ESTABLISH DATABASE
GENERATE DATABASE
CREATE DATABASE
Question 2
1 / 1 point
Which syntax is used to generate a table?
CREATE TABLE
GENERATE TABLE


Page 2
HAVE TABLE
ESTABLISH TABLE
Question 3
1 / 1 point
Which of the following data type is suitable for string data type?
CHAR
DATE
STRING
INT
Question 4
1 / 1 point
Which one is the correct format of date data?
DD/MM/YYYY
DD-MM-YYYY


Page 3
YYYY-MM-DD
YYYY/MM/DD
Question 5
1 / 1 point
Which keyword is used to add records to tables?
INSERT INTO
WRITE INTO
COPY INTO
ADD INTO
Question 6
1 / 1 point
Consider the following ERD. Now, we want to create a database
associated with this ERD. The first step is to create a database called
'HairSalon'. To do so, we write the following syntax. Which one is the
correct syntax?


Page 4
GENERATE DATABASE HairSalon;
MAKE DATABASE HairSalon;
CREATE DATABASE HairSalon;
CREATE TABLES HairSalon;
Question 7
1 / 1 point
Now, suppose the database HairSalon is created. Now, we want to
work on this database. Which syntax is the write one?


Page 5
PICK HairSalon;
USE HairSalon;
BOLD HairSalon;
SELECT HairSalon;
Question 8
1 / 1 point
Now, we want to create a table associated with entity HairStylist.
Which statement is the correct one to create the table and all
columns?


Page 6
CREATE HairStylist( StylistID INT,StylistFirstName
Varchar(32), StylistLastName Varchar(32),StylistAddress
Varchar(255), Primary Key (StylistID));
CREATE TABLE HairStylist( StylistID INT,StylistFirstName
Varchar(32), StylistLastName Varchar(32),StylistAddress
Varchar(255), Primary Key (StylistID));
CREATE TABLE HairStylist( StylistID INT,StylistFirstName
Varchar(32), StylistLastName Varchar(32),StylistAddress
Varchar(255));


Page 7
GENERATE TABLE HairStylist( StylistID
INT,StylistFirstName Varchar(32), StylistLastName
Varchar(32),StylistAddress Varchar(255), Primary Key
(StylistID));
Question 9
1 / 1 point
Now, we want to create the table Client. Which one is the correct
statement?
Create Table Client(ClientID INT Primary Key,
ClientFirstName varchar(32), ClientLastName
varchar(32),ClientPhoneNumber INT(8), StylistID INT);


Page 8
Create Table Client(ClientID INT Primary Key,
ClientFirstName varchar(32), ClientLastName
varchar(32),ClientPhoneNumber INT(8), StylistID
INT,Foreign Key (StylistID))References
airStylist(HairStylistID));
Create Table Client(ClientID INT, ClientFirstName
varchar(32), ClientLastName
varchar(32),ClientPhoneNumber INT(8), StylistID
INT,Foreign Key (StylistID))References
airStylist(HairStylistID));
GENERATE Table Client(ClientID INT Primary Key,
ClientFirstName varchar(32), ClientLastName
varchar(32),ClientPhoneNumber INT(8), StylistID
INT,Foreign Key (StylistID))References
airStylist(HairStylistID));
Question 10
0 / 1 point
Now, we want to create the table of the appointment. Which statement
is the correct one?


Ace your assessments! Get Better Grades
Browse thousands of Study Materials & Solutions from your Favorite Schools
Texas A %26 M University-...
Texas_A_%26_M_University-Corpus_Christi
School:
Data_Management
Course:
Great resource for chem class. Had all the past labs and assignments
Leland P.
Santa Clara University
Introducing Study Plan
Using AI Tools to Help you understand and remember your course concepts better and faster than any other resource.
Find the best videos to learn every concept in that course from Youtube and Tiktok without searching.
Save All Relavent Videos & Materials and access anytime and anywhere
Prepare Smart and Guarantee better grades

Students also viewed documents