Ashish Verma - Study24x7
Social learning Network
Ashish Verma Cover image
Ashish Verma
Ashish Verma
Connections 207
Followers 208
Following 398
study24x7Ashish Verma

Ashish Verma

Studied Bachelor of Technology at Global Institute of Technology
community guy at social media marketing
Live in Jaipur,India, Rajasthan
  • Profile
  • About
  • Connections
About

To pursue a challenging career in leading and progressive research organization ...
See More

Ashish Verma
19 Jun 2024 10:32 AM study24x7 study24x7

What is a stored function in MySQL, and how is it different from a stored procedure?

A

A stored function is a set of SQL statements that can be executed together. It is the same as a stored procedure.

B

 A stored function is a way to create virtual columns in a table. It is different from a stored procedure, which performs a series of actions.

C

A stored function is a group of SQL statements that return a single value. It is different from a stored procedure, which can return multiple values. 

D

A stored function is a temporary table used for complex queries. It is the same as a stored procedure.

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
19 Jun 2024 10:31 AM study24x7 study24x7

How does the concept of indexing contribute to database performance?

A

Indexing is used to define a primary key for a table.

B

Indexing has no impact on database performance.

C

Indexing speeds up the retrieval of rows by creating a data structure that allows for quicker data access.

D

 Indexing is used to encrypt sensitive data in the database.

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
19 Jun 2024 10:30 AM study24x7 study24x7

 What is the purpose of the TRUNCATE statement in MySQL?

A

To remove specific rows from a table based on a condition

B

To delete all rows from a table without logging individual row deletions 

C

To alter the structure of a table

D

To update data in a table

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
12 Jun 2024 11:13 AM study24x7 study24x7

What is a transaction in MySQL?

A

A single SQL statement

B

A group of SQL statements that are executed together

C

A sequence of database operations that are executed as a single unit 

D

A type of table used for logging changes to the database

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
12 Jun 2024 11:12 AM study24x7 study24x7

How can you optimize a slow SQL query?

A

Add more indexes

B

Remove the WHERE clause

C

Use the DISTINCT keyword

D

Increase the number of columns in the SELECT statement

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
12 Jun 2024 11:11 AM study24x7 study24x7

 What is the purpose of the HAVING clause in a SQL query?

A

To filter results based on conditions

B

To order results alphabetically

C

To filter results after a GROUP BY clause

D

To select specific columns

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
05 Jun 2024 10:47 AM study24x7 study24x7

Which annotation is used in Android for dependency injection with Dagger 2?

A

@Inject 

B

@Dependency

C

@Dagger

D

@Component

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
05 Jun 2024 10:46 AM study24x7 study24x7

What is the purpose of the 'ProGuard' tool in Android development?

A

To optimize and obfuscate the code 

B

To manage app permissions

C

To handle background tasks

D

To control the app's navigation

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
05 Jun 2024 10:45 AM study24x7 study24x7

Which Android component is used for performing long-running operations in the background and is not tied to a specific activity?

A

AsyncTask

B

IntentService 

C

Service

D

BroadcastReceiver

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment
Ashish Verma
04 Jun 2024 11:46 AM study24x7 study24x7

What is the purpose of the 'FragmentManager' class in Android?

A

To manage app preferences

B

To control the device's sensors

C

To handle fragments and transactions 

D

To manage background tasks

Mobile Technologies Android
Like Comment Share
study24x7
Write a comment