Filter interviews by
I applied via Company Website and was interviewed in Dec 2021. There was 1 interview round.
Updating customer table
Use UPDATE statement with SET clause to update table
Specify the column to be updated and the new value
Use WHERE clause to specify the condition for updating specific rows
To delete customer table, use DROP TABLE statement.
Use DROP TABLE statement followed by table name to delete the table.
Make sure to take backup of the table before deleting it.
Ensure that there are no dependencies on the table before deleting it.
Creating customer table in SQL
Define the table structure with appropriate data types for each column
Include columns for customer ID, name, address, email, phone number, etc.
Set appropriate constraints such as primary key, unique, not null, etc.
Consider adding additional columns for date of birth, gender, etc. if required
Create indexes on frequently queried columns for better performance
Triggers are special types of stored procedures that are automatically executed in response to certain events.
Triggers are used to enforce business rules or to perform complex calculations that involve multiple tables.
They can be used to audit changes to data, or to replicate data across multiple tables.
Triggers can be defined to execute before or after an INSERT, UPDATE, or DELETE statement.
They can also be defined to...
Cursors are used to retrieve data from a result set one row at a time.
Cursors are used when we need to perform operations on individual rows of a result set.
They are declared, opened, fetched, and closed.
They can be used to update or delete data in a table.
They can be slow and memory-intensive, so should be used sparingly.
Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;
Example: OPEN cursor_name; FETCH ...
Joins are used to combine data from two or more tables based on a related column.
Types of joins: inner, left, right, full outer
Syntax: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
Can also use aliases for table names and columns
Joins can be nested or chained together
Indexes are used to improve the performance of SQL queries by reducing the time taken to retrieve data.
Indexes are created on one or more columns of a table.
They can be clustered or non-clustered.
Clustered indexes determine the physical order of data in a table.
Non-clustered indexes create a separate structure to hold the indexed data.
Indexes should be used judiciously as they can slow down data modification operations
Subsets of SQL are different types of SQL languages used for specific purposes.
Data Definition Language (DDL) - used to define database schema
Data Manipulation Language (DML) - used to manipulate data in database
Data Control Language (DCL) - used to control access to database
Transaction Control Language (TCL) - used to manage transactions
Examples: CREATE, SELECT, INSERT, UPDATE, DELETE, GRANT, REVOKE, COMMIT, ROLLBACK
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
There are different levels of normalization, with each level having specific rules to follow.
Normalization helps to prevent data inconsistencies and anomalies.
Example: A customer table can be normalized into...
Types of joins in SQL are Inner Join, Left Join, Right Join, Full Outer Join, Cross Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables.
Cross Join returns the Cartesian produc
I applied via Company Website and was interviewed in Dec 2021. There was 1 interview round.
To update customer table, use UPDATE statement with SET clause and WHERE clause.
Use UPDATE statement to modify data in customer table
Use SET clause to specify the columns to be updated and their new values
Use WHERE clause to specify the rows to be updated based on a condition
Example: UPDATE customer SET name='John Doe' WHERE id=1
To delete customer table in SQL, use the DROP TABLE command.
Use the DROP TABLE command followed by the table name.
Make sure to backup the data before deleting the table.
Ensure that there are no dependencies on the table before deleting it.
To create a customer table, define columns for customer information and set primary key.
Define columns for customer information such as name, address, phone number, email, etc.
Set primary key for unique identification of each customer.
Consider adding constraints for data validation and normalization.
Example: CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(50), address VARCHAR(100), phone VARCHAR(20), email VAR
Triggers are special types of stored procedures that are automatically executed in response to certain events.
Triggers are used to enforce business rules or data integrity.
They can be used to audit changes to data.
Triggers can be defined to execute before or after a data modification statement.
They can be defined at the table or schema level.
Examples include: enforcing referential integrity, logging changes to a table,
Cursors are used to retrieve data row by row from a result set.
Cursors are used when we need to perform operations on individual rows.
They are declared, opened, fetched, and closed.
They can be used to iterate through a result set.
They can be static, dynamic, or forward-only.
Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;
Example: OPEN cursor_name; FETCH NEXT FROM cursor_name INTO @variable;
Example: CLO
Joins are used to combine data from two or more tables based on a related column.
Types of joins: inner, left, right, full outer
Syntax: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
Can also use aliases for table names and columns
Joins can be nested or chained together
Indexes are used to improve the performance of SQL queries by allowing faster data retrieval.
Indexes are created on one or more columns of a table.
They can be clustered or non-clustered.
Clustered indexes determine the physical order of data in a table.
Non-clustered indexes create a separate structure to hold the index data.
Indexes should be used judiciously as they can slow down data modification operations.
Subsets of SQL are subsets of SQL language that are used for specific purposes.
Common subsets include DDL, DML, DCL, and TCL
DDL (Data Definition Language) is used to define database schema
DML (Data Manipulation Language) is used to manipulate data in the database
DCL (Data Control Language) is used to control access to the database
TCL (Transaction Control Language) is used to manage transactions
Other subsets include DQL...
Normalization is the process of organizing data in a database to reduce redundancy and dependency.
Normalization is divided into several normal forms (1NF, 2NF, 3NF, etc.)
Each normal form has a set of rules that must be followed to achieve it
Normalization helps to improve data consistency, reduce data redundancy, and improve database performance
Example: A customer table should not contain order details, instead, it shou...
Types of joins in SQL are Inner Join, Left Join, Right Join, and Full Outer Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables.
Joining tables using a common column is the mos
I applied via Company Website and was interviewed in Jun 2021. There was 1 interview round.
Typing is the act of inputting text by pressing keys on a keyboard or other input device.
Typing involves using a keyboard or input device to enter text.
It is a fundamental skill for computer users and is used for various purposes such as writing documents, sending emails, and chatting.
Typing speed and accuracy are important factors in productivity and efficiency.
Examples of typing include composing an email, writing a
Top trending discussions
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by eliminating duplicate data
Normalization ensures data integrity by enforcing relationships between tables
There are different normal forms such as 1NF, 2NF, 3NF, and BCNF
Indexing is a technique used to improve the performance of database queries by creating a data structure that allows for faster retrieval of data.
Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.
They work similar to an index in a book, allowing the database to quickly locate the rows that satisfy a query.
Examples of indexes include primary keys, unique
I applied via Naukri.com
I applied via Referral and was interviewed before Mar 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed in Dec 2021. There were 2 interview rounds.
SQL is a language used to manage data in relational databases. It has different types of statements to manipulate data.
SQL has Data Definition Language (DDL) statements to create, modify, and delete database objects.
SQL has Data Manipulation Language (DML) statements to insert, update, and delete data in tables.
SQL has Data Control Language (DCL) statements to grant or revoke access to database objects.
SQL has Transact...
SQL commands are used to manipulate and retrieve data from relational databases.
SELECT statement is used to retrieve data from a table
INSERT statement is used to insert data into a table
UPDATE statement is used to update existing data in a table
DELETE statement is used to delete data from a table
CREATE statement is used to create a new table
ALTER statement is used to modify an existing table
JOIN statement is used to co...
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered indexes physically reorder the data in the table based on the index key.
Non-clustered indexes create a separate structure for the index, pointing back to the original table data.
Unique indexes ensure that no two rows have the same values in the indexed columns.
Composite indexes are created on multiple columns to improve...
I was interviewed in Sep 2016.
Developed a web application for tracking student attendance and performance
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express for back-end
Utilized MongoDB for database storage
Integrated authentication and authorization features for secure access
based on 10 reviews
Rating in categories
Software Engineer
14
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
12
salaries
| ₹0 L/yr - ₹0 L/yr |
UI Developer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
SQL Developer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
Teleperformance
iEnergizer
Reliance Retail