Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

1Z0-062 > OCA > Flashcards

OCA Flashcards

1
Q

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

A
  • Improved parallel Execution performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q 
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
A
  • 6, 5, 4, 7
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

A
  • Oracle Recovery Manager (RMAN)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

A
  • Take the USERDATA tablespace offline in ACCOUNTS_PDB.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

A
  • Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
  • Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
  • Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which statement is true about Oracle Net Listener?

A
  • Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A
  • The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
  • The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

A
  • The primary key constraint on the EMPLOYEES table is disabled during redefinition.
  • VPD policies are copied from the original table to the new table during online redefinition.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file `/u01/app/oracle/oradata/CDB1/temp01.tmp’
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

A
  • Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
  • Shut down the database instance and then restart the CDB and PDBs.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?

A
  • Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Identify three benefits of Unified Auditing.

A
  • Decreased use of storage to store audit trail rows in the database.
  • It improves overall auditing performance.
  • It automatically audits Recovery Manager (RMAN) events.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A
  • The valid time columns employee_time_start and employee_time_end are automatically created.
  • The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  • Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

A
  • It cancels all pending disk drops within the disk group.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.
What could be a solution to make tape streaming happen during the backup?

A
  • Configure the channel to increase the capacity with the RATE parameter
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).
Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?

A
  • Because the FRA disk group is not configured to support mirroring
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

A
  • A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

A
  • Maximum Undo per consumer group
  • Parallel server limit
  • CPU
18
Q

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

A
  • It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
19
Q

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?

A
  • Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
  • Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
20
Q

Which two statements are true when row archival management is enabled?

A
  • The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
  • The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
21
Q

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?

A
  • B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
  • Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
  • Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
22
Q

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?

A
  • It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
  • It may advise the use of online table redefinition for tables in locally managed tablespaces
  • It will detect and advise about chained rows.
23
Q

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

A
  • The index remains invisible.

* The index is updated by the DML on the table.

24
Q

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

A
  • The C # # ROLE1 role is created in the root database and all the PDBs.
  • Privileges are granted to the C##A_ADMIN user only in the root database.
25
Q

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A
  • BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
  • BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
  • BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
  • BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
26
Q

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME “TO_DATE (08/20/12' , MM/DD/YY’)”;
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?

A
  • Only 3
27
Q

Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (batch_job' , FORCED_TRACKING => Y’);
Which two statements are true?

A
  • Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
  • All subsequent statements in the session will be treated as one database operation and will be monitored.
28
Q

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

A
  • System privileges apply only to the PDB in which they are used.
  • The granter of system privileges must possess the set container privilege.
  • System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
29
Q

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A
  • The DBMS_PDB package
30
Q

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

A
  • 2 and 4
31
Q

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are
connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE `u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;
What is the result?

A
  • It executes successfully but neither tablespace nor the data file is created.
32
Q

Which three statements are true about SQL plan directives?

A
  • They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
  • They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
  • They instruct the optimizer to create only column group statistics.
33
Q

You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?

A
  • The database must be MOUNTED for the flashback to succeed.

* The database must be opened with the RESETLOGS option after the flashback is complete.

34
Q

Examine these two statements:

Which three are true about the MRKT tablespace?

A
  • The MRKT tablespace may be dropped if it has no contents.
  • Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
  • No more data files can be added to the tablespace.
35
Q

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

A
  • Decreasing the value of the IDLE_TIME resource limit in the default profile
36
Q

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*’ SCOPE = SPFILE;
Which is true about the result of this command?

A
  • The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
37
Q

Which two are prerequisites for performing a flashback transaction?

A
  • Flashback Database must be enabled.

* EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

38
Q

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

A
  • Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
39
Q

On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id,sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statement are correct?

A
  • Both the indexes are created; however, only the ORD_COSTOMER index is visible.
  • Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
40
Q

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

A
  • BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
  • BACKUP DATABASE while connected to the PDB1 container

1Z0-062 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions