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

 文化衝突 很多人都知道台灣文化與加拿大文化(泛西方文化)有很大的衝突。衝突不是只有台灣人與加拿大人之間。在加拿大住久了的老僑與新僑衝突更大。主要在做事情方式, 價值觀與思考方式。 三十年來 我看到太多新來的台灣人無法適應加拿大 ,找不到工作 ,身體出問題 ,婚姻出問題 ,無法適...