Queries
JOINS
Databases
Interview Questions
Servers
100
Use this SQL statement to retrieve data from a database table.
What is a SELECT statement?
100
The most commonly used JOIN, returns only the rows from both tables where the join condition is met.
What is an INNER JOIN?
100
Structured Query Language
What is SQL?
100
Extract Data, Transform Data, & Load data into a Destination
What is ETL?
100
We use this program as a stand-along local client to connect to the database on the server.
What is Microsoft SQL Server Management Studio?
200
An alternative name that you give to a column or table in a query.
What is an alias?
200
This type of JOIN in SQL returns all the rows from the left table and the matching rows from the right table, along with NULL values for the non-matching rows from the right table.
What is a LEFT JOIN (or LEFT OUTER JOIN)?
200
A type of database that organizes data into one or more tables with rows and columns. Each table represents a different type of entity (such as customers, orders, or products) and relationships between entities are established using common columns between tables.
What is Relational databases?
200
This is the aggregation of data that is then used in reports to inform organizations how to make informed business decisions about various aspects of the organization.
What is Business Intelligence (BI) ?
200
A feature in SQL Server that allows you to connect to other databases, data sources, and file systems outside of the current SQL Server instance.
What are linked servers?
300
Specifies the table(s) where the data is stored.
What is the FROM clause?
300
This type of JOIN in SQL returns all the rows from both tables, including the matching rows and the non-matching rows, with NULL values for the non-matching columns?
What is a FULl JOIN (or FULL OUTER JOIN)
300
A collection of related data entries, organized into rows and columns.
What is a table?
300
Used in the data flow to see what data is travelling down the data flow during runtime.
What is data Viewer in SSIS?
300
A computer system designed to provide shared access to resources, such as printers, files, or applications, for multiple users over a network.
What is a server?
400
A SQL clause that allows you to filter the results of a query based on certain conditions.
What is the WHERE clause?
400
This type of JOIN in SQL returns all the rows from the right table and the matching rows from the left table, along with NULL values for the non-matching rows from the right table.
What is a RIGHT JOIN or RIGHT OUTER JOIN?
400
A user-defined function in SQL returns a table data type that can be used in a SELECT statement
What is a table-valued function?
400
A packages that execute IN THE EVENT that a particular event takes place while a package is running. Event Handler can do anything a regular package can. They are primarily used to send emails to team members is a nightly process fails.
What is an event handler?
400
A small, entry-level SQL Server database management system. Great for small to medium-sized organization, hobbyist and developers.
What is Microsoft SQL Server Express?
500
This clause can be combined with AND, OR, and NOT operators.
What is the WHERE clause?
500
Describe the return of this syntax
What is display the entire Product p table and only the corresponding matching in ProductReview?
500
Created using SQL commands and can be represented visually using ER diagrams (entity-relationship diagrams)
What is Database Schema?
500
You use this to extract a picture or video from a database?
What is The Export Column Transformation
500
A type of server uses virtualization technology to create multiple isolated virtual environments, called "virtual machines," on a single physical server, allowing multiple operating systems and applications to run on the same hardware?
What is a virtual server or a hypervisor-based server?