Search Header Logo

DBMS-9/4/24

Authored by Yash Sinha

Other

University

Used 2+ times

DBMS-9/4/24
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the syntax of PL/SQL Loop?

  1. LOOP
    END LOOP;
    Sequence of statements;

  1. END LOOP;
    LOOP
    Sequence of statements;


  1. LOOP
    Sequence of statements; END LOOP;

  1. END LOOP;
    Sequence of statements; LOOP

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which is a join condition contains an equality operator:

Equi joins

Cartesian

Both Equijoins and Cartesian

None of the mentioned

Answer explanation

An equi-join is a specific type of comparator-based join, that uses only equality comparisons in the join-predicate

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The ___ clause imposes a condition on the group by clause

None of the above

Where

Order by

Having

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of data can be stored in the database?

Image oriented data

Text, files containing data

Data in the form of audio or video

All of the above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Primary key can be?

NULL

NOT NULL

Unique

BOTH NOT NULL AND UNIQUE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt


What does the following statement in SQL do?

TRUNCATE TABLE student;

Creates a table called student

Deletes records of a table called student

Check if there is table called student

none of the above

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The ......... function converts a value of a date datatype to char value

TO_CHAR

TO_CHARACTER

TO_STRING

TO_VARCHAR

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?