052 (19)

91. View the Exhibit and examine the user information

TheUserhas been granted CONNECT andRESOURCE roles andNo individual systemPrivileges. The Sl_repUserExecutes this command to CreateATable: SQL> CREATE TABLEOrders (OID Number(6), Odate Date,ccode Number(4), Oamt Number(Ten,2)) Tablespace purchase_space; The Purchase_space tablespace alreadyexists inchTheDatabase. Which statement describes the effect ofThe command? A. The command executes successfully andCreates theTable inchThe USERS tablespace. B. The command executes successfully andCreates theTable inchThe purchase_space tablespace. C. The command produces an error because theUserDoes notThe privilege toCreatetheTable. D. The command produces an error because theUserDoes notHave quotainchThe Purchase_space tablespace.

Answer:b

View Code

92.

 the. Aconstraint inchATable  isDefined withThe initially IMMEDIATE clause. You executed theALTER TABLECommand withThe ENABLE VALIDATEoption  toEnable theconstraintThat was disabled. What is the effects ofThis command? (Choose.) A. It failsif  anyExisting row violates theconstraint. B. It does notValidate the existing datainchTheTable. C. IT enables theconstraint  tobe enforced at theEnd  ofeachTransaction. D. It preventsInsert,Update, and DeleteOperations onTheTable  whileTheconstraint  is inchThe process ofBeing enabled.

View Code

93.

 the. The session of UserSCOTT receives the following error after executing anUPDATECommand onThe EMPTable: ERROR at line1: ORA-00060: Deadlock Detected whileWaiting forResource onInvestigation, you find a session opened by UserJIM has aTransactionThat caused the deadlock. Which statements is true regarding the session ofSCOTTinchThis scenario? (Choose.) A. The session isTerminated after receiving the error andJIM canContinue  withHisTransaction. B. SCOTT should perform aCOMMIT or ROLLBACK  toAllow JIM to Continue  withHisTransaction. C. The session isRolled back after receiving the error andJIM canContinue  withHisTransaction. D. SCOTT has toReexecute the last CommandinchTheTransactionAfter he commits theTransaction

Answer:bd

View Code

94.

94. Examine the following statement that isUsed toModify thePrimary Key constraint  onThe SALESTable: SQL> ALTER TABLESALES MODIFYCONSTRAINTPK DISABLE VALIDATE; Which three statements is true regarding the above command? (Choose three.) A. theconstraintremains valid. B. theIndex  onTheconstraint  isdropped. C. It allows the loading ofData intoTheTableUsing SQL*Loader. D. New data Conforms toTheconstraint, but existing data is  notchecked. E. It allows the data manipulation onTheTableUsingINSERT/UPDATE/DELETESQL statements.

94. Examine the following statement that isUsed toModify thePrimary Key constraint  onThe SALESTable: SQL> ALTER TABLESALES MODIFYCONSTRAINTPK DISABLE VALIDATE; Which three statements is true regarding the above command? (Choose three.) A. theconstraintremains valid. B. theIndex  onTheconstraint  isdropped. C. It allows the loading ofData intoTheTableUsing SQL*Loader. D. New data Conforms toTheconstraint, but existing data is  notchecked. E. It allows the data manipulation onTheTableUsingINSERT/UPDATE/DELETESQL statements.

View Code

95.

 the. YouExecuteThe following command toChange the status ofThe SALES tablespace:sql> ALTERtablespace sales OFFLINE; Which statements describe the effect ofThe command? (Choose Allthat apply.) A. The tablespace would require recovery to GoBack online. B. ACheckpoint  isTaken on  AllData files that is associated withThe SALES tablespace. C. The sessions that subsequently try toAccess the objectsinchThe SALES tablespace receive an error. D. The new status ofThe SALES tablespace isRecordedinchThe controlfile  whenTheDatabaseInstance isClosed.

Answer:bc

View Code

052 (19)