Home / Akshay Kulkarni / Programming MCQs Solution

Programming Portal Solution

You will find all Programming Portal MCQs whose solution is updated by Akshay Kulkarni

Q. Which of the following are an exception in PHP?

Q. Why using Exception Handling in PHP?

Q. What is the result of the following PHP code?

Q. What is the result of the following PHP code?

Q. What is the result of the following PHP code?

Q. How many functions does PHP provide for searching strings using POSIX style regular expression?

Q. Both POSIX regex and PERL regex are example of _____

Q. Varrays are a good choice when

Q. When building up a single SQL statement in a string, do not include any semicolon at the end.

Q. Which of the following returns the current value in a specified sequence.

Q. Which operators combine the results of two queries into one result?

Q. A recursive subprogram is one that calls itself.

Q. Which of the following provides a way for your program to select multiple rows of data from the database and then process each row individually.

Q. The subprogram is called through a database link or as an external procedure.

Q. The values of any IN OUT parameters are copied before the subprogram is executed.

Q. “NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.

Q. Which structure executes a sequence of statements repeatedly as long as a condition holds true?

Q. What is the maximum number of ELSE clauses that can be included in an IF clause that is not nested?

Q. Which of the following has internal components that can be manipulated individually, such as the elements of an array, record, or table?

Q. Which operator tests set membership?

Q. How many types of literals are available in PL/SQL?

Q. Which is a simple or compound symbol that has a special meaning to PL/SQL?

Q. PL/SQL stored procedures move application code from the server to the client.

Q. PL/SQL is a completely portable, high-performance transaction processing language.

Q. Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations.

Q. In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.

Q. Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?

Q. Which of the following returns the current error message text?

Q. When creating a function, in which section will you typically find a return key word?

Q. You can pass parameters to procedures or functions in a package.

Q. Which package lets PL/SQL programs read and write operating system (OS) text files?

Q. Which of the following is not a schema object?

Q. Subprograms are named PL/SQL blocks that can be called with a set of parameters

Q. The variables or expressions passed from the calling subprogram are

Q. What is the maximum number of triggers that can apply to a single table?

Q. Which statements are used to control a cursor variable?

Q. Which of the following returns all distinct rows selected by either query?

Q. You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.

Q. By using which clause, the mode is OUT, so you cannot specify a parameter mode for output bind arguments?

Q. In the Restrictions on Record Inserts and Updates, which of the following are not supported?

Q. Which of the following cannot be used with associative arrays?

Q. Which statements execute a sequence of statements multiple times?

Q. LOB locators are values, which specify the location of the large object.

Q. How many bytes does each character in the AL16UTF16 encoding take up?

Q. Which keyword is used instead of the assignment operator to initialize variables?

Q. Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

Q. Which of the following is used for reading and writing operating-system files?