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>50 and <80;B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;C) SELECT sname, coursename FROM studentinfo WHERE age>50 and WHERE age<80;D) None of the above2.How to select all data from studentinfo table starting the name from letter 'r'?A) SELECT * FROM studentinfo WHERE sname LIKE 'r%';B) SELECT * FROM studentinfo WHERE sname LIKE '%r%';C) SELECT * FROM studentinfo WHERE sname LIKE '%r';D) SELECT * FROM studentinfo WHERE sname LIKE '_r%';3. Which of the following SQL query is correct for selecting the name of staffs from 'tblstaff' table where salary is 15,000 or 25,000?A) SELECT sname from tblstaff WHERE salary...

Read more »

Solved MCQ of SQL Server set-1

1. ........................ is the full form of SQL.A) Standard Query LanguageB) Sequential Query LanguageC) Structured Query LanguageD) Server Side Query Language2. SQL Server 2005 NOT includes the following system database .............A) tempdb DatabaseB) Master DatabaseC) Model DatabaseD) sqldb Database3. SQL Server stores index information in the ..................... system table.A) sysindexesB) systemindexesC) sysindD) sysindexes4. ..................... is a read-only database that contains system objects that are included with SQL Server 2005.A) Resource DatabaseB) Master DatabaseC) Model DatabaseD) msdb Database5. The SQL Server services includes .....................A) SQL server agentB) Microsoft distribution transaction coordinatorC) Both a & bD) None of the above6. .........................

Read more »

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) The electronic provision of services such as after sales support or online legal adviceC) All the steps involved in trade, such as on-line marketing ordering payment and support for delivery.D) All of the above.2. Which of the following is the largest community in classification of e-commerce?A) Business to Business (B to B)B) Business to Consumer (B to C)C) Business to Government (B to G)D) Government to Government (G to G)3. Which of the following is not the example of business to consumer (B to C) e-commerce?A) Amazon.comB) e-bay.comC) dell.comD) lastminute.com4. The types of Business to Business e-commerce are ................A) Direct selling and support...

Read more »

Solved MCQ of Computer Organization and Architecture set-1

1. A collection of lines that connects several devices is called ..............A) busB) peripheral connection wiresC) Both a and bD) internal wires2. A complete microcomputer system consist of ...........A) microprocessorB) memoryC) peripheral equipmentD) all of the above3. PC Program Counter is also called ...................A) instruction pointerB) memory pointerC) data counterD) file pointer4. In a single byte how many bits will be there?A) 8B) 16C) 4D) 325. CPU does not perform the operation ..................A) data transferB) logic operationC) arithmetic operationD) all of the above6. The access time of memory is ............... the time required for performing any single CPU operation.A) Longer thanB) Shorter thanC) Negligible thanD) Same as7. Memory address refers to the successive...

Read more »

MCQ of Internet and HTML With Answer Set-2

1. ......................... connects web pages.A) ConnectorB) LinkC) HyperlinkD) None of the above2. Internet is ...............................A) a network of networksB) an ocean of resources waiting to be minedC) a cooperative anarchyD) all of the above3. .................. is suitable for remote administration of a computer.A) FTPB) ShellC) Remote Procedure CallD) Telnet4. Title tag is nested within the ....................... tag.A) BodyB) HeadC) ListD) Table5. .................... is a web's native protocol.A) SLIPB) TCP/IPC) HTTPD) PPP6. The Internet uses the ........................ as the protocol engine.A) SLIPB) HTTPC) TCP/IPD) PPP7. A ............................. is a symbolic name a network administrator assigns to a machine.A) URLB) DNSC) IP addressD) Host name8.  Which...

Read more »

Solved MCQ of Internet and HTML set-1

