Please enter your details here.
Which is the subset of SQL command used to manipulate Database structures, including tables?
Which of the following database cannot be dropped?
To Create a new database __________ Command is used
What is the main language of Transact-SQL?
What does a DML Stand for?
What is the meaning of the “HAVING” clause in MySQL?
Which of the following query is correct for selecting the name of the staff from ''staffinfo'' table where salary is 10000 or 25000?
Select ID, name, dept name, salary * 1.1 where instructor;
The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
Select ________ dept_name from instructor;
Here which of the following displays the unique values of the column?
Find the names of the countries whose condition is sunny
Select two options which do not belong to the Purpose of Delete
Which of the SQL statement is correct?
Which SQL keyword is used to sort the result-set?
Which command is used to change the definition of a table in SQL ?
Analyse the following Query and Mark the answer whether it's the correct query or not?
The HAVING clause does which of the following?
Syntax for create a views is _______
The SQL WHERE clause used for
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Can you validate the statement?
"ORDER BY" can only be used by WHERE Clause.
True or False?
Which one is not used in SQL?
If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
What is the meaning of the “ORDER BY” clause in MySQL?
If emp_id contains the following set {-1, -2, 2, 3, -3, 1}, what will be the output on the execution of the following MySQL statement?
Find the name of these cities with temperature and condition whose condition is neither sunny nor cloudy
What is the significance of the statement of the below query?
You can delete a view with _____________ Command.
Which syntax is used for Drop Index (idx_pname) from the Person table in MYSQL?
What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?
Analyze the following Query and Mark the answer whether it's the correct query or not ?
An ORDER BY can be used in a subquery.
Which of the following statement(s) is TRUE regarding subqueries?
What is "Subquery"?
Where subqueries can not be used?
Which of the following is true about sub-queries?
We can use the index on columns that contain a high number of NULL values.
A column with a Unique key has duplicate values.
A table contains more than one foreign key
Does an Index help to speed up?
Student (ID, Name, Dept_name, Total_credit)
In this above query which attribute form the Primary Key?
What are the joins available in SQL?
Join is different from Inner join.
Analyze the following tables and output and choose the correct query to achieve the output.
Choose the query that matches the above image.
What is the syntax for joining two tables? Pick Two
In which two cases would you use an outer join? (Choose two.)
Where are Joins used?
Statement: Join for each row of one table to every row of another table.
Which Join?
Which SQL keyword is used to retrieve the highest value?
The _____ aggregation operation adds up all the values of the attribute
Which of the following is incorrect SQL?
The SQL Statement
SELECT ROUND(45.926, -1) FROM DUAL;
“COUNT” keyword belongs to which categories in MySQL?