MCQ of Structured Query Language(SQL) With Answer Set -2

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: left;"></div><br />1. Which of the following query is correct for using comparison operators in <a class="zem_slink" href="http://www.iso.org/iso/catalogue_detail.htm?csnumber=45498" rel="homepage" target="_blank" title="SQL">SQL</a>?<br /><br />A) SELECT sname, coursename FROM studentinfo WHERE age>50 and <80;<br /><br />B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;<br /><br />C) SELECT sname, coursename FROM studentinfo WHERE age>50 and WHERE age<80;<br /><br />D) None of the above<br /><br /><br /><br />2.How to select all data from studentinfo table starting the name from letter 'r'?<br /><br />A) SELECT * FROM studentinfo WHERE sname LIKE 'r%';<br /><br />B) SELECT * FROM studentinfo WHERE sname LIKE '%r%';<br /><br />C) SELECT * FROM studentinfo WHERE sname LIKE '%r';<br /><br />D) SELECT * FROM studentinfo WHERE sname LIKE '_r%';<br /><br /><br /><br />3. Which of the following <a class="zem_slink" href="http://en.wikipedia.org/wiki/Select_%28SQL%29" rel="wikipedia" target="_blank" title="Select (SQL)">SQL query</a> is correct for selecting the name of staffs from 'tblstaff' table where salary is 15,000 or 25,000?<br /><br />A) SELECT sname from tblstaff WHERE salary IN (15000, 25000);<br /><br />B) SELECT sname from tblstaff WHERE salary BETWEEN 15000 AND 25000;<br /><br />C) Both A and B<br /><br />D) None of the above<br /><br /><br /><br />4. The SELECT statement, that retrieves all the columns from empinfo table name starting with d to p is ..........................<br /><br />A) SELECT ALL FROM empinfo WHERE ename like '[d-p]%';<br /><br />B) SELECT * FROM empinfo WHERE ename is '[d-p]%';<br /><br />C) SELECT * FROM empinfo WHERE ename like '[p-d]%';<br /><br />D) SELECT * FROM empinfo WHERE ename like '[d-p]%';<br /><br /><br /><br />5. Select a query that retrieves all of the unique countries from the student table?<br /><br />A) SELECT DISTINCT coursename FROM studentinfo;<br /><br />B) SELECT UNIQUE coursename FROM studentinfo;<br /><br />C) SELECT DISTINCT coursename FROM TABLE studentinfo;<br /><br />D) SELECT INDIVIDUAL coursename FROM studentinfo;<br /><br /><br /><br />6. Which query is used for sorting data that retrieves the all the fields from empinfo table and listed them in the ascending order?<br /><br />A) SELECT * FROM empinfo ORDER BY age;<br /><br />B) SELECT * FROM empinfo ORDER age;<br /><br />C) SELECT * FROM empinfo ORDER BY COLUMN age;<br /><br />D) SELECT * FROM empinfo SORT BY age; <br /><br /><br /><br />7. Select the right statement to insert values to the stdinfo table.<br /><br />A) <a class="zem_slink" href="http://en.wikipedia.org/wiki/Insert_%28SQL%29" rel="wikipedia" target="_blank" title="Insert (SQL)">INSERT</a> VALUES ("15", "Hari Thapa", 45, 5000) INTO stdinfo;<br /><br />B) INSERT VALUES INTO stdinfo ("15", "Hari Thapa", 45, 5000);<br /><br />C) INSERT stdinfo VALUES ("15", "Hari Thapa", 45, 5000);<br /><br />D) INSERT INTO stdinfo VALUES ("15", "Hari Thapa", 45, 5000);<br /><br /><br /><br />8. How to Delete records from studentinfo table with name of student 'Hari Prasad'?<br /><br />A) <a class="zem_slink" href="http://en.wikipedia.org/wiki/Delete_%28SQL%29" rel="wikipedia" target="_blank" title="Delete (SQL)">DELETE</a> FROM TABLE studentinfo WHERE sname='Hari Prasad';<br /><br />B) DELETE FROM studentinfo WHERE sname='Hari Prasad';<br /><br />C) DELETE FROM studentinfo WHERE COLUMN sname='Hari Prasad';<br /><br />D) DELETE FROM studentinfo WHERE sname LIKE 'Hari Prasad';<br /><br /><br /><br />9. Constraint checking can be disabled in existing ............. and .............. constraints so that any data you modify or add to the table is not checked against the constraint.<br /><br />A) CHECK, <a class="zem_slink" href="http://en.wikipedia.org/wiki/Foreign_key" rel="wikipedia" target="_blank" title="Foreign key">FOREIGN KEY</a><br /><br />B) DELETE, FOREIGN KEY<br /><br />C) CHECK, PRIMARY KEY<br /><br />D) PRIMARY KEY, FOREIGN KEY<br /><br /><br /><br />10. ..................... joins two or more tables based on a specified column value not equaling a specified column value in another table.<br /><br />A) OUTER JOIN<br /><br />B) <a class="zem_slink" href="http://en.wikipedia.org/wiki/Join_%28SQL%29" rel="wikipedia" target="_blank" title="Join (SQL)">NATURAL JOIN</a><br /><br />C) NON-EQUIJOIN<br /><br />D) EQUIJOIN<br /><br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1.  B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;<br />2.  A) SELECT * FROM  studentinfo WHERE sname LIKE 'r%';<br />3.  A) SELECT sname from tblstaff WHERE salary IN (15000, 25000);<br />4.  D) SELECT * FROM empinfo WHERE ename like '[d-p]%';<br />5.  A) SELECT DISTINCT coursename FROM studentinfo;<br />6.  A) SELECT * FROM  empinfo ORDER BY age;<br />7.  D) INSERT INTO stdinfo VALUES ("15", "Hari Thapa", 45, 5000);<br />8.  B) DELETE FROM studentinfo WHERE sname='Hari Prasad';<br />9. A) CHECK, FOREIGN KEY<br />10.C) NON-EQUIJOIN<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><div class="MsoNormal"><ul><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-sql-server-set-1.html" target="_blank">Solved MCQ of SQL Server set-1</a></li><li><a href="http://www.siteforinfotech.com/2013/06/solved-mcq-of-plsql-and-oracle-set-1.html">Solved MCQ of PL/SQL and Oracle set-1 </a></li><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-internet-and-html-set-1.html">Solved MCQ of Internet and HTML set-1 </a> </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-c-set-1_26.html">Solved MCQ of C set-1</a> </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set-2</a>  </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html">Solved MCQ of Data Structure Set-1</a>  </li><li><a href="http://www.siteforinfotech.com/2012/12/mcq-of-database-management-system-dbms_11.html">Solved MCQ of Database Management System (DBMS) Set - 3</a> </li></ul><div style="background-color: white;"><h2><span style="font-size: small;"><b>You can view the following</b> <b>other posts</b></span></h2></div><div class="MsoNormal" style="background-color: white;"><ul><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set - 2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-java-for-java-proficiency.html">Solved MCQ of Java for Java Proficiency test set-3</a></li><li><a href="http://www.blogger.com/blogger.g?blogID=3332849087599085574#editor/target=post;postID=6677146666461105703;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=postname">MCQ of C++ with answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-computer-networking-with-answer_17.html">MCQ of Computer Networking with answer set-4</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/03/solved-mcq-of-database-management-system-dbms.html" target="_blank">Solved MCQ of Database Management System (DBMS) Set - 8</a></li></ul><h2><span style="font-size: small;">For other more Multiple Choice Questions (MCQs): <a href="http://www.siteforinfotech.com/p/mcqs.html" link="red">Click Here</a></span></h2></div></div></div>

