華為的JAVA面試題

華為的JAVA面試題

                                      

 

QUESTION NO: 1

1、public class Test {

    public static void changeStr(String str){

        str="welcome";

    }

    public static void main(String[] args) {

        String str="1234";

        changeStr(str);

        System.out.println(str);

    }

}

Please write the output result ：

 

QUESTION NO:2

1. public class Test {

2. static boolean foo(char c) {

3. System.out.print(c);

4. return true;

5. }

6. public static void main( String[] argv ) {

7. int i =0;

8. for ( foo('A'); foo('B')&&(i<2); foo('C')){

9. i++ ;

10. foo('D');

12. }

13. }

14. }

What is the result?

A. ABDCBDCB

B. ABCDABCD

C. Compilation fails.

D. An exception is thrown at runtime.

 

QUESTION NO: 3

1. class A {

2. protected int method1(int a, int b) { return 0; }

3. }

Which two are valid in a class that extends class A? (Choose two)

A. public int method1(int a, int b) { return 0; }

B. private int method1(int a, int b) { return 0; }

C. private int method1(int a, long b) { return 0; }

D. public short method1(int a, int b) { return 0; }

E. static protected int method1(int a, int b) { return 0; }

 

QUESTION NO: 4

1. public class Outer{

2. public void someOuterMethod() {

3. // Line 3

4. }

5. public class Inner{}

6. public static void main( String[]argv ) {

7. Outer o = new Outer();

8. // Line 8

9. }

10. }

Which instantiates an instance of Inner?

A. new Inner(); // At line 3

B. new Inner(); // At line 8

C. new o.Inner(); // At line 8

D. new Outer.Inner(); // At line 8//new Outer().new Inner()

 

QUESTION NO: 5

Which method is used by a servlet to place its session ID in a URL that is written to the servlet’s response output stream?

A. The encodeURL method of the HttpServletRequest interface.

B. The encodeURL method of the HttpServletResponse interface.

C. The rewriteURL method of the HttpServletRequest interface.

D. The rewriteURL method of the HttpServletResponse interface.

 

QUESTION NO: 6

Which two are equivalent? (Choose two)

A. <%= YoshiBean.size%>

B. <%= YoshiBean.getSize()%>

C. <%= YoshiBean.getProperty("size")%>

D. <jsp:getProperty id="YoshiBean" param="size"/>

E. <jsp:getProperty name="YoshiBean" param="size"/>

F. <jsp:getProperty id="YoshiBean" property="size"/>

G. <jsp:getProperty name="YoshiBean" property="size"/>

 

QUESTION NO: 7

Which of the following statements regarding the lifecycle of a session bean are correct?

1.  java.lang.IllegalStateException is thrown if SessionContext.getEJBObject() is invoked when a stateful session bean instance is passivated.

2.  SessionContext.getRollbackOnly() does not throw an exception when a session bean with bean-managed transaction demarcation is activated.

3.  An exception is not thrown when SessionContext.getUserTransaction() is called in the afterBegin method of a bean with container-managed transactions.

4.  JNDI access to java:comp/env is permitted in all the SessionSynchronization methods of a stateful session bean with container-managed transaction demarcation.

5.  Accessing resource managers in the SessionSynchronization.afterBegin method of a stateful session bean with bean-managed transaction does not throw an exception.

 

 

第二部分：概念題

1．    描述Struts體繫結構？對應各個部分的開發工作主要包括哪些？

 

2．    XML包括哪些解釋技術，區別是什嗎？

 

3．    JSP有哪些內建對象和動作？它們的作用分別是什嗎？

 

 4、SQL問答題

SELECT * FROM TABLE

和

SELECT * FROM TABLE

WHERE NAME LIKE '%%' AND ADDR LIKE '%%'

AND (1_ADDR LIKE '%%' OR 2_ADDR LIKE '%%'

OR 3_ADDR LIKE '%%' OR 4_ADDR LIKE '%%' )

的檢索結果為何不同？

 

 

 

5、SQL問答題

表結構：

1、    表名：g_cardapply

欄位(欄位名/類型/長度)：

g_applyno        varchar   8；//申請單號（關鍵字）

g_applydate     bigint     8；//申請日期

g_state        varchar     2；//申請狀態

2、    表名：g_cardapplydetail

欄位(欄位名/類型/長度)：

g_applyno        varchar     8；//申請單號（關鍵字）

g_name        varchar     30；//申請人姓名

g_idcard        varchar     18；//申請人社會安全號碼

g_state        varchar     2；//申請狀態

其中，兩個表的關聯欄位為申請單號。

題目：

1、    查詢社會安全號碼碼為440401430103082的申請日期

2、    查詢同一個社會安全號碼碼有兩條以上記錄的社會安全號碼碼及記錄個數

3、    將社會安全號碼碼為440401430103082的記錄在兩個表中的申請狀態均改為07

4、    刪除g_cardapplydetail表中所有姓李的記錄

------------------------******測試******-----------------

 create database mianshi

use mianshi;

create table g_cardapply(
 g_applyno varchar(8),
 g_applydate bigint,
 g_state varchar(20)
)
go
create table g_cardapplydetail(
 g_applyno varchar(8),
 g_name varchar(30),
 g_idcard varchar(18),
 g_state varchar(20)
)

1、select a1.g_applydate from g_cardapply as a1 inner join g_cardapplydetail a2 on
a1.g_applyno=a2.g_applyno where a2.g_idcard="123" ;

2、select g_idcard,count(g_idcard) from g_cardapplydetail
 group by g_idcard having count(g_idcard)>=2;

3、update g_cardapply set g_state=603 from g_cardapply as g_d inner join g_cardapplydetail as g_c on
g_d.g_applyno=g_c.g_applyno and g_idcard='123';更新第一個表的g_state   

update g_cardapplydetail set g_state=603 where g_idcard='123';