• databases Online Quiz - 174
Back
0

databases Online Quiz - 174

Description: databases Online Quiz - 174
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

You want to administer your database servers, which are running on different host machines using the web enabled grid control interface. You have configured the agent in the host machines. You have started Oracle database10g grid control utility on your machine. Which two additional components would you configure to achieve this objective?

technology databases

  1. Application server control.

  2. Oracle Management service.

  3. Oracle enterprise manager repository.

  4. Oracle enterprise manager database control.

Show answer
Correct Option: C,D

Your database is in NOARCHIEVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?

technology databases

  1. Hot backup

  2. Online backup

  3. Consistent backup

  4. Incremental backup

  5. Inconsistent backup

Show answer
Correct Option: C

You have enabled tracking while creating a listener to your database. What additional information is available to you when you enable tracking?

technology databases

  1. Information about each oracle Net connection.

  2. Information about each entry in the Listener.ora file

  3. Information about the changes done in the database.

  4. None

Show answer
Correct Option: A

In Oracle 10g , which statement regarding the contents of the V$PARAMETER view is true?
technology databases

  1. Displays only the list of all default values.

  2. Displays only the list of all basic parameters.

  3. Displays currently in effect parameter values.

  4. Displays only the list of all advanced parameter.

Show answer
Correct Option: C

Your database is opened in NOARCHIVELOG mode. You decide to place the database in ARCHIEVELOG mode. How would you do this? ( Choose two)
technology databases

  1. Execute the ALTER DATABASE ARCHIVELOG statement

  2. Select ARCHIVELOG option in database control and restart the database to apply the changes.

  3. Shutdown and restart the instance, and in NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

  4. Shutdown and restart the instance mount the database and execute the ALTER DATABASE ARCHIVELOG statement.

Show answer
Correct Option: B,D

Suppose you are using three databases, DB01, DB02, and DB03 on different host machines in development environment. The database server configuration such as server IP address and listener Port number changes frequently due to development requirements. And you have the task of notifying the developers of the changes. Which connection method would you use to overcome the overhead?

technology databases

  1. Host naming

  2. Local naming

  3. Easy Connect

  4. External naming

  5. Directory naming

Show answer
Correct Option: E

In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?
technology databases

  1. It degrades the run time and compiler performance

  2. It provides better run time and compiler performance

  3. It provides better optimization of the statement during parse time.

  4. It forces the rule based optimizer to be used for statement optimization.

  5. It provides better run time performance, but slightly degraded compiler performance.

Show answer
Correct Option: E

You are working on the Training Database. What is default name of the alert log file in this database?

technology databases

  1. alert_Training.log

  2. alertlog_Training.log

  3. alert_log_Training.log

  4. Training_alert_log.log

Show answer
Correct Option: A

Suppose you are working in a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? (Choose two)

technology databases

  1. By multiplexing the control files.

  2. By multiplexing the redo log files.

  3. By decreasing the size of redo log files.

  4. By configuring the Mean Time Recover (MTTR) to a lower value.

  5. By setting UNDO_RETENTION parameter to a higher value.

Show answer
Correct Option: C,D

Database Vault is available as a standard product included in the Enterprise Edition of Oracle Database 10g Release 2.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

An enhancement in Oracle Database 10g Release 2 is that Enterprise manager computes statistical alert threshold using either static ( user-defined) or dynamic ( self- adjusting) baseline.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The __________ attribute is used to declare variables based on definitions of columns in table.

technology databases

  1. %ROWTYPE

  2. %TYPE

  3. AS_COLUMN

  4. None of the above

Show answer
Correct Option: B

AI Explanation

To answer this question, you need to understand the concept of declaring variables based on definitions of columns in a table.

Option A) %ROWTYPE - This option is incorrect because the %ROWTYPE attribute is used to declare a record variable that has the same structure as a row in a table or a cursor. It is not used to declare variables based on definitions of columns in a table.

Option B) %TYPE - This option is correct because the %TYPE attribute is used to declare variables based on the data type of a column in a table. By using %TYPE, you can ensure that the variable has the same data type as the column, making it easier to work with the data.

Option C) AS_COLUMN - This option is incorrect because there is no attribute called AS_COLUMN in Oracle SQL.

Option D) None of the above - This option is incorrect because option B, %TYPE, is the correct answer.

The correct answer is B) %TYPE. This option is correct because the %TYPE attribute is used to declare variables based on the data type of a column in a table.

Raw types are used to store _________ data.

technology databases

  1. binary

  2. Character

  3. ASCII

  4. All of the above

Show answer
Correct Option: A

SQL has facility for programmed handling of errors that arise during the manipulation of data.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

_________ data type stores unstructured binary data upto 4GB length.
technology databases

  1. CLOB

  2. BLOB

  3. LONG

  4. All of the above

Show answer
Correct Option: B

In a PL/SQL block structure, which parts are optional?
technology databases

  1. DELCARE and BEGIN

  2. DECALRE and EXCEPTION

  3. EXCEPTION and END

  4. BEGIN and END

Show answer
Correct Option: B

CREATE OR REPLACE PACKAGE BODY COMPILE_THIS IS PROCEDURE A IS BEGIN G_VALUE := (‘HELLO WORLD’); END A; PROCEDURE B IS BEGIN C; DBMS_OUTPUT. PUT_LINE (‘PROCEDURE B CALLING C’); END B; PROCEDURE C IS BEGIN B; DBMS_OUTPUT. PUT_LINE (‘PROCEDURE C CALLING B’); END; END COMILE_THIS; / Procedure C is a local construct to the package. What happens when this package is compiled?
technology databases

  1. It produces the output Procedure B calling C

  2. It produces the output Procedure C calling B

  3. It produces a compilation error because procedure C requires a forward declaration

  4. It produces a compilation error because procedure B requires a forward declaration.

  5. It produces a compilation error because identified g_value is not declared in procedure A

Show answer
Correct Option: C

A Rollback statement cannot be used to close transaction.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

If the Oracle Engine for its internal processing has opened a cursor they are known as _________

technology databases

  1. Explicit Cursor

  2. Implicit Cursor

  3. Active Data Set

  4. None of the above

Show answer
Correct Option: B

You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?

technology databases

  1. A stored procedure on the server.

  2. A block of code in a PL/SQL library.

  3. A standalone procedure on the client machine.

  4. A block of code in the body of the program unit ORDERTOTAL.

  5. A local subprogram defined within the program unit ORDERTOTAL.

Show answer
Correct Option: E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions