Solved MCQs on SQL

Solved MCQs on SQL MCQ and Quiz about SQL (Structured Query Language) are available. Q No.1 of 10 What does SQL stand ...


Solved MCQs on SQL
MCQ and Quiz about SQL (Structured Query Language) are available.


Q No.1 of 10

What does SQL stand for?
Option 1
Strong Question Language
Option 2
Structured Question Language
Option 3
Structured Query Language
Correct
Option 4
Static Query Language
Q No.2 of 10

Which SQL statement is used to extract data from a database
Option 1
GET
Option 2
OPEN
Option 3
SELECT
Correct
Option 4
EXTRACT
Q No.3 of 10

Which SQL statement is used to update data in a database?
Option 1
UPDATE
Correct
Option 2
MODIFY
Option 3
SAVE AS
Option 4
SAVE
Q No.4 of 10

Which SQL statement is used to delete data from a database?
Option 1
DELETE
Correct
Option 2
REMOVE
Option 3
COLLAPSE
Option 4
None of these
Q No.5 of 10

Which SQL statement is used to insert new data in a database?
Option 1
INSERT INTO
Correct
Option 2
ADD NEW
Option 3
INSERT NEW
Option 4
ADD RECORD
Q No.6 of 10

With SQL, how do you select a column named "FirstName" from a table named "Persons"?
Option 1
SELECT FROM Person COLUMN FirstName
Option 2
SELECT FirstName FROM Persons
Correct
Option 3
EXTRACT FirstName FROM Persons
Option 4
SELECT Persons.FirstName
Q No.7 of 10

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
Option 1
DELETE ROW FirstName='Peter' FROM Persons
Option 2
DELETE FirstName='Peter' FROM Persons
Option 3
DELETE FROM Persons WHERE FirstName = 'Peter'
Correct
Option 4
Non of these
Q No.8 of 10

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
Option 1
INSERT INTO Persons ('Olsen') INTO LastName
Option 2
INSERT INTO Persons (LastName) VALUES ('Olsen')
Correct
Option 3
INSERT ('Olsen') INTO Persons (LastName)
Option 4
Non of these
Q No.9 of 10

Which SQL keyword is used to sort the result-set?
Option 1
SORT
Option 2
ORDER BY
Correct
Option 3
SORT BY
Option 4
ORDER

Q No.10 of 10

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
Option 1
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
Option 2
SELECT FirstName='Peter', LastName='Jackson' FROM Persons
Option 3
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
Correct
Option 4
All of these
MCQs on SQL II

MCQ and Quiz about SQL (Structured Query Language) are available.




Q No.1 of 10

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
Option 1
SELECT * FROM Persons WHERE FirstName='Peter'
Correct
Option 2
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
Option 3
SELECT * FROM Persons WHERE FirstName<>'Peter'
Option 4
SELECT [all] FROM Persons WHERE FirstName='Peter'
Q No.2 of 10

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
Option 1
SELECT * FROM Persons WHERE FirstName='%a%'
Option 2
SELECT * FROM Persons WHERE FirstName='a'
Option 3
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
Correct
Option 4
SELECT * FROM Persons WHERE FirstName LIKE '%a'
Q No.3 of 10

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
Option 1
True
Correct
Option 2
False
Q No.4 of 10

Which SQL statement is used to return only different values?
Option 1
SELECT DIFFERENT
Option 2
SELECT UNIQUE
Option 3
SELECT DISTINCT
Correct
Option 4
All of these
Q No.5 of 10

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Option 1
SELECT * FROM Persons ORDER FirstName DESC
Option 2
SELECT * FROM Persons SORT BY 'FirstName' DESC
Option 3
SELECT * FROM Persons SORT 'FirstName' DESC
Option 4
SELECT * FROM Persons ORDER BY FirstName DESC
Correct
Q No.6 of 10

With SQL, how can you insert a new record into the "Persons" table?
Option 1
INSERT ('Jimmy', 'Jackson') INTO Persons
Option 2
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
Option 3
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
Correct
Option 4
Non of these
Q No.7 of 10

With SQL, how can you count the number of records in the "Persons" table?
Option 1
SELECT COLUMNS() FROM Persons
Option 2
SELECT COUNT() FROM Persons
Option 3
SELECT COLUMNS(*) FROM Persons
Option 4
SELECT COUNT(*) FROM Persons
Correct
Q No.8 of 10

The result of a SELECT statement can contain duplicate rows.
Option 1
True
Correct
Option 2
False
Q No.9 of 10

Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".
Option 1
False
Correct
Option 2
True
Q No.10 of 10