MCQ of Structured Query Language(SQL) With Answer Set -2

1. Which of the following query is correct for using comparison operators in SQL ? A) SELECT sname, coursename FROM studentinfo WHERE age...

مزيد من المعلومات »

Solved MCQ of SQL Server set-1

<div dir="ltr" style="text-align: left;" trbidi="on">1. ........................ is the full form of SQL.<br />A) Standard Query Language<br />B) Sequential Query Language<br />C) Structured Query Language<br />D) Server Side Query Language<br /><br />2. SQL Server 2005 NOT includes the following system database .............<br />A) tempdb Database<br />B) Master Database<br />C) Model Database<br />D) sqldb Database<br /><br /><a name="more"></a>3. SQL Server stores index information in the ..................... system table.<br />A) sysindexes<br />B) systemindexes<br />C) sysind<br />D) sysindexes<br /><br />4. ..................... is a read-only database that contains system objects that are included with SQL Server 2005.<br />A) Resource Database<br />B) Master Database<br />C) Model Database<br />D) msdb Database<br /><br />5. The SQL Server services includes .....................<br />A) SQL server agent<br />B) Microsoft distribution transaction coordinator<br />C) Both a & b<br />D) None of the above<br /><br />6. ...................... is a utility to capture a continuous record of server activity and provide auditing capability.<br />A) SQL server profile<br />B) SQL server service manager<br />C) SQL server setup<br />D) SQL server wizard<br /><br />7. The query used to remove all references for the pubs and newspubs databases from the system tables is ..........................<br />A) DROP DATABASE pubs, newpubs;<br />B) DELETE DATABASE pubs, newpubs;<br />C) REMOVE DATABASE pubs, newpubs;<br />D) DROP DATABASE pubs and newpubs;<br /><br />8. ...................... clause specifies the groups into which output rows are to be placed and, if aggregate functions are included in the SELECT clause.<br />A) ORDER BY<br />B) GROUP<br />C) GROUP BY<br />D) GROUP IN<br /><br />9. .................. are predefined and maintained SQL Server where users cannot assign or directly change the values.<br />A) Local Variables<br />B) Global Variables<br />C) Assigned Variables<br />D) Direct Variables<br /><br />10. Microsoft SQL Server NOT uses which of the following operator category?<br />A) Bitwise Operator <br />B) Unary Operator<br />C) Logical Operator<br />D) Real Operator<br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1.  C) Structured Query Language<br />2.  D) sqldb Database<br />3.  D) sysindexes<br />4.  A) Resource Database<br />5.  C) Both a & b <br />6.  B) SQL server service manager <br />7.  A) DROP DATABASE pubs, newpubs;<br />8.  C) GROUP BY<br />9.  B) Global Variables<br />10.D) Real Operator<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><div class="MsoNormal" style="text-align: left;"><ul></ul><ul></ul><ul><li><a href="http://www.siteforinfotech.com/2013/06/solved-mcq-of-sql-server-set-2.html">Solved MCQ of SQL Server Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/05/mcq-of-structured-query-language-sql-with-answer.html" target="_blank">MCQ of SQL With Answer Set -2</a></li><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-internet-and-html-set-1.html">Solved MCQ of Internet and HTML set-1 </a> </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-c-set-1_26.html">Solved MCQ of C set-1</a> </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set-2</a>  </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html">Solved MCQ of Data Structure Set-1</a> </li><li><a href="http://www.siteforinfotech.com/2012/12/mcq-of-database-management-system-dbms_11.html">Solved MCQ of Database Management System (DBMS) Set - 3</a> </li></ul><div style="background-color: white;"><h2><span style="font-size: small;"><b>You can view the following</b> <b>other posts</b></span></h2></div><div class="MsoNormal" style="background-color: white;"><ul><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set - 2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-java-for-java-proficiency.html">Solved MCQ of Java for Java Proficiency test set-3</a></li><li><a href="http://www.blogger.com/blogger.g?blogID=3332849087599085574#editor/target=post;postID=6677146666461105703;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=postname">MCQ of C++ with answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-computer-networking-with-answer_17.html">MCQ of Computer Networking with answer set-4</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/03/solved-mcq-of-database-management-system-dbms.html" target="_blank">Solved MCQ of Database Management System (DBMS) Set - 8</a></li><li> </li></ul><h2><span style="font-size: small;">For other more Multiple Choice Questions (MCQs): <a href="http://www.siteforinfotech.com/p/mcqs.html" link="red">Click Here</a></span></h2></div></div></div>

