i
Kyzer Software
Filter interviews by
Clear (1)
A table with 3-4 columns is created to store and organize data in a structured manner.
Columns represent different attributes or properties of the data.
Each row in the table represents a unique record or entry.
Columns can have different data types such as text, numbers, dates, etc.
Primary key column can be used to uniquely identify each record.
Foreign key columns can establish relationships between tables.
Example: A tab...
To add a column without using create, you can use the ALTER TABLE statement.
Use the ALTER TABLE statement to add a new column to an existing table
Specify the table name and the new column name, data type, and any other constraints
Example: ALTER TABLE table_name ADD column_name data_type;
Tomcat server is a Java-based web server that is used to serve Java Servlets and JSP pages.
Tomcat is an open-source web server and servlet container
It is used to deploy Java web applications
It supports Java Servlet, JavaServer Pages (JSP), Java Expression Language (EL), and WebSocket technologies
It can be used as a standalone server or integrated with other web servers like Apache
It provides a web management interface
Views are virtual tables that are based on the result of a query. They provide a way to simplify complex queries and restrict access to data.
Views are created by selecting columns from one or more tables and can include joins, filters, and calculations.
Unlike tables, views do not store data physically, but rather retrieve it dynamically from the underlying tables.
Views can be used to present a subset of data to users, ...
Indices are values that point to specific data within a data structure. They are used to access and manipulate data efficiently.
Indices are commonly used in arrays to access specific elements.
They can also be used in databases to improve search performance.
Indices can be created on columns in a table to speed up queries.
In programming, indices are often used in loops to iterate over data structures.
Indices can also be ...
Left outer join is used to combine all rows from the left table with matching rows from the right table.
Use the LEFT JOIN keyword to perform a left outer join
The syntax is: SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name
If there is no match in the right table, NULL values are returned
Example: SELECT customers.name, orders.order_id FROM customers LEFT JOIN orders ON customer
OOP stands for Object-Oriented Programming, a programming paradigm that focuses on objects and their interactions.
OOP is based on the concept of classes and objects
It emphasizes encapsulation, inheritance, and polymorphism
Examples of OOP languages include Java, C++, and Python
Top trending discussions
I applied via Naukri.com and was interviewed in Feb 2021. There was 1 interview round.
posted on 20 Dec 2024
It was Easy to medium . overall good
It was Medium to tough level
FIFO (First In, First Out) and LIFO (Last In, First Out) are inventory management methods.
FIFO: Items that are added first are the first to be removed. Like a queue.
LIFO: Items that are added last are the first to be removed. Like a stack.
I would focus on improving access to quality education for all citizens.
Implementing policies to ensure equal opportunities for education
Investing in infrastructure and resources for schools in underserved areas
Providing scholarships and financial aid for students from low-income families
Promoting vocational training programs to address skills gaps in the workforce
I applied via Referral and was interviewed in Oct 2021. There were 4 interview rounds.
CGST stands for Central Goods and Services Tax.
CGST is a tax levied on the supply of goods and services within a state.
It is a part of the Goods and Services Tax (GST) system in India.
The revenue collected from CGST is shared between the central and state governments.
CGST rates vary depending on the type of goods or services being supplied.
For example, the CGST rate for essential goods like food items is lower than tha
Application Support Engineers are responsible for troubleshooting and resolving technical issues related to software applications.
Provide technical support to end-users and clients
Identify and resolve software bugs and errors
Collaborate with development teams to enhance application functionality
Document and maintain knowledge base articles for troubleshooting
Monitor application performance and identify areas for improv
posted on 18 Oct 2023
posted on 22 May 2024
I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.
posted on 30 Aug 2022
I applied via Approached by Company and was interviewed in Jul 2022. There were 2 interview rounds.
SQL is a database language used to manage data. Unix is an operating system used for servers and workstations.
SQL is used to create, modify, and query databases.
Unix is a command-line interface used for file management, process control, and networking.
SQL can be used with various database management systems like MySQL, Oracle, and SQL Server.
Unix commands include ls, cd, grep, and chmod.
SQL and Unix are commonly used i
Commonly used Unix commands
ls - list directory contents
cd - change directory
mkdir - make directory
rm - remove files or directories
cp - copy files or directories
mv - move or rename files or directories
grep - search for patterns in files
cat - concatenate and display files
chmod - change file permissions
ssh - secure shell remote login
I will investigate the root cause of the slow performance and take appropriate actions.
Check server resources usage
Analyze application logs
Identify bottleneck areas
Optimize database queries
Implement caching mechanisms
Upgrade hardware or software if necessary
Common SQL commands for data manipulation and retrieval
SELECT - retrieve data from a table
INSERT - insert data into a table
UPDATE - update existing data in a table
DELETE - delete data from a table
CREATE - create a new table or database
ALTER - modify the structure of a table
DROP - delete a table or database
JOIN - combine data from multiple tables
GROUP BY - group data based on a specific column
ORDER BY - sort data based
I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.
based on 1 review
Rating in categories
Software Developer
23
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
20
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Tester
7
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech