A104 dumps Part1

    1. Your company has an azure subscription that includes a storage account, a resource group, a blob container and a file share. 

A colleague named Jon Ross makes use of a solitary Azure Resource Manager (ARM) template to deploy a virtual machine and an additional Azure Storage account. You want to review the ARM template that was used by Jon Ross. 

Solution: You access the Resource Group blade. Does the solution meet the goal?

Answer : Yes

 2 .  A colleague named Jon Ross makes use of a solitary Azure Resource Manager (ARM) template to deploy a virtual machine and an additional Azure Storage account. 

You want to review the ARM template that was used by Jon Ross. 

Solution: You access the Container blade. Does the solution meet the goal?

Answer : No

Reference:https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-manager-export-template

3 .  Your company has three virtual machines (VMs) that are included in an availability set. You try to resize one of the VMs, which returns an allocation failure message. It is imperative that the VM is resized. Which of the following actions should you take?

 A. You should only stop one of the VMs. 

B. You should stop two of the VMs. 

C. You should stop all three VMs. 

D. You should remove the necessary VM from the availability set.

4. You have an Azure virtual machine (VM) that has a single data disk. You have been tasked with attaching this data disk to another Azure VM. You need to make sure that your strategy allows for the virtual machines to be offline for the least amount of time possible. Which of the following is the action you should take FIRST? 

A. Stop the VM that includes the data disk.

 B. Stop the VM that the data disk must be attached to.

 C. Detach the data disk. 

D. Delete the VM that includes the data disk.

5.Your company has an Azure subscription. You need to deploy a number of Azure virtual machines (VMs) using Azure Resource Manager (ARM) templates. You have been informed that the VMs will be included in a single availability set. You are required to make sure that the ARM template you configure allows for as many VMs as possible to remain accessible in the event of fabric failure or maintenance. Which of the following is the value that you should configure for the platformFaultDomainCount property? 

A. 10 

B. 30 

C. Min Value 

D. Max Value

6.Your company has an Azure subscription. You need to deploy a number of Azure virtual machines (VMs) using Azure Resource Manager (ARM) templates. You have been informed that the VMs will be included in a single availability set. 

You are required to make sure that the ARM template you configure allows for as many VMs as possible to remain accessible in the event of fabric failure or maintenance. Which of the following is the value that you should configure for the platformUpdateDomainCount property  ?

A. 10 

B. 20 

C. 30 

D. 40

7.Your company has an Azure Active Directory (Azure AD) tenant that is configured for hybrid coexistence with the on-premises Active Directory domain. The on-premise virtual environment consists of virtual machines (VMs) running on Windows Server 2012 R2 HyperV host servers. You have created some PowerShell scripts to automate the configuration of newly created VMs. You plan to create several new VMs. You need a solution that ensures the scripts are run on the new VMs. Which of the following is the best solution? 

A. Configure a SetupComplete.cmd batch file in the %windir%\setup\scripts directory. 

B. Configure a Group Policy Object (GPO) to run the scripts as logon scripts. 

C. Configure a Group Policy Object (GPO) to run the scripts as startup scripts.

 D. Place the scripts in a new virtual hard disk (VHD).

8.Your company has an Azure Active Directory (Azure AD) tenant that is configured for hybrid coexistence with the on-premises Active Directory domain. You plan to deploy several new virtual machines (VMs) in Azure. The VMs will have the same operating system and custom software requirements. You configure a reference VM in the on-premise virtual environment. You then generalize the VM to create an image. You need to upload the image to Azure to ensure that it is available for selection when you create the new Azure VMs. Which PowerShell cmdlets should you use?

 A. Add-AzVM 

B. Add-AzVhd 

C. Add-AzImage 

D. Add-AzImageDataDisk

9.Your company's Azure subscription includes two Azure networks named VirtualNetworkA and VirtualNetworkB. VirtualNetworkA includes a VPN gateway that is configured to make use of static routing. Also, a site-to-site VPN connection exists between your company's on- premises network and VirtualNetworkA. 

You have configured a point-to-site VPN connection to VirtualNetworkA from a workstation running Windows 10. After configuring virtual network peering between VirtualNetworkA and VirtualNetworkB, you confirm that you are able to access VirtualNetworkB from the company's on-premises network. However, you find that you cannot establish a connection to VirtualNetworkB from the Windows 10 workstation. 

You have to make sure that a connection to VirtualNetworkB can be established from the Windows 10 workstation. Solution: You choose the Allow gateway transit setting on VirtualNetworkA. 

Does the solution meet the goal?

A. Yes

B. NO

10. Your company's Azure subscription includes two Azure networks named VirtualNetworkA and VirtualNetworkB. VirtualNetworkA includes a VPN gateway that is configured to make use of static routing. Also, a site-to-site VPN connection exists between your company's on- premises network and VirtualNetworkA. 

You have configured a point-to-site VPN connection to VirtualNetworkA from a workstation running Windows 10. After configuring virtual network peering between VirtualNetworkA and VirtualNetworkB, you confirm that you are able to access VirtualNetworkB from the company's on-premises network. However, you find that you cannot establish a connection to VirtualNetworkB from the Windows 10 workstation. 

You have to make sure that a connection to VirtualNetworkB can be established from the Windows 10 workstation. Solution: You choose the Allow gateway transit setting on VirtualNetworkB. Does the solution meet the goal?

