Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology programming languages

Dataset: Score Name Score John 10 Greg 20 Dataset: Salary Salary 45000 Data map; If n = 1 then set salary; Set score; Run; How many observations will be in the Data Map and what would be value of salary

  1. Observations =2 and Salary = 45000 at both observations

  2. Observations = 2 and Salary = 45000 at first and Salary =. at second observation

  3. Observation = 1 and Salary = 45000

  4. Error
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology programming languages

data sw; input name $ gender ; datalines; bary 0 bary 0 celina 1 ; run; data re; input name $ gender salary ; datalines; bary . 45000 celina 1 40000 ; run; data final; merge sw re; by name; run; How many Observations will be there in dataset final and what would be the minimum value of gender variable

  1. Observations = 2 and Gender = .

  2. Observations = 2 and Gender = 0

  3. Observations = 3 and Gender = 0

  4. Observations = 3 and Gender = .
Reveal answer Fill a bubble to check yourself
D Correct answer
Multiple choice technology databases

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