Which of the below is an invalid query?

SELECT Unique(name) FROM DataFlair;

SELECT * FROM DataFlair Where experience!=0;

Find out which query gives an error.

select * grades where grade = 1 and grade = 11;

select * from Grades where not Grade = '1' ;

select * from Grades where not Grade =1 ;

select * from Grades where Grade not like '1' ;

Find out which query will give second highest salary (Multiple choose Questions).

SELECT First_name, Max(salary) AS salary FROM employee WHERE salary in (select salary from employee minus select max(salary) from employee);

SELECT First_name, Max(salary) AS salary FROM employee WHERE salary != ( select max(salary) from employee);

SELECT First_name, salary AS salary FROM employee WHERE 1 > ( select Count( DISTINCT salary) FROM employee);

Find out which query will give an error from options?

SELECT * FROM Employee WHERE Salary BETWEEN '50000' OR '100000';

SELECT * FROM Employee WHERE Salary BETWEEN '50000' AND '100000';

SELECT * FROM Employee WHERE Salary in ( '50000') AND salary in ( '100000');

SELECT * FROM Employee WHERE Salary = '50000' AND Salary = '100000';

Write a query to find the employees name whose name start with ‘S’.

SELECT * FROM Employee WHERE First_name LIKE 'S%';

SELECT * FROM Employee WHERE First_name Match'S%';

SELECT * FROM Employee WHERE First_name = 'S%';

SELECT * FROM Employee WHERE First_name in ('S%');

What is sequence of clauses used with SELECT query in SQL?

WHERE clause ,GROUPBY clause,HAVING clause,ORDER BY clause

WHERE clause ,ORDER BY clause,GROUP BY clause,HAVING clause

ORDER BY clause, GROUP BY clause, HAVING clause, WHERE clause

WHERE clause, GROUP BY clause, ORDER BY clause, HAVING clause

What is the purpose of the SQL AS clause?

The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

Which statement is true regarding routines and triggers?

Both consist of procedural code.

Both are stored in the database.

Both have to be called to operate.

Choose correct option to rename database name:

RENAME DATABASE old_database TO new_database;

RENAME old_database TO new_database;

What id Difference between DELETE and TRUNCATE statement?

TRUNCATE command deletes all the rows and free the containing space by table.

Both commands delete all the rows and free the space containing by table.

DELETE command deletes rows based on specified condition and free the space.

With SQL, how can you return number of records in the “Student”Table?

SELECT Columns(*) from Student;

Choose incorrect characteristic of PRIMARY KEY

Primary key doesn’t enforces an entity integrity of the table

Primary key always has unique data.

Primary key length cannot ne exceeded than 900 bytes.

Primary key cannot have null value.

Choose correct answer about where clause and having statement.

Where clause filter records before groupings are made and having filter Records from a group.

Both are used to filter the records from a group

Both can use logical connectives like OR, AND, etc.

How can you change “Sagar” into “Jayesh” in the “Last_name” column in Person table?

UPDATE Person SET Last_name=”Jayesh” WHERE Last_name=”Sagar”;

UPDATE Person SET Last_name=”Sagar” into Last_name=”Jayesh”;

MODIFY Person SET Last_name=” Jayesh” WHERE Last_name=” Sagar”;

MODIFY Person SET Last_name=”Sagar” into Last_name=”Jayesh”;

You attempt to query the database with this command: select nvl (100 / quantity, none) from inventory; Why does this statement cause an error when QUANTITY values are null?

The expression attempts to divide by a null value

The character string none should be enclosed in single quotes (' ')

A null value used in an expression cannot be converted to an actual value

he data types in the conversion function are incompatible

What is the effect of the <b> tag?

It converts the text within it to bold font.

It is used to write black-colored font.

It is used to change the font size.

What is meant by an empty tag in HTML?

An empty tag does not require a closing tag

There is no such concept of an empty tag in HTML

An empty tag cannot have any content within it

Induction_Training_2

Authored by Training TechHub

Education

Professional Development

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

71 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Given table has 100 tuples and write a query to find out only 50 tuples from given table (only first half records).

