Free Oracle 1Z0-948 Exam Dumps Questions & Answers

Which function is commonly used to concatenate multiple column values?

• A.  @NUMSTR
• B.  @VALONE
• C.  @CASE
• D.  @STRCAT

Which two actions help secure GoldenGate administrative access?
Select all that apply

• A.  Enabling BATCHSQL
• B.  Compressing trail files
• C.  Restricting GGSCI user privileges
• D.  Encrypting trail files
• E.  Enabling role-based access control

Which GoldenGate utility verifies database readiness for replication?

• A.  DBLOGIN
• B.  OGGSCI CHECKDB
• C.  OGGCA
• D.  GGSCI CHECKPARAMS

Which GoldenGate architecture feature ensures that committed transactions are applied in the correct order on the target system?

• A.  Checkpoint tables
• B.  Transaction sequencing in trail files
• C.  Supplemental logging
• D.  Integrated Replicat parallelism

What is the primary purpose of using macros in GoldenGate parameter files?

• A.  Improve Extract performance
• B.  Enable encryption
• C.  Reduce configuration duplication
• D.  Manage checkpoints