Oracle 1Z0-931-20 問題集

質問 1：
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
A. VALIDATE_DIMENSION
B. VALIDATE_HIERARCHY
C. VALIDATE_MEASURES
D. VALIDATE_LEVELS
E. VALIDATE_ANALYTIC_VIEW
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?
A. The tablespace names will result in a blocking error during datapump import because of ADB limitations.
B. The migration can be a success, both technically and functional due to datapump enhancements.
C. The migration can be technically a success but the 3-rd party vendor needs to support the result.
D. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
正解：D

質問 3：
When exporting a notebook, what type of file is created?
A. ASCII
B. TXT
C. XML
D. JSON
E. SQL
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
A. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.
B. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
C. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
D. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
正解：A

質問 5：
Which two choices are true for Autonomous Data Warehouse (ADW)? (Choose two.)
A. Billing for compute stops when ADW is stopped
B. Billing stops only when the ADW is terminated
C. Billing stops for both CPU usage and storage usage when ADW is stopped
D. Billing for storage continues when ADW is stopped
正解：A,D

質問 6：
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
A. SQLDeveloper
B. OS command line from the database server.
C. OCI CLI
D. Admin page of the Cloud Service Console
正解：C

質問 7：
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
A. SQLNET.ORA
B. TNSNAMES.ORA
C. CWALLET.SSO
D. OJDBC.PROPERTIES
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
A. LOW
B. MEDIUM
C. HIGH
D. TPPERFORMANT
E. TPURGENT
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?
A. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
B. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
C. Data Sync can only load data from one source into one destination table.
D. Data Sync can not transform your data while loading it into the destination table.
正解：B
解説: (Topexam メンバーにのみ表示されます)