CrazyEngineers Archive
Old, but evergreen and popular discussions on CrazyEngineers, presented to you in read-only mode.
@*pushkar* • 18 Dec, 2011
I have made a project called music.com in my final year which is songs related website. I want to know what kind of questions should i prepare before appearing for an interview.

Project Name : Music.com
Front End : Asp.net
Back End : sql

Brief Into : Its a songs site where a user an play, download songs & visit all albums.
@Kaustubh Katdare • 18 Dec, 2011 Why not tell us what your project does? Give us more details so that we can tell you what type of questions to expect.
@K!r@nS!ngu • 18 Dec, 2011 ya... we need more description
@*pushkar* • 18 Dec, 2011 okk

Music.com which is a information portal to provide latest music albums, movies available in india & world. A user can select a category of albums, select a song, can download it, can download the whole album and even play the songs.

Admin can upload the songs on the portal. Also admin have rights only to add, edit, delete albums of songs.

An inquiry page is there, with the help of which the users can contact admin.

Project Name : Music.com
Front End : Asp.net
Back End : sql
@K!r@nS!ngu • 18 Dec, 2011 o.k. these type of que.s they may ask..

1. Why did you selected this topic???(because it is entertainment related na...)
2. How you can provide security to the content in the portal??
3. Is it for a third party or for the music composers???
@*pushkar* • 18 Dec, 2011 1) We (my friend & i ) are very fun loving persons. We wanted to make a project in which we can enjoy ourselves while working. But its not just for entertainment purpose.

2) we wanted to add something for security purposes like purchasing system via any credit card or paypal. We tried alot & did some search on it but we couldn't able to do it.

3) Its for music composers specially who loves their fans and want to share songs with all of them. I think with this project they can attract more consumer in a wider range. There are many students who are pursing their studies & sing. They always upload their songs on net. So this project gonna help them in creating their own music portal.

Hope i answered well. Comments are welcome 😀
@K!r@nS!ngu • 18 Dec, 2011 • 1 like For the second question you can simply answer:

"only registered users' can access to the content...."

1st and 3rd answers are fine and acceptible...
@PraveenKumar Purushothaman • 19 Dec, 2011 Another question... What have you decided about the IP Challenges you might face? Since it is going to be music, the copyright holders might not like it to be used public, right? And are you going to host them for listening or just listing?
@*pushkar* • 19 Dec, 2011
K!r@nS!ngu
For the second question you can simply answer:

"only registered users' can access to the content...."

1st and 3rd answers are fine and acceptible...
Thanks for your reply. But anyone can download the songs. its open for public users.

What have you decided about the IP Challenges you might face?
Can you describe it in a little more detail. I didn't get it.

Since it is going to be music, the copyright holders might not like it to be used public, right? And are you going to host them for listening or just listing?
Read my 3rd answer bro. I think both the questions are same.

@Praveen Bro, you didn't respond to my last PM. If you can help me then do reply. I would appreciate it. Thanks 😀
@PraveenKumar Purushothaman • 19 Dec, 2011
*pushkar*
@Praveen Bro, you didn't respond to my last PM. If you can help me then do reply. I would appreciate it. Thanks 😀
I couldn't see your message, I didn't get it! Send me once again! 😀
@Kaustubh Katdare • 19 Dec, 2011 Yeah, IP related questions could be one of the most obvious questions. Few more questions that might be asked -
  • How would this website scale? Each song on an average occupies about 4mb space.
  • How does the search engine work? How will it work when the database grows to several thousands of GB?
  • How do you control bandwidth. Streaming content would usually load the server and each a ton of bandwidth.
  • How are you ensuring the security of your website?
  • What kind of hosting environment does your website need?
  • What browser types and versions does your website / web service support?
  • What are the minimum connection speed requirements? What if the user does not meet the requirements.
  • Do you use Javascript on your website? If yes, how does your website handle the browsers with JS turned off. 😀
...and such questions.
@*pushkar* • 19 Dec, 2011 Few more questions that might be asked -
  • How would this website scale? Each song on an average occupies about 4mb space.
I do agree but now a days all hosting companies provides good space & bandwidth. I dont think they would be any problem of such kind.
  • How does the search engine work?
We can add tages in the header part related to the site contents so that search engineer can works.

  • How do you control bandwidth. Streaming content would usually load the server and each a ton of bandwidth.
We can start with the shared server and can shift to the VPS or dedicated server according to our needs.
  • How are you ensuring the security of your website?
Already Answered.
  • What kind of hosting environment does your website need?
I think i have answered it in the above question.
  • What browser types and versions does your website / web service support?
We had checked it on IE & Mozilla. I think there would be no problem of this kind of.
  • What are the minimum connection speed requirements? What if the user does not meet the requirements.
Its normal like you need it to download a song.
  • Do you use Javascript on your website? If yes, how does your website handle the browsers with JS turned off.
No Javasript. We made it with asp.net only

How will it work when the database grows to several thousands of GB?
Does it creates any problem? I don't know.. can you help me
@Kaustubh Katdare • 19 Dec, 2011 @ Pushkar: Be aware that lot of web hosts do not allow streaming content on their webservers. You need to declare that to the hosts before you begin hosting content that will be streamed. The interviewer might grill you on it.
@PraveenKumar Purushothaman • 19 Dec, 2011 My best suggestion would be having it in the home server itself and map the dynamic or static IP address with your domain. You have a lot of tools like DynDNS, etc. and moreover 8 mbps connection is also becoming cheap. What's your go on this Biggie?
@*pushkar* • 19 Dec, 2011 Well i think there are many good webhosts like hostgator ( which i had used ), Liquidweb etc. We can start with any shared server which is good to start and if we are starting getting good no. of visitors and need more bandwidth then we can shift to Virtual Private server and with an excellent traffic we can also shift to dedicated server. I think i am right.. Am i??
@Kaustubh Katdare • 20 Dec, 2011 • 1 like
Praveen-Kumar
My best suggestion would be having it in the home server itself and map the dynamic or static IP address with your domain. You have a lot of tools like DynDNS, etc. and moreover 8 mbps connection is also becoming cheap. What's your go on this Biggie?
Server in home? 😨

For a small website that does not need 99.99% uptime can run on a home based server that can connect to the Internet. But 8 Mbps connection for streaming content isn't enough. Plus if the site grows, maintaining a larger dedicated server at home isn't an easy job. You're going to need 24x7 monitoring. Not to forget the 24x7 power supply and keeping the server up all the time. On the top of that, if the HDD crashes; then you'll have to take the server down! What about backups?

I'd rather pay a little extra to a good web hosting provider than host the server myself.

A VPS server may not necessarily be an 'upgrade' over shared hosting; as against the popular belief. I used to think the same when I realized that I was far better on a shared server than a VPS. A VPS actually limits the memory you can use. If your memory limit is 1 GB, then you can't exceed that limit. However, on a shared server; the memory is dynamically allotted to the web accounts running on it. From my experience, a shared hosting can sometimes handle traffic spikes better than VPS.

The limitation that shared hosting puts is that they'll give you limited file storage space; while on VPS, you'll usually have more storage. A dedicated server too has its own limitations. The latest buzz in town is cloud - where you can adjust the memory & storage space quickly (within 1 hour) without worrying about hardware replacements.
@PraveenKumar Purushothaman • 20 Dec, 2011 • 1 like You would be having full control over the system and yeah, maintenance cost is there. But, if you host any kinda files, there won't be anyone to question right? I mean, you don't need to ask the host then and there to ask for permission for hosting Streaming Media, MP3s, etc. And moreover, you are the admin and there is no restriction. Like once I had an attack on my site because of a loophole in Wordpress TinyMCE and all my sites were affected. After that the hosting company had placed a hell lot of stupid rules and restrictions! These things can be avoided right?
@Krishna Vedulla • 30 Apr, 2014 Its a really great discussion i found..
@Ankita Katdare • 01 Oct, 2015 In my experience, these are the questions that the invigilator/interviewer asks -

1. How is your project different than <existing app/solutions>>
2. How did you develop a particular module of this project? <He expects you to tell him the algorithm or if it's a mech project the step by step process of building it)
3. Why did you choose this particular platform to develop this application/tool/software?
4. What is the scope of improvement if time/money is allotted to this project?

I am going for a generic series here. If you want to know the specific questions asked about a certain project, reply with your brief project description below.
@Karshil Sheth • 14 Feb, 2020

Interview can ask such type of questions. [ these questions were asked to me and it might be different according to project as well and also interviewer.]

  • What is the Architecture Design?
  • If its based on existing model, then does it solve the problem and is it scalabel for long term.
  • What type of backend is being implemented.
  • Write the logic for pagination and search bar used in the project.
  • what is the file structure that you have made in it?


So these were the questions which were asked to me during the interview.

@Swarup Pan • 17 Feb, 2020

You can expect questions like ---

1. What is the database schema you have used?

2. Demonstrate the project.

3. What are the methods you have used in your DAL?

4. What interfaces you have used and why?

5. Have you used JS or Angular or React ?

Etc etc.

@bill yorke • 17 Feb, 2020
  1. What's your experience, personally and expertly? ... 
  2. Have you worked in a similar industry before? ... 
  3. What was a difficult venture, and how could you oversee it? ... 
  4. What's your administration style? ... 
  5. What's your correspondence style? ... 
  6. When do you realize the project is off course?
@Durgesh Srivastava • 19 Feb, 2020

Projects Related Questions In Interview are-

Demonstrate the project. 

What's your experience, personally 

What type of backend is being implemented.

benefits of project

project are hepful or not

uniqueness of project.

@Divisha Madupalli • 19 Feb, 2020

How different is your project?

Why did you opt for that specific frontend and backend technologies?

How useful is it in the present scenario?

The future scope of your project?

Since its about music, how much memory does it require?

How long the downloads will be?

The song's quality and speed?

The storage issues and all.

@Mohana Chandra • 19 Feb, 2020

What are the disadvantages that your project overcomes compared to the the Existed one ?

What is your role in the project ?

What the future scope of your Project?

Explain the Architecture of your project.

what is your project? Explain in brief.

What are the advantages and disadvantages of your project?


@supriya VN gowda • 20 Feb, 2020

Well they make ask you to demonstrate your project and ask you programming languages used for your project. 

Do your project exist in the present. 

It's already existing project then what is the extra feature of your project. 

Uniqueness of your project when compared with other projects. 

How your project helps people. 

How do you connect sql to your project. 

What is the use of using sql in your project. 

13.6k views

Related Posts

@ms_cs · Jul 2, 2009

Here Post the computer tricks and tips:smile:. This can be any computer short cut keys, and locking mechanisms, software easter eggs, anything related to computers and internet.
10.2k views

@vijaymp · Feb 15, 2011

Hi all, I am presently working as testing engineer in one of the companies. My domain of working is Mobile application testing. So I would like to know how is...
3.2k views

@Ankita Katdare · Jan 27, 2014

Maruti Suzuki has already laid out its plans to launch 'Maruti Suzuki Celerio' in the 2014 Delhi Auto Expo in India. Celerio is the upcoming hatchback that aims to replace...
5.9k views

@mbeychok · Sep 20, 2007

When a real gas, as differentiated from an ideal gas, expands at constant enthalpy (i.e., no heat is transfered to or from the gas, and no external work is extracted),...
8.8k views

@zaveri · Jul 6, 2013

Well we all like chocolate, but only when they are freshly taken out from the refrigerator, and present as chilled solid bars. but once they are put in warm places,...
4.7k views