Java MCQ Questions and Answers set-5

<div dir="ltr" style="text-align: left;" trbidi="on">1. Preparedstatement Object in JDBC is used to execute ........................... queries.<br />A) executable<br />B) simple<br />C) high level<br />D) parameterized<br /><br />2. In JDBC ........................ imports all Java classes concerned with database connectivity.<br />A) javax.sql.*<br />B) java.mysql.*<br />C) java.sql.*<br />D) com.*<br /><br />3. MS-SQL stores data in a ........................ file format.<br />A) .DAT<br />B) .MDB<br />C) .MSSQL<br />D) .OBJ<br /><br />4. Ingres is a ........................<br />A) Socket<br />B) Compiler<br />C) Database<br />D) Web server<br /><br />5. In Java servlet method init( ) is called ..................... times.<br />A) 1<br />B) 2<br />C) 0<br />D) multiple<br /><br />6. State true or false for Java Program.<br />i) All class variables are instance variables<br />ii) All protected methods are friendly methods<br />A) i-false, ii-false<br />B) i-false, ii-true<br />C) i-true, ii-false<br />D) i-true, ii-true<br /><br />7. State true or false for Java Program.<br />i) Data members of an interface are by default final<br />ii) An abstract class has implementations of all methods defined inside it.<br />A) i-false, ii-false<br />B) i-false, ii-true<br />C) i-true, ii-false<br />D) i-true, ii-true<br /><br />8. ........................ of a remotely accessible object must implement ................<br />A) all methods, RemoteException<br />B) class, RemoteException<br />C) class, RemoteInterface<br />D) all methods, RemoteInterface<br /><br />9. ......................is the key to ........................<br />A) Serialization, persistence<br />B) Persistence, inheritance<br />C) Inheritance, object<br />D) Persistence, serialization<br /><br />10. A method name myMethod( ) that needs two integer arguments is declared as<br />A) public void myMethod( );<br />B) public void myMethod(int a, int b);<br />C) public void myMethod(int a, b);<br />D) public int myMethod(a, b);<br /><br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1.  D) parameterized<br />2.  C) java.sql.*<br />3.  A) .DAT<br />4.  C) Database<br />5.  A) 1<br />6.  B) i-false, ii-true<br />7.  C) i-true, ii-false<br />8.  C) class, RemoteInterface<br />9.  A) Serialization, persistence<br />10.B) public void myMethod(int a, int b);<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-java-set-1.html">Solved MCQ of Java Set-1</a></li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-java-with-answer-set-2.html">MCQ of Java with answer 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.siteforinfotech.com/2013/06/solved-mcq-of-java-set-4.html" target="_blank">Solved MCQ of Java set-4</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/mcq-of-database-management-system-dbms_11.html">Solved MCQ of DBMS Set - 3</a></li></ul><div class="MsoNormal"><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/05/solved-mcq-of-sql-server-set-1.html">Solved MCQ of SQL Server set-1</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><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>

Java MCQ Questions and Answers set-5

1. Preparedstatement Object in JDBC is used to execute ........................... queries. A) executable B) simple C) high level D) paramet...

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

Solved MCQ of Java set-4

