1Z0-497 Exam Questions

Which three statements represent the benefits of multitenant architecture for database consolidation?

Which statement about the Oracle Advanced Security Data Redaction feature is true?

Your database is down. You log in as the user SYS and issue the following command: SQL>STARTUP Which stops occur and in what order as a result of executing this command?

Your database instance in running.db01 is a net service name. You issue a connection request using the following command: SQL> CONNECT scott/tiger@db01 Which component receives the...

Which two statements are true regarding undo data records? (Choose two.)

You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?

Which two statements are true regarding the database control file? (Choose two.)

Which two statements about Database Express are true?

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow? 1 -Start the analysis. 2 - Set up the analysis policy type (database,...

Which command do you use to create a local role while you are connected as the local user?

YOU want to move all objects of the CONSULTANT user from the test database to the DB-USER schema of the production database. Which option of IMPDP would you use to accomplish this...

For which database operation do you need the database to be in MOUNT state?

Examine the table: Table name: PRODUCTS Schema: SCOTT Tablespace: USERS Organization: Standard (Heap Organized) This table contains 20 rows. In the data that has been entered, the...

A DBA informs you that an Oracle instance has started. What does this imply?

Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

Which command do you use to check for block corruption by validating the database?

Which tool is recommended for moving a PDB to a non-CDB?

Which two statements describe data dictionary views?

Which two statements about this policy are true?

Which option represents a function of Global Data Services (GDS)?

Which two statements represent where Oracle Net must reside?

When you start up a CDB, which operations are performed automatically and in what order? a - The instance is started. b - Control files are opened. c - The root container is opened...

Which new process was introduced as of Oracle Database 12c?

Which two statements are true about this common user?

Which two statements are true regarding undo data records?

Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which t...

Your database is down. You log in as the SYS user and issue this command: SQL> STARTUP What happens after the instance is started?

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c? a - Shut down the database. b - Restart...

Your database is open and the listener is running. The DBA stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are currently connected to the d...

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

Your customer is looking for a solution that meets these four needs: 1 - Replicate data from source to target for reporting purposes. 2 -Replicate data from one source to multiple...

You execute some DMLcommands, followed by a COMMITStatement. Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

Which two statements about PDBs and CDBs are true?

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?

You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

What happens if you execute these SQL statements? SQL> show con_name CON_NAME -------------------------------- CDB$ROOT SQL> create user 1_freed identified by y container=current;

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

Which two statements are true about transactions in Oracle Database 12c?

Which two statements about Data Recovery Advisor are true?

Which two statements about multitenant architecture are true?

You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite...

Examine the command below: LSNRCTL> SERVICES LISTENER2 Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com) (PORT=1525))) Services Summary. . . Service "orc...

Which three statements are true about a database instance that has mounted a database but has not opened it?

View the current parameter settings shown in the output below. NAMETYPEVALUE db_file_multiblock_read_count integer ddl_lock_timeout integer Distributed_lock_timeout integer dml_loc...

Your customer wants to migrate their production database from Oracle Database 10g on AIX to Oracle Database 12c on Solaris, and is concerned about the downtime. Which Oracle soluti...

An Oracle instance is a combination of______.

You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification....

Which two are client-side components of Oracle Data Guard Broker?