1Z0-074 Exam Questions

Your CDB has a PDB, EMP_PDB. You successfully execute these commands as the SYSTEM USER in CDB$ROOT: Which two statements are true about C##USR1? (Choose two.)

Which two statements are true about application containers? (Choose two.)

While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command...

From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2. 1.0 is the current version of the application. You execute this block...

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema. BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker...

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Which three are true about system and object privileges? (Choose three.)

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promoti...

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

Which two statements are true about substitution variables? (Choose two.)

Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks. W...

Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2. USER1 is a local user in PDB1 and has the SYSBACKUP privilege. Connect descriptors for P...

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

Examine these statements executed in the PROD1 database: Which statements are audited?

You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB...

Which three statements are true about inner and outer joins? (Choose three.)

Examine the description of the PRODUCTS table: Which three queries use valid expressions? (Choose three.)

Which three statements are true about the DESCRIBE command? (Choose three.)

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query produces output for C...

The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL: Examine these parameters in ORCL_PDB: You switch to ORCL_PDB and plan to execute these commands: What will be th...

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to '/u01/app/ oracle/oradata'. CDB1 has an application container called REGIONS_APP. There are no seeds fo...

Examine this parameter: Examine these commands: Which three are true after executing these commands? (Choose three.)

In which three situations would you recommend DB Replay to be used? (Choose three.)

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB. Where should you execute these statements?

The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable databases (PDBs) PDB1 and PDB2. A connect descriptor for TESTDB is mapped to the TNS alias tes...

Examine this SQL statement: Which two are true?

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transactions complete thereby co...

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT Which two are true about data type conversions involving t...

The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the...

Examine this query: SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL; What is the result?

Which three are true about the CREATE TABLE command? (Choose three.)

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output?

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

Which three statements are true about single-row functions? (Choose three.)

Which two statements are true regarding a SAVEPOINT? (Choose two.)

Which two statements are true about a PDB lockdown profile? (Choose two.)

Which two statements are true about a band join? (Choose two.)

Examine these parameters in a PFILE used to start database instance. Which two statements are true after an instance restart is attempted and why? (Choose two.)

Which statement is true about Trace File Analyzer (TFA) Collector?

Examine this command: Which statement is true?

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.