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
Similar Resources on Wayground
21 questions
QUIZ NORMALIZATION

Quiz
•
University
20 questions
Management Accounting Analytics Quiz Chapter 2

Quiz
•
University
20 questions
IBT MS Word Review Quiz

Quiz
•
10th Grade - University
20 questions
Approximate Areas with Riemann Sums

Quiz
•
10th Grade - University
24 questions
FBS QUIZ 2

Quiz
•
University
18 questions
MBR et GPT

Quiz
•
12th Grade - University
20 questions
Company Law -Quiz II

Quiz
•
University
23 questions
RÉVISION POUR L'EXAMEN

Quiz
•
University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Other
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
7 questions
Figurative Language: Idioms, Similes, and Metaphors

Interactive video
•
4th Grade - University
15 questions
Properties of Equality

Quiz
•
8th Grade - University
38 questions
WH - Unit 3 Exam Review*

Quiz
•
10th Grade - University
21 questions
Advise vs. Advice

Quiz
•
6th Grade - University
12 questions
Reading a ruler!

Quiz
•
9th Grade - University