Question 13. 13. TCO 7 - In a ____ replicated database architecture, any changes

Question

Question 13.13. TCO 7 - In a ____ replicated database architecture, any changes made to any one of the databases are replicated to all other databases in the replication architectural structure. (Points : 3)        slave-to-slave
       slave-to-master
       master-to-slave
       master-to-master Question 14.14. TCO 7 - ____ statistics parameters generate system statistics essential to tuning. (Points : 3)        Object
       System
       Timed
       Tuning Question 15.15. TCO 7 - ____ is NOT an advisor available within the Advisor Central of the Database Control. (Points : 3)        Schema Advisor
       Segment Advisor
       Memory Advisor
       SQL Access Advisor Question 16.16. TCO 7 - The ____ utility can be used to join the trace activity of a single session, from multiple trace files, when using a shared server configuration. (Points : 3)        Autotrace
       TKPROF
       Trace
       TRCSESS Question 17.17. TCO 7 - The ____ option of the ANALYZE command calculates statistics for all rows and columns in an object, an object being a table or index. (Points : 3)        ESTIMATE
       SYSTEM
       CALCULATE
       COMPUTE Question 18.18. TCO 7 - When an SQL Access Advisor job that has been scheduled has completed executing, a status of ____ is indicated in the Database Control. (Points : 3)        COMPLETED
       FINISHED
       DONE
       ENDED Question 19.19. TCO 7 - Statistics can be gathered manually using a command-line tool such as SQL*Plus, with the ____ command or the DBMS_STATS package. (Points : 3)        OPTIMIZE
       ANALYZE
       STATSPACK
       TRCSESS Question 20.20. TCO 8 - Technically, a ____ is not a table, but a group of tables stored together as if they were one table. (Points : 3)        partition
       cluster
       nested table
       block Question 21.21. TCO 8 - The ____ set operator returns distinct rows from both queries. (Points : 3)        UNION ALL
       INTERSECT
       MINUS
       DISTINCT Question 22.22. TCO 8 - The ____ contains information about the table that has data in a particular data block. (Points : 3)        table directory
       common header
       variable header
       row directory Question 23.23. TCO 9 - The <database name> is usually stored as the ____ environment variable. (Points : 3)        ORACLE_DB
       ORACLE_NAME
       ORACLE_DNAME
       ORACLE_SID Question 24.24. TCO 9 - The ____ contains many of the memory buffer components for an up and running (online) Oracle instance. (Points : 3)        LDAP
       PGA
       SGA
       TNS Question 25.25. TCO 9 - To discover the name on a Unix or Linux machine, use the ____ command in a shell. (Points : 3)        ls
       ENV
       netmgr
       ps Question 13.13. TCO 7 - In a ____ replicated database architecture, any changes made to any one of the databases are replicated to all other databases in the replication architectural structure. (Points : 3)        slave-to-slave
       slave-to-master
       master-to-slave
       master-to-master

Explanation / Answer

Question 13.13. TCO 7 - In a ____ replicated database architecture, any changes made to any one of the databases are replicated to all other databases in the replication architectural structure. (Points : 3)
slave-to-slave
slave-to-master
master-to-slave
master-to-master

ANSWER:master-to-master

Question 14.14. TCO 7 - ____ statistics parameters generate system statistics essential to tuning. (Points : 3)   
Object
System
Timed
Tuning

ANSWER: Timed

Question 15.15. TCO 7 - ____ is NOT an advisor available within the Advisor Central of the Database Control. (Points : 3)
Schema Advisor
Segment Advisor
Memory Advisor
SQL Access Advisor

ANSWER:Schema Advisor

Question 16.16. TCO 7 - The ____ utility can be used to join the trace activity of a single session, from multiple trace files, when using a shared server configuration. (Points : 3)
Autotrace
TKPROF
Trace
TRCSESS

ANSWER: TRCSESS

Question 17.17. TCO 7 - The ____ option of the ANALYZE command calculates statistics for all rows and columns in an object, an object being a table or index. (Points : 3)   
ESTIMATE
SYSTEM
CALCULATE
COMPUTE

ANSWER:COMPUTE

Question 18.18. TCO 7 - When an SQL Access Advisor job that has been scheduled has completed executing, a status of ____ is indicated in the Database Control. (Points : 3)
COMPLETED
FINISHED
DONE
ENDED

ANSWER:COMPLETED

Question 19.19. TCO 7 - Statistics can be gathered manually using a command-line tool such as SQL*Plus, with the ____ command or the DBMS_STATS package. (Points : 3)
OPTIMIZE
ANALYZE
STATSPACK
TRCSESS

ANSWER:ANALYZE

Question 20.20. TCO 8 - Technically, a ____ is not a table, but a group of tables stored together as if they were one table. (Points : 3)
partition
cluster
nested table
block

ANSWER:Cluster

Question 21.21. TCO 8 - The ____ set operator returns distinct rows from both queries. (Points : 3)   
UNION ALL
INTERSECT
MINUS
DISTINCT

ANSWER:INTERSECT

Question 22.22. TCO 8 - The ____ contains information about the table that has data in a particular data block. (Points : 3)
table directory
common header
variable header
row directory

ANSWER: row directory

Question 23.23. TCO 9 - The <database name> is usually stored as the ____ environment variable. (Points : 3)
ORACLE_DB
ORACLE_NAME
ORACLE_DNAME
ORACLE_SID

ANSWER:ORACLE_SID

Question 24.24. TCO 9 - The ____ contains many of the memory buffer components for an up and running (online) Oracle instance. (Points : 3)   
LDAP
PGA
SGA
TNS

ANSWER:SGA

Question 25.25. TCO 9 - To discover the name on a Unix or Linux machine, use the ____ command in a shell. (Points : 3)
ls
ENV
netmgr
ps

ANSWER:ls

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.