Cred Interview Question | Time
Question
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answers ( 3 )
Data Stored in Stored Procedures can be retrieved must faster than data stored in SQL DataBase. Data can be precompiled and stored in-store procedures. This reduces the Time gap between Query.
Data Stored in Stored Procedures can be retrieved must faster than data stored in SQL DataBase. Data can be precompiled and stored in-store procedures. This reduces the Time gap between Query and compilation.
A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name,
which are stored in a relational database management system as a group, so it can be reused and
shared by multiple programs.
Data stored in stored procedures can be retrieved much faster than the data stored in SQL database.
Data can be precompiled and stored in Stored procedures. This reduces the time gap between query
and compiling as the data has been precompiled and stored in the procedure.