Please enter your details here.
What is the main language of Transact-SQL?
Which one is a non-relational database?
What is the full form of SQL?
Which file type is used for database backup?
To delete the database __________ Command is used
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;
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?
The _______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
What is the meaning of the “ORDER BY” clause in MySQL?
Find all the cities whose humidity is 89
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?
You can delete a view with _____________ Command.
What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?
Analyse the following Query and Mark the answer whether it's the correct query or not?
Can you validate the statement?
"ORDER BY" can only be used by WHERE Clause.
True or False?
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''?
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Analyze the following Query and Mark the answer whether it's the correct query or not ?
Syntax for create a views is _______
Which SQL Query is used for updating the ContactName in the Customers table?
Identify the average salary of the jobs 'MANAGER' and 'ANALYST'. Display job, average salary if the identified average salary is more than 1500.
If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
What can be the condition in the "WHERE" clause in a SQL query?
Which syntax is used for Drop Index (idx_pname) from the Person table 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?
What is the significance of “ORDER BY” in the following MySQL statement?
How to create index idx_pname for multiple columns (Lastname, Firstname) in a Person table?
The SQL WHERE clause used for
What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?
What is the meaning of the “HAVING” clause in MySQL?
What is "Subquery"?
A subquery can be used anywhere an expression is allowed.
Which of the following is true about sub-queries?
Which of the following clause is mandatorily used in a sub-query?
An ORDER BY can be used in a subquery.
By default, which key creates Clustered index?
A Key which is a set of one or more columns that can identify a record uniquely is called?
How many Primary Keys can have in a table?
A column with a Unique key has duplicate values.
Which of the following is not a Key in SQL Server?
What is the syntax for joining two tables? Pick Two
Statement: Join for each row of one table to every row of another table.
Which Join?
Choose the correct query for the below scenario.
List all orders, showing order number, customer name and credit limit of a customer.
Which of the below query satisfy the above question?
Which type of join is not desirable for retrieval?
What are the joins available in SQL?
Choose the query that matches the above image.
Evaluate this SQL statement:
Which SQL statement is equivalent to the above SQL statement?
Analyze the following tables and output and choose the correct query to achieve the output.
Below image depicts:
What values does the count(*) function ignore?
Which of the following is incorrect SQL?
In SQL - these functions - AVG, MIN, MAX, COUNT are called as ___________
The SQL Statement
SELECT ROUND(45.926, -1) FROM DUAL;