Oracle認(rèn)證綜合練習(xí)章節(jié)練習(xí)(2019.12.03)

A.LOOP
B.WHILE…LOOP
C.IF…LOOP
D.FOR…LOOP

A.disactive
B.validate
C.active
D.novalidate

A.select * from emp where comm='';
B.select * from emp where comm=null;
C.select * from emp where nvl(comm)=0;
D.select * from emp where comm is null;
E.select * from emp where nvl(comm,0)=0;

A.HAVING
B.ORDER BY
C.WHERE
D.GROUP BY

A.一個例程只能打開一個數(shù)據(jù)庫，一個數(shù)據(jù)庫也只能由一個例程打開
B.一個例程可以打開多個數(shù)據(jù)庫，但一個數(shù)據(jù)庫可以由多個例程打開
C.一個例程只能打開一個數(shù)據(jù)庫，但一個數(shù)據(jù)庫可以由多個例程打開
D.一個例程可以打開多個數(shù)據(jù)庫，一個數(shù)據(jù)庫也只能由一個例程打開

A.范圍分區(qū)
B.列表分區(qū)
C.散列分區(qū)
D.復(fù)合分區(qū)

A.動態(tài)數(shù)據(jù)字典
B.靜態(tài)數(shù)據(jù)字典
C.dba_*視圖
D.all_*視圖