Solved MCQ of SQL Server set-1

1. ........................ is the full form of SQL. A) Standard Query Language B) Sequential Query Language C) Structured Query Language D)...

مزيد من المعلومات »

Solved MCQ of E-Commerce and E-Banking Set-1

<div dir="ltr" style="text-align: left;" trbidi="on">1. The term e-commerce includes ............................<br />A) Electronic trading of Physical goods and intangibles such as information.<br />B) The electronic provision of services such as after sales support or online legal advice<br />C) All the steps involved in trade, such as on-line marketing ordering payment and support for delivery.<br />D) All of the above.<br /><br /><a name="more"></a><br />2. Which of the following is the largest community in classification of e-commerce?<br />A) Business to Business (B to B)<br />B) Business to Consumer (B to C)<br />C) Business to Government (B to G)<br />D) Government to Government (G to G)<br /><br />3. Which of the following is not the example of business to consumer (B to C) e-commerce?<br />A) Amazon.com<br />B) e-bay.com<br />C) dell.com<br />D) lastminute.com<br /><br />4. The types of Business to Business e-commerce are ................<br />A) Direct selling and support to Business<br />B) Industry portals<br />C) Information sites about a industry<br />D) All of the above<br /><br />5. Which of the following are the benefits of E-marketing?<br />i) Speed                                ii) Reach and Penetration<br />iii) Ease and Efficiency           iv) Low Cost<br />v) Targeted audience<br />A) i, ii, iii and iv only<br />B) ii, iii, iv and v only<br />C) i, iii, iv and v only<br />D) All i, ii, iii, iv and v <br /><br />6. ...................... is the process of recreating a design by analyzing a final product.<br />A) Forward Engineering<br />B) Reverse Engineering<br />C) Backward Engineering<br />D) None of the above<br /><br />7. .................. is simply the use of electronic means to transfer funds directly from one account to another, rather than by cheque or cash.<br />A) M-Banking<br />B) O-Banking<br />C) E-Banking<br />D) D-Banking<br /><br />8. The telephone banking service includes ...................<br />i) Automatic balance voice out   ii) Inquiry all term deposit account<br />iii) Direct cash withdraw           iv) Utility Bill payments<br />v) Voice out last five transactions<br />A) i, ii, iii and v only<br />B) i, ii, iv and v only<br />C) ii, iii, iv and v only<br />D) All i, ii, iii, iv and v<br /><br />9. Which of the following are the forms of E-banking?<br />i) Internet Banking                      ii) Telephone Banking<br />iii) Electronic Check conversion   iv) Electronic Bill Payment<br />v) Direct Deposit<br />A) i, ii, iii and iv only<br />B) ii, iii, iv and v only<br />C) i, iii, iv and v only<br />D) All i, ii, iii, iv and v <br /><br />10. What is the full form of SWIFT?<br />A) Society for Worldwide Internet Financial Telecommunications.<br />B) Secret Wide Interbank Financial Telecommunications<br />C) Society for Worldwide Interbank Financial Telecommunications<br />D) None of the Above<br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1.  D) All of the above.<br />2.  A) Business to Business (B to B)<br />3.  B) e-bay.com<br />4.  D) All of the above<br />5.  D) All i, ii, iii, iv and v <br />6.  B) Reverse Engineering <br />7.  C) E-Banking<br />8.  B) i, ii, iv and v only<br />9.  D) All i, ii, iii, iv and v <br />10.D) None of the Above<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><div class="MsoNormal"><ul><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-internet-and-html-set-1.html">Solved MCQ of Internet and HTML set-1 </a> </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-c-set-1_26.html">Solved MCQ of C set-1</a> </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set-2</a>  </li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html">Solved MCQ of Data Structure Set-1</a> </li><li><a href="http://www.siteforinfotech.com/2012/12/mcq-of-database-management-system-dbms_11.html">Solved MCQ of Database Management System (DBMS) Set - 3</a> </li></ul><div style="background-color: white;"><h2><span style="font-size: small;"><b>You can view the following</b> <b>other posts</b></span></h2></div><div class="MsoNormal" style="background-color: white;"><ul><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set - 2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-java-for-java-proficiency.html">Solved MCQ of Java for Java Proficiency test set-3</a></li><li><a href="http://www.blogger.com/blogger.g?blogID=3332849087599085574#editor/target=post;postID=6677146666461105703;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=postname">MCQ of C++ with answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-computer-networking-with-answer_17.html">MCQ of Computer Networking with answer set-4</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/03/solved-mcq-of-database-management-system-dbms.html" target="_blank">Solved MCQ of Database Management System (DBMS) Set - 8</a></li><li> </li></ul><h2><span style="font-size: small;">For other more Multiple Choice Questions (MCQs): <a href="http://www.siteforinfotech.com/p/mcqs.html" link="red">Click Here</a></span></h2></div></div></div>

