Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-931-23

Free Oracle 1Z0-931-23 Exam Braindumps (page: 2)

Page 2 of 44
PDF with 181 Questions

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.

What steps do you need to take?

  1. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
  2. Create a database user with the default privileges.
  3. Create a database user with connect, resource, and object privileges.
  4. Create an IDCS user. Create a database user with connect, resource, and object privileges.

Answer(s): A

Explanation:

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database- actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586

To enable a user to access SQL Developer Web, you need to create a database user with the appropriate privileges, enable the schema for SQL Developer Web, and provide the user with the modified URL that includes the schema name. See Enabling Users to Access SQL Developer Web for more details.



What is the correct way to list all files in the default data pump directory?

  1. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
  2. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
  3. Log onto ADW server and issue is -al on the command line.
  4. By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;

Answer(s): A

Explanation:

To list all files in the default data pump directory, you can use the DBMS_CLOUD.LIST_FILES procedure with the directory name as the parameter. See Listing Files in a Directory for more details.



What REST verb is used to create an Autonomous Database service using REST APIs?

  1. An "INSERT" REST call
  2. A "GET" REST call
  3. A "POST" REST call
  4. A "PUT" REST call

Answer(s): C

Explanation:

https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html

To create an Autonomous Database service using REST APIs, you need to use a POST method with the appropriate request body. See Create Autonomous Database for more details.



When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

  1. Data
  2. Schemas
  3. Tablespaces
  4. Reports

Answer(s): A,B

Explanation:

When using Data Pump to migrate your Oracle database to Autonomous Database, you can import data and schemas from Data Pump files. You cannot import tablespaces or reports. See Export Your Existing Oracle Database to Import into Autonomous Database for more details.






Post your Comments and Discuss Oracle 1Z0-931-23 exam prep with other Community members:

1Z0-931-23 Exam Discussions & Posts