A. Yes

B. No

11.Your company's Azure subscription includes two Azure networks named VirtualNetworkA and VirtualNetworkB. VirtualNetworkA includes a VPN gateway that is configured to make use of static routing. Also, a site-to-site VPN connection exists between your company's on- premises network and VirtualNetworkA. You have configured a point-to-site VPN connection to VirtualNetworkA from a workstation running Windows 10. After configuring virtual network peering between VirtualNetworkA and VirtualNetworkB, you confirm that you are able to access VirtualNetworkB from the company's on-premises network. However, you find that you cannot establish a connection to VirtualNetworkB from the Windows 10 workstation. 

You have to make sure that a connection to VirtualNetworkB can be established from the Windows 10 workstation. Solution: You download and re-install the VPN client configuration package on the Windows 10 workstation.

 Does the solution meet the goal?

A. yes

b. NO

12. Your company has virtual machines (VMs) hosted in Microsoft Azure. The VMs are located in a single Azure virtual network named VNet1. The company has users that work remotely. The remote workers require access to the VMs on VNet1. You need to provide access for the remote workers. What should you do? 

A. Configure a Site-to-Site (S2S) VPN.

 B. Configure a VNet-toVNet VPN. 

C. Configure a Point-to-Site (P2S) VPN. 

D. Configure DirectAccess on a Windows Server 2012 server VM.

 E. Configure a Multi-Site VPN

13.Your company has a Microsoft SQL Server Always On availability group configured on their Azure virtual machines (VMs). You need to configure an Azure internal load balancer as a listener for the availability group. Solution: You create an HTTP health probe on port 1433. Does the solution meet the goal?

A. Yes

B. No

14.Your company has a Microsoft SQL Server Always On availability group configured on their Azure virtual machines (VMs). You need to configure an Azure internal load balancer as a listener for the availability group. Solution: You set Session persistence to Client IP. Does the solution meet the goal? A. Yes

B. NO

15. Your company has a Microsoft SQL Server Always On availability group configured on their Azure virtual machines (VMs). You need to configure an Azure internal load balancer as a listener for the availability group. 

Solution: You enable Floating IP. 

Does the solution meet the goal?

A. Yes

B. NO

16. Your company has two on-premises servers named SRV01 and SRV02. Developers have created an application that runs on SRV01. The application calls a service on SRV02 by IP address. You plan to migrate the application on Azure virtual machines (VMs). You have configured two VMs on a single subnet in an Azure virtual network. You need to configure the two VMs with static internal IP addresses. What should you do? 

A. Run the New-AzureRMVMConfig PowerShell cmdlet. 

B. Run the Set-AzureSubnet PowerShell cmdlet.

 C. Modify the VM properties in the Azure Management Portal. 

D. Modify the IP properties in Windows Network and Sharing Center.

 E. Run the Set-AzureStaticVNetIP PowerShell cmdlet.

17.Your company has an Azure Active Directory (Azure AD) subscription. You need to deploy five virtual machines (VMs) to your company's virtual network subnet. The VMs will each have both a public and private IP address. Inbound and outbound security rules for all of these virtual machines must be identical. Which of the following is the least amount of network interfaces needed for this configuration? 

A. 5

B. 10

C.20.

d. 40

xml. Do you need to install a parser library?

 

                             Pyhton error

---------------------------------------------------------------------------
FeatureNotFound                           Traceback (most recent call last)
Cell In[5], line 1
----> 1 soup=BeautifulSoup(webpage,'xml')

File D:\Lib\site-packages\bs4\__init__.py:250, in BeautifulSoup.__init__(self, markup, features, builder, parse_only, from_encoding, exclude_encodings, element_classes, **kwargs)
    248     builder_class = builder_registry.lookup(*features)
    249     if builder_class is None:
--> 250         raise FeatureNotFound(
    251             "Couldn't find a tree builder with the features you "
    252             "requested: %s. Do you need to install a parser library?"
    253             % ",".join(features))
    255 # At this point either we have a TreeBuilder instance in
    256 # builder, or we have a builder_class that we can instantiate
    257 # with the remaining **kwargs.
    258 if builder is None:

FeatureNotFound: Couldn't find a tree builder with the features you requested: xml. Do you need to install a parser library?

solution:-

AI 900 exam question - Part 2

                                           scan from scanner to read article.

31)  which service should you use to extract text , key/Value pairs and table data automatically from scanned documents?

   a) Form recognizer 

   b) Text Analytics

   c) Language Understanding

   d) Custom vision

32 )You want to use computer vision service to identify the location of individual items in an image. Which of following feature should you retrieve ?

   a)object

   b)Tags

   c)Categories

34 ) You want use the computer vision service to analyse image and to use language service to analyse text.It is a must requirement that developer only use one key and endpoints to access all of your services, What kind recourses should you create in your azure subscription ?

   a)Computer vision

   b)Cognitive services

    c)Custom vision

35 )You use a azure Machine Learning designer pipeline to train and test a binary test a binary classification model.You review the model's performance metrics in an evaluate model module and note that it has AUC score of 0.3. what can you conclude about the model ?

   a)The model can explain 30% of variance between true and predicated labels.

   b) The model predicates accurately for 70% of test cases

  c) The model performs worse than random guessing.