Solved MCQ of E-Commerce and E-Banking Set-1

1. The term e-commerce includes ............................ A) Electronic trading of Physical goods and intangibles such as information. B)...

مزيد من المعلومات »

Solved MCQ of Computer Organization and Architecture set-1

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><br />1. A collection of lines that connects several devices is called ..............<br /><br />A) bus<br /><br />B) peripheral connection wires<br /><br />C) Both a and b<br /><br />D) internal wires<br /><br /><br /><br />2. A complete microcomputer system consist of ...........<br /><br />A) microprocessor<br /><br />B) memory<br /><br />C) peripheral equipment<br /><br />D) all of the above<br /><br /><br /><br />3. PC Program Counter is also called ...................<br /><br />A) instruction pointer<br /><br />B) memory pointer<br /><br />C) data counter<br /><br />D) file pointer<br /><br /><br /><br />4. In a single byte how many bits will be there?<br /><br />A) 8<br /><br />B) 16<br /><br />C) 4<br /><br />D) 32<br /><br /><br /><br />5. CPU does not perform the operation ..................<br /><br />A) data transfer<br /><br />B) logic operation<br /><br />C) arithmetic operation<br /><br />D) all of the above<br /><br /><br /><br />6. The access time of memory is ............... the time required for performing any single CPU operation.<br /><br />A) Longer than<br /><br />B) Shorter than<br /><br />C) Negligible than<br /><br />D) Same as<br /><br /><br /><br />7. Memory address refers to the successive memory words and the machine is called as ............<br /><br />A) word addressable<br /><br />B) byte addressable<br /><br />C) bit addressable<br /><br />D) Terra byte addressable<br /><br /><br /><br />8. A microprogram written as string of 0's and 1's is a .............<br /><br />A) Symbolic microinstruction<br /><br />B) binary microinstruction<br /><br />C) symbolic microinstruction<br /><br />D) binary micro-program<br /><br /><br /><br />9. A pipeline is like ....................<br /><br />A) an automobile assembly line<br /><br />B) house pipeline<br /><br />C) both a and b<br /><br />D) a gas line<br /><br /><br /><br />10. Data hazards occur when .....................<br /><br />A) Greater performance loss<br /><br />B) Pipeline changes the order of read/write access to operands<br /><br />C) Some functional unit is not fully pipelined<br /><br />D) Machine size is limited<br /><br /><br /><br /><h4 style="text-align: left;"> Answers:</h4><div><br /></div><br />1. A) bus<br /><br />2. D) all of the above<br /><br />3. A) instruction pointer<br /><br />4. A) 8<br /><br />5. A) data transfer<br /><br />6. A) Longer than<br /><br />7. A) word addressable<br /><br />8. D) binary microprogram<br /><br />9. A) an automobile assembly line<br /><br />10. B) Pipeline changes the order of read/write access to operands<br /><br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><div class="MsoNormal"><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2013/07/solved-mcq-of-computer-organization-and-organization.html">Solved MCQ of Computer Organization and Architecture set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/08/mcq-of-computer-organization-architecture.html">MCQ of Computer Organization and Architecture with Answer set-3</a></li><li><a href="http://www.siteforinfotech.com/2013/12/computer-organization-and-architecture-interview-questions.html">Computer Organization and Architecture Interview Questions set-4</a></li><li><a href="http://www.siteforinfotech.com/2013/12/computer-organization-architecture-objective-questions.html">Computer Organization and Architecture Objective Questions set-5</a></li></ul><ul style="margin: 0.5em 0px; padding: 0px 2.5em; text-align: left;"></ul><div style="background-color: white;"><h2><span style="font-size: small;"><b>You can view the following</b> <b>other posts</b></span></h2></div><div class="MsoNormal" style="background-color: white;"><ul><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set - 2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-java-for-java-proficiency.html">Solved MCQ of Java for Java Proficiency test set-3</a></li><li><a href="http://www.blogger.com/blogger.g?blogID=3332849087599085574#editor/target=post;postID=6677146666461105703;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=postname">MCQ of C++ with answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-computer-networking-with-answer_17.html">MCQ of Computer Networking with answer set-4</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/03/solved-mcq-of-database-management-system-dbms.html" target="_blank">Solved MCQ of Database Management System (DBMS) Set - 8</a></li><li> </li></ul><h2><span style="font-size: small;">For other more Multiple Choice Questions (MCQs): <a href="http://www.siteforinfotech.com/p/mcqs.html" link="red">Click Here</a></span></h2></div></div></div>

