DBMS_2

DBMS_2

University

20 Qs

quiz-placeholder

Similar activities

Intro to Gamedev

Intro to Gamedev

University

19 Qs

Unit I Quiz

Unit I Quiz

University

15 Qs

Skill India Mission and Youth Empowerment

Skill India Mission and Youth Empowerment

12th Grade - University

15 Qs

MOVEMENT CULTURE

MOVEMENT CULTURE

University

15 Qs

Grammar Class 1 - Teens 4

Grammar Class 1 - Teens 4

6th Grade - Professional Development

18 Qs

BTS/ARMY  2020

BTS/ARMY 2020

KG - Professional Development

19 Qs

Labor Relations and Negotations 1

Labor Relations and Negotations 1

University - Professional Development

15 Qs

Intro to DBMS

Intro to DBMS

University

15 Qs

DBMS_2

DBMS_2

Assessment

Quiz

Other

University

Practice Problem

Medium

Created by

Rajad 8063

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a valid DDL command?

SELECT

INSERT

DROP

UPDATE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the NOT NULL constraint ensure?

Column must have unique values

Column must have non-null values

Column must be primary key

Column cannot be indexed

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which clause can be used with GROUP BY to filter aggregate results?

WHERE

HAVING

ORDER BY

DISTINCT

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which keyword is used to change an existing record in a table?

UPDATE

MODIFY

CHANGE

SET

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of join returns only the matched records from both tables?

FULL JOIN

LEFT JOIN

RIGHT JOIN

INNER JOIN

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SELECT COUNT(*) return?

Number of columns

Number of tables

Number of rows

Number of distinct rows

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does DISTINCT do in a query?

Removes all nulls

Sorts the results

Removes duplicate rows

Filters rows based on condition

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

Already have an account?