MTA Mga Questions na mali si Justine
Quiz
•
Other
•
University
•
Medium
Justine Reyes
Used 3+ times
FREE Resource
22 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
return large result sets
return a range of values by using the = operator
do not use ORDER BY or GROUP BY clauses
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
are accessed randomly
are accessed sequentially
are not unique or contain many common values
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Use the ALTER statement to add a new table in a database.
No change is needed
UPDATE
INSERT
CREATE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which keyword can be used in a create table statement?
ORDER BY
DISTINCT
GROUP BY
UNIQUE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You need to create a view to filter rows of data from an underling table.
Which type of clause must be included in the CREATE VIEW statement?
CONSTRAINT
WHERE
JOIN
FILTER
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which command should you use to add a column to an existing table?
A. MODIFY
B. ALTER
C. UPDATE
D. INSERT
E. CHANGE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
a foreign key constraint violation
a syntax error
a new row in the Product table
D. a primary key constraint violation
a new row in the Category table
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple

Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
19 questions
Gr 5 Library Rules
Quiz
•
5th Grade - University
20 questions
Minecraft
Quiz
•
KG - Professional Dev...
20 questions
Pengelolaan Basis Data
Quiz
•
University
17 questions
Les fournitures scolaires
Quiz
•
University
19 questions
L'hotel et le restaurant
Quiz
•
University
21 questions
Networking and Switching Quiz chapter 2
Quiz
•
University
23 questions
Test your Power Bi
Quiz
•
University
26 questions
Quiz P6
Quiz
•
University
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Other
11 questions
NFL Football logos
Quiz
•
KG - Professional Dev...
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)
Quiz
•
8th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
36 questions
Unit 5 Key Terms
Quiz
•
11th Grade - University
38 questions
Unit 6 Key Terms
Quiz
•
11th Grade - University
20 questions
La Hora
Quiz
•
9th Grade - University
7 questions
Cell Transport
Interactive video
•
11th Grade - University
7 questions
What Is Narrative Writing?
Interactive video
•
4th Grade - University