A.物品库存管理
B.POS系统
C.物品信息采集
D.EDI系统
第1题
A.INDEX_STATS
B.DBA_INDEXES
C.DBA_IND_COLUMNS
D.V$OBJECT_USAGE
第2题
A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.
B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.
C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.
D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup,and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup
第3题
A. V$VALID_NLS_VALUES
B. NLS_VALID_VALUES
C. NLS_VALUE_OPTIONS
D. V$NLS_VALUE_OPTIONS
E. V$NLS_VALID_VALUES
第4题
A.ALTERSESSIONENABLERESUMABLE_TIMEOUT=5;
B.ALTERSYSTEMENABLERESUMABLE_TIMEOUT=5;
C.ALTERSESSIONENABLERESUMABLE_TIMEOUT=300;
D.ALTERSYSTEMENABLERESUMABLETIMEOUT=300;
第5题
A. USER_TAB_PRIVS_MADE
B. USER_TAB_PRIVS
C. USER_COL_PRIVS_MADE
D. USER_COL_PRIVS
第6题
A.Table_open_cache
B.Table_open_cache_instancs
C.Table_definition_cache
D.Tmp_table_size
E.Max_heap_table_size
F.Max_tmp_tables
第7题
A.spaceallocatedinthetablespace
B.spacerequiredforthebitmapindexonacolumnofthetable
C.spaceremaininginthetablespaceaftercreatingthetable
D.estimatedvalueofthePCTFREEstorageparameter
第8题
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupies by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第9题
CREATETABLEscott.dept
(deptnoNUMBER(3),
dnameVARCHAR2(15),
locVARCHAR2(15))
STORAGE(INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4);YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation,youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable?()
第10题
A. WHERE clause WHERE
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!