Search Header Logo

DBMS Quiz 2 DSE

Authored by Abhishek Chaudhari

Other

University

Used 1+ times

DBMS Quiz 2 DSE
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the full form of SQL?

  1. Structured Query List

  1. Structure Query Language

  1. Sample Query Language

  1. None of these.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a DDL command?

  1. TRUNCATE

  1. ALTER

  1. CREATE

  1. UPDATE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How many Primary keys can have in a table?

  1. Only 1

  1. Only 2

  1. Depends on no of Columns

  1. Depends on DBA

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following is not a valid aggregate function?

  1. COUNT

  1. COMPUTE

  1. SUM

  1. MAX

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which operator is used to compare a value to a specified list of values?

  1. ANY

  1. BETWEEN

  1. ALL

  1. IN

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

In which of the following cases a DML statement is not executed?

  1. When existing rows are modified.

  1. When a table is deleted.

  1. When some rows are deleted.

  1. All of the above

Hide Answer

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is true about the HAVING clause?

  1. Similar to the WHERE clause but is used for columns rather than groups.

  1. Similar to WHERE clause but is used for rows rather than columns.

  1. Similar to WHERE clause but is used for groups rather than rows.

  1. Acts exactly like a WHERE clause.

Access all questions and much more by creating a free account

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?