Oracle Database 12c Advanced Administration (1Z0-063)Full Practice Tests Total Questions: 230 – 4 Mock Exams
Practice Set 1
Time limit: 0
0 of 65 questions completed
Questions:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Information
Click on Start Test
You have already completed the Test before. Hence you can not start it again.
Test is loading...
You must sign in or sign up to start the Test.
You have to finish following quiz, to start this Test:
Your results are here!! for" Oracle Autonomous Database 2021 Specialist (1Z0-931-21) Practice Test 1 "
0 of 65 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
Oracle Autonomous Database 2021 Specialist (1Z0-931-21)
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking on “View Answers” option.
Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Answered
Review
Question 1 of 65
1. Question
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
Correct
Incorrect
Unattempted
Question 2 of 65
2. Question
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 3 of 65
3. Question
Which two cloud services are supported to import Data Pump files to Autonomou! Infrastructure? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 4 of 65
4. Question
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?
Correct
Incorrect
Unattempted
Question 5 of 65
5. Question
Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?
Correct
Incorrect
Unattempted
Question 6 of 65
6. Question
You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing License Included Shared Infrastructure Which parameter would you NOT use?
Correct
Incorrect
Unattempted
Question 7 of 65
7. Question
Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure?
Correct
Incorrect
Unattempted
Question 8 of 65
8. Question
Which native data type is used to store spatial information?
Correct
Incorrect
Unattempted
Question 9 of 65
9. Question
Which two statements are true about Data Insights? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 10 of 65
10. Question
Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
Correct
Incorrect
Unattempted
Question 11 of 65
11. Question
How do you change the tablespace quota for user mrizo on Autonomous Database on Shared Infrastructure?
Correct
Incorrect
Unattempted
Question 12 of 65
12. Question
Your customer has upgraded their on-premises 11.2 Database to 12.2. Dui database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?
Correct
Incorrect
Unattempted
Question 13 of 65
13. Question
Which method will NOT permit you to change the database apsrn user‘s password of an Oracle Autonomous Database on Shared Infrastructure?
Correct
Incorrect
Unattempted
Question 14 of 65
14. Question
Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 15 of 65
15. Question
Which stage of the indexing pipeline divides text into tokens?
Correct
Incorrect
Unattempted
Question 16 of 65
16. Question
An Autonomous Database (ADB) user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing ADB. Other than changing the shared user password, what can an administrator do to protect the instance?
Correct
Incorrect
Unattempted
Question 17 of 65
17. Question
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python?
Correct
Incorrect
Unattempted
Question 18 of 65
18. Question
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
Correct
Incorrect
Unattempted
Question 19 of 65
19. Question
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
Correct
Incorrect
Unattempted
Question 20 of 65
20. Question
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 Autonomous Database‘s Data Tools. Which steps do you need to perform?
Correct
Incorrect
Unattempted
Question 21 of 65
21. Question
Which two statements are true about accessing Autonomous Database Tools? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 22 of 65
22. Question
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?
Correct
Incorrect
Unattempted
Question 23 of 65
23. Question
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups
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?
Which two options are available to restore an Oracle Autonomous Database? (Choose all correct answers)
Correct
The correct options to restore an Oracle Autonomous Database are:
Specify the point in time (timestamp) to restore. This allows you to restore the database to a specific point in time, recovering data that may have been lost or corrupted.
Select the backup from which restore needs to be done. You can choose the specific backup that contains the data you want to restore.
The other options are not available for restoring an Oracle Autonomous Database:
Specify the archived custom image. Autonomous Databases are managed services and do not require custom images for restoration.
Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Autonomous Databases are managed by Oracle and do not require manual backup using RMAN.
Select the snapshot of the backup. Autonomous Databases do not use snapshots for backups.
Incorrect
The correct options to restore an Oracle Autonomous Database are:
Specify the point in time (timestamp) to restore. This allows you to restore the database to a specific point in time, recovering data that may have been lost or corrupted.
Select the backup from which restore needs to be done. You can choose the specific backup that contains the data you want to restore.
The other options are not available for restoring an Oracle Autonomous Database:
Specify the archived custom image. Autonomous Databases are managed services and do not require custom images for restoration.
Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Autonomous Databases are managed by Oracle and do not require manual backup using RMAN.
Select the snapshot of the backup. Autonomous Databases do not use snapshots for backups.
Unattempted
The correct options to restore an Oracle Autonomous Database are:
Specify the point in time (timestamp) to restore. This allows you to restore the database to a specific point in time, recovering data that may have been lost or corrupted.
Select the backup from which restore needs to be done. You can choose the specific backup that contains the data you want to restore.
The other options are not available for restoring an Oracle Autonomous Database:
Specify the archived custom image. Autonomous Databases are managed services and do not require custom images for restoration.
Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Autonomous Databases are managed by Oracle and do not require manual backup using RMAN.
Select the snapshot of the backup. Autonomous Databases do not use snapshots for backups.
Question 29 of 65
29. Question
Which statement is FALSE about Oracle Autonomous JSON Database?
Correct
The FALSE statement about Oracle Autonomous JSON Database is:
There is a 20 GB limit on JSON collections.
This is incorrect. Oracle Autonomous JSON Database does not have a 20 GB limit on JSON collections. It can handle JSON collections of any size, making it suitable for large-scale applications.
Here are the other statements, which are true:
JSON data is stored natively in the database. This means that JSON data is stored in a format that is optimized for performance and scalability.
You can promote Autonomous JSON Database to Autonomous Transaction Processing. This allows you to convert a JSON database into a traditional relational database if needed.
It supports NoSQt-style, document-centric applications. Autonomous JSON Database is designed to support applications that store and manage data in a document-oriented format.
Incorrect
The FALSE statement about Oracle Autonomous JSON Database is:
There is a 20 GB limit on JSON collections.
This is incorrect. Oracle Autonomous JSON Database does not have a 20 GB limit on JSON collections. It can handle JSON collections of any size, making it suitable for large-scale applications.
Here are the other statements, which are true:
JSON data is stored natively in the database. This means that JSON data is stored in a format that is optimized for performance and scalability.
You can promote Autonomous JSON Database to Autonomous Transaction Processing. This allows you to convert a JSON database into a traditional relational database if needed.
It supports NoSQt-style, document-centric applications. Autonomous JSON Database is designed to support applications that store and manage data in a document-oriented format.
Unattempted
The FALSE statement about Oracle Autonomous JSON Database is:
There is a 20 GB limit on JSON collections.
This is incorrect. Oracle Autonomous JSON Database does not have a 20 GB limit on JSON collections. It can handle JSON collections of any size, making it suitable for large-scale applications.
Here are the other statements, which are true:
JSON data is stored natively in the database. This means that JSON data is stored in a format that is optimized for performance and scalability.
You can promote Autonomous JSON Database to Autonomous Transaction Processing. This allows you to convert a JSON database into a traditional relational database if needed.
It supports NoSQt-style, document-centric applications. Autonomous JSON Database is designed to support applications that store and manage data in a document-oriented format.
Question 30 of 65
30. Question
Which three options are available to access data in an Autonomous JSON Database?
Correct
Correct Options:
A. Oracle Cloud Infrastructure console using the JSON Online Developer tool: This is a convenient way to interact with JSON data directly within the OCI console.
B. Regular Oracle SQL statements using a connection through the listener: Autonomous JSON Database supports standard SQL queries to access and manipulate JSON data.
C. REST API calls to the database (not enabled by default): While REST API access isn’t enabled by default, it can be configured to provide programmatic access to the database.
Incorrect Options:
D. Oracle JSON Developer tool downloaded from OTN: There is no specific “Oracle JSON Developer tool” available for download from OTN.
E. NoSQL statements using Oracle SODA drivers: While SODA is a powerful tool for NoSQL data access in Oracle Database, it’s not directly applicable to Autonomous JSON Database, which is primarily designed for JSON data.
Incorrect
Correct Options:
A. Oracle Cloud Infrastructure console using the JSON Online Developer tool: This is a convenient way to interact with JSON data directly within the OCI console.
B. Regular Oracle SQL statements using a connection through the listener: Autonomous JSON Database supports standard SQL queries to access and manipulate JSON data.
C. REST API calls to the database (not enabled by default): While REST API access isn’t enabled by default, it can be configured to provide programmatic access to the database.
Incorrect Options:
D. Oracle JSON Developer tool downloaded from OTN: There is no specific “Oracle JSON Developer tool” available for download from OTN.
E. NoSQL statements using Oracle SODA drivers: While SODA is a powerful tool for NoSQL data access in Oracle Database, it’s not directly applicable to Autonomous JSON Database, which is primarily designed for JSON data.
Unattempted
Correct Options:
A. Oracle Cloud Infrastructure console using the JSON Online Developer tool: This is a convenient way to interact with JSON data directly within the OCI console.
B. Regular Oracle SQL statements using a connection through the listener: Autonomous JSON Database supports standard SQL queries to access and manipulate JSON data.
C. REST API calls to the database (not enabled by default): While REST API access isn’t enabled by default, it can be configured to provide programmatic access to the database.
Incorrect Options:
D. Oracle JSON Developer tool downloaded from OTN: There is no specific “Oracle JSON Developer tool” available for download from OTN.
E. NoSQL statements using Oracle SODA drivers: While SODA is a powerful tool for NoSQL data access in Oracle Database, it’s not directly applicable to Autonomous JSON Database, which is primarily designed for JSON data.
Question 31 of 65
31. Question
What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose all correct answers)
Correct
The two correct answers are:
Users have more control over the maintenance schedule.
to offers greater control and Isolation starting at the Exadata cloud infrastructure level.
Oracle Autonomous Database on Dedicated Infrastructure provides users with more control over the maintenance schedule compared to the Autonomous Database on Shared Infrastructure. This allows for more flexibility in planning maintenance activities to minimize disruption to critical applications.
Additionally, Autonomous Database on Dedicated Infrastructure offers greater control and isolation at the Exadata cloud infrastructure level, providing organizations with more flexibility and customization options to meet their specific needs.
Incorrect
The two correct answers are:
Users have more control over the maintenance schedule.
to offers greater control and Isolation starting at the Exadata cloud infrastructure level.
Oracle Autonomous Database on Dedicated Infrastructure provides users with more control over the maintenance schedule compared to the Autonomous Database on Shared Infrastructure. This allows for more flexibility in planning maintenance activities to minimize disruption to critical applications.
Additionally, Autonomous Database on Dedicated Infrastructure offers greater control and isolation at the Exadata cloud infrastructure level, providing organizations with more flexibility and customization options to meet their specific needs.
Unattempted
The two correct answers are:
Users have more control over the maintenance schedule.
to offers greater control and Isolation starting at the Exadata cloud infrastructure level.
Oracle Autonomous Database on Dedicated Infrastructure provides users with more control over the maintenance schedule compared to the Autonomous Database on Shared Infrastructure. This allows for more flexibility in planning maintenance activities to minimize disruption to critical applications.
Additionally, Autonomous Database on Dedicated Infrastructure offers greater control and isolation at the Exadata cloud infrastructure level, providing organizations with more flexibility and customization options to meet their specific needs.
Question 32 of 65
32. Question
Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose all correct answers)
Correct
The correct answers are:
Routinely tune your alarms. This is crucial to ensure that alarms are relevant and effective over time. As your database usage patterns change, you may need to adjust alarm thresholds and intervals.
Select the correct alarm interval for your metric. Choosing the right interval is essential for timely alerts. A shorter interval might be suitable for critical metrics, while a longer interval might be appropriate for less critical ones.
Create multiple alarm metrics. Monitoring multiple metrics provides a comprehensive view of your database’s health. By tracking various metrics, you can identify potential issues early on.
Here’s why the other options are incorrect:
Create a single alarm for each metric. This can lead to alert fatigue and make it difficult to identify the most critical issues. It’s better to create multiple alarms per metric with different severity levels and thresholds.
Use a single interval for all alarms. Different metrics require different intervals. A one-size-fits-all approach can lead to missed alerts or unnecessary noise.
Suppress alarms during investigations. While it might be tempting to suppress alarms temporarily, it can lead to missed issues. It’s better to use more granular filtering and notification mechanisms to avoid alert fatigue.
Incorrect
The correct answers are:
Routinely tune your alarms. This is crucial to ensure that alarms are relevant and effective over time. As your database usage patterns change, you may need to adjust alarm thresholds and intervals.
Select the correct alarm interval for your metric. Choosing the right interval is essential for timely alerts. A shorter interval might be suitable for critical metrics, while a longer interval might be appropriate for less critical ones.
Create multiple alarm metrics. Monitoring multiple metrics provides a comprehensive view of your database’s health. By tracking various metrics, you can identify potential issues early on.
Here’s why the other options are incorrect:
Create a single alarm for each metric. This can lead to alert fatigue and make it difficult to identify the most critical issues. It’s better to create multiple alarms per metric with different severity levels and thresholds.
Use a single interval for all alarms. Different metrics require different intervals. A one-size-fits-all approach can lead to missed alerts or unnecessary noise.
Suppress alarms during investigations. While it might be tempting to suppress alarms temporarily, it can lead to missed issues. It’s better to use more granular filtering and notification mechanisms to avoid alert fatigue.
Unattempted
The correct answers are:
Routinely tune your alarms. This is crucial to ensure that alarms are relevant and effective over time. As your database usage patterns change, you may need to adjust alarm thresholds and intervals.
Select the correct alarm interval for your metric. Choosing the right interval is essential for timely alerts. A shorter interval might be suitable for critical metrics, while a longer interval might be appropriate for less critical ones.
Create multiple alarm metrics. Monitoring multiple metrics provides a comprehensive view of your database’s health. By tracking various metrics, you can identify potential issues early on.
Here’s why the other options are incorrect:
Create a single alarm for each metric. This can lead to alert fatigue and make it difficult to identify the most critical issues. It’s better to create multiple alarms per metric with different severity levels and thresholds.
Use a single interval for all alarms. Different metrics require different intervals. A one-size-fits-all approach can lead to missed alerts or unnecessary noise.
Suppress alarms during investigations. While it might be tempting to suppress alarms temporarily, it can lead to missed issues. It’s better to use more granular filtering and notification mechanisms to avoid alert fatigue.
Question 33 of 65
33. Question
Which three are use cases for Graph Studio? (Choose all correct answers)
Correct
Here are the three use cases for Graph Studio:
Pattern Matching: Graph Studio is excellent for identifying complex patterns within large datasets.
Churn Analysis: It can help visualize customer relationships and predict potential churn by analyzing their behavior patterns.
Fraud Detection: By analyzing networks of transactions and relationships, Graph Studio can identify anomalies and potential fraudulent activities.
The other options, clustering, facial recognition, and 3-D modeling, are not typically associated with Graph Studio’s primary use cases.
Incorrect
Here are the three use cases for Graph Studio:
Pattern Matching: Graph Studio is excellent for identifying complex patterns within large datasets.
Churn Analysis: It can help visualize customer relationships and predict potential churn by analyzing their behavior patterns.
Fraud Detection: By analyzing networks of transactions and relationships, Graph Studio can identify anomalies and potential fraudulent activities.
The other options, clustering, facial recognition, and 3-D modeling, are not typically associated with Graph Studio’s primary use cases.
Unattempted
Here are the three use cases for Graph Studio:
Pattern Matching: Graph Studio is excellent for identifying complex patterns within large datasets.
Churn Analysis: It can help visualize customer relationships and predict potential churn by analyzing their behavior patterns.
Fraud Detection: By analyzing networks of transactions and relationships, Graph Studio can identify anomalies and potential fraudulent activities.
The other options, clustering, facial recognition, and 3-D modeling, are not typically associated with Graph Studio’s primary use cases.
Question 34 of 65
34. Question
Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 35 of 65
35. Question
Which three event types are supported for Autonomous Database? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 36 of 65
36. Question
You have a requirement to create an Autonomous Transaction Processing database that can support up. to 300 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to?
Correct
Incorrect
Unattempted
Question 37 of 65
37. Question
Which two actions are available to perform when an Autonomous Database is stopped? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 38 of 65
38. Question
When cloning from a backup, what is the earliest timestamp of the backup allowed?
Correct
Incorrect
Unattempted
Question 39 of 65
39. Question
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
Correct
Incorrect
Unattempted
Question 40 of 65
40. Question
Which three tools can be used to monitor the usage and activities of Autonomous Database on Infrastructure? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 41 of 65
41. Question
Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to see the effect that changing an object has on other objects?
Correct
Incorrect
Unattempted
Question 42 of 65
42. Question
Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 43 of 65
43. Question
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 44 of 65
44. Question
In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?
Correct
Incorrect
Unattempted
Question 45 of 65
45. Question
Autonomous Database‘s auto scaling feature allows your databa base number of OCPU cores at any time. As demand increases, auto number of cores in use. Likewise, as demand drops, auto scaling automatically cores in use. Which statement is FALSE regarding the auto scaling feature?
Correct
Incorrect
Unattempted
Question 46 of 65
46. Question
During the provisioning of an Autonomous Database on dedicated hardware, what does the database administrator need to select to determine where the Autonomous Database is created on the dedicated infrastructure?
Correct
Incorrect
Unattempted
Question 47 of 65
47. Question
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
Correct
Incorrect
Unattempted
Question 48 of 65
48. Question
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?
Correct
Incorrect
Unattempted
Question 49 of 65
49. Question
Which is NOT needed to manage Oracle Autonomous Database with REST APIs?
Correct
Incorrect
Unattempted
Question 50 of 65
50. Question
You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub. What does it indicate?
Correct
Incorrect
Unattempted
Question 51 of 65
51. Question
Which statement is correct about the Service console in an Autonomous Database?
Correct
Incorrect
Unattempted
Question 52 of 65
52. Question
Which three options do NOT change when enabling auto scaling? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 53 of 65
53. Question
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
Correct
Incorrect
Unattempted
Question 54 of 65
54. Question
Which three advanced options can you enable or disable while creating a business model? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 55 of 65
55. Question
You have been tasked with analyzing a year‘s worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?
Correct
Incorrect
Unattempted
Question 56 of 65
56. Question
What happens with the standby database when disabling Autonomous Data Guard?
Correct
Incorrect
Unattempted
Question 57 of 65
57. Question
Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped. Which statement is true?
Correct
Incorrect
Unattempted
Question 58 of 65
58. Question
Which statement is FALSE about setting up compartment quotas?
Correct
Incorrect
Unattempted
Question 59 of 65
59. Question
Which statement is FALSE about Oracle Data Safe?
Correct
Incorrect
Unattempted
Question 60 of 65
60. Question
Which option should you use to create a graph with Graph Studio?
Correct
Incorrect
Unattempted
Question 61 of 65
61. Question
Which two of the following statements are correct? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 62 of 65
62. Question
Which four file formats are supported when loading data from Cloud Storage? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 63 of 65
63. Question
In which four ways can Oracle Database optimally access data in Object Storage? (Choose all correct answers)
Correct
Incorrect
Unattempted
Question 64 of 65
64. Question
Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?
Correct
Incorrect
Unattempted
Question 65 of 65
65. Question
Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose all correct answers)
Correct
Incorrect
Unattempted
X
Use Page numbers below to navigate to other practice tests
