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

What are Support Libraries ?

Image
Android regularly releases Support Libraries , which are a bunch of features . Why Support Libraries ? Android keeps on adding new features. Say you have an App which was created using an older API version and you want to add the new features, you can do so using the Support libraries. So the purpose of these Libraries is to let Apps use new features of Android. What does the number attached to Support Library indicate ? Let’s take the v4 support library as an example. Now the number 4 in this indicates that this can be added to Apps which have been created with an API level greater than 4. Example v4 support library – Includes largest set of features. v7 appcompat library – Support for Action Bars. Can be included with API level 7 and above. In the next lesson you will create a new Project “ThemeDemoApp” to get better understanding of these concepts. Android Documentation –  http://developer.android.com/tools/support-library/index.html
Read more