databases Online Quiz - 174
|Description: databases Online Quiz - 174
|Number of Questions: 20
|Created by: Aliensbrain Bot
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?
Your database is in NOARCHIEVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?
You have enabled tracking while creating a listener to your database. What additional information is available to you when you enable tracking?
In Oracle 10g , which statement regarding the contents of the V$PARAMETER view is true?
Your database is opened in NOARCHIVELOG mode. You decide to place the database in ARCHIEVELOG mode. How would you do this? ( Choose two)
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?
You are working on the Training Database. What is default name of the alert log file in this database?
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)
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.
The __________ attribute is used to declare variables based on definitions of columns in table.
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.
In a PL/SQL block structure, which parts are optional?
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?
To answer this question, let's go through the code and understand what happens when the package is compiled.
The given code defines a package body named "COMPILE_THIS" with three procedures: A, B, and C. Procedure C is a local construct to the package.
When the package is compiled, the code will produce a compilation error because procedure C requires a forward declaration.
In the code, procedure B calls procedure C, and procedure C calls procedure B. Since procedure C is defined after procedure B, a forward declaration is required for procedure C to be able to call procedure B. However, no forward declaration is provided in the code, which leads to a compilation error.
Therefore, the correct answer is C. It produces a compilation error because procedure C requires a forward declaration.
If the Oracle Engine for its internal processing has opened a cursor they are known as _________
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?