Trsiol Red Group of Companies Sales and Business Development Intern Interview Questions and Answers

Q1. Difference between Inner, outer joins
Ans. 
Inner join returns only the matching rows between two tables, while outer join returns all rows from one table and matching rows from the other.
• Inner join: returns rows that have matching values in both tables

• Outer join: returns all rows from one table and matching rows from the other

• Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example: Outer join - SELECT * FROM table1 LEFT OUTE
Answered by AI
Add your answer
Q2. Difference between full join and union
Ans. 
Full join combines rows from both tables, including unmatched rows. Union combines rows from both tables, excluding duplicates.
• Full join includes all rows from both tables, filling in NULL values for unmatched rows.

• Union combines rows from both tables, excluding duplicates.

• Example: SELECT * FROM table1 FULL JOIN table2 ON table1.id = table2.id;

• Example: SELECT * FROM table1 UNION SELECT * FROM table2;
Answered by AI
Add your answer
Q3. About Copy activity
Add your answer
Q4. About select transformation
Add your answer
Q5. About join transformation and scd type 1
Add your answer

Q1. About your self
Add your answer
Q2. Regarding sales
Add your answer
Q3. If we will hire you you will be able work long shift
Ans. 
Yes, I am willing and able to work long shifts to meet the needs of the business.
• I am committed to meeting the demands of the job and am willing to work long hours when necessary.

• I understand the importance of flexibility in business development roles and am prepared to adjust my schedule accordingly.

• I have previous experience working long shifts in high-pressure environments and have proven my ability to perform well
Answered by AI
Add your answer

Q1. How to convence the parents
Ans. 
Convince parents by highlighting benefits, addressing concerns, and providing evidence.
• Highlight the benefits of the decision, such as potential career growth or financial stability.

• Address any concerns the parents may have, such as job security or work-life balance.

• Provide evidence to support your argument, such as successful track record or testimonials from others.

• Listen to their perspective and try to understand th...read more
Answered by AI
Add your answer
Q2. Tell me about sell sop
Ans. 
A sell sop is a sales technique used to persuade customers to make a purchase by highlighting the benefits and features of a product or service.
• Sell sop involves identifying customer needs and demonstrating how the product or service can meet those needs.

• It often includes creating a sense of urgency or scarcity to encourage immediate action.

• Effective sell sop also involves building rapport with customers and addressing...read more
Answered by AI
Add your answer

Easy to clear and should be confident

Easy to clear and should be worked on it

Q1. What is the best memory of the volunteers in the ngo
Add your answer
Q2. DBMS question and the SQL and python
Add your answer

Q1. What is cloud,DB
Ans. 
Cloud DB refers to a database that is hosted on a cloud computing platform, allowing for remote access and scalability.
• Cloud DB stores data on remote servers accessed over the internet

• It offers scalability, flexibility, and cost-effectiveness

• Examples include Amazon RDS, Google Cloud SQL, and Microsoft Azure SQL Database
Answered by AI
Add your answer
Q2. What is cyber security
Ans. 
Cyber security refers to the practice of protecting systems, networks, and data from digital attacks.
• Involves protecting computers, servers, mobile devices, electronic systems, networks, and data from malicious attacks

• Includes measures such as firewalls, encryption, antivirus software, and user authentication

• Cyber security professionals work to prevent, detect, and respond to cyber threats

• Examples of cyber attacks incl...read more
Answered by AI
Add your answer

Q1. Database based questions
Add your answer
Q2. Dashboard creative
Add your answer
Q3. Power BI module
Add your answer

Q1. Project discussion
Add your answer
Q2. Self introduction
Add your answer

Q1. Mostly asked java 8 update and distinct number in given array and Multithreading
Add your answer
Q2. 2 program based on java 8, array reverse
Add your answer

1 hour discussion on various topics

Q1. Tell me about yourself
Add your answer
Q2. About company, why this role
Add your answer

Q1. Same as 1st round
Add your answer

Q1. What is the Java code for comparing two strings for equality?
Ans. 
Use the equals() method in Java to compare two strings for equality.
• Use the equals() method to compare two strings for equality.

• Example: String str1 = "hello"; String str2 = "hello"; if(str1.equals(str2)) { // strings are equal }
Answered by AI
Add your answer