YuppTV MIS Executive Interview Questions and Answers

It is a 30 minute test based on genral aptitude questions

Q1. Database and types of DBMS?
Ans. 
A database is a collection of organized data. Types of DBMS include relational, object-oriented, hierarchical, and network.
• Relational DBMS: Organizes data into tables with rows and columns. Examples include MySQL, Oracle, and SQL Server.

• Object-oriented DBMS: Stores data as objects. Examples include MongoDB and Cassandra.

• Hierarchical DBMS: Organizes data in a tree-like structure. Example: IBM's Information Management Sy...read more
Answered by AI
View 1 more answer
Q2. What is SQL and tell two query?
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language.

• It is used to communicate with and manipulate databases.

• Two common types of SQL queries are SELECT and UPDATE.

• SELECT query is used to retrieve data from a database.

• Example: SELECT * FROM Customers;

• UPDATE query is used to modify existing data in a database.

• Example: UPDATE Customers SET City = 'N
Answered by AI
View 1 more answer

Practical test on laptop of ms Excel formula and other speed related task

Q1. Why Old organization left ? Why join gtpl ? Other knowledge about dispatch and material management
Add your answer

Q1. Current CTC and in-hand salary
Add your answer
Q2. Expected CTC and other benifits
Add your answer

Technical aspects about linked list,trees, stacks

Topic related to humanities

I was given a case study to write multiple outputs by lookinginto a program.

Group discussion about sales pitch and plan , field and marketing, How to talks customer and convince to taken product.

Medium level aptitude test be prepared

Medium level coding test and sql test also brush up excel and sql

Q1. There are three different columns containing dates for various activities user did on the platform. How would you calculate the earliest activity date for the user
Ans. 
To calculate the earliest activity date for the user, find the minimum date across all three columns.
• Identify the three columns containing dates for various activities

• Use a function to find the minimum date across all three columns

• Consider handling null or missing values appropriately
Answered by AI
View 1 more answer