1Z0-497 Exam Questions
166 real 1Z0-497 exam questions with expert-verified answers and explanations. Page 1 of 4.
- Question #1
Which three statements represent the benefits of multitenant architecture for database consolidation?
- Question #2
Which statement about the Oracle Advanced Security Data Redaction feature is true?
- Question #3
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?
- Question #4
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...
- Question #5
Which two statements are true regarding undo data records? (Choose two.)
- Question #6
You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?
- Question #7
Which two statements are true regarding the database control file? (Choose two.)
- Question #8
Which two statements about Database Express are true?
- Question #9
Which three operations can the PUBLIC user with the SYSOPER privilege perform?
- Question #10
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,...
- Question #11
Which command do you use to create a local role while you are connected as the local user?
- Question #12
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...
- Question #13
For which database operation do you need the database to be in MOUNT state?
- Question #14
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...
- Question #15
A DBA informs you that an Oracle instance has started. What does this imply?
- Question #16
Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?
- Question #17
Which command do you use to check for block corruption by validating the database?
- Question #18
Which tool is recommended for moving a PDB to a non-CDB?
- Question #19
Which two statements describe data dictionary views?
- Question #20
Which two statements about this policy are true?
- Question #21
Which option represents a function of Global Data Services (GDS)?
- Question #22
Which two statements represent where Oracle Net must reside?
- Question #23
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...
- Question #24
Which new process was introduced as of Oracle Database 12c?
- Question #25
Which two statements are true about this common user?
- Question #26
Which two statements are true regarding undo data records?
- Question #27
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...
- Question #28
Your database is down. You log in as the SYS user and issue this command: SQL> STARTUP What happens after the instance is started?
- Question #29
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...
- Question #30
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...
- Question #31
Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?
- Question #32
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...
- Question #33
You execute some DMLcommands, followed by a COMMITStatement. Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?
- Question #34
Which two statements about PDBs and CDBs are true?
- Question #35
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?
- Question #36
You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?
- Question #37
Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?
- Question #38
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;
- Question #39
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?
- Question #40
Which two statements are true about transactions in Oracle Database 12c?
- Question #41
Which two statements about Data Recovery Advisor are true?
- Question #42
Which two statements about multitenant architecture are true?
- Question #43
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...
- Question #44
Examine the command below: LSNRCTL> SERVICES LISTENER2 Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com) (PORT=1525))) Services Summary. . . Service "orc...
- Question #45
Which three statements are true about a database instance that has mounted a database but has not opened it?
- Question #46
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...
- Question #47
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...
- Question #48
An Oracle instance is a combination of______.
- Question #49
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....
- Question #50
Which two are client-side components of Oracle Data Guard Broker?