1. In Java variables, if first increment of the variable takes place and then the assignment occurs. This operation is also called ............................. .<br />A) pre increment<br />B) post increment<br />C) incrementation<br />D) pre incrementation<br /><br />2. When the operators are having the same priority, they are evaluated from .................  ............. in the order they appear in the expression.<br />A) right to left<br />B) left to right<br />C) any of the order<br />D) depends on compiler<br /><br />3. In java,  ............. can only test for equality, where as ............ can evaluate any type of the Boolean expression.<br />A) switch, if<br />B) if, switch<br />C) if, break<br />D) continue, if<br /><br /><a name="more"></a>4. The ....................... looks only for a match between the value of the expression and one of its case constants.<br />A) if<br />B) match<br />C) switch<br />D) None of the above<br /><br />5. System.in.read() is being used, the program must specify the .................. clause.<br />A) throws.java.out.IOException<br />B) throws.java.in.IOException<br />C) throws.java.io.IOException<br />D) throws.java.io.InException<br /><br />6. By using ................... you can force immediate termination of a loop, by passing the conditional expression and any remaining code in the body of the loop.<br />A) Break<br />B) Continue<br />C) Terminate<br />D) Loop Close<br /><br />7. The out object is an object encapsulated inside the ................. class, and represents the standard output device.<br />A) standard<br />B) local<br />C) globlal<br />D) system<br /><br />8. The third type of comment is used by a tool called .................. for automatic generation of documentation.<br />A) Java commenting<br />B) Java generator<br />C) Java doc<br />D) Java loc<br /><br />9. In the second type the information written in java after // is ignored by the .......................<br />A) Interpreter<br />B) Compiler<br />C) Programmer<br />D) All of the above<br /><br />10. The compiled java program can run on any ..................... plateform having Java Virtual Machine (JVM) installed on it.<br />A) program<br />B) java<br />C) hardware<br />D) non java <br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1.  A) pre increment<br />2.  B) left to right <br />3.  A) switch, if<br />4.  C) switch<br />5.  C) throws.java.io.IOException<br />6.  A) Break<br />7.  D) system<br />8.  C) Java doc<br />9.  B) Compiler<br />10.C) hardware<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><ul><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-java-set-1.html">Solved MCQ of Java Set-1</a> </li><li><a href="http://www.siteforinfotech.com/2013/01/mcq-of-java-with-answer-set-2.html">MCQ of Java with answer 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.siteforinfotech.com/2013/05/solved-mcq-of-sql-server-set-1.html">Solved MCQ of SQL Server set-1</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/mcq-of-database-management-system-dbms_11.html">Solved MCQ of DBMS Set - 3</a> </li></ul><div class="MsoNormal"><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>

Solved MCQ of Java set-4

1. In Java variables, if first increment of the variable takes place and then the assignment occurs. This operation is also called ............

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

