Search Header Logo

SQLite CRUD Quiz

Authored by Jaydwin Labiano

Computers

University

Used 3+ times

SQLite CRUD Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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);

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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);

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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();

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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);

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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" />

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?