All Questions
Most of the job interviews close at this basic interview question where the interviewer leaves scope for you to clear your doubts. Moreover, asking questions show that you are a confident and focused person who wants clarity for his/her job. Many fresh graduates hesitate to ask questions from the interviewer, but it is always recommended to ask some relevant questions.
Prepare a list of questions in advance that can help you get familiarize with the job role.
Ask intelligent questions that show your curiosity to know more about the company, its policies, people, any specific skill you need to acquire for the given role, etc.
Avoid asking irrelevant questions such as the duration of lunch hours, how often the company organizes parties, or how soon you will be promoted to the next level!
From this question the employer wants to see your ability to pitch your skills and convincing power. This interview question is an opportunity to show the interviewer your willingness for the job. The best way to answer this fresher interview question is to talk about your skills and strengths that match the job role. You can even share some more examples of how you managed a few projects or important assignments in your college that reflect your strengths.
Share strengths and skills that are relevant for the job description, but keep it short.
- CONCAT(A, B) – Concatenates two string values to create a single string output. Often used to combine two or more fields into one single field.
- FORMAT(X, D) – Formats the number X to D significant digits.
- CURRDATE(), CURRTIME() – Returns the current date or time.
- NOW() – Returns the current date and time as one value.
- MONTH(), DAY(), YEAR(), WEEK(), WEEKDAY() – Extracts the given data from a date value.
- HOUR(), MINUTE(), SECOND() – Extracts the given data from a time value.
- DATEDIFF(A, B) – Determines the difference between two dates and it is commonly used to calculate age
- SUBTIMES(A, B) – Determines the difference between two times.
- FROMDAYS(INT) – Converts an integer number of days into a date value.
A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB –
- TINYBLOB
- BLOB
- MEDIUMBLOB
- LONGBLOB
They all differ only in the maximum length of the values they can hold.
A TEXT is a case-insensitive BLOB. The four TEXT types
- TINYTEXT
- TEXT
- MEDIUMTEXT
- LONGTEXT
They all correspond to the four BLOB types and have the same maximum lengths and storage requirements.
The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive for BLOB values and case-insensitive for TEXT values.
Composer is an application-level package manager for the PHP programming language that provides a standard format for managing dependencies of PHP software and required libraries. It was developed by Nils Adermann and Jordi Boggiano, who continue to manage the project. They began development in April 2011 and first released it on March 1, 2012. Composer is strongly inspired by Node.js's "npm" and Ruby's "bundler". The project's dependency solving algorithm started out as a PHP-based port of openSUSE's libzypp satsolver.
Composer runs from the command line and installs dependencies (e.g. libraries) for an application. It also allows users to install PHP applications that are available on "Packagist" which is its main repository containing available packages. It also provides autoload capabilities for libraries that specify autoload information to ease usage of third-party code.
Laravel is a free, open-source PHP web framework, created by Taylor Otwell and intended for the development of web applications following the model–view–controller (MVC) architectural pattern and based on Symfony. Some of the features of Laravel are a modular packaging system with a dedicated dependency manager, different ways for accessing relational databases, utilities that aid in application deployment and maintenance, and its orientation toward syntactic sugar.
Hot Questions
How to Get the Size of all Tables in a database in MySQL?