Saturday, August 13, 2022

 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;

}

No comments:

Post a Comment

 這是我看到最真誠實在的勸告! 請認清事實 把你英文學好,才不會被坑被騙! 英文能力越強 越不會中計 越能在海外生存紮根! ttp://xhslink.com/m/2ZM25u6gEew