최신Oracle Database 12c Essentials - 1z1-497무료샘플문제
문제1
Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?
Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?
정답: A,B,D
문제2
Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B.
which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?
Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B.
which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?
정답: B,D
문제3
Which two statements are true about transactions in Oracle Database 12c?
Which two statements are true about transactions in Oracle Database 12c?
정답: A,B
문제4
Which three events signal a database writer (DWR) to write buffers to disk?
Which three events signal a database writer (DWR) to write buffers to disk?
정답: A,C,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
What happens when you execute these SQL statements?
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS POOL SIZE = 0;
What happens when you execute these SQL statements?
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS POOL SIZE = 0;
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
Which two statements about Automatic Data Optimization (ADO) are true?
Which two statements about Automatic Data Optimization (ADO) are true?
정답: A,E
문제7
All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?
All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)