In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?()
A.VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG
A.VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG
第1题
A.Donothing.
B.Restartthedatabase.
C.Performrecoveryonthedatabase.
D.Restorethealertlogfromthelastbackup.
第2题
YouareworkingonaninstancestartedusingtheSPFILE.YouwanttomovetheFlashRecoveryAreaofyourdatabasetoanewlocation.YouwanttheFlashbacklogfilestobestoredinthenewlocation.Givenbeloware
thestepstoaccomplishthetaskinrandomorder:
1.Shutdowntheinstance.
2.ChangethevalueoftheDB_RECOVERY_FILE_DESTinitializationparametertoanewvalue.
3.ExecutetheALTERDATABASEFLASHBACKOFFcommand.
4.Startuptheinstanceandmountthedatabase.
5.ExecutetheALTERDATABASEFLASHBACKONcommand.
6.Openthedatabase.
Selectthecorrectorderinwhichthesetasksneedtobeperformed.()
第3题
fileswithunstructureddata,availableinanylocationonthehostmachinefromanapplication.Youwanttorestrictthedatabaseuserstoaccessfilesinaspecificlocationonthehostmachine.Whatcoulddotoachievethis?()
A.ModifythevaluefortheUTL_FILE_DIRparameterintheparameterfile
B.Grantreadandwriteprivilegeontheoperatingsystempathtothedatabaseusers
C.ModifythevaluefortheLDAP_DIRECTORY_ACCESSparameterintheparameterfile
D.ModifythevalueforthePLSQL_NATIVE_LIBRARY_DIRparameterintheparameterfile
E.Createadirectoryobjectreferringtotheoperatingsystempath,andgrantreadandwriteprivilegeonthedirectoryobjecttothedatabaseusers
第4题
A.Bob has max_user_connections set to zero, which blocks all his connections
B.Joe has exceeded the max_user_connections global limit
C.All users are blocked because max_user_connections is accumulated over the host account information
D.Kay is already connected elsewhere and attempting to log in again
E.Connect_timeout is too small to allow a connection to occur
第5题
A. The client and server have different NLS_LANGUAGE settings.
B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
C. The client and server are in different time zones.
D. The client requests automatic data conversion.
E. The AUTO_CONVERT initialization parameter is set to TRUE.
第6题
Thewarninglevelthresholdvalueforatablespace,DATA1,issetto60%andthecriticallevelthresholdvalueissetto80%.Thetablespace,DATA1,isinfrequentlyusedandisnotapartoftheproductionenvironment.Youissuedthefollowingcommand:
SQL>EXECUTE
DBMS_SERVER_ALERT.SET_THRESHOLD
(dbms_server_alert.tablespace_pct_full,
dbms_server_alert.operator_ge,80,
dbms_server_alert.operator_ge,90,
1,1,NULL,
dbms_server_alert.object_type_tablespace,’DATA’);
Whatwillbetheresultofthecommand?()
第7题
tactivityistakingplaceinthedatabase,andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces,youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged?()
A.LOG_BUFFER
B.DB_CACHE_SIZE
C.JAVA_POOL_SIZE
D.LARGE_POOL_SIZE
E.SHARED_POOL_SIZE
F.STREAMS_POOL_SIZE
第8题
A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default.
第9题
ER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? ()
A. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);
C. CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;
D. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
第10题
ethevalueoftheLOG_BUFFERinitializationparameter:ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH;Whatwouldbetheoutcomeofthiscommand()
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds,butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea(SGA)
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!