oracleÆÚÄ©¸´Ï°Ìâ¼°´ð°¸

1¡¢ÒÔÏ£¨ £©ÄÚ´æÇø²»ÊôÓÚSGA¡£

A£®PGA B£®ÈÕÖ¾»º³åÇø C£®Êý¾Ý»º³åÇø D£®¹²Ïí³Ø 2¡¢£¨ £©Ä£Ê½´æ´¢Êý¾Ý¿âÖÐÊý¾Ý×ÖµäµÄ±íºÍÊÓͼ¡£ A£®DBA B£®SCOTT C£®SYSTEM D£®SYS 3¡¢ÔÚOracleÖд´½¨Óû§Ê±£¬ÈôδÌá¼°DEFAULT TABLESPACE

¹Ø¼ü×Ö£¬ÔòOracle¾Í½«£¨ £©±í¿Õ¼ä·ÖÅä¸øÓû§×÷ΪĬÈϱí¿Õ¼ä¡£

A£®HR B£®SCOTT C£®SYSTEM D£®SYS 4¡¢£¨ £©·þÎñ¼àÌý²¢°´ÊÜÀ´×Ô¿Í»§¶ËÓ¦ÓóÌÐòµÄÁ¬½ÓÇëÇó¡£ A£®OracleHOME_NAMETNSListener B£®OracleServiceSID

C£®OracleHOME_NAMEAgent D£®OracleHOME_NAMEHTTPServer

5¡¢£¨ £©º¯Êýͨ³£ÓÃÀ´¼ÆËãÀÛ¼ÆÅÅÃû¡¢Òƶ¯Æ½¾ùÊýºÍ±¨±í¾ÛºÏµÈ¡£ A£®»ã×Ü B£®·ÖÎö C£®·Ö×é D£®µ¥ÐÐ

6¡¢£¨ £©SQLÓï¾ä½«Îª¼ÆËãÁÐSAL*12Éú³É±ðÃûAnnual Salary A£®SELECT ename,sal*12 ?Annual Salary? FROM emp; B£®SELECT ename,sal*12 ¡°Annual Salary¡± FROM emp; C£®SELECT ename,sal*12 AS Annual Salary FROM emp; D£®SELECT ename,sal*12 AS INITCAP(¡°Annual Salary¡±) FROM emp; 7¡¢ËøÓÃÓÚÌṩ( )¡£

A£®¸Ä½øµÄÐÔÄÜ B£®Êý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ C£®¿ÉÓÃÐÔºÍÒ×ÓÚά»¤ D£®Óû§°²È«

8¡¢( )ËøÓÃÓÚËø¶¨±í£¬ÔÊÐíÆäËûÓû§²éѯ±íÖеÄÐкÍËø¶¨±í£¬

µ«²»ÔÊÐí²åÈë¡¢¸üкÍɾ³ýÐС£

A£®Ðй²Ïí B£®ÐÐÅÅËû C£®¹²Ïí D£®ÅÅËû

9¡¢´øÓÐ( )×Ó¾äµÄSELECTÓï¾ä¿ÉÒÔÔÚ±íµÄÒ»Ðлò¶àÐÐÉÏ·ÅÖÃÅÅËûËø¡£

A£®FOR INSERT B£®FOR UPDATE C£®FOR DELETE D£®FOR REFRESH

10¡¢Ê¹ÓÃ( )ÃüÁî¿ÉÒÔÔÚÒÑ·ÖÇø±íµÄµÚÒ»¸ö·ÖÇø֮ǰÌí¼ÓзÖÇø¡£

A£®Ìí¼Ó·ÖÇø B£®½Ø¶Ï·ÖÇø

C£®²ð·Ö·ÖÇø D£®²»ÄÜÔÚµÚÒ»¸ö·ÖÇøÇ°Ìí¼Ó·ÖÇø 11¡¢( )·ÖÇøÔÊÐíÓû§Ã÷È·µØ¿ØÖÆÎÞÐòÐе½·ÖÇøµÄÓ³Éä¡£ A£®É¢ÁÐ B£®·¶Î§ C£®Áбí D£®¸´ºÏ 12¡¢¿ÉÒÔʹÓ㨠£©Î±ÁÐÀ´·ÃÎÊÐòÁС£

A£®CURRVALºÍNEXTVAL B£®NEXTVALºÍPREVAL C£®CACHEºÍNOCACHE D£®MAXVALUEºÍMINVALUE

13¡¢´øÓдíÎóµÄÊÓͼ¿ÉʹÓ㨠£©Ñ¡ÏîÀ´´´½¨¡£

A£®FORCE

B£®WITH CHECK OPTION C£®CREATE VIEW WITH ERROR D£®CREATE ERROR VIEW

14¡¢ÔÚÁª½ÓÊÓͼÖУ¬µ±£¨ £©Ê±£¬¸Ã»ù±í±»³ÆΪ¼ü±£Áô±í¡£ A£®»ù±íµÄÖ÷¼ü²»Êǽá¹û¼¯µÄÖ÷¼ü B£®»ù±íµÄÖ÷¼üÊǽá¹û¼¯µÄÖ÷¼ü C£®»ù±íµÄÖ÷¼üÊǽá¹û¼¯µÄÍâ¼ü D£®»ù±íµÄÖ÷¼ü²»Êǽá¹û¼¯µÄÍâ¼ü