SELECT TOP FIRSTHALF * FROM Bikes;

ELECT TOP 1/2 *

FROM Bikes;

SSELECT TOP

HALF * FROM Bikes;

SELECT TOP 50 PERCENT * FROM Bikes;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Write a query and find out number of unique salaries and return unique salary from EMP table.

SELECT COUNT (UNIQUE Emp_Salary) AS Unique_Salary FROM Employee ;

SELECT COUNT (DISTINCT Emp_Salary) ,Salary FROM Employee ;

SELECT AS Unique_Salary , COUNT (DISTINCT Emp_Salary) FROM Employee ;

SELECT COUNT (DISTINCT Emp_Salary) AS Unique_Salary FROM Employee ;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which query will “find out two employees who came from Delhi”?

SELECT TOP 2 * FROM Employee WHERE Emp_City = Delhi ;

SELECT 2 * FROM Employee WHERE Emp_City = Delhi ;

SELECT * FROM Employee WHERE Emp_City = Delhi AND Emp_City<2;

SELECT TOP 2 * Employee WHERE Emp_City = Delhi ;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which query will help us to select a random record from table?

SELECT column FROM table ORDER BY NEWID()

SELECT RANDOM column FROM table ORDER BY NEWID()

SELECT TOP 1 column FROM table ORDER BY NEWID()

SELECT TOP 1 column FROM table AS NEWID()

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Write a query to find out total sales but total sales greater then 300 from department table?

SELECT department, SUM (sales) AS "Total Sales"

FROM order_details

GROUP BY department WHERE SUM (sales)>300;

SELECT department, SUM (sales) AS "Total Sales"

FROM order_details

GROUP BY department HAVING SUM (sales)>300;

SELECT department, SUM (sales) AS "Total Sales"

FROM order_details

GROUP BY sales HAVING SUM (sales)>300;

SELECT * SUM (sales) AS "Total Sales"

FROM order_details GROUP BY department HAVING SUM (sales)>300;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Write a query and return all records from Table A and Table B.

SELECT Distinct *

FROM table_A

FULL OUTER JOIN table_B

ON table_A.A = table_B.A;

SELECT (Distinct *)

FROM table_A

FULL OUTER JOIN table_B

ON table_A.A = table_B.A;

SELECT *

FROM table_A

JOIN table_B

ON table_A.A = table_B.A;

SELECT *

FROM table_A

FULL OUTER JOIN table_B

ON table_A.A = table_B.A;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We have two tables, Table-1 and Table-2. Column id is common attribute in both tables. Also, only 5 ID are matches in both tables. So, here is the question.
Table-1 has 6 tuples and table-2 has 7 tuples. If we will perform cross join on these tables then, how many tuples will return?

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

75 questions

Sinonim, Antonim, Analogi

Quiz

•

Professional Development

68 questions

Стратегический менеджмент

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Education

10 questions

How to Email your Teacher

Quiz

•

Professional Development

6 questions

3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET

Quiz

•

Professional Development

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

22 questions

Multiplying Exponents with the Same Base

Quiz

•

9th Grade - Professio...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

Induction_Training_2

Given table has 100 tuples and write a query to find out only 50 tuples from given table (only first half records).

Write a query and find out number of unique salaries and return unique salary from EMP table.

Which query will “find out two employees who came from Delhi”?

Which query will help us to select a random record from table?

Write a query to find out total sales but total sales greater then 300 from department table?

Write a query and return all records from Table A and Table B.

We have two tables, Table-1 and Table-2. Column id is common attribute in both tables. Also, only 5 ID are matches in both tables. So, here is the question.Table-1 has 6 tuples and table-2 has 7 tuples. If we will perform cross join on these tables then, how many tuples will return?

If a set is a collection of values given by the select clause, The ______ connective tests for set membership.

Which of the below is an invalid query?

Find out which query gives an error.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Education

We have two tables, Table-1 and Table-2. Column id is common attribute in both tables. Also, only 5 ID are matches in both tables. So, here is the question.
Table-1 has 6 tuples and table-2 has 7 tuples. If we will perform cross join on these tables then, how many tuples will return?