1. SQL stands for _____________
Answer: Structured Query Language
2. ____________ are the basic building blocks of a database.
Answer: Tables
3. ______________ SQL command(s) retrieves information from a table.
Answer: SELECT
4. _________ clause is used to select specific rows in a table.
Answer: WHERE
5. SQL statement will always terminate with _________
Answer: Semicolon
6. The _________ clause in SQL is used to filter records.
Answer: WHERE
7. SQL is not case ____________.
Answer: sensitive
8. DDL stands for ______________.
Answer: Data Definition Language.
9. Create and Alter is __________command.
Answer: DDL
10. _________ command is used to define a database including creating, altering and dropping tables.
Answer: DDL
11. Insert, Update and Delete is ________ command.
Answer: DML
12. In SQL, the ___________ statement is used to retrieve data from a database.
Answer: SELECT
13. The _________ statement is used to insert new records in a table.
Answer: INSERT
14. ___________ statement is used to modify the existing records in a table.
Answer: UPDATE
15. ________________ SQL command is used to modify data in a table.
Answer: UPDATE
16. _________ command is used to delete a record.
Answer: DELETE
17. The keyword _________ can be used in a WHERE clause to refer to a range of values.
Answer: BETWEEN
18. __________ keyword is used to return only unique records from a query result set.
Answer: DISTINCT
19. The SQL keyword _______ is used in SQL expressions to select records based on patterns.
Answer: LIKE
20. To remove duplicate rows from the result of a query, specify the SQL qualifier _______________
Answer: DISTINCT
21. ____________ deletes the existing table permanently from the database.
Answer: DROP
22. _________ function returns the number of rows that matches a specified criterion.
Answer: COUNT
23. The ________ operator is used for making range checks in SELECT queries.
Answer:BETWEEN
24. ______ operator selects values within a given range.
Answer: BETWEEN
25. To sort the rows of the result table, __________ clause is specified.
Answer: ORDER BY
26. __________ constraints uniquely identify each record in a table.
Answer: Primary Key
27. The SQL built-in function ___________ totals values in numeric columns.
Answer: SUM
28. The SQL built-in function _________ computes the average of values in numeric columns.
Answer: AVG
29. The SQL built-in function _________ obtains the largest value in a numeric column.
Answer: MAX
30. The SQL built-in function MIN obtains the smallest value in a numeric column
Answer: MIN
31. The SQL built-in function _________ computes the number of rows in a table.
Answer: COUNT
32. ___________ keyword is used to sort the result set in ascending or descending order.
Answer: ORDER BY
33. Columns can be sorted in descending sequence by using the SQL keyword _________
Answer: DESC
34. __________ command is used to make changes in the structure of a table.
Answer: ALTER
35. The SQL keyword _______________ is used to collect those rows that have the same value in a specified column.
Answer: GROUP BY
36. The ________ keyword is used with the SELECT statement to remove duplicate values.
Answer: DISTINCT
37. ____________ is a command in SQL that is used with the rollback command.
Answer: SAVEPOINT
38. We can use ___________ statement to remove a database or table permanently from the system.
Answer: DROP
39. The SQL keyword _______ instructs the DBMS to group together those rows that have the same value in a column.
Answer: GROUP BY
40. The ________ clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Answer: HAVING
It’s should be so helpful for exam.. Thank you ma’am 😊
Thank you so much Gyan…
Wondeｒful blοg! Dߋ you have any tips for aspiring writers?
I’m hopіng to start my own site soօn but I’m a little lost
on everythіng. Would yoս propose starting wіth a free platform lіke WordPress or go for
a paid option? There are so many options out tһere that I’m totally overwhelmed ..
Any ideas? Kudos!
Temp Mail I am truly thankful to the owner of this web site who has shared this fantastic piece of writing at at this place.
Thank you so much for your kind words…
BaddieHub For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.
allegheny county real estate This was beautiful Admin. Thank you for your reflections.
I have been browsing online more than three hours today yet I never found any interesting article like yours It is pretty worth enough for me In my view if all website owners and bloggers made good content as you did the internet will be a lot more useful than ever before
Masalqseen I really like reading through a post that can make men and women think. Also, thank you for allowing me to comment!
Oh my goodness! a tremendous article dude. Thanks Nevertheless I’m experiencing situation with ur rss . Don’t know why Unable to subscribe to it. Is there anybody getting identical rss downside? Anybody who knows kindly respond. Thnkx
I really appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thx again
I am not really excellent with English but I find this very easygoing to translate.
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how could we communicate?
I will immediately grasp your rss feed as I can not find your e-mail subscription hyperlink or e-newsletter service. Do you’ve any? Please let me know in order that I may just subscribe. Thanks.
You are my intake, I possess few web logs and occasionally run out from brand :). “‘Tis the most tender part of love, each other to forgive.” by John Sheffield.
Nice read, I just passed this onto a friend who was doing some research on that. And he actually bought me lunch because I found it for him smile Thus let me rephrase that: Thanks for lunch! “Procrastination is the thief of time.” by Edward Young.
Can I simply say what a aid to seek out somebody who actually knows what theyre speaking about on the internet. You undoubtedly know the best way to bring a problem to light and make it important. Extra folks need to read this and perceive this aspect of the story. I cant believe youre no more common since you undoubtedly have the gift.
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! By the way, how could we communicate?
I like this web site very much, Its a real nice billet to read and obtain info .
I got what you mean , thankyou for posting.Woh I am glad to find this website through google. “The test and use of a man’s education is that he finds pleasure in the exercise of his mind.” by Carl Barzun.
I appreciate, cause I found exactly what I was looking for. You’ve ended my four day long hunt! God Bless you man. Have a nice day. Bye
I real glad to find this web site on bing, just what I was searching for : D as well saved to fav.
It’s hard to find knowledgeable people on this topic, but you sound like you know what you’re talking about! Thanks
Hi my friend! I want to say that this article is awesome, nice written and include almost all important infos. I would like to see more posts like this.
I appreciate, cause I found just what I was looking for. You have ended my 4 day long hunt! God Bless you man. Have a great day. Bye
very good put up, i definitely love this web site, carry on it
I’ve been exploring for a bit for any high-quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this website. Reading this info So i’m happy to convey that I’ve a very good uncanny feeling I discovered just what I needed. I most certainly will make sure to do not forget this site and give it a glance on a constant basis.
hey there and thank you for your info – I have certainly picked up something new from right here. I did however expertise several technical points using this website, as I experienced to reload the website lots of times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will often affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Well I am adding this RSS to my email and can look out for a lot more of your respective fascinating content. Make sure you update this again soon..
Usually I do not learn post on blogs, however I wish to say that this write-up very pressured me to check out and do it! Your writing taste has been surprised me. Thanks, very great article.
WONDERFUL Post.thanks for share..more wait .. …
Very great post. I simply stumbled upon your blog and wanted to mention that I have really enjoyed browsing your blog posts. In any case I’ll be subscribing on your rss feed and I’m hoping you write once more soon!
You have mentioned very interesting points! ps decent internet site.
I?¦m not certain the place you’re getting your info, however great topic. I must spend a while finding out more or understanding more. Thank you for fantastic information I used to be on the lookout for this info for my mission.
Great goods from you, man. I have understand your stuff prior to and you’re just too excellent. I actually like what you have got here, certainly like what you are stating and the best way through which you assert it. You make it entertaining and you still take care of to stay it sensible. I can’t wait to learn much more from you. This is really a terrific website.
Lovely just what I was looking for.Thanks to the author for taking his time on this one.
It’s in point of fact a great and useful piece of info. I am glad that you shared this useful info with us. Please keep us informed like this. Thanks for sharing.
I’ve learn several good stuff here. Certainly value bookmarking for revisiting. I surprise how much attempt you set to make this kind of magnificent informative site.
Hello my family member! I want to say that this post is awesome, great written and include approximately all significant infos. I would like to peer more posts like this .
I am lucky that I observed this website, just the right info that I was searching for! .
Thanks for another informative web site. Where else could I get that kind of information written in such a perfect way? I have a project that I’m just now working on, and I have been on the look out for such information.
Merely wanna comment on few general things, The website pattern is perfect, the content is rattling great : D.
Howdy very nice website!! Man .. Beautiful .. Superb .. I will bookmark your site and take the feeds alsoKI am satisfied to search out numerous useful information right here within the submit, we’d like develop more strategies on this regard, thanks for sharing. . . . . .
Just desire to say your article is as astounding. The clarity to your put up is simply great and that i could assume you’re knowledgeable on this subject. Fine together with your permission let me to seize your RSS feed to stay up to date with impending post. Thank you 1,000,000 and please carry on the enjoyable work.
You can certainly see your expertise in the paintings you write. The arena hopes for even more passionate writers like you who aren’t afraid to mention how they believe. Always follow your heart.
Its fantastic as your other articles : D, thankyou for posting. “You can’t have everything. Where would you put it” by Steven Wright.
Hello very cool website!! Man .. Beautiful .. Wonderful .. I’ll bookmark your blog and take the feeds additionally?KI’m happy to seek out numerous useful information right here in the submit, we want develop extra techniques on this regard, thanks for sharing. . . . . .
he blog was how do i say it… relevant, finally something that helped me. Thanks
I would like to thnkx for the efforts you have put in writing this blog. I’m hoping the same high-grade web site post from you in the upcoming as well. In fact your creative writing abilities has encouraged me to get my own web site now. Really the blogging is spreading its wings rapidly. Your write up is a great example of it.
I’m not sure where you are getting your info, but great topic. I needs to spend some time learning more or understanding more. Thanks for fantastic information I was looking for this information for my mission.
It’s really a great and useful piece of information. I am glad that you shared this useful info with us. Please keep us informed like this. Thanks for sharing.
I am always browsing online for articles that can help me. Thanks!
I think other website proprietors should take this web site as an example , very clean and fantastic user friendly layout.
Howdy! This is my first visit to your blog! We are a team of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a outstanding job!
Hi! I’ve been following your weblog for a while now and finally got the courage to go ahead and give you a shout out from Houston Texas! Just wanted to tell you keep up the excellent work!
Hey..Thank you so much for your nice comment..
There is apparently a bundle to know about this. I suppose you made certain good points in features also.
Very nice post and straight to the point. I am not sure if this is in fact the best place to ask but do you folks have any ideea where to get some professional writers? Thx 🙂
Thank you for sharing with us, I believe this website genuinely stands out : D.
I am no longer sure the place you are getting your information, but great topic. I needs to spend some time finding out much more or understanding more. Thank you for wonderful info I was in search of this information for my mission.
You should take part in a contest for one of the best blogs on the web. I will recommend this site!
Absolutely written content, Really enjoyed reading.
I haven¦t checked in here for a while since I thought it was getting boring, but the last few posts are great quality so I guess I will add you back to my everyday bloglist. You deserve it my friend 🙂
Utterly written articles, thank you for information. “In the fight between you and the world, back the world.” by Frank Zappa.
I truly appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You’ve made my day! Thx again
There may be noticeably a bundle to learn about this. I assume you made sure good factors in options also.
I like what you guys are up also. Such smart work and reporting! Keep up the excellent works guys I?¦ve incorporated you guys to my blogroll. I think it will improve the value of my web site 🙂
I?¦m not sure the place you are getting your information, however good topic. I needs to spend some time studying more or working out more. Thank you for fantastic information I was in search of this info for my mission.
Some truly interesting information, well written and generally user genial.
I really like your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to design my own blog and would like to find out where u got this from. thanks a lot