When creating indexes in SQL, what two main factors must be considered?

What is the name of the service that provides ETL capabilities for SQL Server for data import, data integration and data warehousing needs?

Which of the following allows you to modify (update or delete) all values of the parent table?

What is the 'WITH RECOMPILE' statement used for?

Which of the following are not default database schemas?

The ________ data type can be used to store values of different data types at the same time, including numeric values, strings, and date values.

The table Comments has an auto incremented column called 'Commentid' and a 'UserComments' column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?

Which of the following statements is wrong?

We have a table named 'Customer' which has a column named 'Customerid' having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query?

Which of the following are correct?

You have a table 'engineers' with the following table structure: enggid int(4) deptname varchar(50) salary int(4) You want to display the minimum and maximum salaries of the individual departments. Which of the following queries will fetch the desired results?