Top 10 List of Best Job Search Sites

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1463oLB1HbFVw_Lc97ET-Ymc9yMZod78H8tSi5msq-48YMypx4-hqAvInx-z2kb2N892Ucgibxfmk_AhrGibC2hFQ4GxolGHuxq7yi3TmXPe-hcQqkK1EcBePf_mgqWhm09vWLN449GDy/s1600/job-search.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Top 10 job search sites" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1463oLB1HbFVw_Lc97ET-Ymc9yMZod78H8tSi5msq-48YMypx4-hqAvInx-z2kb2N892Ucgibxfmk_AhrGibC2hFQ4GxolGHuxq7yi3TmXPe-hcQqkK1EcBePf_mgqWhm09vWLN449GDy/s1600/job-search.gif" title="Top 10 job search sites" /></a></div>Finding a best job that can best match to your academic qualification and your skill may be the difficult task, if you don't select the best way for that. If you are thinking for a job after completing your college or university, at first you have to prepare your best CV and <a class="zem_slink" href="http://en.wikipedia.org/wiki/R%C3%A9sum%C3%A9" rel="wikipedia nofollow" target="_blank" title="Résumé">Resume</a>, and have to apply for the job that fits for you. Today <a href="http://www.siteforinfotech.com/2012/12/the-best-job-search-site-for-job-seekers.html" target="_blank">job search sites</a> became more popular for both searching and posting a job, "you can submit your resume" on those sites, which are easily accessible through web for applying in different jobs. It makes your <a class="zem_slink" href="http://en.wikipedia.org/wiki/Job_hunting" rel="wikipedia nofollow" target="_blank" title="Job hunting">job searching</a> work more easier and faster. So I have listed here some top job search sites through the world.</div><div style="text-align: justify;"><br /><a name="more"></a><br /></div><h3 style="text-align: justify;"> List of Best Job Search Sites</h3><div style="text-align: justify;"><br /></div><div style="text-align: justify;">1.<b> <a href="http://www.indeed.com/" rel="nofollow" target="_blank">Indeed.com:</a> </b>It is the No.1 job search site of the world wide. Millions of jobs were posted here and has over hundreds of millions unique visits on it. Indeed is available in most of the major countries and languages. Mobile application also available for making job searching work more easier and faster. For better performance of searching, it has also the advanced tool for <a href="http://www.siteforinfotech.com/search/label/Online%20IT%20Jobs" target="_blank">searching jobs</a> by using different criteria.</div><div style="text-align: justify;"><br />2. <a href="http://www.monster.com/geo/siteselection" rel="nofollow" target="_blank"><b>Monster.com: </b></a>Monster.com is the top job search site in <a class="zem_slink" href="http://maps.google.com/maps?ll=38.8833333333,-77.0166666667&spn=10.0,10.0&q=38.8833333333,-77.0166666667%20(United%20States)&t=h" rel="geolocation nofollow" target="_blank" title="United States">the US</a> and also available internationally in Europe, North America, Middle East and Asia pacific region. You can get different job based on the different locations and categories by using its <a href="http://www.siteforinfotech.com/2013/04/list-top-65-search-engine-submission-add-urls.html" target="_blank">search engine</a>. You can also get notified by e-mail about any job post openings after subscription.<br /><br /></div><div style="text-align: justify;">3. <b><a href="http://www.simplyhired.com/" rel="nofollow" target="_blank">Simply Hired.com:</a> </b>It is also the largest site for searching desired job for your career. You can search for any <a class="zem_slink" href="http://en.wikipedia.org/wiki/Job_description" rel="wikipedia nofollow" target="_blank" title="Job description">job title</a>, skill, company and for any city, state or zip. It is also available for major of the languages and most of the countries. You can browse for any of topics, titles and categories. You can post your resume here for simple and easy searching your next job or even the first.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">4. <b><a href="http://www.linkedin.com/job/guest?trk=hb_ft_jobs" rel="nofollow" target="_blank">Linkedin.com: </a></b>Linkedin.com is also included in the worlds largest professional network for building professional identity online. You can discover professional opportunities and business deals from here. It has the world largest job directory along with the advanced search engine for finding the jobs for any of topics, titles and categories. You can register on this site and post your resume.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">5. <a href="http://www.careerbuilder.com/?cbRecursionCnt=1" rel="nofollow" target="_blank"><b>CareerBuilder.com:</b></a> <a class="zem_slink" href="http://www.careerbuilder.com/" rel="homepage nofollow" target="_blank" title="CareerBuilder">CareerBuilder</a> is the largest "online job site" in the U.S. It also offered free skill test service targeting for most of the job titles. You can search jobs by using <a href="http://www.siteforinfotech.com/search/label/Keyword%20Research%20Tools" target="_blank">different keywords</a> and for any locations. You can search for any of the categories and also has the advanced searching facility.<br /><br />6. <a href="http://www.dice.com/job/results?caller=basic&x=all&p=" rel="nofollow" target="_blank"><b>Dice.com:</b></a> Dice is the leading career site for technology and engineering professionals.<span style="-webkit-text-stroke-width: 0px; background-color: white; color: #444444; display: inline !important; float: none; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"> </span>It gives search results based on the title of the job posting and also has the advanced searching facility. You can also get jobs list based on the different criteria like country, area code, skill, city etc.<br /><br />7. <b><a href="http://www.snagajob.com/" rel="nofollow" target="_blank">Snagajob.com:</a> </b>Snagajob.com help hourly employers find the best people for their jobs. It is the number one hourly job site in the world. They had innovative tools to help hourly workers and employers simplify their jobs and start living their dreams. You can also sign up for the e-mail alerts to deliver local jobs directly to your inbox. <br /><br />9. <a href="http://us.jobs/" rel="nofollow" target="_blank"><b>US.jobs:</b></a> It is the for US job seekers. You can search jobs on different locations and states within US. You can browse jobs based on the titles of the jobs and apply for the jobs.<br /><br />10. <a href="http://www.linkup.com/" rel="nofollow" target="_blank"><b>Link Up.com:</b></a> <a class="zem_slink" href="http://www.linkup.com/" rel="homepage nofollow" target="_blank" title="LinkUp (website)">LinkUp</a> is the fastest-growing "<a class="zem_slink" href="http://en.wikipedia.org/wiki/Employment_website" rel="wikipedia nofollow" target="_blank" title="Employment website">job search engine</a>" on the web. All the job openings are indexed from company websites and the jobs are updated daily. You can search jobs based on keyword or job title and location or zip code. You can also use advanced search option for searching jobs.<br /><br /><h3>The following post also recommended about jobs for you</h3><ul><li><a href="http://www.siteforinfotech.com/2012/12/how-to-find-best-online-jobs.html">How to find the best online Jobs?</a></li><li><a href="http://www.siteforinfotech.com/2012/12/how-to-earn-money-through-website-or.html">How to earn money through website or blog?</a> </li><li><a href="http://www.siteforinfotech.com/2013/04/earn-online-through-stock-photography-sites.html">How to earn online through stock photography sites?</a></li><li><a href="http://www.siteforinfotech.com/2013/04/top-10-list-stock-photography-sites-earn-online.html">Top 10 List Of Stock Photography Sites To Earn Online</a></li><li><a href="http://www.siteforinfotech.com/2013/04/top-7-list-of-high-paying-file-sharing.html">Top 7 List of High Paying File Sharing Sites</a></li><li><a href="http://www.siteforinfotech.com/2013/03/best-10-ways-of-making-money-online.html">Best 10 ways of making money online</a></li><li><a href="http://www.siteforinfotech.com/2013/03/how-to-earn-online-from-top-revenue-sites.html">How to earn online from Top revenue sharing sites?</a></li></ul></div><div class="zemanta-related" style="clear: both; margin-top: 20px; overflow: hidden;"><h3 style="text-align: left;">Related Articles From The Web</h3><div><br /></div><ul class="zemanta-article-ul zemanta-article-ul-image" style="margin: 0; overflow: hidden; padding: 0;"><li class="zemanta-article-ul-li-image zemanta-article-ul-li" style="background: none; display: block; float: left; font-size: 11px; list-style: none; margin: 2px 10px 10px 2px; padding: 0; text-align: left; vertical-align: top; width: 84px;"><a href="http://www.siteforinfotech.com/2013/06/top-10-list-of-best-job-search-sites.html" rel="nofollow" style="border-radius: 2px; box-shadow: 0px 0px 4px #999; display: block; padding: 2px; text-decoration: none;" target="_blank"><img src="http://i.zemanta.com/182520486_80_80.jpg" style="border: 0; display: block; margin: 0; max-width: 100%; padding: 0; width: 80px;" /></a><a href="http://www.siteforinfotech.com/2013/06/top-10-list-of-best-job-search-sites.html" rel="nofollow" style="display: block; height: 80px; line-height: 12pt; overflow: hidden; padding: 5px 2px 0 2px; text-decoration: none;" target="_blank">Top 10 List of Best Job Search Sites</a></li><li class="zemanta-article-ul-li-image zemanta-article-ul-li" style="background: none; display: block; float: left; font-size: 11px; list-style: none; margin: 2px 10px 10px 2px; padding: 0; text-align: left; vertical-align: top; width: 84px;"><a href="http://jasindace.wordpress.com/2013/07/05/most-popular-job-titles-on-linkup-in-july/" rel="nofollow" style="border-radius: 2px; box-shadow: 0px 0px 4px #999; display: block; padding: 2px; text-decoration: none;" target="_blank"><img src="http://i.zemanta.com/182729343_80_80.jpg" style="border: 0; display: block; margin: 0; max-width: 100%; padding: 0; width: 80px;" /></a><a href="http://jasindace.wordpress.com/2013/07/05/most-popular-job-titles-on-linkup-in-july/" rel="nofollow" style="display: block; height: 80px; line-height: 12pt; overflow: hidden; padding: 5px 2px 0 2px; text-decoration: none;" target="_blank">Most Popular Job Titles On LinkUp In July</a></li><li class="zemanta-article-ul-li-image zemanta-article-ul-li" style="background: none; display: block; float: left; font-size: 11px; list-style: none; margin: 2px 10px 10px 2px; padding: 0; text-align: left; vertical-align: top; width: 84px;"><a href="http://blog.turbotax.intuit.com/2013/05/31/summer-job-search-expenses-that-can-save-you-money/" rel="nofollow" style="border-radius: 2px; box-shadow: 0px 0px 4px #999; display: block; padding: 2px; text-decoration: none;" target="_blank"><img src="http://i.zemanta.com/173826609_80_80.jpg" style="border: 0; display: block; margin: 0; max-width: 100%; padding: 0; width: 80px;" /></a><a href="http://blog.turbotax.intuit.com/2013/05/31/summer-job-search-expenses-that-can-save-you-money/" rel="nofollow" style="display: block; height: 80px; line-height: 12pt; overflow: hidden; padding: 5px 2px 0 2px; text-decoration: none;" target="_blank">Summer Job Search Expenses That Can Save You Money</a></li><li class="zemanta-article-ul-li-image zemanta-article-ul-li" style="background: none; display: block; float: left; font-size: 11px; list-style: none; margin: 2px 10px 10px 2px; padding: 0; text-align: left; vertical-align: top; width: 84px;"><a href="http://stacywhalsy.wordpress.com/2013/07/01/job-search-strategy-1-targeted-research/" rel="nofollow" style="border-radius: 2px; box-shadow: 0px 0px 4px #999; display: block; padding: 2px; text-decoration: none;" target="_blank"><img src="http://i.zemanta.com/181563538_80_80.jpg" style="border: 0; display: block; margin: 0; max-width: 100%; padding: 0; width: 80px;" /></a><a href="http://stacywhalsy.wordpress.com/2013/07/01/job-search-strategy-1-targeted-research/" rel="nofollow" style="display: block; height: 80px; line-height: 12pt; overflow: hidden; padding: 5px 2px 0 2px; text-decoration: none;" target="_blank">Job Search Strategy # 1 - Targeted Research</a></li><li class="zemanta-article-ul-li-image zemanta-article-ul-li" style="background: none; display: block; float: left; font-size: 11px; list-style: none; margin: 2px 10px 10px 2px; padding: 0; text-align: left; vertical-align: top; width: 84px;"><a href="http://mplicjob.wordpress.com/2013/05/31/win-hot-tips-for-a-summer-job-search/" rel="nofollow" style="border-radius: 2px; box-shadow: 0px 0px 4px #999; display: block; padding: 2px; text-decoration: none;" target="_blank"><img src="http://i.zemanta.com/noimg_91_80_80.jpg" style="border: 0; display: block; margin: 0; max-width: 100%; padding: 0; width: 80px;" /></a><a href="http://mplicjob.wordpress.com/2013/05/31/win-hot-tips-for-a-summer-job-search/" rel="nofollow" style="display: block; height: 80px; line-height: 12pt; overflow: hidden; padding: 5px 2px 0 2px; text-decoration: none;" target="_blank">WIN - Hot Tips for a Summer Job Search</a></li></ul></div><h3 style="text-align: left;">Related Recommended Videos For You</h3><div><br /></div><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="allowfullscreen" frameborder="0" height="266" mozallowfullscreen="mozallowfullscreen" src="https://www.youtube.com/embed/i8CqOMvo6J8?feature=player_embedded" webkitallowfullscreen="webkitallowfullscreen" width="320"></iframe></div><div><br /></div></div>

