Angular面試問題  by YuH

========問觀念

ngrx

code review experience

angular httpProxy, httpClient, httpIntercepter and Cross-Origin

angular e2e testing

angular observable, subject

web debug, performance trcing

prototype inheritance

map, reduce

html tag appending

sql injection, internet fraud website, other security concern

 

sql join, group by, having

hash table, hash function

Synchronization in Java

java debug, performance tuning, profiling

string compress 

angular directives

Polymorphism, override

generic

========SQL

Create view from select sin, name, addr from PERSON where sin = %sin%

studdent id, name

course id, description

student_course studdent_id, course_id

student per course

course descroption student

select 

 student_course.descroption

 count(student_course.studdent_id) as stu_count

from student_course as student_course 

 studdent as studdent

 course as course

 join studdent on studdent.id = student_course.studdent_id

 join course on course.id = student_course.course_id

group by course_id

having stu_count > 30

========string compress in Javascript

AA--> A2

A---> A  (X)A1

ACCBCCC ---> ABC4  (O)AC2BC2

AA--

AA

2A

AAB

funciton (str){

 let arr = str.split('');

 let result = '';

 

 

 let pre = arr[0];

 let count = 1;

 

 for(let i=1; i<arr.length; i++){

  if(arr[i]===pre){    

   count++;

   if(i===arr.length-1){

    result += count + pre;

   }   

  }else{   

   if(count===1){

    result += pre;

   }else{

    result += count + pre;

   }

  }

  pre = arr[i];

 }

 

 return result;

}