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 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”>
Previous Post Next Post