Solved MCQ of Computer Organization and Architecture set-1

1. A collection of lines that connects several devices is called .............. A) bus B) peripheral connection wires C) Both a and b D) int...

مزيد من المعلومات »

MCQ of Internet and HTML With Answer Set-2

<div dir="ltr" style="text-align: left;" trbidi="on"><br />1. ......................... connects web pages.<br />A) Connector<br />B) Link<br />C) Hyperlink<br />D) None of the above<br /><br />2. Internet is ...............................<br />A) a network of networks<br />B) an ocean of resources waiting to be mined<br />C) a cooperative anarchy<br />D) all of the above<br /><br />3. .................. is suitable for remote administration of a computer.<br />A) FTP<br />B) Shell<br />C) Remote Procedure Call<br />D) Telnet<br /><br />4. Title tag is nested within the ....................... tag.<br />A) Body<br />B) Head<br />C) List<br />D) Table<br /><br />5. .................... is a web's native protocol.<br />A) SLIP<br />B) TCP/IP<br />C) HTTP<br />D) PPP<br /><br />6. The Internet uses the ........................ as the protocol engine.<br />A) SLIP<br />B) HTTP<br />C) TCP/IP<br />D) PPP<br /><br />7. A ............................. is a symbolic name a network administrator assigns to a machine.<br />A) URL<br />B) DNS<br />C) IP address<br />D) Host name<br /><br />8.  Which of the following protocol is used for e-mail services.<br />A) SMAP<br />B) SMTP<br />C) SMIP<br />D) SMOP<br /><br />9. ...................... is the incoming e-mail server.<br />A) POP<br />B) SMTP<br />C) SMIP<br />D) PPP<br /><br />10. ....................... is a uniform naming scheme for locating resources on the web.<br />A) URI<br />B) HTTP<br />C) WEBNAME<br />D) RESOURCENAME<br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1. C) Hyperlink<br />2.  D) all of the above<br />3.  D) Telnet<br />4.  B) Head<br />5.  C) HTTP<br />6.  C) TCP/IP<br />7.  D) Host name<br />8.  B) SMTP<br />9.  A) POP<br />10. A) URI<br /><br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><div class="MsoNormal"><ul style="margin: 0.5em 0px; padding: 0px 2.5em; text-align: left;"><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-internet-and-html-set-1.html" target="_blank">Solved MCQ of Internet and HTML set-1 </a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-c-set-1_26.html" target="_blank">Solved MCQ of C set-1</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18px;">Solved MCQ of Data Structure Set-2</a> </li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html" target="_blank">Solved MCQ of Data Structure Set-1</a><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2012/12/mcq-of-database-management-system-dbms_11.html">Solved MCQ of Database Management System (DBMS) Set - 3</a> </li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-database-management.html">Solved MCQ of Database Management System (DBMS) Set - 5</a> </li></ul><div style="background-color: white;"><h2><span style="font-size: small;"><b>You can view the following</b> <b>other posts</b></span></h2></div><div class="MsoNormal" style="background-color: white;"><ul><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set - 2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-java-for-java-proficiency.html">Solved MCQ of Java for Java Proficiency test set-3</a></li><li><a href="http://www.blogger.com/blogger.g?blogID=3332849087599085574#editor/target=post;postID=6677146666461105703;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=postname">MCQ of C++ with answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-computer-networking-with-answer_17.html">MCQ of Computer Networking with answer set-4</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/03/solved-mcq-of-database-management-system-dbms.html" target="_blank">Solved MCQ of Database Management System (DBMS) Set - 8</a></li><li> </li></ul><h2><span style="font-size: small;">For other more Multiple Choice Questions (MCQs): <a href="http://www.siteforinfotech.com/p/mcqs.html" link="red">Click Here</a></span></h2></div></div></div>

