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

來加拿大唸書要注意的常見問題 1. 不要唸沒有專長的科系 有些科目被視為沒有專長,例如銷售,誰都能做銷售 有高學歷不見得賣的好。一般商業, 什麼都學, 等於沒有專長.  企業管理 你剛出道 又不可能做管理職,這個什麼都學, 什麼都不精, 跟其他科系相比完全沒有競爭力。文科, 藝術...