Note :The ROC AUC score can range from 0 to 1.

A score of 0.5 indicates random guessing,

score of 1 indicates perfect performance.

A score slightly above 0.5 shows that a model has at least "some" (albeit small) predictive power. This is generally inadequate for any real applications.

above 0.8 is considered good,

score above 0.9 is considered great. 

36) You use Azure Machine Learning designer to create a training pipeline for classification model. What must you do before deploying the model as a service ? a) Create an interface pipeline from the training pipeline b) Add an Evaluate Model module to training pipeline c) Clone the training pipeline with a different name

37) You are using Azure Machine Learning designer to create training pipeline for binary classification model.you have added dataset contain feature and labels, a two class decision forest module and train module.you plan to use Score Model and Evaluate Model modules to test the trained model with subset of dataset that was not used for training. what is another module should you add ? a) join data b) Split data c) Select column in dataset

38)The ability to extract subtotal and total from receipt is a capability of the A)custom vision b)Form recognizer c)Ink Recognizer d) Test Analytics

39)You are building a tool that will process images from retail store and identify the products of competitors.The solution will use a custome model.which azure cognitive service should you use ? a)custom vision b)form recognizer c)face d)Computer vision

40)When you design an AI system to assess wheather lonas should be approved, ha factor used to make the decision should be explinable. This is an example of which Microsoft guiding principle for Repsponsible AI ? a)transparency b)inclusiveness c)Fairness d)Private an security

AI 900 exam question - Part 1

scan above image read this article.

Like page and share link to others

1) Which AI Service should you use to create a bot from a frequently asked question (FAQ) document ?
a) Qna Maker
b) Language understanding (LUIS)
c) Test Analysis
d) Speech text


2) You build machine learning model by using automated machine learning user interface (UI). you need to ensure thta model meet the microsoft transparency principle for responsible AI what should you do ?
a) Set vaildation type to Auto.
b) Enable Explain best model
c) Set Primary metic to accurency.

3)Which scenario is an example of webchart bot?
a) Determine whether review entered on website for concert are positive or negative, and then add thumbs up or thumps down emoji to reviews. b) Translate into English questions entered by customer at koisk so that appropriate person can call the customer back.
c) Accept questions through email , and then route the email messages to correct person based on content messages.
d) From Website interface , answer common question about scheduled events and ticket purchases for music festival.

4) For machine Learning Process , how should you spilt data for training and evaluation ?
a) Use features for training and Labesl for evalution.
b) Randomly split the data into rows for trainig and rows for evalution.
c) Use labels for training and features for evolution.
d) Randomly split the data into column for training and columns for evaluations.


5)Which of following is calculated probity of correct image classification

A)Accuracy
b)Confidence
c) Root Mean Square Error.
d) Sentiment

6)Ensuring AI system dows not provide a prediction when important fields conation unusual or missing values is *** principle for responsible AI.
a) an inclusiveness
b) a privacy and security
c) a reliability and safety
d) a transparency


7) Ensuring that numeric variable in variable data are on similar scale is example of *** **

a) Data ingestion
b) Feature engineering
c) Feature selection
d) Model training

8) You want to create a model to predict sales of ice cream based on historic data that includes daily ice cream sales total and weather measurement. what Azure service should you use ?
a) Azure Machine Learning
b) Azure Bot.
c) Language

9) The interactive answering of question entered by user as part an application is an example of
a)anomaly detection
b) computer vision
c)conversation AI
d)forecasting

10)You are designing an AI Application that uses images to detect creks in windows-panes of building and warns when windows pane should be repaired or replaced. What AI workload is described ?
a)Computer Vision
b) Natural Language Processing.
c) Anomaly Detection

13 >Match the column
Regression          Predict How many minutes a late flight will arrive based on the amount of snowfall at an airport
clustering        Segment customer into different group to support a marketing department
Classification      Predict wheatear a student will complete a university course

14) A Predictive app provide audio output for visually impaired used.which principle of Responsible AI is reflected here ?
a) Transparency
b) inclusiveness
c) Fainness

15) You need to determine the location of cars in an image so that can estimate the distance between that cars. Which type computer vision should you use ?
a) optical character recognition (OCR)
b)object detection
c) Image classification
d) face detection.

 
16) Azure Machine Learing desinger lets you create machine learning models by:

  a) Adding and connecting modules on visaul canvas. 

b)automatically performing common data preparation tasks.
c)automatically selecting an algorithm to build the most accurate model.
d) using a code-fiart notebook experience.


17) Your company is exploring the use of voice recognition technologies in its smart home devices.The company wants to identify any barriers that might unintentionally leave out specific user groups. This is example of which Microsoft guiding principle for responsible AI?
a) Accountability
b) fairness
c) inclusiveness 

d) Private and security.

18) A housing dealership wants to use historic apartment sales data to train a machine learning model. The model should predict the price of pre-owned apartment based on its location, size and apartment aging. what kind of machine model should dealership use automated machine learning to create ? 

a) classification
b) regression
c) Time series forecasting

20) What are three Microsoft guiding principles for responsible AI >

 a) Knowledgeability

b)decisiveness
c) inclusiveness
d) fairness
e)reliability and safety

