Please enter your details here.
To delete the database __________ Command is used
Which file type is used for database backup?
What is the meaning of a Database?
Which one is a non-relational database?
What is the SQL query used to retrieve all the data from the customer table?
Syntax for create a views is _______
What can be the condition in the "WHERE" clause in a SQL query?
The _______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Identify the average salary of the jobs 'MANAGER' and 'ANALYST'. Display job, average salary if the identified average salary is more than 1500.
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?
How to create index idx_pname for multiple columns (Lastname, Firstname) in a Person table?
Which SQL Query is used for updating the ContactName in the Customers table?
How to delete the Customer name of Alfreds Futterkiste (CustomerID is 1) from the Customers table?
Analyze the following Query and Mark the answer whether it's a correct query or not?
You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following queries will be correct?
If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
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?
What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?
What is the significance of “ORDER BY” in the following MySQL statement?
Which SQL keyword is used to sort the result-set?
Select two options which do not belong to the Purpose of Delete
What is the significance of the statement of the below query?
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
What is the meaning of the “ORDER BY” clause in MySQL?
Select ________ dept_name from instructor;
Here which of the following displays the unique values of the column?
Analyze the following Query and Mark the answer whether it's the correct query or not ?
What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?
Can you validate the statement?
"ORDER BY" can only be used by WHERE Clause.
True or False?
The SQL WHERE clause used for
Find all the cities whose humidity is 89
A subquery in an SQL SELECT statement is enclosed in
Where subqueries can not be used?
Which of the following is true about sub-queries?
Which of the following statements are TRUE regarding subqueries?
What is "Subquery"?
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
A Key which is a set of one or more columns that can identify a record uniquely is called?
We can use the index on columns that contain a high number of NULL values.
How many types of indexes are there in the SQL server?
How many Primary Keys can have in a table?
Analyze the following tables and output and choose the correct query to achieve the output.
Below image depicts:
What is the syntax for joining two tables? Pick Two
Evaluate this SQL statement:
Which SQL statement is equivalent to the above SQL statement?
Where are Joins used?
Alias is used in Joins.
Join is different from Inner join.
What is the function of Full Outer Join in SQL?
Use below table (Salesemployee) and answer the following question
What is the output of the following query?
Which of the following do you need to consider when you make a table in SQL?