שיחזור ראיון ב-QUALITEST - SQL ANGULAR CSS MVC and more. למשרת intel בדיקות C# SQL. יש בערך שעה+ לעשות את המבחן which is a child selector in CSS? what is an attribute selector describe the MVC model what is routing in MVC and where is it written which file name a few ways to validations in MVC how do you share data between controllers what is the difference between ng-showing/ng-hide and ng-if is it a good practice to use AngularJS with Jquery what directive would you use to hide elements from HTML DOM explain what is $scope in angularJS what are directives explain ng-repeat what is the use of $routeProvider what are the controller in angularJS what are the advantage of using AngularJS can angular have multiple ng-app in a single page what does single page app(sap) mean and how to implement it is angularJS compatible with all browsers ----------------------------------------- SQL ----------------------------------------- table Invoices ----------------------------------------- id ---- int ----- NOT Null billing ----- data ----- NOT Null customId ---- int ---- NOT Null ----------------------------------------- table Customers ----------------------------------------- id ----- int ----- Not Null Name ----- nvarchar(50) ----- Not Null refferredBy ------ int ------ Null allow ----------------------------------------- for each invoices show: invoices.id, invoices.billing, customers.name if any --------------------------------------------------------------------------------------------------------- Emp(id, name,depId) dept(id, name) if there are 10 records in Emp and 5 in dept how many rows will be displayed: SELECT * FROM Emp, dept what is UNION and UNION ALL what is the key difference Truncate vs Delete select all even num select all odd num show the year concatenate multiple rows into a single text string is Null same as zero or blank space find current data time create new empty table same as another table without the data table(id, name, salary) remove duplicates without a temporary table search value in a table when you don't know the exact value table sal has m-male/f-female value swap m to f and vice versa find the mistake select subject_code, avg(marks) from students where avg(marks) > 75 group by subject_code varchar vs char data types what is SQL agent find the 2nd highest value inner vs outer join how do you code error handling logic - stored procedures