21> A bank wants to use historic credit card repayment records to categorize credit card application as low-risk or high risk based on characterises like the credit amount, the income of borrower and credit peroid. What kind of machine learning model should bank use automated machine learning to create ?
a)Classification
b)Regression
c)Time series forecasting

Note ::           Numeric ---> Regression
                      Category ---> Classification

23) Predicating how many hours of overtime a delivery a delivery person will work based on number of order received is example of
a) classification
b) Clustering
c)Regression

24) Which following service should you use to train an object detection model by using own images.

a) Computer vision

b) Custom vision 

c)Form Recognizer

d)Video indexer

25) You are creating training pipeline for regression model. You use a dataset has multiple numeric column in which values on different scales. you want to transform the numeric column so that values are all on similar scale.You also want reformation to scale relative to maximum and maximum values in each column. Which module you add to pipeline?

a) Select Column in Dataset

b)Normalise Data.

c)Clean missing Data.

26)What are two tasks that can performed by using Computer Vision service ?

a) Trian A custome image classification model.

b) Detect faces in an image.

C) Recognise hadwritten text.

d) Translate the text in an image between languages.

27)You are working in a tour & tourism company.Your company wants to use the Computer Vision service to analyse image of location and identify well-known monuments. What should you do ?

a) Retrieve the objects in the image

b)Retrieve the categories for image, specifying the celebrations domain

c)Retrieve the categories for image, specifying the landmarks domain

28) Why do you spilt data into training and validation sets ?

a) Data is split two sets in order to create two models, one models with trining set and a different model with validation set.

b) Splitting data into two set enables you to compare the labesl that model redicits with the actaul known lables in original dataset.

c)Only split data when you use Azure Machine Learing Designer ,not in other machine learing scenarios. 

29)What are two metrics that you can use to evaluate a regression model ?

a)coefficient of determination (R2)

b) root mean squared error(RMSE)

c) F1 score

d) area under cureve (AUC)

e) balanced accuracy

30)You are processing photos of runners in race.You need to read the numbers on runners shirts to identify the the runners in photoes.Which type of computer vision should you use ?

a) facial recognition

b) optical character recognition (OCR)

c) semantic segemention

d) object detecton

Phython to MSSQL connection

                              Phython to MSSQL connection

You have install  drives using following command.

pip install pyodbc

hhhhh

Index in oracle

                                 Index in oracle

  An index is database object used primarily to improve the performance of SQL queries.

Following point taken care for creating index:-

1.    Type index
2. Tables column to include 
3. feature like compression, invisible or Parnellism
4. Uniqueness

Estimating the space an index will require

SQL> SET SERVEROUTPUT ON

DECLARE

v_used_bytes NUMBER(10);

v_Allocated_Bytes NUMBER(10);

BEGIN

DBMS_SPACE.CREATE_INDEX_COST

(

'CREATE INDEX IDX ON test(ID) ',

v_used_Bytes,

v_Allocated_Bytes

);

DBMS_OUTPUT.PUT_LINE('Used Bytes: ' || TO_CHAR(v_used_Bytes));

DBMS_OUTPUT.PUT_LINE('Allocated Bytes: ' || TO_CHAR(v_Allocated_Bytes));

END;

/SQL> SQL>   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17  

Used Bytes: 12

Allocated Bytes: 65536

PL/SQL procedure successfully completed.

 

Static or dynamic parameter in Oracle  

FALSE -It requires changes to carry out to SPFILE ,All parameter that have the column ISSYS_MODIFIABLE value FALSE in the V$PARAMETER view are STATIC parameters and remaining are DYNAMIC parameters in Oracle database.

   SQL> select name, value, issys_modifiable from v$parameter ;

NAME     VALUE       ISSYS_MOD

----------------------------------- ------------------------- ---------

lock_name_space                FALSE

processes     300                      FALSE

sessions     472                      IMMEDIATE

timed_statistics     TRUE              IMMEDIATE

timed_os_statistics     0                IMMEDIATE

resource_limit     TRUE                IMMEDIATE

license_max_sessions     0       IMMEDIATE

license_sessions_warning     0       IMMEDIATE

long_module_action     TRUE       IMMEDIATE

standby_db_preserve_states     NONE       FALSE

instance_abort_delay_time     0       IMMEDIATE

cpu_count     2               IMMEDIATE

instance_groups               FALSE

event               FALSE

sga_max_size     1660944384       FALSE

use_large_pages     TRUE                   FALSE

pre_page_sga     TRUE                   FALSE

shared_memory_address     0       FALSE

hi_shared_memory_address     0       FALSE

lock_sga     FALSE                   FALSE

processor_group_name       FALSE

allow_group_access_to_sga     FALSE       FALSE

sga_min_size     0                   IMMEDIATE

shared_pool_size     0                   IMMEDIATE

large_pool_size     0                   IMMEDIATE

java_pool_size     0           IMMEDIATE

streams_pool_size     0               IMMEDIATE

shared_pool_reserved_size     10905190       FALSE

java_soft_sessionspace_limit     0       FALSE

java_max_sessionspace_size     0       FALSE

pga_aggregate_limit     2147483648       IMMEDIATE

spfile     /u01/app/oracle/product/1     IMMEDIATE

    2.2.0/dbhome_1/dbs/spfile

    orcl.ora

instance_type     RDBMS       FALSE

uniform_log_timestamp_format     TRUE       IMMEDIATE

