Tv18 Broadcast Interview Questions and Answers

Role of Media

Q1. Tell me something about yourself
Add your answer
Q2. Honest answer and positive body language.
Add your answer

Q1. Are you comfortable with the job role ?
Ans. 
Yes, I am comfortable with the job role.
• I have extensive experience in sales and have successfully met and exceeded targets in my previous roles.

• I am confident in my ability to build and maintain relationships with clients.

• I am comfortable with the responsibilities and challenges that come with the sales executive position.

• I am familiar with the industry and have a good understanding of the products/services we will be...read more
Answered by AI
Add your answer
Q2. Tell me about yourself.
Ans. 
I am an experienced Sales Executive with a proven track record of exceeding targets and building strong client relationships.
• Over 5 years of experience in sales, with a focus on B2B sales

• Consistently achieved or exceeded sales targets by 20% each quarter

• Developed and maintained relationships with key clients, resulting in a 30% increase in repeat business

• Implemented effective sales strategies, resulting in a 15% increa...read more
Answered by AI
Add your answer

Q1. Sell me this Table !
Ans. 
This table is a versatile piece of furniture that combines style and functionality, perfect for any home or office.
• This table is made of high-quality wood, ensuring durability and longevity.

• The sleek design and neutral color make it easy to match with any decor.

• It features a spacious surface area, ideal for working, dining, or displaying items.

• The sturdy construction and stable legs provide a reliable and secure base.

• W...read more
Answered by AI
Add your answer
Q2. What are the objectives you are looking for this role ?
Add your answer
Q3. Sell me this Chair !
Ans. 
This chair is not just a piece of furniture, but a stylish and comfortable addition to any room.
• Highlight the ergonomic design for maximum comfort

• Emphasize the durability of the materials used

• Mention the versatile style that complements any decor
Answered by AI
Add your answer

Basic aptitude and graduation based OS, CN, DAA and DBMS questions

Q1. Psychological warfare, to be honest
Add your answer

Q1. Questions on DBMS, CN and DAA
Add your answer

Q1. C# abstraction and encapsulation
Add your answer
Q2. Reflection and indexers in c#
Ans. 
Reflection and indexers in C#
• Reflection allows inspecting and manipulating metadata of types, objects, and assemblies at runtime

• Indexers provide a way to access elements of a class or struct using array-like syntax

• Reflection can be used to dynamically access and invoke indexers
Answered by AI
Add your answer
Q3. Difference between ienumerable and iqueryable
Ans. 
IEnumerable is read-only and forward-only while IQueryable is queryable and can be filtered.
• IEnumerable is used for in-memory collections while IQueryable is used for querying databases.

• IQueryable is more efficient for large datasets as it allows for server-side filtering.

• IQueryable extends IEnumerable and adds additional functionality for querying data sources.

• Example: IEnumerable numbers = new List { 1, 2, 3 }; IQuer
Answered by AI
Add your answer
Q4. Difference between rank and dense rank in c#
Ans. 
Rank assigns unique numbers to each distinct value, while dense rank assigns consecutive numbers to each distinct value.
• Rank and DenseRank are used to assign a unique number to each distinct value in a sorted list.

• Rank assigns a unique number to each distinct value, but leaves gaps for ties.

• DenseRank assigns consecutive numbers to each distinct value, without leaving gaps for ties.

• In C#, Rank and DenseRank are availabl...read more
Answered by AI
Add your answer
Q5. Difference between function and Stored procedure
Ans. 
Functions return a value while stored procedures do not.
• Functions are used to perform a specific task and return a value to the caller.

• Stored procedures are used to execute a set of statements and do not return a value.

• Functions can be used in SQL statements while stored procedures cannot.

• Functions can be called from within stored procedures.

• Functions can be used in expressions while stored procedures cannot.
Answered by AI
Add your answer
Q6. Difference between clustered and non clustered index
Ans. 
Clustered index determines the physical order of data in a table, while non-clustered index has a separate structure.
• Clustered index sorts and stores the data rows in the table based on their key values, while non-clustered index has a separate structure that contains the key values and a pointer to the data row.

• A table can have only one clustered index, while it can have multiple non-clustered indexes.

• Clustered index ...read more
Answered by AI
Add your answer
Q7. Difference between execute scalar and execute nonquery
Ans. 
ExecuteScalar returns single value while ExecuteNonQuery does not return any value.
• ExecuteScalar is used for retrieving a single value from the database, such as a count or sum.

• ExecuteNonQuery is used for executing SQL statements that do not return any value, such as INSERT, UPDATE, DELETE.

• ExecuteScalar returns the first column of the first row of the result set, while ExecuteNonQuery returns the number of rows affecte...read more
Answered by AI
Add your answer