SQLite CRUD Quiz

What does the onCreate(SQLiteDatabase db) method do?

• It updates the database to a new version.

• It deletes the existing table from the database.

• It creates a new table in the database.

• It inserts data into the database.

What is the purpose of the onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) method?

• It creates a new table in the database.

• It fetches data from the database.

• It updates the database structure when the database version changes.

• It updates the database structure when the database name changes.

What code is used to navigate from MainActivity to MainActivity2.

• Intent intent = new Intent(MainActivity.this, MainActivity2.class);
  startActivity(intents);

• Intent intent = new Intent(MainActivity.this, MainActivity2.class);
  startActivity(intent);

• Intent intent = new Intent(MainActivity.class, MainActivity2.this);
  startActivity(intent);

• Intent intent = new Intent(MainActivity.this, MainActivity2.class);
  onLoadActivity(intent);

Line of code that executes a raw SQL query on the SQLite database and returns a Cursor object.

• Cursor cursor = sqLiteDatabase.rawQuery("select *from subject".null);

• Cursor cursor = sqLiteDatabase.executeQuery("select *from subject", null);

• Cursor cursor = sqLiteDatabase.loadQuery("select *from subject", null);

• Cursor cursor = sqLiteDatabase.rawQuery("SELECT *from subject", null);

Which of the following code is used to make a toast?

• Toast.makeText(MainActivity.this, "Update successfully", Toast.LENGTH_SHORT).alert();
  

• Toast.makeText(MainActivity.this, "Update successfully", Toast.LENGTH_SHORT).show();
  

• Toast.createText(MainActivity.this, "Update successfully", Toast.LENGTH_SHORT).show();
  

• Toast.makeText(MainActivity.class, "Update successfully", Toast.LENGTH_SHORT).show();
  

Which of the following code is used to create a table with attributes.

• String query = "create table " + TABLE + "(id integer primary key, fname text, lname text)";
  db.execSQLite(query);

• String query = "create table " + TABLE + "(id integer primary key, fname text, lname text)";
  db.loadSQL(query);

• String query = "create table + TABLE + (id integer primary key, fname text, lname text)";
  db.execSQL(query);

• String query = "create table " + TABLE + "(id integer primary key, fname text, lname text)";
  db.execSQL(query);

Which of the following best describes the SUBMIT button?

• <Button
  android:id="@+id/submit_btn"
  android:layout_width="match_parent"
  android:layout_height="match_parent"
  android:layout_weight="1"
  android:text="SUBMIT" />

• <Button
  android:id="@+id/submit_btn"
  android:layout_width="wrap_content"
  android:layout_height="match_content"
  android:layout_weight="1"
  android:text="SUBMIT" />

• <Button
  android:id="@+id/submit_btn"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content"
  android:layout_weight="1"
  android:text="SUBMIT" />

• <Button
  android:id="@+id/submit_btn"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content"
  android:layout_size="1"
  android:text="SUBMIT" />

Which of the following is used to import ImageButton?

• import widget.view.ImageButton;

• import android.content.ImageButton;

• import android.view.ImageButton;

• import android.widget.ImageButton;

What code is used to import SQLite Database?

• 
  import android.sqlitedatabase.SQLiteOpenHelper;

• import android.database.sqlite.SQLiteDatabase;

• import android.database.sqlite.SQLiteOpenDatabase;

• import android.sqlite.database.SQLiteDatabase;

What code is used to delete record?

• long recremove = sqLiteDatabase.delete("subject", "id=" + id[position], null);
  

• long recremove = sqLiteHelperDatabase.delete("subject", "id=" + id[position], null);
  

• long recremove = sqLiteOpenDatabase.delete(subject, "id=" + id[position], null);
  

• long recremove = sqLiteDatabaseHelper.delete("subject", "id=" + id[position], void);