AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-023





Question ID 9068

DRAG DROP

Drag the administrative script name to its description.

Explanation Explanation/Reference: Explanation: Cat*.sql = Catalog and dictionary information Dbms*.sql = Database package specifications. Prvt*.plb = Wrapped database package code Utl*.sql = Views and table for database utilities. Cat*.sql administrative scripts are used to store catalog and dictionary information. Dbms*.sql scripts define database package specifications. Prvt*.plb scripts are used for wrapped database package code. Utl*.sql scripts defines views and tables for database utilities. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 312-318 Chapter 7: Managing the Physical Database Structure


Question ID 9069

DRAG DROP

The datafile is in a non-SYSTEM tablespace. Place the steps for renaming a datafile in the correct order.

Explanation Explanation/Reference: Explanation: For to multiple or system tablespace: (5 steps) Shutdown -> Copy or rename -> Startup mount -> Alter database rename file-> Alter database open. Tablespace offline -> Copy or move -> Alter database rename file or Alter tablespace ... rename datafile -> Online To rename a datafile you need to put tablespace offline, copy or move datafiles of the tablespace, issue ALTER DATABASE ... RENAME FILE or ALTER TABLESPACE ... RENAME DATAFILE command and put tablespace online. This works if the datafile is in a non-SYSTEM tablespace. If it is in a SYSTEM tablespace, procedure is a little different and it requires to restart instance.

Send email to admin@getfreedumps for new dumps request!!!