0

databases Online Quiz - 123

Description: databases Online Quiz - 123
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SOUNDEX

  2. DIFFERENCE

  3. GROUPING

  4. SUBSTRING


Correct Option: C
  1. Select isnumeric('Test Text')

  2. Select numeric('Test Text')

  3. Both of the above

  4. none of the above


Correct Option: A

What operator performs pattern matching?

  1. &

  2. LIKE

  3. %

  4. NONE


Correct Option: B
  1. Functions always return the same result any time they are called with a specific set of input values.

  2. Functions may return different results each time they are called with a specific set of input values

  3. None

  4. Both of Them


Correct Option: A

What is the maximum number of columns per select statement allowed in SQL 2005?

  1. 1024

  2. 4096

  3. 512

  4. 2048


Correct Option: B

Can we insert data into a view?

  1. True

  2. False


Correct Option: A

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode?

  1. PL/SQL program needs to be recompiled frequently.

  2. /SQL program that spends most of the time executing SQL

  3. PL/SQL program , which performs computation-intensive procedural operations and is recompiled rarely

  4. PL/SQL program , which is called frequently with the same parameter values by multiple sessions and is recompiled rarely.


Correct Option: A,B

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?

  1. It loads the Java code into the database.

  2. It publishes Java methods in CardValidation.java

  3. It loads the metadata related to the Java class file into the database.

  4. It loads the Java class file into the Java pool in the database instance.


Correct Option: A

Examine the settings for a user session given below : RESULT_CACHE_MODE =FORCE. What would be the implications of this setting on query execution?

  1. Query results are bigger than the available space in the result cache are not cached

  2. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in query.

  3. All query results are stored in the result cache if possible.

  4. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query


Correct Option: C

Which statements are true about internal LOBs?

  1. They can be used as attributes of a user-defined data type.

  2. They cannot use redo logging.

  3. They cannot be passed as parameters to PL/SQL subprograms.

  4. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column


Correct Option: A,D

Which statements are true about the SecureFile storage paradigm?

  1. SecureFiles storage can be used for internal and external LOBs

  2. ASSM must be enabled for a tablespace to store SecureFile LOBs

  3. SecureFile is the default storeage paradigm for all LOBs

  4. SecureFile options enabled for a LOB column can be overridden on a per-LOB basis wihtin the LOB column


Correct Option: B,D

Which statements are true about inlining of PL/SQL subprograms?

  1. Only local subroutins can be inlined

  2. Inlining always reduces the execution time for the PL/SQL program unit

  3. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2

  4. the PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining


Correct Option: A,C

Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package?

  1. DDL report for all objects dependent on a table

  2. DDL report for all the invalidated objects in a schema

  3. data definition language (DDL) report for all the tables in a schema

  4. DDL report for all the objects stored in a tablespace


Correct Option: A,C
  1. A cursor variable points to the current roe in the result set of a multirow query stored in work area

  2. A cursor variable is an explicitly named work area in which the results of different multirow queries can be stored.

  3. A cursor variable can be used only if a query is performed and its results are processed in the same subprogram.

  4. A cursor variable can be used to perform a query in one subprogram , and process results in a different sub program


Correct Option: A,C

What is a constraint?

  1. It is a standard method to enforce information integrity

  2. It is a standard method to manipulate data in databases

  3. They are policies to enforce security access to database

  4. Are method that allow users to authenticate


Correct Option: A
  1. When a field that is a primary key cannot be used a foreign key because of security policies

  2. When a primary key is composed by more than field

  3. When a primary key is a set of fields that are foreign keys

  4. When a set of fields that are foreign keys are set as a primary key


Correct Option: B

What does the stack space in a PGA hold?

  1. stack variables and other info

  2. session's variables and arrays

  3. session info stored in PGA

  4. binding variables and runtime buffers


Correct Option: B
- Hide questions