2022 Updated Verified Pass 1z0-063 Exam - Real Questions & Answers
Dumps Moneyack Guarantee - 1z0-063 Dumps Approved Dumps
NEW QUESTION 49
Examine the output:
SQL > ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive Destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 376
Next log sequence to archive 378
Current log sequence 378
Which three types of files are automatically placed in the fast recovery area?
- A. Control file autobackups
- B. Archived redo log files
- C. Recovery Manager (RMAN) backup pieces
- D. Flashback data archives (FDA)
- E. Server parameter file (SPFILE)
Answer: A,B,C
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526
NEW QUESTION 50
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters VERSION=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the FULL, NETWORK_LINK, and TRANSPORT_DATAFILES parameters.
7. Perform an import on the target database by using the full and TRANSPORT_DATAFILES parameters.
Identify the minimum required steps in the correct order.
- A. 3, 5, 4, 2, and 7
- B. 1, 2, 4, 6, 5, 3 and 7
- C. 2, 4, 5, 3 and 7
- D. 1, 3, 5, 4, 2, and 7
- E. 1, 4, 5, 2 and 6
Answer: D
NEW QUESTION 51
Which two statements are true when row-archival management is enabled?
- A. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
- B. The ORA_ARCHIVE_STATE column is updated automatically by the databasebased on activity tracking columns, to indicate that a row is no longer considered active.
- C. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
- D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
- E. The row archival visibility session parameter defaults to all rows.
Answer: A,D
NEW QUESTION 52
Which statement is true about the ALTER SESSION SET CONTAINERcommand to switch between containers?
- A. It rolls back any pending transactions in the container from which it is executed.
- B. It will not fire login triggers for the specified container.
- C. It can be executed only from CDB$ROOT.
- D. It cannot be used to connect to PDB$SEED.
- E. It cannot be used to connect to CDB$ROOTfrom a pluggable database (PDB).
Answer: D
Explanation:
The current container can be the root or a PDB.
The current container can be CDB$ROOT (root) only for common users. The current container can be a particular PDB for both common users and local users.
References: https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm
NEW QUESTION 53
An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed.
You execute:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which two are true? (Choose two.)
- A. It returns an error because there is no existing level 0 backup for new data files.
- B. It creates image copies of all the new data files.
- C. It creates a level 0 backup set containing all the new data files.
- D. It creates a level 1 incremental backup set containing all the new data files.
- E. It creates a level 1 incremental backup set containing all the previously existing data files.
Answer: E
NEW QUESTION 54
Which three types of failures are detected by the Data Recovery Advisor (DRA)?
- A. loss of a non-critical data file
- B. logical data block corruption
- C. loss of an archived redo log file
- D. physical data block corruption
- E. loss of a control file
Answer: A,D,E
Explanation:
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm#BRAD V89728
NEW QUESTION 55
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
- A. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
- B. expdp will succeed but impdp will fail because the users do not exist.
- C. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.
- D. expdp will fail because no path has been defined for the dumpfile.
Answer: B
NEW QUESTION 56
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
What is the outcome of the import?
- A. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
- B. It fails because RMAN is not connected to the target database with DBID=1423241.
- C. It fails because the target database and recovery catalog database are of different versions.
- D. It succeeds but the database is not automatically registered in the RC12c catalog.
Answer: C
NEW QUESTION 57
Which three statements are true about Oracle Secure Backup (OSB)?
- A. It can be used to manage tape backup and restore operations for multiple databases.
- B. It can encrypt client data written to tape.
- C. It can be used to perform file system backups at the file, directory, file system, or raw partition level.
- D. It can be used along with an RMAN recovery catalog for maintaining records of backups
in a tape library. - E. It can be used to take image copy backups to tape.
Answer: A,B,C
NEW QUESTION 58
You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
- A. Flashback Database must be enabled.
- B. A database backup must be taken.
- C. Undo retention guarantee must be enabled
- D. Fast Recovery Area must be enabled.
- E. The recyclebin must be enabled for the database.
- F. The database must be running in ARCHIVELOG mode.
Answer: D,F
NEW QUESTION 59
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within
the Oracle Job Scheduler? (Choose three.)
- A. A job is specified as part of a program definition.
- B. A program and window can be specified as part of a job definition.
- C. A program and job can be specified as part of a schedule definition.
- D. A program can be used in the definition of multiple jobs.
- E. A program and schedule can be specified as part of a job definition.
Answer: B,D,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 60
Which two statements are true regarding Oracle Data Pump? (Choose two.)
- A. EXPDP and IMPDP are the client components of Oracle Data Pump.
- B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
- C. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
- D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
- E. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
Answer: A,B
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
NEW QUESTION 61
In a database supporting an OLTP workload, tables are frequently updated on both key and non- keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
- A. index clustered table
- B. global temporary table
- C. heap table with a primary key index
- D. external table
- E. hash clustered table
Answer: A
NEW QUESTION 62
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1is created? (Choose two.)
- A. The FILE_NAME_CONVERTclause must be added to the command.
- B. The ENABLE_PLUGGABLE_DATABASEparameter must be set to TRUE.
- C. The PDB_FILE_NAME_CONVERTparameter must be configured.
- D. The USER_DATA TABLESPACE clause must be added to the command.
- E. The DB_CREATE_FILE_DESTparameter must be configured.
Answer: A,B
Explanation:
Explanation
NEW QUESTION 63
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
- A. default encryption
- B. transparent encryption
- C. password-mode encryption
- D. dual-mode encryption
Answer: C
Explanation:
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password -encrypted backups)
NEW QUESTION 64
Evaluate these statements:
CREATE TABLE purchase_orders
( po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
( PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')),
PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')),
PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-mm-yyyy')),
PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));
CREATE TABLE purchase_order_items
(po_idNUM3ER(4)NOT NULL,
product_idNUMBER(6)NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_f k
FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
Which two statements are true? (Choose two.)
- A. Partitions of purchase_order_items are assigned unique names based on a sequence.
- B. The purchase_orders and purchase_order_items tables are created with four partition each.
- C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table
partitions. - D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the
parent table. - E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key
constraint.
Answer: B,C
NEW QUESTION 65
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1.Place all the user-defined tablespace in read-only mode on the source database.
2.Upgrade the source database to a 12c version.
3.Create a new PDB in the target container database.
4.Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility.
5.Copy the associated data files and export the dump file to the desired location in the target database.
6.Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7.Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
- A. 1, 3, 4, 5, 6, 7
- B. 1, 5, 6, 4, 3, 2
- C. 1, 4, 3, 5, 6, 7
- D. 2, 1, 3, 4, 5, 6, 7
- E. 2, 1, 3, 4, 5, 6
Answer: C
NEW QUESTION 66
......
More Info
For more info visit: Oracle 12c Official 1Z0-063 Exam Reference
Updated PDF (New 2022) Actual Oracle 1z0-063 Exam Questions: https://www.exams4collection.com/1z0-063-latest-braindumps.html
