SQL Interview Question Set - 5 Released
Intermediate Level How do I count the number of records in a MySQL query? select count(*) from TABLE_NAME where 'status' = 1; What is heap table in MySQL? HEAP tables are in memory. No TEXT or BLOB fields are allowed inside HEAP tables. They are...
SQL Interview Question Set - 4 Released
Intermediate Level What are Storage Engines in Mysql? Storage engines are Mysql components, that can handle the operations for different table types to store and manage information in a database. • InnoDB • MyISAM • MEMORY • MERGE • EXAMPLE • CSV • ARCHIVE etc...
Python with Gemini (Gen AI) using Google Colab
Introduction Hi folks! Welcome to an another exciting blog at Gamaka AI. This article basically deals with the use of Python with Gen AI using Google Colab. The advantage of using Google Colab is that it allows you to write and execute Python code directly in your...
SQL Interview Question Set - 3 Released
Intermediate Level What are the difference between MongoDB and MySQL? MongoDB - The representation of data in MongoDB is totally different from Mysql, as in MongoDB data is represented in the collection of JSON documents. MongoDB is an object oriented database. MySQL - The representation...
SQL Interview Question Set - 2 Released
Intermediate Level Explain the difference between primary key and candidate key in Mysql? Primary Key - It is a column that uniquely identifies a record. In Mysql, only one candidate key can behave like Primary Key. Candidate Key - It can be any column that...
SQL Interview Question Set - 1 Released
Intermediate Level What is MySQL? MySQL is a multithreaded, multi-user SQL database management system which has more than 11 million installations. It is the world's second most popular and widely-used open source database. It is interesting how MySQL name was given to this query language....
Power BI Interview Question Set - 4 Released
Intermediate Level 1. Case: Sales Performance Analysis Question: You're tasked with analyzing sales performance for a retail company. How would you approach this analysis using Power BI? Solution: - Import sales data into Power BI Desktop. - Create visualizations such as sales trend over time,...