You create the following PL/SQL block: DECLARE var1 CONSTANT NUMBER := 50; var2 NUMBER := 0; BEGIN SELECT acctno INTO var2 FROM bank_acct WHERE name = 'JORDAN'; var1 :=var2 + 2000; END; Which of the following lines in this block of PL/SQL code will produce an error?

You run the following SQL statement: SELECT a.lname, a.location, b.dname, b.hiredate FROM emp a, emp b WHERE a.empid=b.empid; Which options are correct? (Choose all that apply)

Which of the following SQL statements will not execute successfully? (Choose all that apply)

Carl, a database user, creates and executes the following SQL statement: CREATE SYNONYM employee FOR stanley.employee; What statements below are true?

A const pointer cannot be assigned to an ordinary pointer.

Public inheritance signifies__________ relation ship

Which of the following can be used to modify the value of a variable?

Which of the following is an error in calling the function? void func( int i = 5, double d = 1.234 );

In CPP program if the function is defined in the same program file before it is called, a separate prototype is required.

What command can you use to test a named PL/SQL block for compilation?

What can be implemented to reuse a cursor definition in PL/SQL?

What must be included within a cursor when the WHERE CURRENT OF clause is used in PL/SQL?

You run the following SQL statement: SQL> SELECT lname, deptid, sal, bonus FROM emp WHERE sal, bonus IN (SELECT sal, bonus FROM emp WHERE deptid=20); The statement resulted in an error. Which line is causing the error?

Examine the following PL/SQL block of code: ... DELETE FROM orders WHERE pay_stat = ‘Overdue’; IF SQL%ROWCOUNT > 5 THEN RAISE out_of_bounds; END IF; ... What value is returned after the statement is run and the DELETE statement returned no rows?

What is the effect when a clear statement is used on an internal table without header line?

Which statement will cause a syntax check error?

Which data type cannot be used to define parameters

What are the two elementary data types provided for character strings in ABAP?

The settings in the Data Browser/Table View Maintenance field...

IN WHICH OF THE FOLLOWING VERSIONS OF COBOL, THE USE OF GO TO STATEMENT HAS BEEN ELIMINATED FROM COBOL STANDARDS?