052 (33)

161.

161. Note the following points describing various utilitiesinchOracleDatabase11g:1. It enables the high-Speed transfer ofData fromOneDatabase  toanother2. IT provides a complete solution forTheBackup, restoration andRecovery needs ofThe entireDatabase3. It Enables the loading ofData fromAn externalfile  into Table  ofAn OracleDatabase 4. It provides aTape BackupManagement forThe Oracle Ecosystem which point describes Oracle SecureBackup? A.1B.2C.3D.4E.1,2  and 4F.1,2,3, and 4

Answer:d

View Code

162.

162. Examine theValues  forThe following initialization parameters:fast_start_mttr_target=0Log_checkpoint_interval=0which the implications ofTheseValues inchYourDatabase? (Choose.) A. The SGA Advisor would be disabled B. The MTTR advisor would be disabled C. AutomaticCheckpointtuning'll be disabled D.CheckpointInformation would notBe written toThe alertLog file 

Answer:bc

View Code

163.

163. You had an ORDERSTable  withThe following Structure:nameNull? Type--------- ------- ----------------Oid Number(6) odate Dateccode Number(6) Oamt Number(Ten,2) theTableHas datainchThe Odatecolumn  for  AllRows. Many orders is placedinchA Single  Day. You need toensure that the OdatecolumnMust contain data forEveryOrder inchFuture . Which method would serve the purpose? A. Modify ThecolumnUsing theALTER TABLE ... MODIFY command. B.ADDAUNIQUE constraint  toThecolumnUsing theALTER TABLE...ADD CONSTRAINTcommand. C.ADDA not NULL constraint  toThecolumnUsing theALTER TABLE...ADD CONSTRAINTcommand. D.ADDAPRIMARY KEY constraint  toThecolumnUsing theALTER TABLE...ADD CONSTRAINTCommand.

Answer:a

View Code

164.

164. Identify situationsinchwhich you can UseData Recovery Advisor forrecovery. (Choose.) A. theDatabaseFiles are corrupted whenTheDatabase  is OpenB. theUserHave dropped an importantTableThat needs toBe recovered C. The archived RedoLogFiles are missing forwhich theBackup  is  notavailable D. theDatabase  is  notOpening because the requiredDatabaseFiles are missing

Answer:ad

View Code

165.

You have a tables with referential integrity enforced between them.
You need to insert data to the child table first because it's going to bes a long transaction and data for the parent tabl E'll be available on a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.

Which action would toDelay the referential integrity checking until theEnd  ofTheTransaction? A.SetTheconstraint  toDeferred before starting theTransactionB.AlterTheconstraint  toNovalidate state before starting theTransactionC. Enable the resumable mode forThe session before starting theTransactionD.SetThe commit_wait parameter toForce_wait forThe session before starting theTransaction

Answer:a

View Code

052 (33)