Monday, 19 December 2016

1z0-053 Questions Answers

Question: 21

Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

A. A single ADR can support multiple ADR homes for different database instances.
B. The alert files are stored in XML file format in the TRACE directory of each ADR home.
C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.
D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.

Answer: A,C

Explanation/Reference:

the ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:


  • If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
  • If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log


Within ADR base, there can be multiple ADR homes, where each ADR home is the root directory for all diagnostic data—traces, dumps, the alert log, and so on-for a particular instance of a particular Oracle product or component. For example, in an Oracle Real Application Clusters environment with Oracle ASM, each database instance, Oracle ASM instance, and listener has an ADR home.

Friday, 19 August 2016

1z0-053 Questions Answers

Question: 20

Which two statements are true regarding hot patching? (Choose two.)

A. It requires relinking of the Oracle binary.
B. It does not require database instance shutdown.
C. It can detect conflicts between two online patches.
D. It is available for installing all patches on all platforms.
E. It works only in a single database instance environment.

Answer: B,C

Thursday, 28 July 2016

1z0-053 Questions Answers

QUESTION NO : 19

Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?

A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.

Answer: B 

Tuesday, 12 July 2016

1z0-053 Questions Answers

QUESTION NO : 18

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,into the recovery catalog owned by RCO11. You executed the following commands:RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

A. They import all metadata from the RCAT10 catalog.
B. They unregister the database from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They register all databases registered in the RCAT10 catalog.

Answer : A,D

Monday, 20 June 2016

1z0-053 Questions Answers

QUESTION No : 17

Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

A. A single ADR can support multiple ADR homes for different database instances.
B. The alert files are stored in XML file format in the TRACE directory of each ADR home.
C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.
D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.

Answer: A,C

Explanation/Reference:

the ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log

Within ADR base, there can be multiple ADR homes, where each ADR home is the root directory for all diagnostic data—traces, dumps, the alert log, and so on—for a particular instance of a particular Oracle product or component. For example, in an Oracle Real Application Clusters environment with Oracle ASM, each database instance, Oracle ASM instance, and listener has an ADR home.

Friday, 6 May 2016

Google to Face Off Against Oracle Next Week in $8.8 Billion Lawsuit

The retrial of a lawsuit for copyright between the two technology giants is about to begin.

Although a Google Jury alphabet orders to pay a total of $8.8 Billion sought by Oracle in an upcoming trial copyright of San Francisco by the Android operating system, shareholders and analysts say it is likely to have little impact on the results of the search giant.

Oracle says Google Android violated its copyright on parts of the Java programming language, while Google says it should be able to use Java without paying a fee under the provision on the legitimate use of copyright.

The case was tried earlier in 2012, but a jury deadlocked. If the new jury in the trial that began Monday against Google rules about fair use, then the damage will be considered.
Google (GOOG 0.82%) made $ 75 billion in revenue in 2015, so even a large verdict for Oracle would have little impact on investors, because it would be a burden on time, said Mike Bailey, director of search Partners FBB capital, which owns shares in alphabetical format, parent company Google.

Oracle (ORCL -0.15%) is also seeking an injunction against future use of Google Android Java, which Oracle would give more power to negotiate a current rate. However, such a warrant should be issued by a judge, not a jury, and legal experts believe that it is a remote possibility.

After the first trial, Judge William Alsup of US District It found that the material in question in the case should not be subject to copyright at all. A federal appeals court overturned that decision, however, say that the structure of the computer language that connects programs can be protected.

An Oracle representative did not respond to a request for comment and a spokesman for Google declined to comment.

An expert hired for damages Oracle believes that Google took in $ 29 billion in advertising revenue and gross search for Android devices since its inception, according to court documents, plus an additional $ 11.6 million in sales of Android applications and phones.

Friday, 1 April 2016

1z0-053 Questions Answers

QUESTION No : 16

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?

A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

Correct Answer: A