PL SQL Tutorial

What a beautiful language it is !!!!

I have around of 9 years of experience in IT industry and i just love Oracle.
Very easy to learn and to work in Pl SQL

So I am sharing a tip to hold on PL SQL ,it is 'Practice','Practice' and 'practice'

this is the only one thing that need to  understand that practice make a professional perfect.

Second, Break your longer query into small chunks.

Third, Uses of sub-queries .trust me it increase the performance.

Fourth,never underestimate the power of indexing.

Fifth,uses of hints but it works only if tables are analysed and updated stats.

Sixth,uses of with clause.

Seventh,proper use of indexing.

Eight, when to use dynamic query, when not!!!!

Comments

Post a Comment

Popular posts from this blog

renewal of DP-300 exam questions

Image
  According to Microsoft SQL Server configuration best practices, what should you do to configure cach According to Microsoft SQL Server configuration best practices, what should you do to configure caching on volumes that host log files? Select only one answer. Enable read caching only. Enable write caching only. Enable read and write caching. Disable all caching. You plan to deploy Microsoft SQL Server 2019 to an Azure virtual machine that has eight CPUs and four disks. You expect that SQL Server will run tempdb heavy-workloads. You need to optimize the performance of tempdb. What should you do? Select only one answer. Store tempdb in eight files of the same size. Store tempdb in four files. Configure one of the files to have the size matching the amount of memory allocated to SQL Server. Enable trace flag 1117. Enable trace flag 1118. : You plan to implement SQL Server on an Azure virtual machine that has managed disks. You need to ensure that the virtual machine disks hosting t...
Read more

DP-300 dumps

Image
 Question #1 Topic 1 You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. total size of all the databases B. geo-replication support C. number of concurrently peaking databases * peak CPU utilization per database D. maximum number of concurrent sessions for all the databases E. total number of databases * average CPU utilization per database Correct Answer: ACE  CE: Estimate the vCores needed for the pool as follows: For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB) A: Estimate the storage space needed for the pool by adding the number of bytes needed for ...
Read more

DP-300(30-60 questions)

Image
  You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: ✑ Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. ✑ Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.  What should you create on VNet1?  A. a VPN gateway  B. a service endpoint  C. a private link  D. an ExpressRoute gateway  Correct Answer: C  You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server. You need to ensure that each customer can only connect to and access their respective database. Which two actions should you perform? Each correct answer presents part of the solution.  NOTE: Each correct selection is worth one point. A. Imp...
Read more