Pragmatic Play SQL Developer Interview Questions and Answers

Q1. Difference between delete and truncate
Ans. 
Delete removes specific rows from a table, while truncate removes all rows from a table.
• Delete is a DML command, while truncate is a DDL command.

• Delete is slower as it logs individual row deletions, while truncate is faster as it deallocates the data pages.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete can have a WHERE clause to specify conditions, while truncate removes all rows without any con...read more
Answered by AI
View 1 more answer

Q1. What is identify property
Ans. 
Identity property is used in SQL to automatically generate unique values for a column.
• Identity property is used to create an auto-incrementing column in a table.

• It is commonly used as a primary key in a table.

• The identity property can be applied to numeric data types such as INT, BIGINT, etc.

• The identity value starts from a seed value and increments by a specified increment value.

• Example: CREATE TABLE Employees (ID INT
Answered by AI
View 1 more answer
Q2. What is synonyms what is use of it?
Ans. 
Synonyms are database objects that allow users to create aliases for other database objects.
• Synonyms can be used to simplify complex queries by providing a shorter name for a table or view.

• They can also be used to provide a layer of abstraction between the user and the underlying database objects.

• Synonyms can be created for tables, views, stored procedures, and other database objects.

• They can be used to reference objec...read more
Answered by AI
Add your answer

Q1. What is index what is use off it
Ans. 
An index is a database object that improves the speed of data retrieval operations on a table.
• Indexes are used to quickly locate data without having to search every row in a table.

• They are created on one or more columns of a table.

• Indexes can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes are separate structures that contain a copy of the indexed co...read more
Answered by AI
Add your answer

Q1. What is difference between tempory table and table variable
Ans. 
Temporary tables are stored in tempdb while table variables are stored in memory.
• Temporary tables are created using CREATE TABLE statement while table variables are declared using DECLARE statement.

• Temporary tables can be accessed across sessions while table variables are limited to the scope of the batch, stored procedure or function.

• Temporary tables can have indexes and constraints while table variables cannot.

• Tempor...read more
Answered by AI
Add your answer

Q1. What is synonyms what is use off it
Ans. 
Synonyms are alternate names for database objects. They are used to simplify queries and provide security.
• Synonyms are used to provide an alternate name for a database object such as a table, view, stored procedure, or function.

• They can simplify queries by providing a shorter or more meaningful name for an object.

• Synonyms can also be used to provide security by allowing users to access an object without knowing its act...read more
Answered by AI
Add your answer

Q1. Total subject about sql and power bi
Add your answer

Q1. How does the virtual DOM improve performance?
Add your answer
Q2. It minimize direct DOM updates, reducing reflows are repaints.
Add your answer

Q1. They ask me about my previous job description details and education details
Add your answer
Q2. About carrier goals
Add your answer
Q3. About my responsibility in side the current company
Add your answer

Q1. They ask me about core concept of react js and next js
Add your answer
Q2. Ask me about core concepts of mongo Db and Node js
Add your answer

Q1. They told me about company curriculum, goals and ethics
Add your answer

Q1. Coding question related to js
Add your answer
Q2. Basic theory questions of js
Add your answer

1st round was aptitude round average level of question

2nd round was coding round and the level of question were easy to hard

Q1. Tell me about yourself
Ans. 
I am a front end developer with 5 years of experience in creating user-friendly and visually appealing websites.
• 5 years of experience in front end development

• Proficient in HTML, CSS, and JavaScript

• Strong understanding of responsive design principles

• Experience with front end frameworks like React and Angular

• Ability to collaborate with designers and backend developers to implement website features

• Portfolio showcasing pre
Answered by AI
Add your answer
Q2. Why do you want to join Webdew
Ans. 
I want to join Webdew because of their reputation for innovative web development and their focus on creating user-friendly experiences.
• Webdew has a strong track record of delivering cutting-edge web development projects.

• I am impressed by their portfolio of user-friendly websites and applications.

• I believe joining Webdew will provide me with opportunities to learn and grow as a front-end developer.

• Their company culture ...read more
Answered by AI
Add your answer
Q3. What were your day-to-day responsibilities at your last job?
Ans. 
As a front end developer, my day-to-day responsibilities at my last job included designing and developing user interfaces, collaborating with the design team, and ensuring cross-browser compatibility.
• Designing and developing user interfaces

• Collaborating with the design team

• Ensuring cross-browser compatibility
Answered by AI
Add your answer

Q1. What are hooks in WordPress and what type hooks available?
Ans. 
Hooks in WordPress are functions that allow developers to modify the behavior of WordPress core, themes, and plugins.
• There are two types of hooks: action hooks and filter hooks.

• Action hooks allow developers to execute code at specific points in the WordPress core, themes, and plugins.

• Filter hooks allow developers to modify data before it is displayed to the user.

• Examples of hooks include 'wp_head', 'wp_footer', and 'th
Answered by AI
Add your answer
Q2. What you will do if website gets hacked?
Ans. 
I will immediately take the website offline and assess the damage. Then I will work on fixing the vulnerabilities and restoring the website.
• Take the website offline

• Assess the damage

• Identify the vulnerabilities

• Fix the vulnerabilities

• Restore the website

• Implement security measures to prevent future attacks
Answered by AI
Add your answer