发布时间 : 星期一 文章中兴软创笔试题更新完毕开始阅读beb001deb14e852458fb5769
数据库: CCBBB BDAAB BCCBD DACAB Java: DDDAA BAABB AECAC DBCDC 数据库应用题: 1. 答案
INSERT INTO CUST_INFO
VALUES(27005, ’艾美’, NULL,SYSDATE, 530); 或者 INSERT
INTO
CUST_INFO
(CUST_ID,CUST_NAME,CONTACT_NUMBER,CONSUME_DATE,CONSUME) VALUES(27005, ’艾美’, NULL,SYSDATE, 530);
(占总分20%,没有写出NULL和SYSDATE在原得分基础上适当扣分) 2. 答案
SELECT * FROM CUST_INFO
WHERE CUST_ID>20000 AND CUST_ID<99999 AND CONSUME<>0; 或者
SELECT * FROM CUST_INFO
WHERE CUST_ID BETWEEN 20000 AND 99999 AND CONSUME<>0; (占总分20%) 3. 答案
SELECT * FROM CUST_INFO WHERE CONSUME > (
SELECT AVG(CONSUME) FROM CUST_INFO) (占总分20%) 4. 答案
SELECT CUST_NAME, SUM(CONSUME) FROM CUST_INFO
HAVING SUM(CONSUME)>=10000 GROUP BY CUST_NAME ORDER BY SUM(CONSUME) ; (占总分20%) 5. 答案
(1)ALTER TABLE CUST_INFO MODIFY(CUST_ID NUMBER(6));
(占总分10%)
(2)UPDATE CUST_INFO SET CUST_ID= CUST_ID+100000; COMMIT;
(占总分10%)
编程题(请酌情给分) 1. 答案
import java.io.* ; public class Reverse
{ public static void main(String args[ ]) { int i , n =10 ; int a[ ] = new int[10]; for ( i = 0 ; i < n ; i ++ ) try {
BufferedReader br = new BufferedReader( new InputStreamReader(System.in));
a[i] = Integer.parseInt(br.readLine( )); // } catch ( IOException e ) { } ; for ( i = n-1 ; i >= 0 ; i ―― ) System.out.print(a[i]+\ System.out.println( ); } }
2. 答案
import java.io.*;
public class Class1 {
public static void main( String args[] ) {
Fact N = new Fact( 4 ); System.out.println( N.fact( ) ); } }
class Fact { int n ;
Fact( int nn ) { n = nn; } int fact( ) { int i , f = 1;
for ( i=1; i<=n; i++ ) f = f*i; return f; } }
输入一个整数