MCQ of Internet and HTML With Answer Set-2

1. ......................... connects web pages. A) Connector B) Link C) Hyperlink D) None of the above 2. Internet is ........................

مزيد من المعلومات »

Solved MCQ of Internet and HTML set-1

<div dir="ltr" style="text-align: left;" trbidi="on"><br />1. The attribute .................. of <BODY> tag sets color of hypertext links.<br />A) link<br />B) vlink<br />C) alink<br />D) hlink<br /><br />2. Default font size of HTML is .......................<br />A) 2<br />B) 4<br />C) 6<br />D) 3<br /><br /><a name="more"></a>3. This is a networking device that passes data between networks having similar functions but dissimilar implementations.<br />A) Hub<br />B) Modem<br />C) Gateway<br />D) Repeater<br /><br />4. In order to connect to ISP's server you need .......<br />A) Hand gloves<br />B) Printer<br />C) User name and Password<br />D) None of the above<br /><br />5. DNS translates .........<br />A) domain name into IP<br />B) IP into domain name<br />C) both a & b<br />D) domain name into physical address<br /><br />6. In order to upload a HTML file to a web server, you use<br />A) HTTP<br />B) SMTP<br />C) SIP<br />D) FTP<br /><br />7. IEEE stands for ........<br />A) Institute of estimated elevator efficiency<br />B) Institute of electrical and economical engineers<br />C) Institute of Eurasia engineering event<br />D) Institute of electrical and electronics engineers<br /><br />8. The regional networks are connected to the corporate networks, this is also called as ........<br />A) Backbone<br />B) LAN COM<br />C) WAN COM<br />D) Intranet<br /><br />9. Once the email is sent, the message is broken into pieces called ..................<br />A) Packets<br />B) Process<br />C) Digits<br />D) Bytes<br /><br />10. ................... is known as father of World Wide Web.<br />A) Robert Cailliau<br />B) Tim Thompson<br />C) Charles Darwin<br />D) Tim Berners-Lee<br /><br /><br /><div style="text-align: left;"><span style="font-size: large;">Answers:</span></div><br />1. A) link<br />2. D) 3<br />3. C) Gateway<br />4. C) User name and Password<br />5. C) both a & b<br />6. D) FTP<br />7. D) Institute of electrical and electronics engineers<br />8. A) Backbone<br />9. A) Packets<br />10. D) Tim Berners-Lee<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><div class="MsoNormal"><ul style="margin: 0.5em 0px; padding: 0px 2.5em; text-align: left;"></ul><ul style="margin: 0.5em 0px; padding: 0px 2.5em; text-align: left;"><li> <a class="GIL3GQOBOB" href="http://www.siteforinfotech.com/2013/05/mcq-of-internet-and-html-with-answer.html" target="_blank">MCQ of Internet and HTML With Answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-c-set-1_26.html" target="_blank">Solved MCQ of C set-1</a></li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18px;">Solved MCQ of Data Structure Set-2</a> </li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html" target="_blank">Solved MCQ of Data Structure Set-1</a><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2012/12/mcq-of-database-management-system-dbms_11.html">Solved MCQ of Database Management System (DBMS) Set - 3</a> </li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/01/mcq-of-database-management-system-dbms.html">Solved MCQ of Database Management System (DBMS) Set - 4</a> </li><li style="background-color: white;"><a href="http://www.siteforinfotech.com/2013/03/solved-mcq-of-database-management-system-dbms.html" target="_blank">Solved MCQ of Database Management System (DBMS) Set - 8</a></li></ul><div style="background-color: white;"><h2><span style="font-size: small;"><b>You can view the following</b> <b>other posts</b></span></h2></div><div class="MsoNormal" style="background-color: white;"><ul><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-2.html">Solved MCQ of Data Structure Set - 2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/solved-mcq-of-java-for-java-proficiency.html">Solved MCQ of Java for Java Proficiency test set-3</a></li><li><a href="http://www.blogger.com/blogger.g?blogID=3332849087599085574#editor/target=post;postID=6677146666461105703;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=postname">MCQ of C++ with answer Set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-computer-networking-with-answer_17.html">MCQ of Computer Networking with answer set-4</a></li></ul><h2><span style="font-size: small;">For other more Multiple Choice Questions (MCQs): <a href="http://www.siteforinfotech.com/p/mcqs.html" link="red">Click Here</a></span></h2></div></div></div>

