MTA Mga Questions na mali si Justine

MTA Mga Questions na mali si Justine

University

22 Qs

quiz-placeholder

Similar activities

other & another

other & another

KG - Professional Development

20 Qs

Assessment 2 Quiz

Assessment 2 Quiz

University

20 Qs

Soil Factors and components-Aviation

Soil Factors and components-Aviation

University

20 Qs

SMW2 M5 OKTOBER

SMW2 M5 OKTOBER

6th Grade - University

20 Qs

REFRESHING QUIZ

REFRESHING QUIZ

12th Grade - University

20 Qs

First Sessional: Communication Skills

First Sessional: Communication Skills

University

20 Qs

EFFECTS OF HEAT ON FOOD

EFFECTS OF HEAT ON FOOD

University

20 Qs

sampling

sampling

University

20 Qs

MTA Mga Questions na mali si Justine

MTA Mga Questions na mali si Justine

Assessment

Quiz

Other

University

Medium

Created by

Justine Reyes

Used 3+ times

FREE Resource

22 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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

Media Image

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

Media Image

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?