10+ SitusAMC Interview Questions and Answers

Query to retrieve all customer names starting with A.

• Use the SELECT statement to retrieve customer names.

• Use the LIKE operator with the pattern 'A%' to match names starting with A.

• Specify the table and column name where the customer names are stored.

• Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

Compare record count of 2 score files and print if they are equal or not.

• Read both score files

• Count the number of records in each file

• Compare the record counts

• Print if they are equal or not

Index in SQL is a database object that improves the speed of data retrieval operations.

• Index is created on one or more columns of a table.

• It stores a copy of the data in the indexed columns in a separate structure.

• This allows for faster search and retrieval of data.

• Examples of index types include clustered, non-clustered, and unique indexes.

SQL is a programming language used for managing and manipulating relational databases. NoSQL is a non-relational database management system. RDBMS is a type of DBMS that stores data in a structured format.

• SQL (Structured Query Language) is used to manage and manipulate data in relational databases.

• Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.

• NoSQL databases are non-relational and do not use SQL. They are used for handling large volumes of unstructured d...read more

Char is fixed length while varchar is variable length.

• Char takes up the same amount of space for each value, while varchar only takes up as much space as needed.

• Char is faster for fixed length data, while varchar is more flexible for variable length data.

• Example: char(10) will always take up 10 characters, while varchar(10) will only take up as much space as needed for the value.

• Example: char is commonly used for storing codes or identifiers, while varchar is commonly used fo...read more

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down a database into smaller, more manageable tables

• Each table should have a primary key that uniquely identifies each record

• Data is then organized into related tables to minimize redundancy

• Normalization helps to prevent data inconsistencies and anomalies

• There are different levels of normalization, with each level building on the previo...read more

SQL has four types of joins: 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, with NULL values in the columns where there is no match.

• Examples: SELECT * FROM table1 INNER JOIN tab...read more

Substring is a part of a string that is smaller in length and extracted from the original string.

• Substring is a sequence of characters within a string.

• It can be extracted using string slicing or substring functions.

• For example, 'hello world'[0:5] will return 'hello'.

The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.

• HAVING is used with GROUP BY to filter groups based on aggregate functions results

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: SELECT...read more