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
|
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”>
|