You are using Data Pump to upload rows into a table, and you wish to use the direct path. Which of the following statements is correct? Should have chosen
You have no control over this; Data Pump will use the direct path automatically if it can. You must include the DIRECT keyword in the Data Pump controlfile. Direct path is slower than the external table path because it doesn’t cache data in memory.
This is not possible if the table is in a cluster.
Which three statements are true about using flashback database in a multitenant container database (CDB)? The root container can be flashed back without flashing back the pluggable databases (PDBs). Individual PDBs can be flashed back without flashing back the entire CDB. To enable flashback database, the CDB must be mounted. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
Which users are created and can be used for database and host management of your DBaaS database servers? opc and oracle users cloud and oracle users root, oracle and cloud users root and oracle users.
You want to start up the database using a binary initialization file. What is another name for this file? init_pfile.ora Configfile Spfile Pfile.
Which two are prerequisites for performing a flashback transaction? Recycle bin must be enabled for the database. Supplemental logging must be enabled. Undo retention guarantee for the database must be configured. Flashback Database must be enabled. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Which statement is true redo log files during instance recovery? All current, online, and archived redo logs are required to complete instance recovery. All current, active, and inactive redo logs are required to complete instance recovery. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
Which three statements are true about a job chain? It can contain a nested chain of jobs. It can be used to implement dependency-based scheduling. It cannot have more than one dependency. It cannot invoke the same program or nested chain in multiple steps in the chain.
It can be executed using event-based or time-based schedules.
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);
Which three statements are true about the effect of this command? Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Which two options are not true with the STARTUP UPGRADE mode instance startup? It suppresses spurious and unnecessary error messages, especially the ORA-00942. It initiates the upgrade process automatically after the instance is started. It handles certain system startup parameters that could interfere with the upgrade. This option is more of a documentation purpose when the database is started for upgrade. Its functionality is no different than the default STARTUP option. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?
(Choose two.) trace file generated using BACKUP CONTROLFILE TO TRACE backup pieces copies of all parameter files control file autobackups Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database? a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled a default database configuration a Data Warehouse database template, with the dedicated server mode option and AMM enabled a General Purpose database template with default memory allocation.
By default, how long will database statistics be retained in the AWR? 30 days 7 hours Indefinitely 8 days.
Which query can be used to find the names of Oracle Scheduler metadata views? SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%SCHED%'; SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%RSRC%'; SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%JOB%'; SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%PLAN%';.
Is it possible for the unified audit trail to lose audit records? It is possible for records to be lost in the event of an instance failure. The unified audit trail is always protected in all circumstances. Records cannot be lost, but they can be deleted or modified with DML commands. The audit trail is protected against DML, but DDL (such as TRUNCATE) can lose records.
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? The index remains invisible. The index is not updated by the DML statements on the indexed table. The index is updated by the DML on the table. The index automatically becomes visible in order to have it updated by DML on the table. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
How can a table space be made larger? Resize the existing file(s). Convert it from a SMALLFILE tablespace to a BIGFILE tablespace. If it is a BIGFILE tablespace, add more files. If it is a SMALLFILE tablespace, add files.
You want to make Grid Infrastructure services available to your database. Where can the software be installed? Into a dedicated Oracle Home on each machine running a database All of the above Into an Oracle Home on a machine accessible to all databases over a network Into the database Oracle Home, if it is the same release.
You would like to perform maintenance on the system and limit access to only the DBA staff during the maintenance window.
Which of the following startup options should you use? STARTUP RESTRICT STARTUP MOUNT RESTRICT STARTUP NOMOUNT RESTRICT STARTUP MOUNT FORCE RESTRICT.
Which three statements are true about using flashback database in a multitenant container database (CDB)? A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. The root container can be flashed back without flashing back the pluggable databases (PDBs). To enable flashback database, the CDB must be mounted.
Individual PDBs can be flashed back without flashing back the entire CDB.
Which statement is true redo log files during instance recovery? All current, active, and inactive redo logs are required to complete instance recovery. All redo log entries in the current log are applied to data files until the checkpoint position is reached. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint. All current, online, and archived redo logs are required to complete instance recovery.
Which three factors influence the optimizer's choice of an execution plan? the optimizer_mode initialization parameter cardinality estimates fixed baselines operating system (OS) statistics object statistics in the data dictionary.
You’ve noticed that when an instance crashes, it takes a long time to start up the database. Which advisor can be used to tune this situation? The SQL Tuning Advisor The Undo Advisor The Database Tuning Advisor All current, online, and archived redo logs are required to complete instance recovery. The MTTR Advisor.
Which three statements are true about using flashback database in a multitenant container database (CDB)? The root container can be flashed back without flashing back the pluggable databases (PDBs). Individual PDBs can be flashed back without flashing back the entire CDB. To enable flashback database, the CDB must be mounted. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
Which statement is true redo log files during instance recovery? All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint. All current, active, and inactive redo logs are required to complete instance recovery. All current, online, and archived redo logs are required to complete instance recovery. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
Which of these operations cannot be accomplished while the database is open? Adding an online logfile member Changing the archivelog mode of the database Adding a controlfile copy Changing the location of the fast recovery area.
You notice that sessions have been waiting on the “resmgr:cpu quantum” wait event. What might this indicate? That the system has hit 100-percent CPU usage That no Resource Manager plan been enabled That the number of sessions has reached the limit imposed by the SESSIONS parameter That the CPU_COUNT has been exceeded.
Your users have called to complain that system performance has suddenly decreased markedly. Which is the most likely place to look for the cause of the problem in EM Database Control? The Maintenance tab The Performance tab The Main screen The Administration tab.
Which two are prerequisites for performing a flashback transaction? EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. Supplemental logging must be enabled. Recycle bin must be enabled for the database. Flashback Database must be enabled. Undo retention guarantee for the database must be configured.
You are using Data Pump to upload rows into a table, and you wish to use the direct path. Which of the following statements is correct? You have no control over this; Data Pump will use the direct path automatically if it can. You must include the DIRECT keyword in the Data Pump controlfile. Direct path is slower than the external table path because it doesn’t cache data in memory. This is not possible if the table is in a cluster.
Which two statements correctly describe the relationship between data files and logical database structures? An extent cannot span data files. A data file can belong to only one tablespace. A segment cannot span data files. The size of an Oracle data block in a data file should be the same as the size of an OS block.
You receive an alert warning you that a tablespace is nearly full. What action could you take to prevent this becoming a problem, without any impact for your users? Shrink the indexes in the tablespace. Purge all recycle bin objects in the tablespace. Move one or more indexes to a different tablespace. Shrink the tables in the tablespace. Move one or more tables to a different tablespace.
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED. Use the DBMS_PDB package to clone an existing PDB. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
|