nls_language     AMERICAN       FALSE

nls_territory     AMERICA       FALSE

nls_sort                   FALSE

nls_date_language       FALSE

nls_date_format       FALSE

nls_currency       FALSE

nls_numeric_characters       FALSE

nls_iso_currency       FALSE

nls_calendar       FALSE

nls_time_format       FALSE

nls_timestamp_format       FALSE

nls_time_tz_format       FALSE

nls_timestamp_tz_format       FALSE

nls_dual_currency       FALSE

nls_comp     BINARY       FALSE

nls_length_semantics     BYTE       IMMEDIATE

nls_nchar_conv_excp     FALSE       IMMEDIATE

disk_asynch_io     TRUE       FALSE

tape_asynch_io     TRUE       FALSE

dbwr_io_slaves     0       FALSE

backup_tape_io_slaves     FALSE       DEFERRED

fileio_network_adapters       FALSE

filesystemio_options     none       FALSE

dnfs_batch_size     4096       FALSE

clonedb     FALSE       FALSE

instant_restore     FALSE       FALSE

ofs_threads     4       IMMEDIATE

resource_manager_cpu_allocation     2       IMMEDIATE

resource_manager_plan     SCHEDULER[0x4AC7]:DEFAULT IMMEDIATE

    _MAINTENANCE_PLAN

db_performance_profile       FALSE

max_iops     0       IMMEDIATE

max_mbps     0       IMMEDIATE

max_idle_time     0       IMMEDIATE

cluster_interconnects       FALSE

exafusion_enabled     1       FALSE

file_mapping     FALSE       IMMEDIATE

max_datapump_jobs_per_pdb     100       IMMEDIATE

service_names     ORCL       IMMEDIATE

threaded_execution     FALSE       FALSE

clonedb_dir       FALSE

enable_dnfs_dispatcher     FALSE       FALSE

gcs_server_processes     0       FALSE

active_instance_count       FALSE

instance_mode     READ-WRITE       FALSE

sga_target     0       IMMEDIATE

memory_target     1660944384       IMMEDIATE

memory_max_target     1660944384       FALSE

control_files     /u01/app/oracle/oradata/o FALSE

    rcl/control01.ctl, /u01/a

    pp/oracle/oradata/orcl/co

    ntrol02.ctl

db_file_name_convert     /u01/app/oracle/oradata/o FALSE

    rcl/, /u01/app/oracle/ora

    data/orcl/

log_file_name_convert     /u01/app/oracle/oradata/o FALSE

    rcl/, /u01/app/oracle/ora

    data/orcl/

control_file_record_keep_time     7       IMMEDIATE

db_block_buffers     0       FALSE

db_block_checksum     TYPICAL       IMMEDIATE

db_ultra_safe     OFF       FALSE

db_block_size     8192       FALSE

db_cache_size     0       IMMEDIATE

db_2k_cache_size     0       IMMEDIATE

db_4k_cache_size     0       IMMEDIATE

db_8k_cache_size     0       IMMEDIATE

db_16k_cache_size     0       IMMEDIATE

db_32k_cache_size     0       IMMEDIATE

db_keep_cache_size     0       IMMEDIATE

db_recycle_cache_size     0       IMMEDIATE

db_big_table_cache_percent_target   0       IMMEDIATE

encrypt_new_tablespaces     CLOUD_ONLY       IMMEDIATE

db_writer_processes     1       FALSE

buffer_pool_keep       FALSE

buffer_pool_recycle       FALSE

db_flash_cache_file       IMMEDIATE

db_flash_cache_size     0       IMMEDIATE

db_cache_advice     ON       IMMEDIATE

compatible     12.2.0       FALSE

log_archive_dest_1     location=/u01/app/oracle/ IMMEDIATE

    product/12.2.0/dbhome_1/d

    bs/arch valid_for=(all_lo

    gfiles,all_roles) db_uniq

    ue_name=ORCL

log_archive_dest_2     service=stand async valid IMMEDIATE

    _for=(online_logfiles,pri

    mary_role) db_unique_name

    =DRORCL

log_archive_dest_3       IMMEDIATE

log_archive_dest_4       IMMEDIATE

log_archive_dest_5       IMMEDIATE

log_archive_dest_6       IMMEDIATE

log_archive_dest_7       IMMEDIATE

log_archive_dest_8       IMMEDIATE

log_archive_dest_9       IMMEDIATE

log_archive_dest_10       IMMEDIATE

log_archive_dest_11       IMMEDIATE

log_archive_dest_12       IMMEDIATE

log_archive_dest_13       IMMEDIATE

log_archive_dest_14       IMMEDIATE

log_archive_dest_15       IMMEDIATE

log_archive_dest_16       IMMEDIATE

log_archive_dest_17       IMMEDIATE

log_archive_dest_18       IMMEDIATE

log_archive_dest_19       IMMEDIATE

log_archive_dest_20       IMMEDIATE

log_archive_dest_21       IMMEDIATE

log_archive_dest_22       IMMEDIATE

log_archive_dest_23       IMMEDIATE

log_archive_dest_24       IMMEDIATE

log_archive_dest_25       IMMEDIATE

log_archive_dest_26       IMMEDIATE

log_archive_dest_27       IMMEDIATE

log_archive_dest_28       IMMEDIATE

log_archive_dest_29       IMMEDIATE

