Oracle基础知识考试题——孙云涛部门:姓名:成绩:(33个,每题3分,最后一题4分,共100分):?internal/oraclesys/change_on_installsystem/managerscott/tigersysman/$session;?in()操作时集合里最多允许有多少个元素??select'etovisit'||chr(10)||''fromdual;?altersessionsetnls_date_format='yyyymmddhh24miss';?altertableaaadropconstraintaaa_key;altertableaaaaddconstraintaaa_keyprimarykey(a1,b1);:第一步:,,#,,$locked_objectt1,v$sessiont2,v$==:altersystemkillsession'sid,serial#';?||?: SELECTTO_CHAR(SYSDATE,'D')FROMDUAL; DELETEFROMTABLE_NAME WHEREROWID!=(SELECTMAX(ROWID)FROMTABLE_NAMED ==);,,,,?写出一个方法即可:Selectlength(‘abcabcabc’)-length(replace(‘abcabcabc’,’a’,’’)?主键不可以为null,唯一索引可以。,个数不限。cume_dist(),dense_rank(),first_value(),last_value(),rank(),dense_rank(),row_number()()和dens
oracle基础知识考试题答案 来自淘豆网www.taodocs.com转载请标明出处.