Top 10 List of Best Job Search Sites

Finding a best job that can best match to your academic qualification and your skill may be the difficult task, if you don't select the ...

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

Solved MCQ of SQL Server Set-2

1. ......................... are predefined and maintained SQL Server and users cannot assign or directly change the values.<br />A) Global variables<br />B) Local Variables<br />C) Integer Variables<br />D) Floating Variables<br /><br />2. A local variable is shown ........................... preceding its name.<br />A) One @ symbol<br />B) Two @@ symbol<br />C) One # symbol<br />D) Two ## symbol<br /><br />3. Constraint checking can be disabled on existing ........... and ............. constraints so that any data you modify or add to the table is not checked against the constraint.<br />A) CHECK, FOREIGN KEY<br />B) DELETE, FOREIGN KEY<br />C) CHECK, PRIMARY KEY<br />D) PRIMARY KEY, FOREIGN KEY<br /><br /><a name="more"></a>4. ................ and ................... are the Transact - SQL control-of-flow key words.<br />A) Continue, Stop<br />B) Break, Stop<br />C) Continue, While<br />D) While, Going to<br /><br />5. The type of constraint ........................ specifies data values that are acceptable in a column.<br />A) DEFAULT<br />B) CHECK<br />C) PRIMARY<br />D) UNIQUE<br /><br />6. The ..................... constraint defines a column or combination of columns whose values match the primary key of the same or another table.<br />A) DEFAULT<br />B) CHECK<br />C) PRIMARY<br />D) FOREIGN KEY<br /><br />7. <b> </b>The control-of-flow statement ..................... defines conditional, and optionally, alternate execution when a condition is FALSE.<br />A) WHILE<br />B) WAITFOR<br />C) IF........ELSE<br />D) BEGIN.......... END<br /><br />8. In SQL Server, ..................... is based on relationships between foreign keys and primary keys or between foreign keys and unique keys.<br />A) Entity integrity<br />B) Domain integrity<br />C) Referential integrity<b><br /></b><br />D) User-defined integrity<br /><br />9. When a ................. clause is used, each item in the select list must produce a single value for each group.<br />A) ORDER BY<br />B) GROUP<br />C) GROUP BY<br />D) GROUP IN<br /><br />10. MS SQL Server uses a variant of SQL called T-SQL, or Transact SQL, an implementation of .................. with some extensions.<br />A) MS SQL Server<br />B) Tabular Data Set<br />C) SQL-92<br />D) Tabular Data Stream<br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1.  A) Global variables<br />2.  A) One @ symbol<br />3.  A) CHECK, FOREIGN KEY<br />4.  C) Continue, While<br />5.  B) CHECK<br />6.  D) FOREIGN KEY<br />7.  C) IF........ELSE<br />8.  C) Referential integrity<br />9.  C) GROUP BY<br />10.C) SQL-92<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><ul><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-sql-server-set-1.html">Solved MCQ of SQL Server set-1</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 DBMS Set - 3</a> </li></ul><div class="MsoNormal"><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>

