Nodejs: Database SQL

Quiz
•
Professional Development
•
Professional Development
•
Medium
Daniel Adesoji
Used 8+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct syntax to create a table on MySQL
CREATE TABLE <tablename>
CREATE ENTITY <tablename>
CREATE COLLECTION <tablename>
CREATE RECORD <tablename>
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Replace the missing word:
CREATE TABLE departments (
name _____ NOT NULL
)
varchar(255)
string(255)
letters(255)
words(255)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choose the correct option to create a field with a default time stamp
created_at datetime DEFAULT CURRENT
created_at datetime DEFAULT TIMESTAMP
created_at datetime DEFAULT CURRENT_TIMESTAMP
created_at datetime DEFAULT TIME
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would we represent a column referencing another table as the a foreign key?
FOREIGN KEY (department_id) REFERENCES departments(id)
FOREIGN KEY departments(id)
REFERENCES (department_id),
FOREIGN KEY REFERENCES
departments(id)
(department_id),
FOREIGN KEY
REFERENCES
(department_id) departments(id)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which syntax is correct for setting enum constraints?
status ('active', 'inactive') ENUM
ENUM status ('active', 'inactive')
('active', 'inactive') status ENUM
status ENUM ('active', 'inactive')
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To create a record into a users table, what would be the correct syntax?
insert from users (name) values ("stephen")
insert into users (name) values ("stephen")
insert where users (name) values ("stephen")
insert when users (name) values ("stephen")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
We want to get the records for all users, but we want only their names. Choose the right option?
select * from users
select id from users
select from users where name
select name from users
Create a free account and access millions of resources
Similar Resources on Wayground
11 questions
PH: P#y#x Ph#s# 1

Quiz
•
Professional Development
15 questions
Microsoft 365

Quiz
•
Professional Development
15 questions
PHP tutorial review

Quiz
•
Professional Development
12 questions
SLPIS Pre-Test

Quiz
•
Professional Development
15 questions
GCP_FUNDAMENTALS_QUIZ

Quiz
•
Professional Development
10 questions
SheerID DR Quiz 09/07/2022

Quiz
•
Professional Development
10 questions
ServiceNow Review

Quiz
•
Professional Development
10 questions
SheerID DR Quiz 02/07/2022

Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade