There are six steps that lead from the first to the second floor. No two people can be on the same step. Mr. A is two steps below Mr. C. Mr. B is a step next to Mr. D. Only one step is vacant (No one standing on that step) Denote the first step by step 1 and second step by step 2 etc. If Mr. A is on the first step. Which of the following is true?A. Mr. B is on the second stepB. Mr. C is on the fourth step.C. A person Mr. E, could be on the third stepD. Mr. D is on higher step than Mr. C.

#include void func(){int x = 0;static int y = 0;+; y++;printf( "%d -- %dn", x, y );}int main(){func();func();return 0;}printf("%dn", 64>>3);What will the sample code above produce when executed?A. 8B. 16C. 32D. 256

#include void inc_count(int count){count ++;}int main(){int count = 0; /* number of times through */while (count < 10)inc_count(count);return count ;}What will be the value returned by the function main?A. 0B. 10C. 9D. Null

Which of the following statements are true about roles?A. Roles can be granted to other roles and/or users.B. Privileges can be granted to roles.C. Roles can be granted to synonyms.D. Both a and b.

The exact content and the storage representation of a column in database can be found out using the functionA. translateB. to_charC. dumpD. substr

A ddl statement in a pl/sql can be issued in a pl/sql block using the packageA. dbms_outputB. dbms_sqlC. UTL_FILED. dbms_job

Choose the result of the following sql statement.SELECT hire_dateFROM empwhere to_char(hire_date) > '01-FEB-00';A. 01-APR-00B. 01-OCT-00C. 01-APR-99D. 01-DEC-00

Purity level of a function can be checked usingA. PRAGMA EXCEPTION_INIT.B. PRAGMA RESTRICT REFERENCESC. DBMS_OUTPUT.D. DBMS_SQL.

The __________ statement is used to run the pl/sql block.A. get filenameB. start filenameC. run filenameD. none of the above

Which of the following is TRUE about a FUNCTION?A. can return a valueB. can be used in SQL statementC. all of the aboveD. none of the above