Solved MCQ of SQL Server Set-2

1. ......................... are predefined and maintained SQL Server and users cannot assign or directly change the values. A) Global varia...

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

Solved MCQs of XML set - 1

<div dir="ltr" style="text-align: left;" trbidi="on">1. XML stands for ......................<br />A) Extensible Markup Language<br />B) Eccessive Markup Language<br />C) Executive Markup Language<br />D) Extensible Managing Language<br /><br />2. The XML format has a simpler set of ........................ than HTML.<br />A) loader rule<br />B) parsing rules<br />C) generator rule<br />D) logical rule<br /><br />3. All information in XML is .....................<br />A) Unicode text<br />B) multi code<br />C) multi text<br />D) simple text<br /><br /><a name="more"></a>4. An entity in XML is a ................................<br />A) class<br />B) logical information<br />C) simple information<br />D) flexible information storage unit<br /><br />5. A tool for reading XML documents is popularly called a .....................<br />A) XML delimiters<br />B) XML processor<br />C) XML parser<br />D) Both b and c<br /><br />6. XSL stands for<br />A) Extensible Style sheet Language<br />B) Extensible Style Language<br />C) Exclusive Stylesheet Language<br />D) Exclusive Style Language<br /><br />7. XML tabs are .............................<br />A) case sensitive<br />B) case insnesitive<br />C) easy<br />D) deficult<br /><br />8. In XML the attribute value must always be quoted with .................<br />A) double quotes<br />B) single quotes<br />C) both a and b<br />D) name of attributes<br /><br />9. Elements from the HTML namespace are displayed as they would in .......................<br />A) DHTML<br />B) XML<br />C) HTML<br />D) DXML<br /><br />10. An .................... block can be to embed a CSS style sheet within an XML document.<br />A) <bk:Book><br />B) <Element Type><br />C) <HTML:STYLE><br />D) <XML:STYLE><br /><br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1. A) Extensible Markup Language<br />2. B) parsing rules<br />3. A) Unicode text<br />4. D) flexible information storage unit<br />5. D) Both b and c<br />6. A) Extensible Style sheet Language<br />7. A) case sensitive<br />8. A) double quotes<br />9. C) HTML<br />10.C) <HTML:STYLE><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><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-sql-server-set-1.html" target="_blank">Solved MCQ of SQL Server 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-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/2013/05/mcq-of-structured-query-language-sql-with-answer.html">MCQ of Structured Query Language(SQL) With Answer Set -2</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/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/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>

Solved MCQs of XML set - 1

1. XML stands for ...................... A) Extensible Markup Language B) Eccessive Markup Language C) Executive Markup Language D) Extensib...

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

MCQ of PL/SQL and Oracle With Answer set -2

<div dir="ltr" style="text-align: left;" trbidi="on"><br />1. ....................... are used to recreate if trigger already exists.<br /><br />A) Cursor<br /><br />B) Trigger<br /><br />C) Keywords<br /><br />D) Replace<br /><br /><br />2. .............................. is used to define code that is executed / fired when certain actions or event occur.<br /><br />A) Cursor<br /><br />B) Trigger<br /><br />C) Keywords<br /><br />D) Replace<br /><br /><br /> 3. ................. provide a way for your program to select multiple rows of data from the database and then process each row individually.<br /><br />A) PL/SQL Cursors<br /><br />B) PL/SQL Trigger<br /><br />C) PL/SQL Select<br /><br />D) PL/SQL Process<br /><br /><br />4. ........................... cursor are declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.<br /><br />A) Implicit<br /><br />B) Explicit<br /><br />C) Internal<br /><br />D) External<br /><br /><br />5. ......................... cursors are declared and used by the user to process multiple row, returned by SELECT statement.<br /><br />A) Implicit<br /><br />B) Explicit<br /><br />C) Internal<br /><br />D) External<br /><br /><br />6. ....................... contain a pointer that keeps track of current row being accessed, which enables your program to process the rows at a time.<br /><br />A) Tracker<br /><br />B) Cursor<br /><br />C) Accesser<br /><br />D) Trigger<br /><br /><br />7. ....................... a cursor enables you to define the cursor and assign a name to it.<br /><br />A) Declearing<br /><br />B) Stating<br /><br />C) Extracting<br /><br />D) Importing<br /><br /><br />8. In ................... the cursor advances to the next row in the active set each time the fetch command is executed.<br /><br />A) recreating process<br /><br />B) redefining process<br /><br />C) iterative process<br /><br />D) None of the above<br /><br /><br />9. A ......................... is a database object that groups logically related PL/SQL types, objects and subprograms.<br /><br />A) Module<br /><br />B) Package<br /><br />C) Body<br /><br />D) Name<br /><br /><br />10. In the PL/SQL, the package specification contains ....................... declarations.<br /><br />A) Public<br /><br />B) Private<br /><br />C) Friend<br /><br />D) Protected<br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1. D) Replace<br />2. B) Trigger<br />3. A) PL/SQL Cursors<br />4. A) Implicit<br />5. B) Explicit<br />6. B) Cursor<br />7. A) Declearing<br />8. C) iterative process<br />9. B) Package<br />10.A) Public<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><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-sql-server-set-1.html" target="_blank">Solved MCQ of SQL Server 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-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/2013/05/mcq-of-structured-query-language-sql-with-answer.html">MCQ of Structured Query Language(SQL) With Answer Set -2</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/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/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 PL/SQL and Oracle With Answer set -2

