Data Analytics Internship Quiz 10

Which of the following is used to modify the data stored in the database?

• select

• check

• insert into

• update

What is the major difference in the operation of the UNION and UNION ALL clause in SQL?

• Union returns unique data and UNION ALL returns all possible cases.

• Union all returns unique data while Union returns all the possible cases.

• Both return the same set of data, difference is observed in the versions only.

• None of the above

Which type of join is the query written below?
SELECT *
FROM tableName1
INNER JOIN tableName2
ON tableName1.matchingColumn = tableName2.matchingColumn ;

• Inner Join

• Left Join

• Outer Join

• Right Join

What are the data definition commands in SQL known as popularly?

• DML

• UML

• RDBMS

• DDL

Which of the query below is used to put a value in a variable we need to define for our SQL query?

• Id = 6;

• SET @id = 6;

• SET #id = 6;

• SET id = 6;

Write a query to find the company domain mail-id of each employee at DataFlair. Given the company domain being @dataflair.com.

• USE DataFlair; SELECT name ,concat('@dataflair.com',name) AS Official_mail_id FROM DataFlair;

• USE DataFlair; SELECT name ,strcmp(name,'@dataflair.com') AS Official_mail_id FROM DataFlair;

• USE DataFlair; SELECT name ,concat(name,'@dataflair.com') AS Official_mail_id FROM DataFlair;

• All of these are correct.

We can’t use subqueries with which of the clauses given below?

• SELECT

• UPDATE

• DELETE

• None of these

Write a query in SQL using just two words to extract the time of the system as of now?

• SELECT RIGHTNOW();

• SELECT CURR();

• SELECT NOW();

• SELECT TIME();

Write a query to display the base pay and name of each employee at DataFlair using the following formula to calculate base pay:
BP = 20000 + (experience*5000)
Also, display the results with the highest-paid employee being the first.

• USE DataFlair; SELECT name ,(20000 + (experience*5000)) AS Base_Pay FROM DataFlair;

• USE DataFlair; SELECT name ,(20000 + (experience*5000)) AS Base_Pay FROM DataFlair order by experience DESC;

• USE DataFlair; SELECT name ,(20000 + (experience*5000)) AS Base_Pay FROM DataFlair order by experience;

• None of these

Which of the following is not a built-in function in SQL?

• DATE_ADD( )

• DATE_SUB( )

• DATE_DIFF( )

• DATE_FORMAT( )