log_archive_dest_30       IMMEDIATE

log_archive_dest_31       IMMEDIATE

log_archive_dest_state_1     enable       IMMEDIATE

log_archive_dest_state_2     ENABLE       IMMEDIATE

log_archive_dest_state_3     enable       IMMEDIATE

log_archive_dest_state_4     enable       IMMEDIATE

log_archive_dest_state_5     enable       IMMEDIATE

log_archive_dest_state_6     enable       IMMEDIATE

log_archive_dest_state_7     enable       IMMEDIATE

log_archive_dest_state_8     enable       IMMEDIATE

log_archive_dest_state_9     enable       IMMEDIATE

log_archive_dest_state_10     enable       IMMEDIATE

log_archive_dest_state_11     enable       IMMEDIATE

log_archive_dest_state_12     enable       IMMEDIATE

log_archive_dest_state_13     enable       IMMEDIATE

log_archive_dest_state_14     enable       IMMEDIATE

log_archive_dest_state_15     enable       IMMEDIATE

log_archive_dest_state_16     enable       IMMEDIATE

log_archive_dest_state_17     enable       IMMEDIATE

log_archive_dest_state_18     enable       IMMEDIATE

log_archive_dest_state_19     enable       IMMEDIATE

log_archive_dest_state_20     enable       IMMEDIATE

log_archive_dest_state_21     enable       IMMEDIATE

log_archive_dest_state_22     enable       IMMEDIATE

log_archive_dest_state_23     enable       IMMEDIATE

log_archive_dest_state_24     enable       IMMEDIATE

log_archive_dest_state_25     enable       IMMEDIATE

log_archive_dest_state_26     enable       IMMEDIATE

log_archive_dest_state_27     enable       IMMEDIATE

log_archive_dest_state_28     enable       IMMEDIATE

log_archive_dest_state_29     enable       IMMEDIATE

log_archive_dest_state_30     enable       IMMEDIATE

log_archive_dest_state_31     enable       IMMEDIATE

log_archive_start     FALSE       FALSE

log_archive_dest       IMMEDIATE

log_archive_duplex_dest       IMMEDIATE

log_archive_min_succeed_dest     1       IMMEDIATE

standby_archive_dest     ?#/dbs/arch       IMMEDIATE

fal_client     PRIME       IMMEDIATE

fal_server     STAND       IMMEDIATE

log_archive_trace     0       IMMEDIATE

data_guard_sync_latency     0       IMMEDIATE

log_archive_config     dg_config=(ORCL,DRORCL)   IMMEDIATE

log_archive_format     %t_%s_%r.dbf       FALSE

redo_transport_user       IMMEDIATE

log_archive_max_processes     4       IMMEDIATE

log_buffer     7806976       FALSE

log_checkpoint_interval     0       IMMEDIATE

log_checkpoint_timeout     1800       IMMEDIATE

archive_lag_target     0       IMMEDIATE

db_files     200       FALSE

db_file_multiblock_read_count     128       IMMEDIATE

read_only_open_delayed     FALSE       FALSE

cluster_database     FALSE       FALSE

cluster_database_instances     1       FALSE

db_create_file_dest       IMMEDIATE

db_create_online_log_dest_1       IMMEDIATE

db_create_online_log_dest_2       IMMEDIATE

db_create_online_log_dest_3       IMMEDIATE

db_create_online_log_dest_4       IMMEDIATE

db_create_online_log_dest_5       IMMEDIATE

db_recovery_file_dest     /u01/app/oracle/FRA       IMMEDIATE

db_recovery_file_dest_size     3221225472       IMMEDIATE

standby_file_management     AUTO       IMMEDIATE

db_unrecoverable_scn_tracking     TRUE       IMMEDIATE

thread     0       IMMEDIATE

enabled_PDBs_on_standby     *       IMMEDIATE

fast_start_io_target     0       IMMEDIATE

fast_start_mttr_target     0       IMMEDIATE

log_checkpoints_to_alert     FALSE       IMMEDIATE

db_lost_write_protect     NONE       IMMEDIATE

recovery_parallelism     0       FALSE

enable_goldengate_replication     FALSE       IMMEDIATE

inmemory_adg_enabled     TRUE       IMMEDIATE

db_flashback_retention_target     1440       IMMEDIATE

data_transfer_cache_size     0       IMMEDIATE

dml_locks     2076       FALSE

replication_dependency_tracking     TRUE       FALSE

transactions     519       FALSE

transactions_per_rollback_segment   5       FALSE

temp_undo_enabled     FALSE       IMMEDIATE

rollback_segments       FALSE

undo_management     AUTO       FALSE

undo_tablespace     UNDOTBS1       IMMEDIATE

undo_retention     900       IMMEDIATE

fast_start_parallel_rollback     LOW       IMMEDIATE

resumable_timeout     0       IMMEDIATE

instance_number     0       FALSE

heat_map     OFF       IMMEDIATE

inmemory_size     0       IMMEDIATE

db_block_checking     FALSE       IMMEDIATE

recyclebin     on       DEFERRED

db_index_compression_inheritance    NONE       IMMEDIATE

db_securefile     PREFERRED       IMMEDIATE

inmemory_clause_default       IMMEDIATE

inmemory_force     DEFAULT       IMMEDIATE

