NEW
Font size
WorksheetsQuiz: Construct Database using SQLite CRUD
Total questions: 10
Worksheet time: 2mins
What does CRUD stand for?
Copy, Replace, Upload, Download
Create, Run, Undo, Deploy
Create, Read, Update, Delete
Compile, Render, Update, Debug
Which class in Android is used to manage SQLite database creation and version management?
SQLiteManager
SQLiteOpenHelper
DatabaseHelperActivity
SQLiteCursor
Which SQL statement is used to retrieve data from a table?
INSERT INTO
SELECT * FROM
UPDATE
DELETE
Which SQL statement adds a new record into a table?
INSERT INTO
UPDATE
SELECT
ALTER TABLE
In SQLite for Android, what is the purpose of ContentValues?
To store user interface data
To hold key-value pairs for inserting or updating data
To manage app permissions
To handle file storage
What is the role of a Cursor object in SQLite?
It saves images into database
It reads query results (result set)
It deletes old database files
It updates the database schema
Which CRUD operation modifies existing data in a database?
CREATE
READ
UPDATE
DELETE
In Room Database, which annotation is used to define a table?
@Dao
@Entity
Why should CRUD operations run on a background thread in Android?
To reduce app file size
To prevent the UI from freezing or crashing (ANR)
To speed up app installation
To compile code faster
What does the DELETE operation in CRUD do?
Removes the entire database
Drops the whole table
Deletes specific records from the table
Clears all app data in the device
