Jul 02, 2024 Updated 1Z0-083 Dumps Questions For Oracle Exam [Q39-Q55]

NO.39 An Oracle Database server session has an uncommitted transaction in progress which updated
5000 rows in one table.
In which two situations does the transaction complete, thereby committing the updates?

NO.40 Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

NO.41 Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

NO.42 Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED —————————————————————2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C ‘PDB2’ What is the outcome?

NO.43 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: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

NO.44 Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome
Oracle_home_path
For which two purposes can you use this command? (Choose two.)

NO.45 Which three are true about Automatic Workload Repository (AWR)?

NO.46 Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true?

NO.47 Choose three. Which three capabilities require the use of the RMAN recovery catalog?

NO.48 The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace?
(Choose two.)

NO.49 Which four are true about RMAN backup sets? (Choose four.)

NO.50 Choose two. Which two are true about Rapid Home Provisioning of Oracle software?

NO.51 Which operating system group is NOT needed to perform an Oracle Database installation?

NO.52 Which two are true about the SQL Tuning Advisor?

NO.53 Which three are true? (Choose three.)

NO.54 Choose the best answer. Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB $SEED. How many default temporary tablespaces can be assigned in the CDB?

NO.55 Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)