Ques:- How many ways can an argument be passed to a subroutine?
Ques:- X and Y together can do a piece of work in 8 days. If X alone can do the same work in 12 days, then Y alone can do the same work in?
Right Answer:
Y alone can do the same work in 24 days.
Y alone can do the same work in 24 days.
Comments
24 days
Ques:- One half of a two digit number exceeds its one third by 6. Find the sum of the digits of the number?
Asked In :-
Gallagher Offshore, lincolnshire county council, mdrt, hibernia college, engineering excellence,
Right Answer:
The sum of the digits of the number is 11.
The sum of the digits of the number is 11.
Comments
Let the number be 10Y+X
(10Y+X)/2 = (10X+Y)/3+6
(10Y+X)(1/2-1/3) = 6
10Y+X = 36
Therefore, sum of the digits = 3+6 = 9
Ans: 9
Ques:- Find the greatest number which is such that when 697, 909 and 1227 are divided by it, the remainders are all the same?
Asked In :-
Gallagher Offshore, saudi electricity company,
Right Answer:
The greatest number is 66.
The greatest number is 66.
Comments
3
Ques:- A and B enter into partnership with capital as 7:9. At the end of 8 months, A withdraws. If they receive the profits in the ratio of 8:9 find how long B’s capital was used?
Right Answer:
B's capital was used for 12 months.
B's capital was used for 12 months.
Comments
7 months
Ques:- The surface of a cube is 24sq cm. Evaluate its volume?
Asked In :-
MedGenome Labs, BOM, Everest Bank, GACL, GSFC, Lucky Cement, GAIN Credit, Bhavna, Advansoft International, Can Fin Homes,
Right Answer:
The volume of the cube is 64 cubic centimeters.
The volume of the cube is 64 cubic centimeters.
Ques:- Three 6 faced dice are thrown together. The probability that all the three show the same number on them is -.
Asked In :-
NISC Exports Services (p), Airborne Recruiting, Eastman Chemical, FIN Infocom, ITC Indian Tobacco Company, NBP National Bank of Pakistan, Quantile, Motilal Oswal Securities, IDP Education, OfBusiness,
Right Answer:
The probability that all three dice show the same number is ( frac{1}{6} ).
The probability that all three dice show the same number is ( frac{1}{6} ).
Ques:- WHAT IS WORKING CAPITAL
Asked In :-
Protege Solutions, SPARX IT SOLUTIONS, Adnate IT Solutions, COEPD, Elsner Technologies, Unica Solutions, Target Integration, Valethi, 9series Solutions, Travanleo Info Solutions India,
Right Answer:
Working capital is the difference between a company's current assets and current liabilities, indicating the short-term financial health and operational efficiency of the business.
Working capital is the difference between a company's current assets and current liabilities, indicating the short-term financial health and operational efficiency of the business.
Ques:- A man can row his boat with the stream at 6 km/h and against the stream in 4 km/h. The man’s rate is?
Asked In :-
Bangladesh Securities and Exchange Commission BSEC, BPSC, CPCL, Exim Bank, First American Corporation, GACL, KAS, NBP National Bank of Pakistan, Gallagher Offshore, KALKINE,
Right Answer:
The man's rate is 5 km/h.
The man's rate is 5 km/h.
Ques:- In a game of billiards, A can give B 20 points in 60 and he can give C 30 points in 60. How many points can B give C in a game of 100?
Asked In :-
Bapco Bahrain Petroleum Company, First American Corporation, Federal Bank India, Prakash Kochar & Co, Tube Investments of India, Zydus Wellness, India Shelter Finance, NISM, Gallagher Offshore, Wolseley UK,
Right Answer:
B can give C 10 points in a game of 100.
B can give C 10 points in a game of 100.
Comments
50
Ques:- How to replace particular string.For example:- suppose their are 1000 of records for email-id.like tarun.it@hotmail.com..but i want to replace the only hotmail.com for all email-ids not the user name(tarun.it) with yahoo.com.
Asked In :-
Trigent Software, Evolvus Solutions, Novatech Software, Solix Technologies, Inc, TriSys, Infomats Technologies, JSL, ImpactQA, Netcon Technologies, VEDA IIT,
Right Answer:
You can use the `REPLACE` function in SQL Server to replace "hotmail.com" with "yahoo.com" in the email addresses. Here’s the SQL query:
```sql
UPDATE your_table_name
SET email_column = REPLACE(email_column, 'hotmail.com', 'yahoo.com')
WHERE email_column LIKE '%hotmail.com';
```
You can use the `REPLACE` function in SQL Server to replace "hotmail.com" with "yahoo.com" in the email addresses. Here’s the SQL query:
```sql
UPDATE your_table_name
SET email_column = REPLACE(email_column, 'hotmail.com', 'yahoo.com')
WHERE email_column LIKE '%hotmail.com';
```
Ques:- What is an Exception ? What are types of Exception ?
Asked In :-
CTRLS DATACENTERS, bKash, Data Patterns, Webtech Developers, Cinif Technologies, Gallagher Offshore, MyDBOPS, Cateina Technologies, Icon Technologies, Techvaria Solutions,
Right Answer:
An exception is an event that occurs during the execution of a program that disrupts the normal flow of instructions. The types of exceptions include:
1. **Checked Exceptions**: These are exceptions that are checked at compile-time, such as `IOException` or `SQLException`.
2. **Unchecked Exceptions**: These are exceptions that occur at runtime and are not checked at compile-time, such as `NullPointerException` or `ArrayIndexOutOfBoundsException`.
3. **Errors**: These are serious issues that a typical application should not try to catch, such as `OutOfMemoryError` or `StackOverflowError`.
An exception is an event that occurs during the execution of a program that disrupts the normal flow of instructions. The types of exceptions include:
1. **Checked Exceptions**: These are exceptions that are checked at compile-time, such as `IOException` or `SQLException`.
2. **Unchecked Exceptions**: These are exceptions that occur at runtime and are not checked at compile-time, such as `NullPointerException` or `ArrayIndexOutOfBoundsException`.
3. **Errors**: These are serious issues that a typical application should not try to catch, such as `OutOfMemoryError` or `StackOverflowError`.
Ques:- How to remove duplicate records from a table?
Asked In :-
Sardonyx Technologies, rapidera technologies, Valued Epistemics, Pi Techniques, PrimeSoft Solutions, District Cooperative Central Bank DCCB, Qseap Technologies, JustDial, Tower Research Capital LLC, AMI Tech India,
Right Answer:
To remove duplicate records from a table in SQL Server, you can use a Common Table Expression (CTE) with the `ROW_NUMBER()` function. Here’s an example query:
```sql
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY (SELECT NULL)) AS rn
FROM your_table
)
DELETE FROM CTE WHERE rn > 1;
```
Replace `column1`, `column2` with the columns that define duplicates, and `your_table` with the name of your table.
To remove duplicate records from a table in SQL Server, you can use a Common Table Expression (CTE) with the `ROW_NUMBER()` function. Here’s an example query:
```sql
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY (SELECT NULL)) AS rn
FROM your_table
)
DELETE FROM CTE WHERE rn > 1;
```
Replace `column1`, `column2` with the columns that define duplicates, and `your_table` with the name of your table.
Ques:- What is User Defined Functions?
Asked In :-
Velocity Software Solutions, TVISHA TECHNOLOGIES PVT, Mundrisoft Solutions LLP, The Unified Cloud, Circle Internet Financial, SureSoft, Data Patterns, Ojas Innovative Technologies, Simeio, tringapps,
Ques:- How many types of system privileges are there, Can we add or delete privileges?
Asked In :-
Razorpay-Startup, Helical It Solutions, Walking Tree Consultancy Services pvt, Atidan Technologies, MagicPin, CloudKaptan, Adloid, Gallagher Offshore, Intune, CodeQuotient,
Right Answer:
There are two types of system privileges: administrative privileges and object privileges. In SQL Server, you cannot directly add or delete system privileges; they are predefined by the system. However, you can grant or revoke them to users or roles.
There are two types of system privileges: administrative privileges and object privileges. In SQL Server, you cannot directly add or delete system privileges; they are predefined by the system. However, you can grant or revoke them to users or roles.
Ques:- How do you connect Power BI to different data sources
Asked In :-
Berger Paints, EpiSource, Talencia LLC, Nalsoft, Gallagher Offshore, Ulearn, think-cell, Amshuhu, Amul, ecolab,
Right Answer:
You can connect Power BI to different data sources by using the "Get Data" option in Power BI Desktop. From there, you can choose from various data source types such as Excel, SQL Server, SharePoint, Web, and many others. After selecting a data source, you will need to provide the necessary connection details and credentials to establish the connection.
You can connect Power BI to different data sources by using the "Get Data" option in Power BI Desktop. From there, you can choose from various data source types such as Excel, SQL Server, SharePoint, Web, and many others. After selecting a data source, you will need to provide the necessary connection details and credentials to establish the connection.
Ques:- What is Power BI and what are its main components
Asked In :-
C E I India, Amtex Software Solutions, Code Board Technology, EpiSource, Talencia LLC, Metrics4 Analytics, Thryve Digital, Gallagher Offshore, Propel Technology, Oakland Systems,
Right Answer:
Power BI is a business analytics tool by Microsoft that allows users to visualize data and share insights across their organization. Its main components are:
1. **Power BI Desktop** - A desktop application for creating reports and data visualizations.
2. **Power BI Service** - An online service for sharing and collaborating on reports and dashboards.
3. **Power BI Mobile** - Mobile applications for accessing reports and dashboards on smartphones and tablets.
4. **Power BI Gateway** - A bridge that facilitates secure data transfer between on-premises data sources and Power BI services.
5. **Power BI Report Server** - An on-premises server for hosting Power BI reports and traditional paginated reports.
Power BI is a business analytics tool by Microsoft that allows users to visualize data and share insights across their organization. Its main components are:
1. **Power BI Desktop** - A desktop application for creating reports and data visualizations.
2. **Power BI Service** - An online service for sharing and collaborating on reports and dashboards.
3. **Power BI Mobile** - Mobile applications for accessing reports and dashboards on smartphones and tablets.
4. **Power BI Gateway** - A bridge that facilitates secure data transfer between on-premises data sources and Power BI services.
5. **Power BI Report Server** - An on-premises server for hosting Power BI reports and traditional paginated reports.
Ques:- What are bookmarks in Power BI and how are they used
Asked In :-
EdgeVerve Systems, Berger Paints, Talencia LLC, ESAF Small Finance Bank, BluePi, C-Edge Technologies, Nalsoft, Vayavya Labs, BridgeLabz Solutions, Metrics4 Analytics,
Right Answer:
Bookmarks in Power BI are a feature that allows users to capture the current state of a report page, including filters, slicers, and visuals. They can be used to create a guided navigation experience, highlight specific insights, or save different views of the data for easy access later. Users can easily switch between bookmarks to present different perspectives of the data.
Bookmarks in Power BI are a feature that allows users to capture the current state of a report page, including filters, slicers, and visuals. They can be used to create a guided navigation experience, highlight specific insights, or save different views of the data for easy access later. Users can easily switch between bookmarks to present different perspectives of the data.
Ques:- What is the use of Power Query Editor in Power BI
Asked In :-
Velocity Software Solutions, ProMobi Technologies, PrimeSoft Solutions, Berger Paints, ESAF Small Finance Bank, Vayavya Labs, Konnect Insights, Relinns Technologies, Gallagher Offshore, Amshuhu,
Right Answer:
Power Query Editor in Power BI is used to connect to, transform, and clean data before loading it into the Power BI model. It allows users to perform data shaping tasks such as filtering, merging, and aggregating data.
Power Query Editor in Power BI is used to connect to, transform, and clean data before loading it into the Power BI model. It allows users to perform data shaping tasks such as filtering, merging, and aggregating data.
Ques:- What is the difference between import and direct query mode in Power BI
Asked In :-
C E I India, PrimeSoft Solutions, PreludeSys India, Code Board Technology, Amiti Software Technologies, ESAF Small Finance Bank, C-Edge Technologies, Nalsoft, Profound Edutech, Gallagher Offshore,
Right Answer:
In Power BI, Import mode loads data into the Power BI model, allowing for faster performance and advanced data modeling features, while DirectQuery mode connects directly to the data source, querying it in real-time without storing the data in Power BI, which can lead to slower performance but ensures the data is always up-to-date.
In Power BI, Import mode loads data into the Power BI model, allowing for faster performance and advanced data modeling features, while DirectQuery mode connects directly to the data source, querying it in real-time without storing the data in Power BI, which can lead to slower performance but ensures the data is always up-to-date.
