MTA Mga Questions na mali si Justine

MTA Mga Questions na mali si Justine

University

22 Qs

quiz-placeholder

Similar activities

Approximate Areas with Riemann Sums

Approximate Areas with Riemann Sums

10th Grade - University

20 Qs

QUIZ NORMALIZATION

QUIZ NORMALIZATION

University

21 Qs

BOCA

BOCA

University

20 Qs

MBR et GPT

MBR et GPT

12th Grade - University

18 Qs

IBT MS Word Review Quiz

IBT MS Word Review Quiz

10th Grade - University

20 Qs

Management Accounting Analytics Quiz Chapter 2

Management Accounting Analytics Quiz Chapter 2

University

20 Qs

Ventures 2A | Midterm

Ventures 2A | Midterm

University

20 Qs

CHFI Module 4 Review

CHFI Module 4 Review

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?