A NULL value is treated as a blank or 0
Option 1
False
Correct
Option 2
True

iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

Solved MCQs on HTML Part-I

MCQs and Quizzes about HTML and HTML Tags.



Q No.1 of 10


HTML stand for_______________.
Option 1
High Text Multi Language
Option 2
Hyper Text Markup Language

Correct
Option 3
Home Tool Markup Language
Option 4
Hyperlinks and Text Markup Language
Q No.2 of 10

Choose the correct HTML tag for the largest heading
Option 1
<heading6>
Option 2
<h6>
Option 3
<h1>

Correct
Option 4
<head1>
Q No.3 of 10

Choose the correct HTML tag to make a text bold
Option 1
<bold>
Option 2
<b>

Correct
Option 3
<bold=true>
Option 4
<bld>
Q No.4 of 10

What is the correct HTML for creating a hyperlink?
Option 1
<a href="http://www. educatepk.com"> educatepk </a>

Correct
Option 2
<a>http://www.educatepk.com</a>
Option 3
<a url="http://www. educatepk.com"> educatepk.com</a>
Option 4
<a name="http://www. educatepk.com"> educatepk.com</a>
Q No.5 of 10

Choose the correct HTML to left-align the content inside a table cell
Option 1
<td leftalign>
Option 2
<td valign="left">
Option 3
<td align:”left”>
Option 4
<td align="left">

Correct
Q No.6 of 10

How can you make a list that lists the items with bullets?
Option 1
<bullets>
Option 2
<ul>

Correct
Option 3
<ol>
Option 4
<list type=”bullets”>
Q No.7 of 10

Choose the correct HTML tag to make a text italic
Option 1
<italic>
Option 2
<text style=”italic”>
Option 3
<i>

Correct
Option 4
<i text=”italic”>
Q No.8 of 10

How can you make a list that lists the items with numbers?
Option 1
<list type=”number”>
Option 2
<number list>
Option 3
<ol>

Correct
Option 4
<ul>
Q No.9 of 10


What is the preferred way for adding a background color in HTML?
Option 1
<body style="background-color: yellow">

Correct
Option 2
<background>yellow</background>
Option 3
<body background="yellow">
Option 4
<body style=”bgcolor=yellow”>

Q No.10 of 10


What is the correct HTML tag for inserting a line break?
Option 1
<endl />
Option 2
<br />

Correct
Option 3
<insertline>
Option 4


<break />


Solved MCQs on HTML Part-II

MCQs and Quizzes about HTML and HTML Tags.



Q No.1 of 10

Choose the correct HTML tag to make a text italic
Option 1
<i>

Correct
Option 2
<italic>
Option 3
<text style=”italic”>
Option 4
<i text=”italic”>
Q No.2 of 10

Who is making the Web standards?
Option 1
Google
Option 2
Intel
Option 3
The World Wide Web Consortium

Correct
Option 4
Microsoft
Q No.3 of 10

Which of these tags are all <table> tags?
Option 1
<table><head><div>
Option 2
<table><tr><td>

Correct
Option 3
<table><tr><li>
Option 4
<thead><ul><tr>
Q No.4 of 10

How can you create an e-mail link?
Option 1
<mail>test@educatepk .com</mail>
Option 2
<mail href=" test@educatepk .com ">
Option 3
<a href=" test@educatepk .com ">
Option 4
<a href="mailto: test@educatepk .com ">

Correct
Q No.5 of 10

How can you open a link in a new browser window?
Option 1
<a href="url" target="new">
Option 2
<link href="url" target="_blank">
Option 3
<a href="url" new>
Option 4
<a href="url" target="_blank">

Correct
Q No.6 of 10

What is the correct HTML for inserting an image?
Option 1
<img href="imgName.gif" alt=" img text " />
Option 2
<img src=" imgName.gif" alt="img text" />

Correct
Option 3
<img alt=" img text "> imgName.gif</img>
Option 4
<image src=" imgName.gif" alt=" img text " />
Q No.7 of 10

What is the correct HTML for inserting a background image?
Option 1
<background img=" bgImgName.gif">
Option 2
img src="bgImgName.gif" background />
Option 3
<body background=" bgImgName.gif">

Correct
Option 4
< bgImgName.gif>
Q No.8 of 10

What is the correct HTML for making a checkbox?
Option 1
<checks>
Option 2
<input type="checkbox" />

Correct
Option 3
<input type="check" />
Option 4
<checkbox>
Q No.9 of 10

