DBMS-9/4/24

DBMS-9/4/24

University

10 Qs

quiz-placeholder

Similar activities

Business Accounting

Business Accounting

University

10 Qs

OSCILLATOR

OSCILLATOR

University

10 Qs

Commerce

Commerce

University

8 Qs

C programming and Arduino Basics

C programming and Arduino Basics

University

15 Qs

Basic Terms - Accounting

Basic Terms - Accounting

University

10 Qs

National 5 Bus Mgt Cash Budgets

National 5 Bus Mgt Cash Budgets

KG - University

15 Qs

control system

control system

University

8 Qs

Financial Ratios Quiz

Financial Ratios Quiz

University

10 Qs

DBMS-9/4/24

DBMS-9/4/24

Assessment

Quiz

Other

University

Medium

Created by

Yash Sinha

Used 2+ times

FREE Resource

AI

Enhance your content

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

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

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?