A33a

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 above 2.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 IN (15000, 25000); B) SELECT sname from tblstaff WHERE salary BETWEEN 15000 AND 25000; C) Both A and B D) None of the above 4. The SELECT ...

1. ........................ is the full form of SQL. A) Standard Query Language B) Sequential Query Language C) Structured Query Language D) Server Side Query Language 2. SQL Server 2005 NOT includes the following system database ............. A) tempdb Database B) Master Database C) Model Database D) sqldb Database 3. SQL Server stores index information in the ..................... system table. A) sysindexes B) systemindexes C) sysind D) sysindexes 4. ..................... is a read-only database that contains system objects that are included with SQL Server 2005. A) Resource Database B) Master Database C) Model Database D) msdb Database 5. The SQL Server services includes ..................... A) SQL server agent B) Microsoft distribution transaction coordinator C) Both a & b D) None of the above 6. ...................... is a utility to capture a continuous record of server activity and provide auditing capability. A) SQL server profile B) SQL server service manager C) SQL serv...

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 advice C) 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.com B) e-bay.com C) dell.com D) lastminute.com 4. The types of Business to Business e-commerce are ................ A) Direct selling and support to Business B) Industry portals C) Information sites about a industry D) All of the above 5. Which of the following are the benefits of E-marketing? i) Speed   ...

1. A collection of lines that connects several devices is called .............. A) bus B) peripheral connection wires C) Both a and b D) internal wires 2. A complete microcomputer system consist of ........... A) microprocessor B) memory C) peripheral equipment D) all of the above 3. PC Program Counter is also called ................... A) instruction pointer B) memory pointer C) data counter D) file pointer 4. In a single byte how many bits will be there? A) 8 B) 16 C) 4 D) 32 5. CPU does not perform the operation .................. A) data transfer B) logic operation C) arithmetic operation D) all of the above 6. The access time of memory is ............... the time required for performing any single CPU operation. A) Longer than B) Shorter than C) Negligible than D) Same as 7. Memory address refers to the successive memory words and the machine is called as ............ A) word addressable B) byte addressable C) bit addressable D) Terra byte addressable 8. A microprogram written as...

1. ......................... connects web pages. A) Connector B) Link C) Hyperlink D) None of the above 2. Internet is ............................... A) a network of networks B) an ocean of resources waiting to be mined C) a cooperative anarchy D) all of the above 3. .................. is suitable for remote administration of a computer. A) FTP B) Shell C) Remote Procedure Call D) Telnet 4. Title tag is nested within the ....................... tag. A) Body B) Head C) List D) Table 5. .................... is a web's native protocol. A) SLIP B) TCP/IP C) HTTP D) PPP 6. The Internet uses the ........................ as the protocol engine. A) SLIP B) HTTP C) TCP/IP D) PPP 7. A ............................. is a symbolic name a network administrator assigns to a machine. A) URL B) DNS C) IP address D) Host name 8.  Which of the following protocol is used for e-mail services. A) SMAP B) SMTP C) SMIP D) SMOP 9. ...................... is the incoming e-mail server. A) POP B) SMTP C) SMI...

1. The attribute .................. of <BODY> tag sets color of hypertext links. A) link B) vlink C) alink D) hlink 2. Default font size of HTML is ....................... A) 2 B) 4 C) 6 D) 3 3. This is a networking device that passes data between networks having similar functions but dissimilar implementations. A) Hub B) Modem C) Gateway D) Repeater 4. In order to connect to ISP's server you need ....... A) Hand gloves B) Printer C) User name and Password D) None of the above 5. DNS translates ......... A) domain name into IP B) IP into domain name C) both a & b D) domain name into physical address 6. In order to upload a HTML file to a web server, you use A) HTTP B) SMTP C) SIP D) FTP 7. IEEE stands for ........ A) Institute of estimated elevator efficiency B) Institute of electrical and economical engineers C) Institute of Eurasia engineering event D) Institute of electrical and electronics engineers 8. The regional networks are connected to the corporate networks, thi...

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 popular Photo editing Software. Along with editing you can save images as optimize for web by using the following steps.  1. At first open an image using Adobe Photoshop program and redesign or edit that using appropriate tools.  2. After that go to file menu and click on save for web option.  3. In the new wind...

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 of your image on search engines. If your blogs image appeared on the 'image search result', user also goes to your blog which can directly increase your blogs traffic. Here I have explained the easiest methods to insert 'alt' and 'title' attribute of image in the blog post. S...

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 subscription management option shown as in the image below and place this on the required place on your blog. OR  You can place it directly by selecting your blog service provider and clicking on Go button. How to place feedburner reader icon on your blog # At first login to your feedburner account. And go to publicize tab. # And the...

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. # At first register to Google Feed burner. You can register on it, by logging on using Google account. Click Here To Register To Google Feed burner Click on the Claim your feeds now button shown in image below. On the next page you can move your feed burner feed if you are already using feed burner by log in into it, us...

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 should apply for successful link building work for your online success. The  most effective tips for  link building strategies which may be the key success for your website, blog and your whole online business are as follows.  Give Quality Content and Services The most well known secret for success of any business is their cu...

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 the fast loading websites can achieve better user experience and can have the minimum exit ratio. They can only achieve their goals in their online business and marketing. Search engine ...

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 by Google to optimize their site for website owners. They provides different types of tools for websites Health, Traffic and Optimization for search engines and also provides helps and guidelines for creating quality website. Using this webmaster service, you can do the following activities to optimize your site for search engines.  a. ...