Search Header Logo

Oracle PL/SQL Quizz

Authored by Fernando Moura

Information Technology (IT)

University

Oracle PL/SQL Quizz
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

30 sec • 1 pt

O que significa a sigla PL/SQL?

Procedural Language for SQL

Programmatic Logic for SQL

Process Language for SQL

Procedural Logic in SQL

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Que comando é utilizado para exibir mensagens em PL/SQL?

PRINT

DBMS_OUTPUT.PUT_LINE

DISPLAY

OUTPUT_MESSAGE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Como se inicia um bloco anónimo em PL/SQL?

START

BEGIN

OPEN

EXECUTE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Que tipo de exceção é utilizado para lidar com erros personalizados?

WHEN OTHERS

RAISE_APPLICATION_ERROR

USER_EXCEPTION

ERROR_MESSAGE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Que estrutura permite armazenar múltiplos valores em PL/SQL?

Array

Collection

Record

Cursor

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Que comando é utilizado para definir variáveis num bloco PL/SQL?

LET

SET

DECLARE

VAR

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Como se declara um cursor em PL/SQL?

DECLARE CURSOR

OPEN CURSOR

CREATE CURSOR

DEFINE CURSOR

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

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?