)( A 58¡¢ÏÂÁÐÄÄÒ»Ïî×ÊÔ´²»ÄÜÔÚÓû§ÅäÖÃÎļþÖÐÏÞ¶¨£¿
¸÷¸ö»á»°µÄÓû§ÊýA. µÇ¼ʧ°ÜµÄ´ÎÊýB. ʹÓÃC. CPU ʱ¼ä ÇøµÄ´óС ʹÓà SGA D.
59¡¢ÏÂÃæÄĸöϵͳԤ¶¨Òå½ÇÉ«ÔÊÐíÒ»¸öÓû§´´½¨ÆäËûÓû§£¿( B ) A¡¢ CONNECTB¡¢ DBAC¡¢RESOURCED¡¢SYSDBA
60¡¢ÔÚ´´½¨±í¿Õ¼äʱ£¬¿ÉÒÔÖ¸¶¨±í¿Õ¼äÖд洢¶ÔÏóµÄĬÈÏ´æ´¢²ÎÊý£¬ÆäÖÐ()
)²ÎÊýÓÃÓÚÉèÖ÷ÖÅä¸øÿһ¸ö¶ÔÏóµÄ³õʼÇø´óС¡£
( A INITIAL A. NEXT
B. PCTINCREASE C. MINEXTENTS D.
61¡¢°ÑÒ»¸ö±í¿Õ¼äÇл»µ½ OFFLINE ״̬ʱ£¬¿ÉÒÔʹÓà 4 ¸ö²ÎÊý£¬²»°üÀ¨ÏÂÁÐÄÄÒ»¸öÑ¡Ï ( D )
A. IMMEDIATE B. NORMAL
C. TEMPORARY D. FORCE
FOR RECOVERY
62¡¢½¨Á¢Ò»Õűí²åÈë 1 ÐмǼ£¬Ö®ºóʹÓà exp µ¼³öÊý¾Ý£¬Ôٴθø±í²åÈë2 ÐÐÊý¾Ý£¬
Ö®ºó°Ñ±í¸ñɾ³ý£¬ÖØÐÂʹÓÃimp ÃüÁîµ¼Èëµ¼³öµÄÊý¾Ý£¬µ¼Èëºó±íÖÐÓУ¨B £© Ìõ¼Ç¼¡£ 0A. 21C. B. 3D.
£©½«Êý¾Ý¿âÆô¶¯µ½×°ÔØ״̬µÄÃüÁC63 B:
startup nomountA: startupD: startup openC: startup
mount
64£©BÃüÁî¹Ø±ÕÊý¾Ý¿â shutdown ʹÓ÷¢ÉúµÄ´ÎÐòÊÇ
£¨,
A: ÏȹرÕʵÀý½ø³Ì ÏȹرÕÊý¾Ý¿âB: ÏÈжÔØÊý¾Ý¿âC: ûÓÐÏȺó´ÎÐòD:
£©ÃüÁÏÂÁÐÕýÈ·µÄÊÇ£¨D65Ö´ÐÐ shutdown transactional
A: Êý¾Ý¿âÈÔÈ»ÔÊÐíеÄÓû§Á¬½Ó B:Êý¾Ý¿âÂí
ÉÏ¹Ø±Õ µÈ´ýµ±Ç°ËùÓлỰ½áÊøºó¹Ø±ÕC: D: Èç¹ûûÓÐÖ´ÐÐÖеÄÊý¾Ý¿âÊÂÎ¼´ÂíÉϹرÕ
£©£¨ B66·þÎñÆ÷¶Ïµç£¬·¢ÉúµÄÏÖÏóÊÇÄÄÒ»¸ö£¿ A: Êý¾Ý»º³åÇøµÄÐÞ¸ÄдÈëÊý¾Ý¿â ûÓÐÌá½»µÄÊÂÎï×Ô¶¯³·ÏúB: Êý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ´¦ÓÚ²»Ò»ÖÂ״̬C: D: Ï´ÎÆô¶¯£¬ÐèÒª½øÐÐÊÖ¹¤»Ö¸´
UPDATE Óï¾ä£¬ÐèÒª±£Ö¤Àí SCOTT µÄÐ޸IJÙ×÷Íê³É£¬ÕýÔÚÖ´ÐÐ67 Óû§ SCOTT £©DÏëµÄ¹Ø
±ÕʵÀý·½Ê½ÊÇ£¨ A: SHUTDOWN ABORTB: SHUTDOWN IMMEDIATE C: SHUTDOWN TRANSACTIONALD: SHUTDOWN NORMAL
£©£¨ ÒÔÏ´´½¨±í¿Õ¼äµÄÕýÈ·Óï¾äÊÇ£º68. D ???…Í???ئ??Œ°??ئ???? LOGGING DATAFILE
'/home/oracle/app/oracle/oradata/orcl/EVCHGJ4.dbf'
SIZE 5M ???…Í???ئ??Œ°‡j??ÞÏ
LOGGING DATAFILE
'/home/oracle/app/oracle/oradata/orcl/EVCHGJ4.dbf'
??Ìê??·Í??‚¬?????? LOGGING SIZE 5M ??Ìê??·Í??‚¬?????? DATAFILE
'/home/oracle/app/oracle/oradata/orcl/EVCHGJ4.dbf'
SIZE 5M
Êý¾Ý¿âϵͳÌØȨ²»°üÀ¨¡££¨C£©Oracle ´«Í³µÄ69. B. CONNECTC. RESOURCED. SELECT ANY
TABLEA. DROP
70. ÏÂÁÐÄĸöÓï¾äÄܹ»»á¹öµ½Ìض¨µØ·½¡£ £¨D£© A. UPDATE...
SAVEPOINT update_done; Savepoint created. INSERT...
ROLLBACK TO update_done; B. commit C. commit to update_done; D. rollback;
Áù¡¢ ¶àÏîÑ¡ÔñÌâ
1¡¢Oracle ÄÚ´æ½á¹¹¿ÉÒÔ·ÖΪ ( BC ) A£©±¸·ÝÇø B£©³ÌÐòÈ«¾ÖÇø