1. ....................... are used to recreate if trigger already exists. A) Cursor B) Trigger C) Keywords D) Replace 2. .....................

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

Solved MCQ of PL/SQL and Oracle set-1

<div dir="ltr" style="text-align: left;" trbidi="on">1. ........................ is a procedural extension of Oracle - SQL that offers language constructs similar to those in imperative programming languages.<br />A) SQL<br />B) PL/SQL<br />C) Advanced SQL<br />D) PQL<br /><br />2. .................... combines the data manipulating power of SQL with the data processing power of Procedural languages.<br />A) PL/SQL <br />B) SQL<br />C) Advanced SQL<br />D) PQL<br /><br /><a name="more"></a>3. ................... has made PL/SQL code run faster without requiring any additional work on the part of the programmer.<br />A) SQL Server<br />B) My SQL<br />C) Oracle<br />D) SQL Lite<br /><br />4. A line of PL/SQL text contains groups of characters known as .......................<br />A) Lexical Units<br />B) Literals<br />C) Textual Units<br />D) Identifiers<br /><br />5. We use ........................ name PL/SQL program objects and units.<br />A) Lexical Units<br />B) Literals<br />C) Delimiters<br />D) Identifiers<br /><br />6. A .................... is an explicit numeric, character, string or Boolean value not represented by an identifier.<br />A) Comments<br />B) Literals<br />C) Delimiters<br />D) Identifiers<br /><br />7. If no header is specified, the block is said to be an ...................... PL/SQL block.<br />A) Strong <br />B) Weak <br />C) Empty <br />D) Anonymous<br /><br />8. ............. is a sequence of zero or more characters enclosed by single quotes.<br />A) Integers literal<br />B) String literal<br />C) String units<br />D) String label<br /><br />9. In ........................, the management of the password for the account can be handled outside of oracle such as operating system.<br />A) Database Authentication<b><br /></b><br />B) Operating System Authentication<br />C) Internal Authentication<br />D) External Authentication<br /><br />10. In ............................ of Oracle, the database administrator creates a user account in the database for each user who needs access.<br />A) Database Authentication<br />B) Operating System Authentication<br />C) Internal Authentication<br />D) External Authentication<br /><br /><h4><span style="font-size: large;">Answers:</span></h4>1. B) PL/SQL<br />2. A) PL/SQL<br />3. C) Oracle<br />4. A) Lexical Units<br />5. D) Identifiers<br />6. B) Literals<br />7. D) Anonymous<br />8. B) String literal<br />9. B) Operating System Authentication<br />10.A) Database Authentication<br /><br /><h2><b><span style="font-size: small;">You Might also view the following Related Posts</span></b></h2><ul><li><a href="http://www.siteforinfotech.com/2013/06/mcq-of-plsql-and-oracle-with-answer-set.html">MCQ of PL/SQL and Oracle With Answer set -2</a></li><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/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-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/2013/05/mcq-of-structured-query-language-sql-with-answer.html">MCQ of Structured Query Language(SQL) With Answer Set -2</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 class="MsoNormal" style="text-align: left;"><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/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/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>

Solved MCQ of PL/SQL and Oracle set-1

1. ........................ is a procedural extension of Oracle - SQL that offers language constructs similar to those in imperative program...

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