Please enter your details here.
In SQL, which command is used to change a table's storage characteristics?
Which one is a non-relational database?
What is the full form of SQL?
What is the main language of Transact-SQL?
SQL can be used to
The _______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
The SQL WHERE clause used for
What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?
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 “HAVING” clause in MySQL?
We can use one table to create another table using the below query. True or False ?
CREATE TABLE TestTable AS
SELECT customername, contactname
FROM customers;
How to create index idx_pname for multiple columns (Lastname, Firstname) in a Person table?
What is the meaning of the “ORDER BY” clause in MySQL?
The HAVING clause does which of the following?
What can be the condition in the "WHERE" clause in a SQL query?
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Find all the cities whose humidity is 89
Find the name of these cities with temperature and condition whose condition is neither sunny nor cloudy
Which of the following query is correct for selecting the name of the staff from ''staffinfo'' table where salary is 10000 or 25000?
Which syntax is used for Drop Index (idx_pname) from the Person table in MYSQL?
Can you validate the statement?
"ORDER BY" can only be used by WHERE Clause.
True or False?
Select ________ dept_name from instructor;
Here which of the following displays the unique values of the column?
What is the significance of “ORDER BY” in the following MySQL statement?
Which SQL keyword is used to sort the result-set?
You can delete a view with _____________ Command.
With SQL, how do you select all the records from a table named "Persons" where the value of the column "Firstname" ends with an ''a''?
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?
How to delete the Customer name of Alfreds Futterkiste (CustomerID is 1) from the Customers table?
Find the names of the countries whose condition is sunny
Analyze the following Query and Mark the answer whether it's the correct query or not ?
Which of the following multi-row operators can be used with a sub-query?
Which of the following statement(s) is TRUE regarding subqueries?
Where subqueries can not be used?
Which of the following operators cannot be used in a sub-query?
Which of the following statements are TRUE regarding subqueries?
Does an Index help to speed up?
A ______ index is created based on only one table column.
A column with a Primary key has a Null value.
Which key accepts multiple NULL values?
We can use the index on columns that contain a high number of NULL values.
What is the function of Full Outer Join in SQL?
Alias is used in Joins.
In the absence of WHERE condition this JOIN will function like a _______.
Statement: Join for each row of one table to every row of another table.
Which Join?
Analyze the following tables and output and choose the correct query to achieve the output.
In which two cases would you use an outer join? (Choose two.)
Where are Joins used?
How many tables may include with a join?
Below image depicts:
Which of the following is incorrect SQL?
“COUNT” keyword belongs to which categories in MySQL?
Which among the following belongs to an “aggregate function”?