1. The attribute .................. of <BODY> tag sets color of hypertext links.A) linkB) vlinkC) alinkD) hlink2. Default font size of HTML is .......................A) 2B) 4C) 6D) 33. This is a networking device that passes data between networks having similar functions but dissimilar implementations.A) HubB) ModemC) GatewayD) Repeater4. In order to connect to ISP's server you need .......A) Hand glovesB) PrinterC) User name and PasswordD) None of the above5. DNS translates .........A) domain name into IPB) IP into domain nameC) both a & bD) domain name into physical address6. In order to upload a HTML file to a web server, you useA) HTTPB) SMTPC) SIPD) FTP7. IEEE stands for ........A) Institute of estimated elevator efficiencyB) Institute of electrical and economical engineersC)...

Read more »

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 very small than the original images, so it can decrease the weight of your site drastically. 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. To Optimize Images Using Adobe Photoshop It is well known that Adobe Photoshop is the most...

Read more »

Best Blog Post Optimization Tips for Blogger

You can optimize your blog post or whole your blog by following the some very simple steps which may not know most of the bloggers. Today I am going to tell you very simple and easy tips but which are very important for fulfillment of your dream of creating quality blog. These tips also help for making your blog more visible on search engines.  Tip-1: Insert image 'alt' and 'title' attribute in your blog post? It is necessary to insert image 'alt' and 'title' attribute in your blog post for better search engine optimization (SEO) and blogs quality. If you placed 'alt' and 'title' attribute in your post images, it will increases the visibility...

Read more »

How to add Feedburner's icon and e-mail subscription box?

After registering and setting up feedburner's account you can place email-subscription box to help your blog readers to subscribe your blog post and to update instantly and reader icon to subscribe for different readers like My Yahoo, Newsgator Bloglines etc. You can make easier to subscribe your blog post for your users by placing HTML codes provided by feedburner.How to place feedburner email subscription box on your blog# At first login to your feedburner account. And go to publicize tab.# And then click on Email Subscriptions option as shown in image below.# Click on on Activate button. # Copy the given code under...

Read more »

How To Setup Google Feedburner Feed To Your Blog ?

Google Feedburner is the best and free to use service to subscribe your blog posts by your blog users. It is the best option for marketing your blog post and informing about your latest post on the blog. It makes easy to update content updates My Yahoo, News-gator  Bloglines and other more. Your content was delivered automatically via web portal, news reader, e-mail etc. It is also possible for site content can be packaged into widgets, gadgets, mobile device, postcard and other news headlines.How to Setup Google Feed burner Feed to Your Blog? Here are the steps to Setup Google Feed burner Feed to your blog.#...

Read more »

Most Effective Tips for Your Link Building Success

Getting quality links from high ranked and quality website is the most important and required task for your site. Such links which are getting from other sites called back-links. Along with creating quality back-links, how you link your site internally and how you place outgoing external links affects your websites success. You can achieve this only by applying most effective and successful link building strategies. If you applied any bad methods for creating links, may harm for your online business after. Google and other major search engines may exclude your site from the search results. So in this post, I am telling you what strategies you...

Read more »

Easy Methods to Increase Your Website Speed

Website speed is the most important factor for SEO. It also affects the popularity of your site, about every 25% of the visitors of the site left that even if it is useful for them for slow loading sites. Google also decided to include website loading speed for website ranking. You can increase your website by performing testing or analyzing your site by using different such tools and performing the actions suggested by them. The main tasks to be performed to achieve such goals are setting an expiry date or maximum age in the HTTP headers, minimizing the HTTP redirects, minimizing the amount of JavaScript need while loading the page, minimizing unnecessary JavaScript, CSS Scripts and HTML, Optimizing images and long running scripts etc. Why Website Speed is Most Important For SEO? Only...

Read more »

How to Utilize Google Services for effective SEO?

Everyone knows that Google is the emperor of the web. It is the largest web search engine and it does not just a web search. There are many services offered by Google for different purposes. Some of those services may extremely useful for search engine optimization work. Almost all of the SEO experts utilize those services for better SEO. If anyone can achieve successful utilization of them definitely get benefit from their sites. Here I have listed here some important services of Google for Search Engine Optimization purposes and their effective methods of utilization. 1. Google Webmasters: It is the most important service provided...

Read more »