Freeman Pacifico

How do I define a function with optional arguments?

Defining a function with optional arguments in Python is a great way to make your code more flexible and user-friendly. Optional arguments allow you to call the function with fewer parameters if needed, without breaking the code. Here's how you can define a function with optional arguments: Using default parameter…

Python

Answered May 20, 2025 · 1.2K Views Read answer →

Finding duplicate values in a SQL table

Finding duplicate values in a SQL table is a common task when you want to clean up data, enforce uniqueness, or analyze repeated records. But how exactly can you identify duplicates based on one or more columns? How to find duplicates in SQL? The most common approach is to use the GROUP BY clause combined with HAVING.…

SQL Server

Answered May 15, 2025 · 848 Views Read answer →

In which scenario you would rebuild the index?

The answer to your question - In which scenario you would rebuild the index is - You should run an index maintenance process regularly. However, your index maintenance process should only rebuild/reorganize the indexes that specifically require it. This presents the question: when does an index require to be rebuilt…

SQL Server

Answered Oct 3, 2022 · 997 Views Read answer →

How to pivot on multiple columns in SQL Server?

Here is one way of getting the result set you want without doing the multiple joins. It takes a little more setup and uses two pivot operations instead of one, but avoids the multiple joins. I admit that I had to look it up, but Ken O'Bonn had a great article.

Salesforce

Answered Aug 22, 2021 · 1.6K Views Read answer →

using regex in replaceAll to replace multiple char in one go

You can Try this to replaceall: String r = t.replaceAll('[^0-9]','');Explanation: Instead of hunting for invalid characters and removing them explicitly you can specify remove all characters other than numbers. ^ for not a given char [0-9] for numbers ranging from 0 to 9 '' replace it with empty char (removes it from…

Salesforce

Answered Apr 22, 2021 · 2.5K Views Read answer →

Regex puzzle, limit optional first character to one of two values

You're just missing the ?, which s why you are facing regex optional character: Pattern regex = Pattern.compile('([U|S])?02-1234'); Note that technically, using [], you don't want the | "operator", because you're actually checking if the string starts with U, S, or |. Similarly, you don't need the (), because it's not…

Power BI

Answered Apr 16, 2021 · 1.1K Views Read answer →

What’s the need of Acceptance testing when all other levels of testing have been done over an application?

Prima facie, we might understand that after unit testing, component testing, integration testing and system testing is done, execution of acceptance testing is of no use apart from just an addition burden, but we need to understand acceptance testing is mandatory because: a) Both the developers code and test the…

QA Testing

Answered Nov 15, 2019 · 1.4K Views Read answer →

Which is the first and last testing conducted over an application?

As we are aware that once coding phase is completed, the application moves to the next testing phase and component testing is the first testing done here. However, if we talk of which is the first testing done over the application, it would be Unit Testing. However, unit testing is part of coding phase only, here the…

QA Testing

Answered Nov 15, 2019 · 1.4K Views Read answer →