Oracle SQL/PLSQL

Oracle SQL/PLSQL

Professional Development

10 Qs

quiz-placeholder

Similar activities

Digital test

Digital test

Professional Development

10 Qs

OS-Module 1

OS-Module 1

Professional Development

10 Qs

Knowledge Assessment for Chicken Tenders

Knowledge Assessment for Chicken Tenders

Professional Development

10 Qs

Ethics-Reliability and productivity

Ethics-Reliability and productivity

Professional Development

10 Qs

Bronze Label Course 203-204 (Updated)

Bronze Label Course 203-204 (Updated)

Professional Development

15 Qs

GUL Competence Stream: 4G Troubleshooting

GUL Competence Stream: 4G Troubleshooting

Professional Development

10 Qs

Pengelolaan Asset Informasi

Pengelolaan Asset Informasi

Professional Development

10 Qs

EMM

EMM

Professional Development

10 Qs

Oracle SQL/PLSQL

Oracle SQL/PLSQL

Assessment

Quiz

Other

Professional Development

Practice Problem

Medium

Created by

William Lawrence

Used 169+ times

FREE Resource

AI

Enhance your content in a minute

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

1. What is the result if the query executes(SAL=3000,COMM=NULL): SELECT SAL+COMM FROM EMP WHERE EMPNO=7654;

Error

3000

NULL

None

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. Which of the following Statement will cancel the SAVEPOINTS

iNSERT

UPDATE

DELETE

COMMIT

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. How many join condition will exists if we join 100 tables

100

99

1

10

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. Where do Sub Query Reside

FROM

WHERE

SELECT LIST

ALL THE ABOVE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of argument passes a value from a procedure to the calling environment?

VARCHAR2

CHAR

BOOLEAN

IN

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The function used to capture the Error Message

SQLERRM

SQLERR

SQLERROR

SQL

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The dictionary view used to view the Source code of a Procedure

USER_PROCEDURES

USER_SOURCE

USER_FUNCTIONS

USER_PROCEDURE

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?