inmemory_query     ENABLE       IMMEDIATE

inmemory_expressions_usage     ENABLE       IMMEDIATE

inmemory_virtual_columns     MANUAL       IMMEDIATE

inmemory_max_populate_servers     0       IMMEDIATE

inmemory_trickle_repopulate_servers 1       IMMEDIATE

_percent

create_stored_outlines       IMMEDIATE

serial_reuse     disable       FALSE

ldap_directory_access     NONE       IMMEDIATE

ldap_directory_sysauth     no       FALSE

os_roles     FALSE       FALSE

rdbms_server_dn       FALSE

remote_os_authent     FALSE       FALSE

remote_os_roles     FALSE       FALSE

sec_case_sensitive_logon     TRUE       IMMEDIATE

O7_DICTIONARY_ACCESSIBILITY     FALSE       FALSE

remote_login_passwordfile     EXCLUSIVE       FALSE

license_max_users     0       IMMEDIATE

audit_sys_operations     TRUE       FALSE

DBFIPS_140     FALSE       FALSE

one_step_plugin_for_pdb_with_tde    FALSE       IMMEDIATE

external_keystore_credential_locati       FALSE

on

unified_audit_sga_queue_size     1048576       FALSE

db_domain       FALSE

global_names     FALSE       IMMEDIATE

distributed_lock_timeout     60       FALSE

commit_point_strength     1       FALSE

global_txn_processes     1       IMMEDIATE

instance_name     orcl       FALSE

dispatchers     (PROTOCOL=TCP) (SERVICE=o IMMEDIATE

    rclXDB)

shared_servers     1       IMMEDIATE

max_shared_servers       IMMEDIATE

max_dispatchers       IMMEDIATE

circuits       IMMEDIATE

shared_server_sessions       IMMEDIATE

local_listener     LISTENER_ORCL       IMMEDIATE

remote_listener       IMMEDIATE

listener_networks       IMMEDIATE

use_dedicated_broker     FALSE       IMMEDIATE

connection_brokers     ((TYPE=DEDICATED)(BROKERS IMMEDIATE

    =1)), ((TYPE=EMON)(BROKER

    S=1))

cursor_space_for_time     FALSE       FALSE

session_cached_cursors     50       DEFERRED

remote_dependencies_mode     TIMESTAMP       IMMEDIATE

utl_file_dir       FALSE

smtp_out_server       IMMEDIATE

plsql_v2_compatibility     FALSE       IMMEDIATE

plsql_warnings     DISABLE:ALL       IMMEDIATE

plsql_code_type     INTERPRETED       IMMEDIATE

plsql_debug     FALSE       IMMEDIATE

plsql_optimize_level     2       IMMEDIATE

plsql_ccflags       IMMEDIATE

plscope_settings     IDENTIFIERS:NONE       IMMEDIATE

permit_92_wrap_format     TRUE       FALSE

java_jit_enabled     TRUE       IMMEDIATE

java_restrict     none       FALSE

job_queue_processes     4000       IMMEDIATE

parallel_min_percent     0       FALSE

create_bitmap_area_size     8388608       FALSE

bitmap_merge_area_size     1048576       FALSE

cursor_sharing     EXACT       IMMEDIATE

result_cache_mode     MANUAL       IMMEDIATE

parallel_min_servers     8       IMMEDIATE

parallel_max_servers     80       IMMEDIATE

parallel_instance_group       IMMEDIATE

parallel_execution_message_size     16384       FALSE

hash_area_size     131072       FALSE

result_cache_max_size     4161536       IMMEDIATE

result_cache_max_result     5       IMMEDIATE

result_cache_remote_expiration     0       IMMEDIATE

shadow_core_dump     partial       IMMEDIATE

background_core_dump     partial       IMMEDIATE

background_dump_dest     /u01/app/oracle/product/1 IMMEDIATE

    2.2.0/dbhome_1/rdbms/log

user_dump_dest     /u01/app/oracle/product/1 IMMEDIATE

    2.2.0/dbhome_1/rdbms/log

core_dump_dest     /u01/app/oracle/diag/rdbm IMMEDIATE

    s/orcl/orcl/cdump

audit_file_dest     /u01/app/oracle/admin/orc DEFERRED

    l/adump

audit_syslog_level       FALSE

resource_manage_goldengate     FALSE       IMMEDIATE

object_cache_optimal_size     10240000       DEFERRED

object_cache_max_size_percent     10       DEFERRED

session_max_open_files     10       FALSE

open_links     4       FALSE

open_links_per_instance     4       FALSE

commit_write       IMMEDIATE

commit_wait       IMMEDIATE

commit_logging       IMMEDIATE

optimizer_features_enable     12.2.0.1       IMMEDIATE

fixed_date       IMMEDIATE

audit_trail     DB       FALSE

sort_area_size     65536       DEFERRED

sort_area_retained_size     0       DEFERRED

cell_offload_processing     TRUE       IMMEDIATE

cell_offload_decryption     TRUE       IMMEDIATE

cell_offload_parameters       IMMEDIATE

cell_offload_compaction     ADAPTIVE       IMMEDIATE

cell_offload_plan_display     AUTO       IMMEDIATE

db_name     orcl       FALSE

db_unique_name     ORCL       FALSE

open_cursors     300       IMMEDIATE

ifile       FALSE

