Map api key for android

Step:1 Go to Run and Type cmd

Step:2 Go to Path at (.android) folder.

Step:3 Now type command
             kaytool -list -alias androiddebugkey -keystore debug.keystore -storepass android -keypass  android

what is WEB HOSTING?

WEB HOSTING
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own or lease for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers theydo not own to be located in their data center.

Internet,Intranet,Extranet

Internet - The Internet is a huge public forum which is ideally suited for
marketing, real-time commerce, delivery of technical support
information, contact information and the posting of other “public”
resources.

SQL Syntax

Select
SELECT "column_name" FROM "table_name"
Distinct
SELECT DISTINCT "column_name"
FROM "table_name"
Where
SELECT "column_name"
FROM "table_name"
WHERE "condition"

Grant/Revoke Privileges in plsql

Grant Privileges on Tables

You can grant users various privileges to tables. These privileges can be any combination of select, insert, update, delete, references, alter, and index. Below is an explanation of what each privilege means.

Privilege	Description
Select	Ability to query the table with a select statement.
Insert	Ability to add new rows to the table with the insert statement.
Update	Ability to update rows in the table with the update statement.
Delete	Ability to delete rows from the table with the delete statement.
References	Ability to create a constraint that refers to the table.
Alter	Ability to change the table definition with the alter table statement.
Index	Ability to create an index on the table with the create index statement.

Data Dictionary in dbms

Data Dictionary

Data dictionary — metadata — system & object privileges — dictionary structure — ``user'' tables - ``all'' tables — ``dba'' tables — ``v$'' tables — frequently used tables — usage examples — exercises — using the dictionary in PL/SQL programs — optional exercise.

Introduction

This document presents Oracle's data dictionary, also called the system catalogue. The data dictionary is the repository of all the meta-data relevant to the objects stored in the database—and also of information concerning the DBMS itself.

uinx command and shell script

Assignment – 1

v  Locate lines that are longer than 100 and smaller than 150 characters using grep.

è grep -c '\{101,150\}' keval.txt

grep `^.\{100,150\}$` keval.txt

v  Merge and sort the contents of files A and B and display the sorted output on the screen.

è cat file1 file2 | sort

SQL Questions and Answers

1.      To see current user name 

 Sql> show user;

2.      Change SQL prompt name 
 SQL> set sqlprompt “Manimara > “ 
Manimara > 
Manimara >

Core Java interview questions with answers

1.How could Java classes direct program messages to the system console, but error messages, say to a file?

The class System has a variable out that represents the standard output, and the variable err that represents the standard error device. By default, they both point at the system console. This how the standard output could be re-directed:
Stream st = new Stream(new FileOutputStream(“output.txt”)); System.setErr(st); System.setOut(st);

2.How would you create a button with rounded edges?

There’s 2 ways. The first thing is to know that a JButton’s edges are drawn by a Border. so you can override the Button’s paintComponent(Graphics) method and draw a circle or rounded rectangle (whatever), and turn off the border. Or you can create a custom border that draws a circle or rounded rectangle around any component and set the button’s border to it.

29 Ideas to Increase Sales and Profi

Growing your business doesn't have to be difficult or expensive. These simple, cost-effective ideas are designed to help you increase your sales and profit, without draining your budget.

1. FOCUS ON HELPING, INSTEAD OF SELLING

You shouldn't be trying to force people into purchasing your product or service. You should find people who want your product or service and then focus on offering any helpful information to them so that they can make an informed decision.

2. TARGET

If you're trying to target everybody, then chances are, you're not targeting anybody. For example, if you're selling something that homeowners would want, as opposed to renters, then target homeowners. State your target clearly in all of your marketing materials.

Datatype in sql

CHAR Datatype

The CHAR datatype stores fixed-length character strings. When you create a table with a CHAR column, you must specify a string length (in bytes or characters) between 1 and 2000 bytes for the CHAR column width. The default is 1 byte. Oracle then guarantees that:

·         When you insert or update a row in the table, the value for the CHAR column has the fixed length.

·         If you give a shorter value, then the value is blank-padded to the fixed length.

·         If a value is too large, Oracle Database returns an error.

Oracle Database compares CHAR values using blank-padded comparison semantics.

SQL interview questions and answers

What is SQL and where does it come from?
Structured Query Language (SQL) is a language that provides an interface to relational database systems. SQL was developed by IBM in the 1970s for use in System R, and is a de facto standard, as well as an ISO and ANSI standard. SQL is often pronounced SEQUEL.
In common usage SQL also encompasses DML (Data Manipulation Language), for INSERTs, UPDATEs, DELETEs and DDL (Data Definition Language), used for creating and modifying tables and other database structures.

TCS APTITUDE PAPER WITH SOLUTIONS

1) If log 0.317=0.3332 and log 0.318=0.3364 then find log 0.319 ?

Sol)

 log 0.317=0.3332 and log 0.318=0.3364, then
log 0.319=log0.318+(log0.318-log0.317) = 0.3396

2) A box of 150 packets consists of 1kg packets and 2kg packets. Total weight of box is 264kg. How many 2kg packets are there ?

Sol)

 x= 2 kg Packs
y= 1 kg packs
x + y = 150 .......... Eqn 1
2x + y = 264 .......... Eqn 2
Solve the Simultaneous equation; x = 114
so, y = 36
ANS : Number of 2 kg Packs = 114.