Ques:- When do we use the UPDATE_STATISTICS command?
Asked In :-
CAP Digisoft Solutions, de facto infotech, Network Labs, QSpiders, Tecnotree, Azuga, OfBusiness, London Stock Exchange Group, MedSpecialized, CETAS Information Technology,
Ques:- How to check the structure of Table and Stored Procedure with the help of query?
Asked In :-
Shipmnts, Artech Infosystems, PrimeSoft Solutions, StockEdge, Surya Software, SRF, ANZ Bank, Abzooba India Infotech, Headrun Technologies, SNB,
Ques:- Provide all the built in string function of SQL SERVER
Asked In :-
LiteBreeze Infotech, EdgeVerve Systems, FUTURISM TECHNOLOGIES PVT, Ramboll India, Gainers Infotech, WebMobril Technologies, Streebo Solutions, Sterling Software (India), Analyttica Datalab, Kendo,
Right Answer:
Here are the built-in string functions in SQL Server:
1. LEN()
2. DATALENGTH()
3. UPPER()
4. LOWER()
5. SUBSTRING()
6. CHARINDEX()
7. REPLACE()
8. RTRIM()
9. LTRIM()
10. CONCAT()
11. LEFT()
12. RIGHT()
13. FORMAT()
14. STUFF()
15. REVERSE()
16. SPACE()
17. STRING_AGG() (SQL Server 2017 and later)
18. PATINDEX()
19. NCHAR()
20. CHAR()
These functions can be used for various string manipulations and operations.
Here are the built-in string functions in SQL Server:
1. LEN()
2. DATALENGTH()
3. UPPER()
4. LOWER()
5. SUBSTRING()
6. CHARINDEX()
7. REPLACE()
8. RTRIM()
9. LTRIM()
10. CONCAT()
11. LEFT()
12. RIGHT()
13. FORMAT()
14. STUFF()
15. REVERSE()
16. SPACE()
17. STRING_AGG() (SQL Server 2017 and later)
18. PATINDEX()
19. NCHAR()
20. CHAR()
These functions can be used for various string manipulations and operations.
Ques:- How has the company helped you achieve your career goals?
Asked In :-
DREAMORBIT SOFTECH PVT, E2E Research, Isolve Technologies, Invimatic, Caliber Technologies, Infiniti Software Solutions, Odessa Technologies, Renault Nissan, Unilogic Software, Nalsoft,
Right Answer:
The company has provided me with opportunities for professional development, mentorship, and access to training resources, which have helped me enhance my skills and advance my career.
The company has provided me with opportunities for professional development, mentorship, and access to training resources, which have helped me enhance my skills and advance my career.
Ques:- Tell the difference between Union and UnionAll in Sql Server?
Asked In :-
Sardonyx Technologies, BillDesk, PEOL, DataMetica, Tecnotree, Shadowfax Technologies, SoftNice, Digital Harbor, PRGX Global, Spoors Technology Solutions India,
Ques:- What is the difference between deep and shallow copy?
Asked In :-
Emtec Technologies, Grapelime Infotech, HashRoot Technologies, Nagarro Software, ISC Software, Indium Software, Carisma Solutions, Elait, Entropik Tech, playstation,
Comments
• Shallow copy is used when a new instance type gets created and it keeps the values that are copied in the new instance. Whereas, deep copy is used to store the values that are already copied.
• Shallow copy is used to copy the reference pointers just like it copies the values. These references point to the original objects and the changes made in any member of the class will also affect the original copy of it. Whereas, deep copy doesn’t copy the reference pointers to the objects. Deep copy makes the reference to an object and the new object that is pointed by some other object gets stored. The changes made in the original copy won’t affect any other copy that uses the object.
• Shallow copy allows faster execution of the program and it depends on the size of the data that is used. Whereas, deep copy makes it slower due to making certain copies for each object that is been called.
Ques:- How do I create a multidimensional list?
Asked In :-
Bit Canny Technologies, Mobio Solutions, HashRoot Technologies, Infometry, Cloud Analogy, Systenics Solutions, VectoScalar Technologies, Intello Labs, Testpress, DATAZOIC MACHINES,
Ques:- How is memory managed in python?
Asked In :-
AnAr Solutions, Feathersoft Info Solutions, Twilio, Blackcoffer, Nova Solutions, Nuware Systems, Nalsoft, TSS Consultancy, Beautiful Code, KeyValue Software Systems,
Comments
Memory management in Python involves a private heap containing all Python objects and data structures. Interpreter takes care of Python heap and that the programmer has no access to it.
The allocation of heap space for Python objects is done by Python memory manager. The core API of Python provides some tools for the programmer to code reliable and more robust program.
Python also has a build-in garbage collector which recycles all the unused memory. When an object is no longer referenced by the program, the heap space it occupies can be freed. The garbage collector determines objects which are no longer referenced by the sprogram frees the occupied memory and make it available to the heap space.
The gc module defines functions to enable /disable garbage collector:
gc.enable() -Enables automatic garbage collection.
gc.disable() - Disables automatic garbage collection.
Ques:- How you are testing your application?
Asked In :-
Happiest Minds Technologies Pvt., Mobio Solutions, SOFTWAREGEN TECHNOLOGIES, INATECH INFOSOLUTIONS, Code Board Technology, WAEC, Cron-J, MountBlue Technologies, ITH Technologies (Infotech HUB), Zalando,
Right Answer:
I test my Django application using a combination of unit tests, integration tests, and functional tests. I utilize Django's built-in testing framework, which allows me to write test cases for models, views, and forms. Additionally, I use tools like pytest for more advanced testing features and coverage reports. For end-to-end testing, I may use Selenium or Django's test client to simulate user interactions.
I test my Django application using a combination of unit tests, integration tests, and functional tests. I utilize Django's built-in testing framework, which allows me to write test cases for models, views, and forms. Additionally, I use tools like pytest for more advanced testing features and coverage reports. For end-to-end testing, I may use Selenium or Django's test client to simulate user interactions.
Ques:- Types of Session handling methods in Django?
Asked In :-
Mundrisoft Solutions LLP, Amtex Software Solutions, LAP, OCCL, Thrillophilia, Freshworks, Sion Semiconductors, Volansys, Mantra Softech, Ulearn,
Right Answer:
Django supports several session handling methods:
1. **Database-backed sessions**: Stores session data in the database.
2. **Cached sessions**: Stores session data in the cache.
3. **File-based sessions**: Stores session data in files on the server.
4. **Cookie-based sessions**: Stores session data directly in cookies on the client side.
5. **In-memory sessions**: Stores session data in memory (not persistent).
These methods can be configured in the Django settings.
Django supports several session handling methods:
1. **Database-backed sessions**: Stores session data in the database.
2. **Cached sessions**: Stores session data in the cache.
3. **File-based sessions**: Stores session data in files on the server.
4. **Cookie-based sessions**: Stores session data directly in cookies on the client side.
5. **In-memory sessions**: Stores session data in memory (not persistent).
These methods can be configured in the Django settings.
Ques:- How to assign a macro value to a variable?
Asked In :-
Creditsafe Technology, ICPS, Winjit Technologies, sirius computer solutions, bse, accenture software for p&c insurance,
Ques:- What are the Different Data Providers support in WebIntelligence and DeskTop Intelligence?
Asked In :-
Highbar Technocrat, Data Patterns, Jp Morgan Chase, sirius computer solutions, rategain, hevo,
Ques:- Have you been involved in editing the data or writing data queries?
Asked In :-
Exusia, Accelya, Harris Global Enterprise, IOOF, corelogic, sirius computer solutions, norges bank investment management, thescore, inc., neebal technologies, applied data finance,
Ques:- Can you excute a macro within a macro? Describe.
Asked In :-
CIGNEX Datamatics Technologies, Creditsafe Technology, KBRA, Keyrus Group, Real Fruit Bubble Tea, TekFriday Processing Solutions, Bio-Reference Labs, webhelp, sirius computer solutions, mcap,
Right Answer:
Yes, you can execute a macro within another macro in most programming environments that support macros, such as VBA in Excel. This is done by simply calling the inner macro by its name within the outer macro's code.
Yes, you can execute a macro within another macro in most programming environments that support macros, such as VBA in Excel. This is done by simply calling the inner macro by its name within the outer macro's code.
Ques:- What are the new features included in the new version of SAS i.e., SAS9.1.3?
Asked In :-
Tatvic Analytics, Jiva Ayurveda, Perceptive Analytics, First Insight, Clarivate, Washington DC Government, equifax, sirius computer solutions, mcap, datavail,
Right Answer:
SAS 9.1.3 introduced several new features, including enhanced data integration capabilities, improved support for web-based applications, new statistical procedures, better performance for large data sets, and enhanced tools for data visualization and reporting.
SAS 9.1.3 introduced several new features, including enhanced data integration capabilities, improved support for web-based applications, new statistical procedures, better performance for large data sets, and enhanced tools for data visualization and reporting.
Ques:- A steel company in was experiencing large amounts of inventory and customers which complained about long wait times for orders. Company used to have a monopoly however deregulation had allowed for competition starting 10 years ago and the firm now had 40% market share. Firm had four plants, two made mostly flat steel products and two made pipe like steel products. For all plants half the products were specialized and half were standard. What should be done to solve the problems?
Asked In :-
Fluid AI, Ziffity Solutions, Aranca (Mumbai), SmartData Enterprises, SysTrack Solution, Triassic Solutions, Wellness Forever, Lucid Imaging, Pi Techniques, Cyber Infrastructure (P),
Right Answer:
The company should implement a demand forecasting system to better align production with customer needs, streamline operations to reduce lead times, improve inventory management to minimize excess stock, and enhance customer service to address complaints. Additionally, consider investing in technology to increase efficiency and exploring partnerships or collaborations to improve market competitiveness.
The company should implement a demand forecasting system to better align production with customer needs, streamline operations to reduce lead times, improve inventory management to minimize excess stock, and enhance customer service to address complaints. Additionally, consider investing in technology to increase efficiency and exploring partnerships or collaborations to improve market competitiveness.
Ques:- What will you do when client is asking you to provide something which has no meaning?
Asked In :-
Unyscape Infocom Pvt. Ltd., DREAMORBIT SOFTECH PVT, MattsenKumar Services, LiteBreeze Infotech, Energytech Global, Razorpay-Startup, Softcell Technologies, Big Rattle Technologies, Rits Software, Zyoin Web Pvt.,
Right Answer:
I would ask the client for clarification on their request, explain why it may not have meaning, and suggest alternative solutions that align with their goals.
I would ask the client for clarification on their request, explain why it may not have meaning, and suggest alternative solutions that align with their goals.
Ques:- A channel partner in the trucking industry is facing declining porfits, and they have already determined that their cost structure is comparable to competitors. What is the problem?
Asked In :-
Vinove Software & Services Pvt Ltd, Hidden Brains InfoTech, STIC SOFT E-SOLUTIONS, FIS Global Business Solutions India, SysTrack Solution, MBR Informatics, MedGenome Labs, Zyoin Web Pvt., Raykor Technologies, Mindcurv Technology Solutions,
Right Answer:
The problem may be related to revenue generation, such as lower sales volume, pricing issues, or lack of differentiation in services compared to competitors.
The problem may be related to revenue generation, such as lower sales volume, pricing issues, or lack of differentiation in services compared to competitors.
Ques:- Please estimate the total revenue of [a particular juice brand] from the Swedish market who has a 10% market share. You have 5 minutes?
Asked In :-
WSNE Consulting, STIC SOFT E-SOLUTIONS, Indocosmo Systems, Dhruvsoft Services, Infinity Labs LLP, Cloud Kinetics Technology Solutions, Principal Global Services, COEPD, Sify Technologies, Technostacks Infotech,
Right Answer:
To estimate the total revenue of the juice brand in the Swedish market, you need to know the total market size for juice in Sweden. If we assume the total market size is, for example, 1 billion SEK, then with a 10% market share, the revenue would be 100 million SEK. Please replace the market size with the actual figure if known.
To estimate the total revenue of the juice brand in the Swedish market, you need to know the total market size for juice in Sweden. If we assume the total market size is, for example, 1 billion SEK, then with a 10% market share, the revenue would be 100 million SEK. Please replace the market size with the actual figure if known.
Ques:- A leverage buyout firm is considering buying a company that owns proprietary database of real time Federal Aviation Administration database on every commercial flight in America and its current flight status. Should they buy the company?
Asked In :-
Object Frontier Software, Protege Solutions, Toxsl Technologies, Infinity Labs LLP, WFM, Codebox, Media Agility, Technonix Infosystem, EduGorilla, Rudder Analytics,
Right Answer:
Yes, they should consider buying the company if the database provides valuable insights, has a competitive advantage, and can generate revenue through licensing or services.
Yes, they should consider buying the company if the database provides valuable insights, has a competitive advantage, and can generate revenue through licensing or services.
Sirius Computer Solutions is a leading IT solutions and services provider, specializing in helping organizations of all sizes to design, implement, and manage their IT infrastructure. With a focus on delivering innovative technology solutions, Sirius has established itself as a trusted partner for businesses seeking to optimize their operations and drive growth through technology.
Founded in 1980, Sirius has since grown into one of the largest IT solution integrators in the United States, serving clients across various industries, including healthcare, finance, retail, government, and education. The company offers a comprehensive suite of services, including infrastructure and operations, data management and analytics, security, cloud computing, and application development.
One of Sirius' key strengths is its team of highly skilled engineers and consultants who possess deep expertise in a wide range of technologies and platforms. This allows Sirius to deliver tailored solutions that address each client's unique business needs and challenges.
Sirius is also known for its partnerships with leading technology vendors, including IBM, Cisco, Microsoft, and Dell Technologies, among others. These partnerships enable Sirius to offer best-in-class products and services to its clients, ensuring that they have access to the latest innovations and solutions in the industry.
Overall, Sirius Computer Solutions has built a reputation for delivering exceptional value to its clients through its combination of industry-leading expertise, innovative solutions, and strong partnerships. As businesses continue to navigate the complexities of the digital age, Sirius remains committed to helping them leverage technology to achieve their goals and stay ahead of the competition.
