Tag: technology

Questions Related to technology

Multiple choice technology databases

The || is is an example of what function SELECT last_name || ', ' || first_name || ' ' || middle_name FROM employees;

Incantination
Integration
Continuation
Concatenation
Pipeline
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Assuming the date and time is 09/09/2009 09:09:09, what value will the following statement return SELECT TO_CHAR(TRUNC(SYSDATE),'MM/DD/YYYY HH24:MI:SS') FROM dual;

09/09/2009 00:00:00
09/09/2009 09:09:09AM
09/09/2009
09/09/2009 09:09:09
None of the above.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Select the best answer. Which listed attribute is an invalid attribute of an Explicit cursor.

%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN
None of the above. All of these are valid.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Where do you declare an explicit cursor in the PL/SQL language?

In the PL/SQL working storage section
In the PL/SQL declaration section
In the PL/SQL body section
In the PL/SQL exception section
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Select the best answer. This is an example of what _____ type of cursor? DECLARE l_date DATE; BEGIN SELECT TRUNC(SYSDATE) INTO l_date FROM DUAL; END;

Explicit
Implicit
Select
PL/SQL
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Select the best answer. This is an example of what _____ type of cursor? DECLARE l_date DATE; CURSOR c1 IS SELECT TRUNC(SYSDATE) FROM DUAL; BEGIN OPEN c1; FETCH c1 INTO l_date; CLOSE c1; END;

Explicit
Implicit
Select
PL/SQL
None of the above.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Select the best answer to complete this variable declaration for a record. DECLARE l_foo_table SOME_TABLE_________; BEGIN ...

%ROWTYPE
%TABLE
%COLUMNTYPE
%TYPE
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Select the best answer to complete this variable declaration for a column value. DECLARE l_foo_column_id SOME_TABLE.SOME_COLUMN_________; BEGIN ...

%ID
%ROWTYPE
%TYPE
%COLUMNTYPE
None of the above.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Select the best answer PACKAGE foo_foo IS PROCEDURE foo ( p_foo_text IN VARCHAR2 ); PROCEDURE foo (p_foo_number IN NUMBER); END;

Package specification is invalid. Too many procedures named foo.
Package specification is invalid. First procedure should be called called foo_1, second procedure should be called foo_2.
Package specification is valid. This is an example of overloading.
Package specification is invalid. We can only have one procedure named foo in the package
Package specification is valid. We can have an unlimited number of procedures name foo.
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

List the correct sequence of commands to process a set of records when using explicit cursors

INITIALIZE, GET, CLOSE
OPEN, FETCH, CLOSE
CURSOR, GET, FETCH, CLOSE
CURSOR, FETCH, CLOSE
GET, SEEK, HIDE
None of the above.

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
2020
2021
2022
2023
2024
2025
2026
2027
2028
…
3670
3671
Next →