PNJ Sharptech Web Development Intern Interview Questions and Answers

Q1. There was two round of Technical Interview and My Interview had on PHP & MySQL. - They have asked me about PHP OOP Concept. - They Have asked difference between Authentication and Authorization - They have...read more
Add your answer
Q2. After Clear two round of technical discussion there was an HR round
Add your answer

Q1. This round was held with Project Manager with the knowledge of PHP tech stack again and project discussion.
Add your answer
Q2. After clear these two round HR round was there where they have discussed with Salary and offer letter etc.
Add your answer

Q1. Are you comfortable to change the job profile from frontend to backend
Add your answer
Q2. Can you relocate to kolkata?
Add your answer

Mathematics, English

Q1. Project work- Libraries used
Ans. 
I have experience using various libraries such as React, Redux, and Express in my project work.
• React

• Redux

• Express
Answered by AI
Add your answer

Q1. PHP baisc questions
Add your answer

Q1. What's charecteristics of oops?
Ans. 
Characteristics of OOP include encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Inheritance: Ability to create new classes based on existing classes.

• Polymorphism: Ability to use a single interface for different data types or classes.

• Abstraction: Hiding the implementation details and showing only the necessary features.
Answered by AI
Add your answer
Q2. Diffrence between dynamic and object?
Ans. 
Dynamic refers to runtime behavior while object refers to a specific instance of a class.
• Dynamic behavior is determined at runtime, while objects are instances of classes

• Dynamic programming languages allow for dynamic behavior, while objects are static entities

• Examples: In Python, dynamic behavior can be seen with dynamic typing, while objects are created using classes and instantiated as objects
Answered by AI
Add your answer
Q3. What is finilize and compose.
Ans. 
finalize and compose are methods used in software development to manage resources and create complex objects.
• finalize is a method in Java used for cleanup operations before an object is garbage collected

• compose is a design pattern where objects are combined to create a more complex object

• finalize is discouraged to be used in modern Java due to unpredictability
Answered by AI
Add your answer
Q4. What is indexs?
Ans. 
Indexes are data structures that improve the speed of data retrieval operations in databases.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on columns in a database table to speed up the data retrieval process.

• Examples of indexes include primary keys, unique keys, and non-unique keys.
Answered by AI
Add your answer
Q5. How to delete duplicate records from sql.
Ans. 
Use a SQL query with a GROUP BY clause to delete duplicate records.
• Use a SELECT statement with a GROUP BY clause to identify the duplicate records.

• Use the DELETE statement with a subquery to delete the duplicate records.

• Make sure to keep the record with the lowest ID or timestamp if needed.
Answered by AI
Add your answer
Q6. What is the difference between views and temp table?
Ans. 
Views are virtual tables generated from a query, while temp tables are physical tables stored in tempdb for temporary use.
• Views are saved queries that act as virtual tables, while temp tables are physical tables stored in tempdb.

• Views are not stored physically on disk, while temp tables are stored in tempdb.

• Views are used for simplifying complex queries and providing security, while temp tables are used for storing tem...read more
Answered by AI
Add your answer

Basic aptitude test with reasonings

DSA related coding probleme

Q1. Questions regarding Sql, c, html css and basic coding optimisation
Add your answer
Q2. What is join in sql?
Ans. 
Join in SQL is used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q3. How many types of join?
Ans. 
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
• INNER JOIN: Returns rows when there is at least one match in both tables.

• LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.

• RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.

• FULL JOIN: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer
Q4. Html page starts with which tag?
Ans. 
Html page starts with the <html> tag.
• Html page starts with the <html> tag.

• The <html> tag defines the root of an HTML document.

• All other HTML elements must be nested inside the <html> tag.
Answered by AI
Add your answer

Q1. Simple discussion about yourself and future in organization
Add your answer