SQLite based Android interview questions and answers

1) What are joins that are not supported by SQLite?

Answer: Right outer join and full outer joins

2) What are SQLite and its methods?

Answer: SQLite is a relational open source database which comes inbuilt in android devices which enables you to store, retrieve, manipulate and delete data.

Using SQLite android application can run in offline mode also.

Sqlite is implemented in our project by extending the class with SqliteOpenHelper class which overrides 2 methods i.e;

1.oncreate() -Where the database is created along with its version.

2.onUpgrade() -It is supporting function of onCreate() when the version has updated the changes in a database will be performed in an on upgrade method without disturbing the existing one

3) What is the limit of data storage in sqlite?

Answer: Maximum data SQLite can store depends on the storage space of your device.

SQLite database save data in which storage?

A) Internal storage

There are five different methods to store persistent data. They are: Shared Preferences. Internal Storage. External Storage. Network and __?

A) SQLite Database

In class SQLiteOpenHelper class, there are 2 methods we should usually override. What are they?

A) onCreate() and onUpgrade()

Which two methods will be Override from SQliteOpenHelper?

Ans:

OnCreate()

OnUpgrade()

Comments

Post a Comment

Popular posts from this blog

Jetpack Compose based Android interview and questions

What’s Jetpack Compose and its Benefits? Jetpack Compose is a modern UI toolkit recently launched by Google which is used for building native Android UI. It simplifies and accelerates the UI development with less code, Kotlin APIs, and powerful tools.  Declarative Compatible Increase development speed Concise and Idiomatic Kotlin Easy to maintain Written in Kotlin To read more, refer  to  the article:  Jetpack Compose in Android Aaaaaa
Read more

Null safety based Kotlin interview questions and answers

Image
Nullable Non Nullable Types What’s Null Safety and Nullable Types in Kotlin? What is the Elvis Operator? Kotlin puts a lot of weight behind null safety which is an approach to prevent the dreaded Null Pointer Exceptions by using nullable types which are like  String? ,  Int? ,  Float?  etc. These act as a wrapper type and can hold null values. A nullable value cannot be added to another nullable or basic type of value. To retrieve the basic types we need to use safe calls that unwrap the Nullable Types. If on unwrapping, the value is null we can choose to ignore or use a default value instead. The Elvis Operator is used to safely unwrap the value from the Nullable. It’s represented as  ?:  over the nullable type. The value on the right hand side would be used if the nullable type holds a null. var str: String ? = "JournalDev.com" var newStr = str?: "Default Value" str = null newStr = str?: "Default Value" How is  !! different from ?. in unwrapping t
Read more

CustomView based Android interview questions and answers

1) Design one custom view for displaying TextView in UI with a attributes tribute like Title and Colour. When we need to create any custom view in Android, we will extend our class from the View parent class. In this scenario, as we need to create a custom Text view so we will create a subclass of TextView class.  And then we can our Custom textview in a layout.xml file. For example please follow below code where I am trying to create Custom TextView CustomTextView extends TextView { private String title;     private boolean color; title = tarry.getString(R.styleable.CustomTextView_settitle);             if(title == null)             setText("Custom Message");             else                 setText("Welcome to the Class"); color = tarry.getBoolean(R.styleable. CustomTextView _setColor, false);             if(color == true)             setTextColor(Color.RED); } We need to define our custom textview  in \res\layout  folder and write the code like as shown below. &l
Read more