android populer

 <Spinner
    android:id="@+id/myspinner"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content" /> 

public class Custom_spinner extends Activity {
	String[] data1 = { "Java", "Android","Blackberry", "Apple", "Windows" };
	
	String[] data2 = { "Developed by Sun Microsystems", "Android is a Linux-based operating system",
			"Designed and marketed by Research In Motion Limited ","Designed and marketed by Apple Inc" 
	        ,"developed, marketed, and sold by Microsoft."};
	
	Integer[] images = { R.drawable.java, R.drawable.android,
			R.drawable.blackberry, R.drawable.apple, R.drawable.windows };

	/** Called when the activity is first created. */
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.custom_spinner);
		Spinner mySpinner = (Spinner) findViewById(R.id.spinner1);
		mySpinner.setAdapter(new MyAdapter(this, R.layout.cus_row, data1));
	}

	public class MyAdapter extends ArrayAdapter<String> {

		public MyAdapter(Context context, int textViewResourceId,
				String[] objects) {
			super(context, textViewResourceId, objects);
			// TODO Auto-generated constructor stub
		}

		@Override
		public View getDropDownView(int position, View convertView,
				ViewGroup parent) {
			return getCustomView(position, convertView, parent);
		}

		@Override
		public View getView(int position, View convertView, ViewGroup parent) {
			return getCustomView(position, convertView, parent);
		}

		public View getCustomView(int position, View convertView,
				ViewGroup parent) {

			LayoutInflater inflater = getLayoutInflater();//inflate xml for each row
			View row = inflater.inflate(R.layout.cus_row, parent, false);
			TextView label = (TextView) row.findViewById(R.id.textView1);
			label.setText(data1[position]);

			TextView sub = (TextView) row.findViewById(R.id.textView2);
			sub.setText(data2[position]);

			ImageView icon = (ImageView) row.findViewById(R.id.imageView1);
			icon.setImageResource(images[position]);

			return row;
		} }}

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:padding="10dp" >
    <Spinner
        
        android:id="@+id/spinner1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:drawSelectorOnTop="true"
        android:background="@drawable/purple"
        >
    </Spinner>
</RelativeLayout>

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/relativeLayout1"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:padding="3dip" >

    <LinearLayout
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:orientation="horizontal" >

        <ImageView
            android:id="@+id/imageView1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:src="@drawable/ic_launcher" >
        </ImageView>
    </LinearLayout>

    <LinearLayout
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:orientation="vertical"
        android:paddingLeft="70dp" >

        <TextView
            android:id="@+id/textView1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:textStyle="bold" >
        </TextView>

        <TextView
            android:id="@+id/textView2"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" >
        </TextView>
    </LinearLayout>

</RelativeLayout>

 
public class MainActivity extends Activity {
  //Create broadcast object
    BroadcastReceiver mybroadcast = new BroadcastReceiver() {
  
  //When Event is published, onReceive method is called
  @Override
  public void onReceive(Context context, Intent intent) {
   // TODO Auto-generated method stub
       Log.i("[BroadcastReceiver]", "MyReceiver");

          if(intent.getAction().equals(Intent.ACTION_SCREEN_ON)){
              Log.i("[BroadcastReceiver]", "Screen ON");
          }
          else if(intent.getAction().equals(Intent.ACTION_SCREEN_OFF)){
              Log.i("[BroadcastReceiver]", "Screen OFF");
          }
   }};

   @Override
   public void onCreate(Bundle savedInstanceState) {
       super.onCreate(savedInstanceState);
       setContentView(R.layout.activity_main);
 
       registerReceiver(mybroadcast, new IntentFilter(Intent.ACTION_SCREEN_ON));
       registerReceiver(mybroadcast, new IntentFilter(Intent.ACTION_SCREEN_OFF));
   }  
}

See more basics on Android along with interview questions

See SQLite tutorial here

public class SqliteAssetHelper extends ListActivity {

 private Cursor students;
 private MyDatabase db;

 @Override
 public void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);

  db = new MyDatabase(this);
  students = db.getEmployees(); // you would not typically call this on the main thread

  ListAdapter adapter = new SimpleCursorAdapter(this, 
                  android.R.layout.simple_list_item_2, 
    students,
    new String[] {"name","age"}, //table values 
    new int[] {android.R.id.text1,android.R.id.text2});

  getListView().setAdapter(adapter);
 }

 @Override
 protected void onDestroy() {
  super.onDestroy();
  students.close();
  db.close();
 } }

public class MyDatabase extends SQLiteAssetHelper {

 private static final String DATABASE_NAME = "mydatabase";
 private static final int DATABASE_VERSION = 2;
 
 public MyDatabase(Context context) {
  super(context, DATABASE_NAME, null, DATABASE_VERSION); 
  }

 public Cursor getEmployees() {

  SQLiteDatabase db = getReadableDatabase();
  SQLiteQueryBuilder qb = new SQLiteQueryBuilder();

  String [] sqlSelect = {"0 _id","name","age"}; 
  String sqlTables = "mytable";

  qb.setTables(sqlTables);
  Cursor c = qb.query(db, sqlSelect, null, null,
    null, null, null);

  c.moveToFirst();
  return c;

 } }