What is the correct HTML for making a text input field?
Option 1
<textinput type="text" />
Option 2
<input type="textfield" />
Option 3
<text type="inputfield" />
Option 4
<input type="text" />

Correct


Q No.10 of 10

What is the correct HTML for making a drop-down list?
Option 1
<input type="dropdown" />
Option 2
<select>

Correct
Option 3
<input type="dropdown" />
Option 4
<list type=”dropdown”>

TECH$type=three$author=hide

Name

5G Technology,1,Abbreviations,2,Agent AI,1,Agentic Ai,1,AI in Education,1,AI in Healthcare,1,AI in surgery,1,AI Reasoning,1,Algorithm,1,Algorithms,4,android,2,Artemis Mission,1,Artificial Intelligence,5,Artificial Intelligence AI,2,Artificial Neural Networks,1,ASCI and UNI),1,Augmented Reality,1,Automata,3,Blockchain,1,Blockchain Technology,1,C Language,2,C Programming,1,c#,1,C++,2,C++ Programming,1,CakePhp,1,Carbon Neutrality,1,CCNA,1,Cellular Communication,1,Chatgpt,1,Cloud Computing,4,Compiler Construction,1,Compiler Construction Solved MCQs,1,Compiler Design,1,Computer,18,Computer Applications,1,Computer Architecture,3,Computer Arithmetics,1,Computer Basics,1,Computer Codes (BCD,1,Computer Fundamentals,5,Computer Graphics,4,Computer Networking,2,Computer Networks,4,Computer Organization,1,Computer Science,2,Computer Short Cut Keys,1,Computer Short Keys,1,CPU Sceduling,1,Cryptocurrency,1,CSS,1,CSS PMS,1,Current Trends and Technologies,1,Custom Hardware,1,Cyber Security,6,Cybercrimes,1,DALL-E,1,Data Communication,1,Data Privacy,1,Data structures,3,Database Management System,4,DBMS,4,Deadlock,1,DeepSeek,1,Digital Systems,1,Digital Systems Solved MCQs - Part 2,1,Discrete Mathematics,2,Discrete Structure,1,dot Net,1,EBCDIC,1,Edge Computing,2,English,1,Ethical AI and Bias,1,Ethics,1,Explainable AI (XAI),1,File System,1,Flowcharts,1,General Data Protection Regulation GDPR,1,General Knowledge,1,Generative AI,2,Gig Economy,1,Graphics Designing,1,Helping Materials,1,HTML,1,HTML 5,1,hybrid work model,1,Inference Optimization,1,Information Systems,1,Information Technology,1,Inpage,1,intelligence,1,Internet,1,Internet Basics,1,Internet of Things,1,Internet of things IOT,2,IT,1,JavaScript,1,jQuery,1,Language,11,Languages Processor,1,Languge,1,Li-Fi,1,Linux/Unix,2,Magento,1,Memory Management,1,Microprocessor,1,Microsoft PowerPoint,1,MidJourney,1,mindfulness apps,1,MS Access,1,MS DOS,1,MS Excel,1,MS Word,2,Multimodal AI,1,NASA,1,Number System,1,Object Oriented Programming (OOP),1,Object Oriented Programming(OOP),1,Operating System,9,Operating System Basics,1,oracle,2,Others,1,Pakistan,1,PCS,1,PHP,1,PMS,1,Process Management,2,Programming,3,Programming Languages,1,Python,2,python language,1,Quantitative Aptitude,2,Quantum Computing,2,R Programming,1,Ransomware,1,Robotic Process Automation RPA,1,Robotics,2,Ruby Language,1,search engine optimization,1,Semester III,2,seo,1,Sloved MCQs on Microsoft Power Point - updated,1,Software Engineering,3,Solved MCQs of MS Access - Updated,1,Solved MCQs on Computer Fundamentals,1,SpaceX Starship,1,SQL,1,System Analysis and Design,1,Theory of Computation,1,Trends and Technologies,1,Virtual Reality,1,web,1,web Fundamental,1,Web Technologies,2,Web3,1,WEB3 Technology,1,x8086,1,zoology,1,
ltr
item
COMPUTER SCIENCE SOLVED MCQS: Solved MCQs on SQL
Solved MCQs on SQL
http://cliqcriativo.com.br/images/sql.png
COMPUTER SCIENCE SOLVED MCQS
https://cs-mcqs.blogspot.com/2014/04/solved-mcqs-on-sql.html
https://cs-mcqs.blogspot.com/
https://cs-mcqs.blogspot.com/
https://cs-mcqs.blogspot.com/2014/04/solved-mcqs-on-sql.html
true
1616963833964386058
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content