Solved MCQ of Internet and HTML set-1

1. The attribute .................. of <BODY> tag sets color of hypertext links. A) link B) vlink C) alink D) hlink 2. Default font si...

مزيد من المعلومات »

How to Optimize Images for Web Using Photoshop and ImageReady?

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVlnmjuxiI-D7fSC8i1MfRwjdA0h9heAy5732qPVoFF4fsV_fgZwfQznfSeFrS90ZBcYJgYx3paox8AYI_6aK2qbE_VKCRF3q8eQiz2mXUVJEedJIqo1qp4F04-d797uFGgC7E4BFunc-O/s1600/image-optimization.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Image Optimization" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVlnmjuxiI-D7fSC8i1MfRwjdA0h9heAy5732qPVoFF4fsV_fgZwfQznfSeFrS90ZBcYJgYx3paox8AYI_6aK2qbE_VKCRF3q8eQiz2mXUVJEedJIqo1qp4F04-d797uFGgC7E4BFunc-O/s1600/image-optimization.png" title="Image Optimization" /></a></div><div style="text-align: justify;">Using optimized images on your website or blog is most necessary thing for both loading speed and quality. The size of optimized images are very small than the original images, so it can decrease the weight of your site drastically. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">There are lots of free as well as paid websites for providing service of image optimization on online. You can also use some special applications for optimizing images by downloading from web. But today, I am going to tell about a best offline method using well known applications Adobe Photoshop and ImageReady. </div><div style="text-align: justify;"><br /><a name="more"></a></div><h3 style="text-align: left;">To Optimize Images Using Adobe Photoshop </h3><div style="text-align: justify;"><br /></div><div style="text-align: justify;">It is well known that Adobe Photoshop is the most popular Photo editing Software. Along with editing you can save images as optimize for web by using the following steps. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">1. At first open an image using Adobe Photoshop program and redesign or edit that using appropriate tools. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">2. After that go to file menu and click on save for web option. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">3. In the new window select Optimized or 2-up or 4-up tab to preview optimized images. Select the image having required format and quality and click on save. </div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLqD-ShoTOnpUtlycD4gi-g5np_29uRyQ_-aOUIvn8E8RIyhcJbPSpDMPJIlIQ07dDBzm_SuNYh_03bkUvpFdHt17abAQrocFMHBzeO93yLr32FV6kP3IzBdG4qqK7PI52F7I3UDE6CI9A/s1600/img-opt-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="optimizing image using photoshop" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLqD-ShoTOnpUtlycD4gi-g5np_29uRyQ_-aOUIvn8E8RIyhcJbPSpDMPJIlIQ07dDBzm_SuNYh_03bkUvpFdHt17abAQrocFMHBzeO93yLr32FV6kP3IzBdG4qqK7PI52F7I3UDE6CI9A/s1600/img-opt-1.png" title="optimizing image using photoshop" /></a></div><div style="text-align: justify;"><br /></div><h3 style="text-align: left;">To Optimize Images Using Adobe ImageReady </h3><div style="text-align: justify;"><br /></div><div style="text-align: justify;">Adobe ImageReady is the application specially for designing images for web. You can create different size of banners image in the number of formats like '.jpeg', '.gif', '.png' etc. To save your designed image as optimized for web, you can use the following steps. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">1. At first open an image using Adobe ImageReady program and redesign or edit that using appropriate tools. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">2. Select the required file format and quality from the palate. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">3. After that go to file menu and click on save optimized as option. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">4. Click on save after giving filename. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">If you have such any other tips for optimizing images for web and if you have any comments about this post you can mention this on the comment session of this blog. I will always welcome to you</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><h2 style="text-align: left;"><span style="font-size: small;">You may also wanted to view the following related posts</span></h2><div class="MsoNormal" style="text-align: left;"><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2013/05/best-blog-post-optimization-tips-for-blogger.html" target="_blank">Best Blog Post Optimization Tips for Blogger</a></li><li><a href="http://www.siteforinfotech.com/2013/05/how-to-add-feedburners-icon-and-e-mail.html" target="_blank">How to add Feedburner's icon and e-mail subscription box?</a></li><li><a href="http://www.siteforinfotech.com/2013/05/how-to-setup-google-feedburner-feed-to-your-blog.html" target="_blank">How To Setup Google Feedburner Feed To Your Blog ?</a></li><li><a href="http://www.siteforinfotech.com/2013/05/most-effective-tips-for-your-link-building-success.html" target="_blank">Most Effective Tips for Your Link Building Success</a></li><li><a href="http://www.siteforinfotech.com/2013/05/easy-methods-to-increase-your-website-speed.html">Easy Methods to Increase Your Website Speed</a></li><li><a href="http://www.siteforinfotech.com/2013/05/how-to-utilize-google-services-for-effective-seo.html" target="_blank">How to Utilize Google Services for effective SEO?</a></li><li><a href="http://www.siteforinfotech.com/2013/04/top-20-lists-of-blog-search-sites-and.html" target="_blank">Top 20+ Lists of Blog Search Sites and Directories</a></li><li><a href="http://www.siteforinfotech.com/2013/04/list-top-65-search-engine-submission-add-urls.html" target="_blank">List of Top 65 Search Engine Submission Add URLs</a></li><li><a href="http://www.siteforinfotech.com/2013/03/list-of-top-7-free-bulk-search-engine-submission-tools.html" target="_blank">List of top 7 Free bulk search engine submission tools</a></li><li><a href="http://www.siteforinfotech.com/2013/03/list-top-.edu-forums-sites-to-create-quality-backlinks.html" target="_blank">List of top .edu forums or sites to create quality backlinks</a></li><li><a href="http://www.siteforinfotech.com/2012/12/list-of-sites-to-create-shortcut-url.html">List of sites to create shortcut URL for your bog or site</a></li></ul></div><h1 style="font-size: large; text-align: left;">Tags: <a href="http://www.siteforinfotech.com/2013/05/most-effective-tips-for-your-link-building-success.html" target="_blank">Link Building  </a><a href="http://www.siteforinfotech.com/2013/03/list-good-ways-building-quality-backlinks.html" target="_blank">creating quality backlinks</a>  <a href="http://www.siteforinfotech.com/2013/04/list-of-best-keyword-research-tools-for-seo.html" target="_blank">keyword research tools</a> <a href="http://www.siteforinfotech.com/search/label/Blogging%20Tips" target="_blank">Blogging Tips</a></h1></div></div>

How to Optimize Images for Web Using Photoshop and ImageReady?

Using optimized images on your website or blog is most necessary thing for both loading speed and quality. The size of optimized images are ...

مزيد من المعلومات »