New 2021 Latest Questions 1Z0-931-20 Dumps - Use Updated Oracle Exam
Latest 1Z0-931-20 Exam Dumps Oracle Exam from Training Expert VCEEngine
NEW QUESTION 59
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- B. It is enabled by default.
- C. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
- D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- E. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
Answer: D
NEW QUESTION 60
Which operating system can Data Visualization Desktop be run on?
- A. AIX
- B. Solaris
- C. Linux
- D. Windows
Answer: D
Explanation:
NEW QUESTION 61
Which statement about the Export Wizard used to export database objects and data is NOT correct?
- A. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.
- B. Export DDL includes features such as "Show schema," "Storage," and "Terminator."
- C. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
- D. If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema.
Answer: D
Explanation:
https://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm
https://www.thatjeffsmith.com/archive/2012/06/copying-columns-from-grid-to-clipboard-in-sql-developer/
NEW QUESTION 62
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
- A. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
- B. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
- C. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
- D. In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
Answer: D
Explanation:
NEW QUESTION 63
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are exported?
- A. Reports
- B. Data
- C. Tablespaces
- D. Schemas
Answer: B,D
NEW QUESTION 64
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
- B. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- E. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
Answer: A,B,D
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION 65
Which two methods can you use to create users and grant roles in Autonomous Database services?
(Choose two.)
- A. through the Oracle Cloud Infrastructure service console
- B. through SQL/Developer s
- C. using DBMS_CLOUD_ADMIN package
- D. through SQLPIus
Answer: B,D
Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
NEW QUESTION 66
When exporting a notebook, what type of file is created?
- A. ASCII
- B. SQL
- C. JSON
- D. TXT
- E. XML
Answer: C
Explanation:
Export a Notebook
You can export a notebook as a .json (JavaScript Object Notation) file, and later import it in to the same or a different environment.
To export a notebook:
- In the Notebooks page, click the notebook that you want to export. The notebook opens in the notebook editor.
- In the top panel of the notebook editor, click export. The notebook is saved to your local folder as a .json file.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks-data-analysis-and-data-visualization.html#GUID-009B9073-4B45-4505-8DAD-F1F04FD3E160
NEW QUESTION 67
You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 days. Which database backup strategy would you select?
- A. Use the automated backups.
- B. Take monthly manual backups to supplement the automated backups and preserve them for 12 months.
- C. Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.
- D. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.
Answer: D
NEW QUESTION 68
Which statement is correct about the version of Java that is recommended for use with tools that use Java Database Connectivity (JDBC) connections?
- A. Java Development Kit Version 7
- B. JDBC drivers do NOT support multiple Java Developer Kit versions.
- C. JDBC .Jar files are specific to each platform.
- D. Java Development Kit Version 8 or higher
- E. It doesn't matter, but you must Install the JCE Unlimited Strength Policy Files.
Answer: C
NEW QUESTION 69
You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application.
Which two are true when deciding the number of sessions for each application? (Choose two.)
- A. The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements
- B. The HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each
- C. The HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements
- D. The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group has 0 SQL statements
- E. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has
0 SQL statements
Answer: D,E
NEW QUESTION 70
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
- A. You have direct access to the database node.
- B. Oracle Database Result Cache is enabled by default for all SQL statements.
- C. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
- D. Parallelism is not enabled by default.
Answer: C,D
NEW QUESTION 71
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 72
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
- A. Tools are no longer able to connect to a stopped instance.
- B. CPU billing is halted based on full-hour cycles of usage.
- C. In-flight transactions and queries are stopped.
- D. User with DWROLE can still access the database.
Answer: A,B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9
NEW QUESTION 73
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
- B. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- C. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- D. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- E. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
Answer: D,E
NEW QUESTION 74
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Reports
- B. Data
- C. Tablespaces
- D. Schemas
Answer: B,D
NEW QUESTION 75
......
Updated Test Engine to Practice 1Z0-931-20 Dumps & Practice Exam: https://www.vceengine.com/1Z0-931-20-vce-test-engine.html
