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 order by experience DESC;

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;

Which of the following query is correct to perform union on DataFlair and location tables?

Select name, id FROM Dataflair UNION Select location, id FROM location;

Select col1, col2,col3 FROM DataFlair UNION Select col1, col2 FROM location;

Select name, id FROM DataFlair UNION SELECT id, location FROM location;

What is the major difference between the implicit and explicit cursor?

Depending on whether applied by SQL or by the user.

Depending on the time of execution.

Depending on the scale of efficiency and execution.

Which of the following is not true about SQL Subqueries?

Only one subquery can be nested.

Which of the following is true about a view?

Views are created by grouping a single desired attributes of a database.

The view gets deleted automatically after the session is completed.

Views cant be updated once created.

Which of the following is true about NULL values in SQL?

Null value just means that data of that attribute is not available.

A null value can only be used with numeric attributes.

Which of the following query would limit the output to 5 rows?

SELECT TOP 5 * FROM DataFlair ;

SELECT * FROM DataFlair 5 LIMIT;

SELECT TOP(5) * FROM DataFlair ;

Which of the following is not true about views?

No DML queries can be executed on the views.

Can be created only from one table.

Grouping using functions is present.

All of the above statements are true.

Which of the following is true about a view?

Views are created by grouping a single desired attributes of a database.

The view gets deleted automatically after the session is completed.

Views cant be updated once created.

Which of the following statements about the MAX function in SQL are true?

All of the above statements are true.

Returns the max value of the attribute.

Which of the following is true about the RDBMS?

RDBMS stands for the Relational Database Management System.

RDBMS is mandatory to use to create a database.

What is the difference if we truncate a table and if we drop a table?

In truncate, the data is deleted and in drop the whole table is deleted.

In both cases, the table is deleted.

In both cases, the data is deleted.

Write a query to draw out details of all the employees whose name starts with ‘A’ or are based in Pune.

USE DataFlair; SELECT * FROM DataFlair WHERE name LIKE 'A%' or location = 'Pune';

USE DataFlair; SELECT * DataFlair WHERE name location = 'Pune';

USE DataFlair; SELECT * FROM DataFlair WHERE name LIKE '%A__' or location = 'Pune';

Write a query to find the average pay of employees at Dataflair assuming that the pay of each is calculated by the formula Pay = (experience*1.5*10000).

USE DataFlair; SELECT (experience*1.5*10000) AS average_pay FROM DataFlair;

USE DataFlair; SELECT average((experience*1.5*10000)) AS average_pay FROM DataFlair;

USE DataFlair; SELECT AVGVALUE((experience*1.5*10000)) AS average_pay FROM DataFlair;

Which of the queries below can be used to alter the DataFlair table such that we can add a new gender column to our table?

ALTER TABLE DataFlair ADD gender varchar(10);

ALTER TABLE DataFlair ADD gender int;

ALTER TABLE DataFlair gender varchar(10);

ALTER DataFlair ADD gender varchar;

Which of the following query returns the results in ascending order of the experience column?

SELECT experience, name FROM DataFlair Order By experience ASC;

SELECT experience, name FROM DataFlair;

SELECT name, experience FROM DataFlair;

SELECT name, experience FROM DataFlair Order By name ASC;

Write a query to find the second employee in terms of experience in increasing order? (first being the one with max experience)

USE DataFlair; SELECT emp_id, MAX(experience) AS second_max_exp FROM DataFlair WHERE experience < (SELECT MAX(experience) FROM DataFlair);

USE DataFlair; SELECT emp_id, experience AS second_max_exp FROM DataFlair WHERE experience < (SELECT MAX(experience) FROM DataFlair);

Which of the below queries can be used to rename the table DataFlair to DataFlair_Info?

ALTER TABLE DataFlair RENAME TO DataFlair_Info ;

ALTER TABLE DataFlair SET TO DataFlair_Info ;

ALTER TABLE DataFlair TO DataFlair_Info ;

ALTER TABLE DataFlair UPDATE TO DataFlair_Info ;

In SQL the package definition is made up of which two elements?

Package body and Package Specifications

Package definitions and Package Variables

Package libraries and Package codes

Which of the query below is likely to run into an error?

SELECT name, emp_id FROM DataFlair;

Which of the below queries results have only 10 rows being shown in the result displayed?

Select name, location from DataFlair LIMIT 10;

SELECT name,emp_id FROM DataFlair Display 10;

Select Count(name) FROM DataFlair;

Predict the expected output of the query given below: SELECT salary*10 AS New_Salary FROM DataFlair

Returns the Salary multiplied by 10 in a new column called New_Salary.

Returns all the contents of the DataFlair Table.

Returns the Salary of the employees at DataFlair.

Returns the New_Salary of the employees at DataFlair.

What happens when we run the below query but emp_id ‘AR5’ doesn’t exist in our table. SELECT * FROM DataFlair_info WHERE emp_id = ‘AR5’

Nothing appears in the result tab.

Choose the correct query using the IFNULL function of SQL to replace the NULL value in the experience column of DataFlair with 0.

Select IFNULL(experience,0) FROM DataFlair;

Select * From DataFlair IFNULL(experience) = 0;

Data Analytics Internship Quiz 10

Authored by Vindhya Gaddam

Professional Development

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

select

check

insert into

update

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

DML

UML

RDBMS

DDL

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

SELECT

UPDATE

DELETE

None of these

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

LATIHAN UNBK 1

Quiz

•

Professional Development

50 questions

Pedagogi

Quiz

•

Professional Development

50 questions

Latihan Evaluasi MOOC PPPK

Quiz

•

Professional Development

50 questions

ID703 Book Quiz # 1

Quiz

•

Professional Development

55 questions

Ice Breaker Questions

Quiz

•

KG - Professional Dev...

50 questions

EMA_EE3109FP_Revision paper 1

Quiz

•

Professional Development

53 questions

HTML And CSS

Quiz

•

4th Grade - Professio...

55 questions

TO WEEKLY 12 MANSOSWA PPPK GMI

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

10 questions

Probability Practice

Quiz

•

4th Grade

15 questions

Probability on Number LIne

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

6 questions

Appropriate Chromebook Usage

Lesson

•

7th Grade

10 questions

Greek Bases tele and phon

Quiz

•

6th - 8th Grade

Discover more resources for Professional Development

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

12 questions

Mardi Gras Trivia

Quiz

•

Professional Development

7 questions

Copy of G5_U5_L14_22-23

Lesson

•

KG - Professional Dev...

12 questions

Unit 5: Puerto Rico W1

Quiz

•

Professional Development

42 questions

LOTE_SPN2 5WEEK2 Day 4 We They Actividad 3

Quiz

•

Professional Development

15 questions

Balance Equations Hangers

Quiz

•

Professional Development

31 questions

Servsafe Food Manager Practice Test 2021- Part 1

Quiz

•

9th Grade - Professio...

Data Analytics Internship Quiz 10

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

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

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

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

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

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

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

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

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.

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Professional Development

Data Analytics Internship Quiz 10

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

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

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

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

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

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

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

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

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.

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Professional Development

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

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.