oca ocp

Reprint Please specify source : http://blog.csdn.net/guoyjoe/article/details/386848191. Get the library cache Latch(1) The text of the SQL statement was not found in the handle of the parent cursor: SELECT * from Gyj_t1 where id=1;2. Release Library

17. YouconfigureAUTOBACKUPtoONinanRMANsession. WhenwillRMANbackupthecontrolfile? (Chooseallthatapply.) A. WhenyourunanRMANBACKUPcommandB. WhenyourunanRMANALLOCATEcommandC. Whenyouaddordropatableinthe 17. You configure AUTOBACKUP to ON an RMAN

703. Given below are RMAN commands to enable ba ckup optimization and set the retention policy: The USERS tablespace has never been backed up. Y ou take the USERS tablespace offline on Monday. View the Exhibit to examine the operations saved med

Question no: 2 You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. the STUDENT_GRADES table stores information about the student's

Question no: 1 Evaluate the SQL statement: Truncate table dept; Which three are true about the SQL statement? (Choose three .) A. It releases the storage space used by the table. B. It does not release the storage space used by the table. C. You can

586. Consider the following command: Backup database plus archivelog delete input; How many backup sets wocould be created by this command if the following were true: Control-file auto backups were enabled. The size of backup sets was not restricted.

400. Which of the following methods can be used to detect block upload uption? A. ANALYZE operations B. dbv C. SQL queries that access the potentially encrypted upt block D. RMAN E. All of the above Answer: E Answer: Reference:

Users are connected to a database instance, which is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the ASM instance: Users connect to a DB instance, using Automatic storage Management (ASM).The DBA

QUESTION 68You have three temporary tablespace groups named G1, G2, and G3 in your database. You areCreating a new temporary tablespace as follows:CREATE temporary tablespace TEMP1 tempfile '/u1/data/temp1.dbf ' SIZE 10M tablespaceGROUP ";Which

QUESTION 63Which method would the changes made by a particular transaction without affectingThe changes made by other transactions?A. Point-in-time RecoveryB. Execute the ROLLBACK command with transaction numberC. Flashback the database to before

Preface Aside from a few questions, I am a little satisfied with all the series of blog posts. For my own monograph, I will post an Oracle blog every day, and other blog posts will be posted in my spare time. Click Database Configuration

Preface If we have some experience in starting and stopping databases, we always think that there is only one command. However, I have seen a book with more than 100 pages dedicated to the operation process after the command. Let's just talk a

Every day is a repeat of 2.1 lines. The work is boring, and the work described above is done. The technology used is also the same. It has been used since its entry into the company, never changed. Without passion, it's just a groose job. Every day,

1. backup and recovery problems The final result of considering business needs, performance, and capital costs is usually a compromise. It is extremely important to record this scheme, usually in the form of a service level agreemenet ). The service

121. you want to create a new optimized database for your transactional production environment to be used by a financial application. while creating the database, you want the Oracle software to take care of all basic settings to optimize the

Statement: the answer is a personal understanding of Oracle. 1. Because of a power outage, instance failure has occurred. From what point in the redo log does recovery in and where does it end? A. Current redo log and inactive redo log B. Checkpoint

33.You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:1) The order ID will be unique and cannot have null values.2) The order date cannot have null values and the default shocould be

21. Examine the description of the EMP_DETAILS table given below:Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME not null VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?

6. Examine the structure of the SHIPMENTS table: Name Null Type PO_ID not null number (3) PO_DATE NOT NULL DATE SHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2 (30) SHIPMENT_COST NUMBER (8, 2) You want to generate a report that displays the PO_ID

24. Examine the structure proposed for the TRANSACTIONS table:Name Null TypeTRANS_ID not null number (6)CUST_NAME not null VARCHAR2 (20)CUST_STATUS not null VARCHAR2TRANS_DATE NOT NULL DATETRANS_VALIDITY INTERVAL DAY TO SECONDCUST_CREDIT_VALUE