Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

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
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

Which two statements are true about cursor variables?

  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
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Multiple choice technology databases

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
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

What do we call a superkey?

  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
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation