Design database, Design patterns, SQL, PHP, HTML, CSS, JS

Technical: Close Book: 1.) Basic CSS Questions: properties of elements. 2.) JavaScript: If it's loosely typed? Basic questions of code snippet if they will work. 3.) PHP: Code Snippets like associative arrays, loops, increment and decrement operations, Regular expressions etc. 4.) SQL: Basic SQL queries with joins, ORDER BY, ASC and DESC etc Open Book challenges: debug code for given outputs. CSS: position, overflow of divs, JavaScript: onclick CSS change challenges, PHP: indexed to associative arrays, SQL: SQL queries with JOINS and ORDER BY using alias etc. Remember the first round you may lose some time as the computer does not boot quickly. They won't provide extra time due to this and you will end up not completing the entire round. Behavioural: the Greatest success of your life, Greatest regret of your life, have you put your success over others, why are you a good fit for this company, what do you like about this company, what are your hobbies, How do you come over failures, about yourself (not professional intro but rather personal introduction) Team Challange: Different for everyone.

I was asked about big-O questions and also a coding knowledge about Stacks and Queues.