IT Interview Questions

1. Implicit cursors are used for SQL statements that are not named.
2. Developers should use implicit cursors with great care.
3. Implicit cursors are used in cursor for loops to handle data processing.
4. Implicit cursors are no longer a feature in Oracle.

1. Record type declaration.
2. Opening and parsing of SQL statements.
3. Fetches records from cursor.
4. Requires exit condition to be defined.

1. Only one
2. All that apply
3. All referenced
4. None

1. Statement and Row
2. Statement only
3. Row only
4. Oracle Forms trigger

CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER)
RETURN number IS
 
v_yearly_budget NUMBER;
 
BEGIN
       SELECT  yearly_budget
       INTO            v_yearly_budget
       FROM            studio
       WHERE   id = v_studio_id;
 
       RETURN v_yearly_budget;
END;

Which set of statements will successfully invoke this function within SQL*Plus?

1. VARIABLE g_yearly_budget NUMBER
   EXECUTE g_yearly_budget := GET_BUDGET(11);

1. When the transaction is committed
2. During the data manipulation statement
3. When an Oracle supplied package references the trigger
4. During a data manipulation statement and when the transaction is committed

1. DBMS_DISPLAY
2. DBMS_OUTPUT
3. DBMS_LIST
4. DBMS_DESCRIBE

1. Any DML statements issued by the construct are still pending and can be committed or rolled back.

SQL> set sqlprompt “database-1 > ”
database-1 >
database-1 >

SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

or

SQL> delete duplicate_values_field_name dv from table_name ta where rowid < (select min(rowid) from table_name tb where ta.dv=tb.dv);