sql_trace     FALSE       IMMEDIATE

os_authent_prefix     ops$       FALSE

optimizer_mode     ALL_ROWS       IMMEDIATE

sql92_security     TRUE       FALSE

blank_trimming     FALSE       FALSE

star_transformation_enabled     FALSE       IMMEDIATE

parallel_degree_policy     MANUAL       IMMEDIATE

parallel_adaptive_multi_user     FALSE       IMMEDIATE

parallel_threads_per_cpu     2       IMMEDIATE

optimizer_index_cost_adj     100       IMMEDIATE

optimizer_index_caching     0       IMMEDIATE

query_rewrite_enabled     TRUE       IMMEDIATE

query_rewrite_integrity     enforced       IMMEDIATE

pga_aggregate_target     0       IMMEDIATE

workarea_size_policy     AUTO       IMMEDIATE

optimizer_dynamic_sampling     2       IMMEDIATE

statistics_level     TYPICAL       IMMEDIATE

cursor_bind_capture_destination     memory+disk       IMMEDIATE

skip_unusable_indexes     TRUE       IMMEDIATE

optimizer_secure_view_merging     TRUE       IMMEDIATE

ddl_lock_timeout     0       IMMEDIATE

deferred_segment_creation     TRUE       IMMEDIATE

optimizer_use_pending_statistics    FALSE       IMMEDIATE

optimizer_capture_sql_plan_baseline FALSE       IMMEDIATE

s

optimizer_use_sql_plan_baselines    TRUE       IMMEDIATE

parallel_min_time_threshold     AUTO       IMMEDIATE

parallel_degree_limit     CPU       IMMEDIATE

parallel_force_local     FALSE       IMMEDIATE

optimizer_use_invisible_indexes     FALSE       IMMEDIATE

dst_upgrade_insert_conv     TRUE       IMMEDIATE

parallel_servers_target     32       IMMEDIATE

max_string_size     STANDARD       IMMEDIATE

optimizer_adaptive_reporting_only   FALSE       IMMEDIATE

optimizer_adaptive_plans     TRUE       IMMEDIATE

optimizer_inmemory_aware     TRUE       IMMEDIATE

cursor_invalidation     IMMEDIATE       IMMEDIATE

approx_for_aggregation     FALSE       IMMEDIATE

approx_for_count_distinct     FALSE       IMMEDIATE

approx_for_percentile     none       IMMEDIATE

optimizer_adaptive_statistics     FALSE       IMMEDIATE

sec_protocol_error_trace_action     TRACE       IMMEDIATE

sec_protocol_error_further_action   (DROP,3)       IMMEDIATE

sec_max_failed_login_attempts     3       FALSE

sec_return_server_release_banner    FALSE       FALSE

enable_ddl_logging     FALSE       IMMEDIATE

client_result_cache_size     0       FALSE

client_result_cache_lag     3000       FALSE

outbound_dblink_protocols     ALL       IMMEDIATE

allow_global_dblinks     FALSE       IMMEDIATE

aq_tm_processes     1       IMMEDIATE

hs_autoregister     TRUE       IMMEDIATE

xml_db_events     enable       IMMEDIATE

dg_broker_start     FALSE       IMMEDIATE

dg_broker_config_file1     /u01/app/oracle/product/1 IMMEDIATE

    2.2.0/dbhome_1/dbs/dr1ORC

    L.dat

dg_broker_config_file2     /u01/app/oracle/product/1 IMMEDIATE

    2.2.0/dbhome_1/dbs/dr2ORC

    L.dat

olap_page_pool_size     0       DEFERRED

asm_diskstring       IMMEDIATE

asm_preferred_read_failure_groups       IMMEDIATE

asm_diskgroups       IMMEDIATE

asm_power_limit     1       IMMEDIATE

asm_io_processes     20       IMMEDIATE

control_management_pack_access     DIAGNOSTIC+TUNING       IMMEDIATE

awr_pdb_autoflush_enabled     FALSE       IMMEDIATE

awr_snapshot_time_offset     0       IMMEDIATE

sqltune_category     DEFAULT       IMMEDIATE

autotask_max_active_pdbs     2       IMMEDIATE

enable_automatic_maintenance_pdb    TRUE       IMMEDIATE

spatial_vector_acceleration     FALSE       IMMEDIATE

diagnostic_dest     /u01/app/oracle       IMMEDIATE

tracefile_identifier       FALSE

max_dump_file_size     unlimited       IMMEDIATE

trace_enabled     TRUE       IMMEDIATE

cell_offloadgroup_name       IMMEDIATE

enable_pluggable_database     FALSE       FALSE

pdb_os_credential       FALSE

pdb_file_name_convert       IMMEDIATE

noncdb_compatible     FALSE       FALSE

common_user_prefix     C##       FALSE

target_pdbs     0       FALSE

max_pdbs     4098       IMMEDIATE

cdb_cluster     FALSE       FALSE

cdb_cluster_name     ORCL       FALSE

remote_recovery_file_dest       IMMEDIATE

disable_pdb_feature     0       IMMEDIATE

containers_parallel_degree     65535       IMMEDIATE

default_sharing     metadata       IMMEDIATE

pdb_lockdown       IMMEDIATE

shrd_dupl_table_refresh_rate     60       IMMEDIATE

417 rows selected.