databases Online Quiz - 123
|Description: databases Online Quiz - 123
|Number of Questions: 20
|Created by: Aliensbrain Bot
Which one of them is not an String Function?
What is the function which is used to check whether the value is a numeric value or not?
What operator performs pattern matching?
Deterministic functions are?
SQL_VARIEANT datatype column can be any datatype except?
What is the maximum number of columns per select statement allowed in SQL 2005?
Can we insert data into a view?
Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode?
You designed a CardValidation.java Java source file. You also have the corresponding CardValidation.class file . As a part of invoking a Java class method, you execute this command at the command prompt: Loadjava –user oe/oe CardValidation.java . Which statement is true about the command?
Examine the settings for a user session given below : RESULT_CACHE_MODE =FORCE. What would be the implications of this setting on query execution?
Which statements are true about internal LOBs?
Which statements are true about the SecureFile storage paradigm?
Which statements are true about inlining of PL/SQL subprograms?
Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package?
Which two statements are true about cursor variables?
What is a constraint?
What do we call a superkey?
What does the stack space in a PGA hold?
To answer this question, you need to understand the concept of the Program Global Area (PGA) and its components.
The PGA is a memory area that is allocated for each session in a database. It is used to store session-specific information and data structures. One of the components of the PGA is the stack space.
The stack space in a PGA holds session variables and arrays. These variables and arrays are used by the session during its execution. The stack space is used for storing local variables, procedure and function call frames, and other temporary data structures specific to the session.
Now let's go through each option to understand why it is correct or incorrect:
Option A) stack variables and other info - This option is incorrect because the stack space in a PGA does hold stack variables, but it does not hold "other info" such as session-specific information.
Option B) session's variables and arrays - This option is correct because the stack space in a PGA holds session variables and arrays. These variables and arrays are used by the session during its execution.
Option C) session info stored in PGA - This option is incorrect because session info is stored in the PGA, but it is not specifically stored in the stack space.
Option D) binding variables and runtime buffers - This option is incorrect because binding variables and runtime buffers are not stored in the stack space of the PGA.
Therefore, the correct answer is Option B) session's variables and arrays. This option is correct because the stack space in a PGA holds session variables and arrays that are used by the session during its execution.
The HAVING clause was added to SQL because the WHERE keyword could be used with aggregate functions.
The FULL JOIN keyword return rows when there is a match in one of the tables.