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.