Skills and Position Requirement:
- 4+ years of Software Development Experience
- 4+ years of programming experience in an OO language (Java)
- 2+ years of SQL experience in Oracle or SQL Server
- Ability to write SQL stored procedures, analyze queries and optimize queries
- Ability to understand business processes and data and translate them into reports
- Agile experience (e.g. Scrum, RUP, Kanban)
- Excellent critical thinking & troubleshooting skills, ability to find and solve root causes of problems amid "noise"
- Must be comfortable and eager to perform tasks in all phases of the software lifecycle (e.g., requirements analysis, design/development/test)
- Object-Oriented design experience using common software design patterns
- Experience with unit testing, and automated testing frameworks
- Ability to work on an agile team or in an agile environment
- Good Communication skills: ability to communicate with others to receive requirements and clarifications and to convey progress and/or issues
Please find the list of SQL questions.
Question #1) What is SQL?
Structured Query Language is a database tool which is used to create and an access database to support software application.
Question #2) What are tables in SQL?
The table is a collection of record and its information at a single view.
Question #4) How do we use DISTINCT statement? What is its use?
The DISTINCT statement is used with the SELECT statement. If the records contain duplicate values then DISTINCT is used to select different values among duplicate records.
Question #5) What is Unique Key?
The unique key is nothing but the columns which are uniquely identifies the values. There are more than one unique keys for each table. The Entry of Null value is allowed in Unique key.
Question #6) What are the different types of SQL commands?
SQL commands are segregated into the following types:
- DDL – Data Definition Language
- DML – Data Manipulation Language
- DQL – Data Query Language
- DCL – Data Control Language
- TCL – Transaction Control Language
Question #7) What are the different DDL commands in SQL?
DDL commands are used to define or alter the structure of the database.
- CREATE: To create databases and database objects
- ALTER: To alter existing database objects
- DROP: To drop databases and databases objects
- TRUNCATE: To remove all records from a table but not its database structure
- RENAME: To rename database objects
Question #8) What are the different DML commands in SQL?
DML commands are used for managing data present in the database.
- SELECT: To select specific data from a database
- INSERT: To insert new records into a table
- UPDATE: To update existing records
- DELETE: To delete existing records from a table
Question #9) What are all the different types of indexes?
There are three types of indexes
1. Unique Index: Unique Indexes helps maintain data integrity by ensuring that no two rows of data in a table have identical key values. A unique index can be applied automatically when a primary key is defined. It ensures that the values in the index key columns are unique.
2. Clustered Index: Clustered Index reorders the physical order of the table and search based on the key values. There will be only one clustered index per table.
3. Non-Clustered Index: Non-Clustered Index doesn’t alter the physical order of the table and maintains a logical order of the data. Each table can have many non-clustered indexes.
Question #10) What is a query?
A database query is a request for data or information from a database table or combination of tables. A database query can be either a select query or an action query.
Question #11) What is a Subquery?
A Subquery is a SQL query within another query. It is a subset of a Select statement whose return values are used in filtering the conditions of the main query.
Question #12) What is a Join?
Join is a query, which retrieves related columns or rows from multiple tables.
Question #13) What are the different types of joins?
Types of Joins are as follows:
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- OUTER JOIN