Oracle Database 12c Essentials - 1z1-497 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

A. Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication. B. These administrative privileges enable you to connect to the database only if the database is open. C. After connecting with these privileges, you are connected under a predefined user whose name is the privilege name. D. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

Identify three key properties of a transaction in Oracle Database 12c.

A. concurrency B. scalability C. isolation D. manageability E. durability F. consistency

Discussion 0

Correct Answer: C,E,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

After a ___________ statement is issued, a transaction ends. (select three)

A. SAVEPOINT B. SELECT C. CREATE D. COMMIT E. ROLLBACK

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

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

A. Hung sessions were more than 10% of total sessions. B. The average active sessions were more than three times the number of CPU cores. C. A deadlock was detected. D. Memory allocations were more than 95% of physical memory. E. The session limit was close to 100%. F. Active sessions were more than 10% of total load and CPU utilization was more than 50%.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Which three events signal a database writer (DWR) to write buffers to disk?

A. The redo log buffer becomes full. B. The database advances a checkpoint. C. A server process cannot find non-dirty blocks after scanning a threshold number of buffers. D. The database is shut down in immediate mode. E. A tablespace is changed to read-only status. F. A client process commits a transaction.

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

A. Option B B. Option E C. Option A D. Option C E. Option D

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 7

Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime. Which Oracle solution would you recommend?

A. Active Data Guard B. Oracle Cloud Platform as a Service C. Oracle Real Application Clusters D. Oracle GoldenGate E. Oracle Transportable Tablespaces

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which three statements about replication options are true?

A. Oracle Streams is deprecated in Oracle Database 12c Release 1. B. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates. C. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption. D. Oracle Database Advanced Queuing is independent of Oracle Streams. E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 9

Which two statements about PDBs and CDBs are true?

A. There is only one UNDO tablespace per CDB. B. There is one SYSAUXtablespace per PDB. C. There is a set of redo log files per PDB. D. There is only one SYSTEM tablespace per CDB. E. There is only one instance per PD

Discussion 0

Correct Answer: A,B Vote an answer