15¡¢ÔÚÁеÄÈ¡ÖµÖظ´ÂʱȽϸߵÄÁÐÉÏ£¬Êʺϴ´½¨£¨ £©Ë÷Òý¡£ A£®±ê×¼ B£®Î¨Ò» C£®·ÖÇø D£®Î»Í¼ 16¡¢ÒªÒÔ×ÔÉíµÄģʽ´´½¨Ë½ÓÐͬÒå´Ê£¬Óû§±ØÐëÓµÓУ¨ £©ÏµÍ³È¨ÏÞ

A£®CREATE PRIVATE SYNONYM B£®CREATE PUBLIC SYNONYM C£®CREATE SYNONYM D£®CREATE ANY SYNONYM

17¡¢PL/SQL¿éÖв»ÄÜÖ±½ÓʹÓõÄSQLÃüÁîÊÇ£¨ £©¡£ A£®SELECT B£®INSERT C£®UPDATE D£®DROP 18¡¢ÒÔÁã×÷³ýÊýʱ»áÒý·¢£¨ £©Òì³£¡£

A£®VALUE_ERROR B£®ZERO_DIVIDE

C£®STORAGE_ERROR D£®SELF_IS_NULL 19¡¢Òª¸üÐÂÓαê½á¹û¼¯Öеĵ±Ç°ÐУ¬Ó¦Ê¹Ó㨠£©×Ӿ䡣 A£®WHERE CURRENT OF B£®FOR UPDATE C£®FOR DELETE D£®FOR MODIFY 20¡¢ÓÃÓÚ´¦ÀíµÃµ½µ¥Ðвéѯ½á¹ûµÄÓαêΪ£¨ £©¡£ A£®Ñ­»·Óαê B£®ÒþʽÓαê C£®REFÓαê D£®ÏÔʽÓαê 21¡¢¹«ÓõÄ×Ó³ÌÐòºÍ³£Á¿ÔÚ£¨ £©ÖÐÉùÃ÷¡£ A£®¹ý³Ì B£®Óαê C£®°ü¹æ·¶ D£®°üÖ÷Ìå

22¡¢Êý¾Ý×ÖµäÊÓͼ£¨ £©°üº¬´æ´¢¹ý³ÌµÄ´úÂëÎı¾ A£®USER_OBJECTS B£®USER_TEXT C£®USER_SOURCE D£®USER_DESC 23¡¢ÒÔϲ»ÊôÓÚÃüÃûµÄPL/SQL¿éµÄÊÇ£¨ £©¡£ A£®³ÌÐò°ü B£®¹ý³Ì C£®Óαê D£®º¯Êý

24¡¢£¨ £©°üÓÃÓÚÏÔʾPL/SQL¿éºÍ´æ´¢¹ý³ÌÖеĵ÷ÊÔÐÅÏ¢¡£ A£®DBMS_OUTPUT B£®DBMS_STANDARD C£®DBMS_INPUT D£®DBMS_SESSION

25¡¢OracleµÄÄÚÖóÌÐò°üÓÉ£¨ £©Óû§ËùÓС£

A£®SYS B£®SYSTEM C£®SCOTT D£®PUBLIC

26¡¢£¨ £©´¥·¢Æ÷ÔÊÐí´¥·¢²Ù×÷ÖеÄÓï¾ä·ÃÎÊÐеÄÁÐÖµ¡£ A£®Ðм¶ B£®Óï¾ä¼¶ C£®Ä£Ê½ D£®Êý¾Ý¿â¼¶

27¡¢Ôڷǹ鵵ÈÕÖ¾·½Ê½Ï²Ù×÷µÄÊý¾Ý¿â½ûÓÃÁË£¨ £©¡£A£®¹éµµÈÕÖ¾ B£®Áª»úÈÕÖ¾ C£®ÈÕ־дÈë³ÌÐò D£®ÈÕÖ¾Îļþ

28¡¢ÒÔÏÂÄÄÖÖ±¸·Ý·½Ê½ÐèÒªÔÚÍêÈ«¹Ø±ÕÊý¾Ý¿â½øÐУ¨A£®Î޹鵵ÈÕ־ģʽϵÄÊý¾Ý¿â±¸·Ý B£®¹éµµÈÕ־ģʽϵÄÊý¾Ý¿â±¸·Ý C£®Ê¹Óõ¼³öʵÓóÌÐò½øÐÐÂß¼­±¸·Ý D£®ÒÔÉ϶¼²»¶Ô

29¡¢£¨ £©·½Ê½µÄµ¼³ö»á´ÓÖ¸¶¨µÄ±íÖе¼³öËùÓÐÊý¾Ý¡£A£®·ÖÇø B£®±í C£®È«²¿Êý¾Ý¿â D£®±í¿Õ¼ä

30¡¢£¨ £©²ÎÊýÓÃÓÚÈ·¶¨ÊÇ·ñÒªµ¼ÈëÕû¸öµ¼³öÎļþ¡£ A£®CONSTRAINTS B£®TABLES C£®FULL D£®FILE Ò»¡¢ ¼òÊöOracleµÄÄÚ´æ½á¹¹?

¡£ £©