Topics
Products
Follow Us:

SQL Questions and Answers (Q&A)

T. Perez
Answered: May 10, 2018
SQL is the most widely used database language. SQL is a domain specific language used in programming and designed for managing data held in a relational database management system. It is useful...Read More

6 Answers

1677 views
G.Carol
Answered: Feb 19, 2018
There are different clauses and tools that are used to modify columns and rows in order to edit tables as you need. Each has a precise function and as the names aren’t self-exploratory, you...Read More

3 Answers

831 views
Carice Snow, Motivator
Answered: Dec 14, 2018
The correct answer is B. When trying to select all the records from a table named "Persons" where the value of the column "FirstName" starts with an 'a' with SQL, SELECT FROM Persons WHERE...Read More

3 Answers

787 views
John Smith
Answered: Apr 01, 2020
SELECT FirstName FROM Persons

1 Answer

532 views
Kabirkhanna
Answered: Apr 01, 2020
DELETE FROM TABLE studentinfo WHERE sname= Hari Prasad ;

1 Answer

395 views
lifetodeath
Answered: Apr 01, 2020
All are true.

1 Answer

393 views
E. Austin
Answered: Dec 14, 2018
The answer is D. A commonly asked question by SQL users or those learning how to use SQL is if you can return all the records from a table named "Persons" sorted descending by "FirstName" with...Read More

2 Answers

381 views
Melissajanuary
Answered: Apr 01, 2020
Multiple columns or expressions can be compared between the main query and subquery.
Main query and subquery can get data from different tables.
Subqueries can contain GROUP BY and ORDER...Read More

1 Answer

371 views
Cerebralrust
Answered: Apr 01, 2020
Definition of the condition to be met for the rows to be returned.

1 Answer

345 views
Gaurav.
Answered: Apr 01, 2020
3. UPDATE Persons SET LastName= Nilsen WHERE LastName= Hansen

1 Answer

342 views
Njoki
Answered: Jul 07, 2017

This is the correct answer.

SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) <5000 AND MAX(salary) >15000.

3 Answers

293 views
E. Stanley, Technical writer
Answered: Sep 20, 2018
The answer to this is D. From the name itself, you can already make a guess on what the union clause can do. It has the ability to combine two different statements. Once these statements are...Read More

4 Answers

290 views
Danny R. Glover, Editor
Answered: Jul 11, 2018
Take note that you want to gather information about the total number of orders. This means that you need to choose the select count from sales which is letter B in the choices. This will allow...Read More

3 Answers

277 views
John Smith
Answered: Apr 01, 2020
The contents of packages can be shared by many applications.-2. you can achieve information hiding by making package constructs private.-explanation actually theses are some of the advantages of the...Read More

1 Answer

274 views

Related Topics Of SQL

Loading, please wait...

Email Sent
We have sent an email to your address "" with instructions to reset your password.