Oracle SOL developer is an
[Link] database instance
[Link] database management system
[Link] Listener
[Link] client
What are the various types of parameter modes in a procedure ? CHOOSE
[Link]
[Link]
[Link]
[Link]
What is the use of an index?
[Link] data more quickly and efficiently
[Link] data requires much less 1/0 overhead if accessed simultaneously
[Link] the user's perception of data access
[Link] of the Mentioned
[Link]
Which of the following is NOT VALID is PL/SOL
[Link] boolean:
2.NUM1. NUM2 number;
[Link] [Link]%type;
4.date1 date = sysdate
[Link] of the above
Which of the following is true about scalar data types in PL/SOL?
[Link] hold single values with no internal components
[Link] of scalar data types are NUMBER, DATE, or BOOLEAN.
[Link] provides subtypes of data types
[Link] are true
Which one of the following statements about formal and actual parameters is true?
[Link] and Actual parameters have the same name
[Link] and Actual parameters have the different name
3.A formal parameter is declared within the called procedure, while an actual parameter is declared in the caling
environment
[Link] actual parameter is declared within the called procedure
[Link] of these
Which of the following is not true about PL/SQL loop structures?
[Link] the basic loop structure, sequence of statements is enclosed between the LOOP and END LOOP statements.
[Link] WHILE loop repeats a statement or group of statements while a given condition is true.
[Link] FOR loop executes a sequence of statements multiple times and abbreviates the code that manages the loop
variable.
[Link] of loops is not allowed
Which of the following is an Oracle DDL function?
[Link]
[Link]
3.TO_CHAR
[Link]
[Link] of these are Oracle DDL functions
cursor are declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.
[Link]
[Link]
[Link]
[Link]
Which of the following is not true about the PL/SOL functions?
1.A PL/SQL function is same as a procedure except that it returns a value.
[Link] function body must contain a RETURN statement.
[Link] RETURN clause does not specify the data type of the return value.
[Link] AS keyword is used instead of the IS keyword,for creating a standalone function.
____is a procedural extension of Oracle-SQL that offers language constructs similar to those in imperative programming
languages
[Link]
[Link]/SQL
[Link] SQL
[Link]
List the correct sequence of commands to process a set of records when using explicit cursors
[Link], GET, CLOSE
[Link], GET, FETCH, CLOSE
[Link], FETCH, CLOSE
[Link], FETCH, CLOSE
[Link], SEEK, HIDE
Enter the missing keyword If foo = 1 THEN I_text:= 'A' ____foo=2 THEN I_text:='B'; 'ELSE I_text := 'C';END IF;
[Link]
[Link] IF
[Link]
[Link]
[Link] of the above
In PL/SQL ____errors can arise from design faults, coding mistakes, hardware failures, and many other sources
[Link] error
[Link] error
[Link]-time
[Link] error
[Link] error
Functions for error trapping are contained in which section of a PL/SQL block?
1. Header
[Link]
[Link]
[Link]
Supply the missing key word IF foo IS NULL___
NULL;END IF;
[Link]
[Link]
[Link]
[Link]
The user defined data type can be created using
[Link] datatype
[Link] data
[Link] definetype
[Link] type
[Link] userdata
Which of the following is not true about PL/SOL cursors?
1.A cursor is a view on a table
2.A cursor holds the rows (one or more) returned by a SQL statement.
[Link] set of rows the cursor holds is referred to as the active set.
[Link] of the above
Which of the following is not a grouping function?
[Link]
[Link]
[Link]
[Link]
[Link] the above
Select invalid variable types
[Link]
2.VARCHAR1
3.VARCHAR2
[Link]
[Link]
In this PL/SQL statement, which of the following lines will produce an error?
[Link] CAPITALS is
[Link] CITY, STATE
[Link] my_city, my_state
[Link] CITIES
Which of the following is true about the parameter modes in PL/SQL Subprograms?
[Link] IN parameter lets you pass a value to the subprogram. It is a read-only parameter.
[Link] OUT parameter returns a value to the calling program.
[Link] IN OUT parameter passes an initial value to a subprogram and returns an updated value to the caller.
[Link] of the above
Select the invalid PL/SQL looping construct.
[Link] LOOP
[Link] LOOP
[Link] rec IN some_cursor LOOP_END LOOP
3.LOOP_UNTIL;END LOOP
4.LOOP_EXIT WHEN ; END LOOP
[Link] of the above All are valid
Which SELECT statement wilthe result 'elloworld' from the string 'HelloWorld"?
[Link] SUBSTR( "HelloWorld",1) FROM dual;
[Link] INITCAP(TRIM ("HelloWorld", 1,1) FROM dual,
[Link] LOWER(SUBSTR("Helloworld", 1, 1) FROM dual,
[Link] LOWER(SUBSTR("HelloWorld", 2, 1) FROM dual;
[Link] LOWER(TRIM ("H" FROM "HelloWorld") FROM dual;
Which of the following is NOT VALID is PL/SQL
[Link] boolean;
2.NUM1, NUM2 number,
[Link] [Link]%type,
4.date1 date := sysdate
Which of the following is NOT VALID is PL/SQL
Functions for error trapping are contained in which section of a PL/SQL block?
[Link]
[Link]
[Link]
[Link]
Which of the following is an Oracle DDL function?
[Link]
[Link]
3.TO_CHAR
[Link]
[Link] of these are Oracle DDL functions.
CREATE TABLE is a__ statememt.
[Link]
[Link]
3 DCL
[Link] Control Language
____is a database object that groups logically related PL/SOL types, objects and subprograms.
[Link]
[Link]
[Link]
[Link]
oracle client
in,out,inout
Retrieve data more quickly and
efficiently.
NUM1. NUM2 number;
4. All are true.
Formal and Actual parameters
have different names.
Nesting of loops is not
allowed.
DROP.
Implicit.
The RETURN clause does not
specify the data type of the
return value.
PL/SQL
OPEN, FETCH, CLOSE
ELSIF
Logic error.
Exception
THEN
create type
A cursor is not a view on a
table
DISTINCT
VARCHAR1.
into my_city, my_state
All of the above
LOOP_UNTIL;END LOOP.
SELECT LOWER (TRIM ('H'
FROM 'Hello World')) FROM
dual
Bool boolean;
Exception
DROP
DDL
Package.