网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?()
A
CYCLE
B
ITERATE
C
NO_REPEAT
D
REUSE
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?()A CYCLE B ITERATEC NO_REPEAT D REUSE” 相关考题
考题
Evaluate the following function code:Which statement is true regarding the above function? ()
A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
考题
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?()
A. V$VALID_NLS_VALUESB. NLS_VALID_VALUESC. NLS_VALUE_OPTIONSD. V$NLS_VALUE_OPTIONSE. V$NLS_VALID_VALUES
考题
WhichvalueisvalidfortheiterateparameterintheCREATE_TIMERbuilt-infunction?()
A.CYCLEB.ITERATEC.NO_REPEATD.REUSE
考题
Given an EL function foo, in namespace func, that requires a long as a parameter and returns a Map, which two are valid invocations of function foo?()A、 ${func(1)}B、 ${foo:func(4)}C、 ${func:foo(2)}D、 ${foo(5):func}E、 ${func:foo(“easy”)}F、 ${func:foo(“3”).name}
考题
Which three statements describe the functionality of the DO_KEY built-in?()A、It accepts both a built-in and a key name as argument. B、If no key trigger is defined, the specified built-in executes. C、Its parameter must be specified in upper case, enclosed in single quotation marks. D、It performs the same task as if you pressed the function key associated with the specified argument. E、It executes the key trigger that corresponds to the built-in specified as its parameter.
考题
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A、 0B、 1C、 NONED、 DEFAULT
考题
Which of the following are valid settings for the NLS_COMP parameter?()A、 ASCIIB、 ANSIC、 BINARYD、 MONOLINGUALE、 MULTILINGUAL
考题
Which datatype is returned by the FIND_MENU_ITEM built-in function?()A、number B、Boolean C、menuitem D、VARCHAR2
考题
What is the data type returned by the CREATE_TIMER built-in?()A、longB、timerC、numberD、varchar2
考题
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?()A、CYCLE B、ITERATEC、NO_REPEAT D、REUSE
考题
You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?()A、Design a trigger that verifies that the first names and surnames are not empty strings.B、Design a check constraint that verifies that the first names and surnames are not empty strings.C、Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.D、Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.E、Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.F、Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.
考题
多选题Which three statements describe the functionality of the DO_KEY built-in?()AIt accepts both a built-in and a key name as argument.BIf no key trigger is defined, the specified built-in executes.CIts parameter must be specified in upper case, enclosed in single quotation marks.DIt performs the same task as if you pressed the function key associated with the specified argument.EIt executes the key trigger that corresponds to the built-in specified as its parameter.
考题
多选题Which three values are valid parameters for the DO_KEY built-in?()AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
考题
单选题You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do?()A
Create DML triggers that query the inserted and deleted tables.B
Create a stored procedure that calls the LTRIM and RTRIM built-in functions.C
Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.D
Call the TRIM built-in function.
考题
多选题Which of the following are valid settings for the NLS_COMP parameter?()AASCIIBANSICBINARYDMONOLINGUALEMULTILINGUAL
考题
单选题What is the data type returned by the CREATE_TIMER built-in?()A
longB
timerC
numberD
varchar2
考题
单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A
number B
Boolean C
menuitem D
VARCHAR2
考题
多选题You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?()ADesign a trigger that verifies that the first names and surnames are not empty strings.BDesign a check constraint that verifies that the first names and surnames are not empty strings.CDesign a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.DDesign a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.EDesign a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.FDesign a trigger that ensures that the phone number cannot be changed from a valid format to a null value.
考题
单选题You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A
0B
1C
NONED
DEFAULT
考题
单选题Which value is valid for the iterate parameter in SET_TIMER built-in procedure? ()A
REUSE B
RECYCLE C
NO_CHANGE D
OCCURRENCE
考题
单选题Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()A
PLSQL_BLOCKB
JAVA_STORED_PROCEDUREC
STORED_PROCEDURED
EXECUTABLEE
None of the above are invalid settings.
考题
单选题Evaluate the following function code: CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE RELIES_ON (EMPLOYEES) IS avgsal NUMBER(6); BEGIN SELECT AVG(SALARY)INTO avgsal FROM EMPLOYEES WHERE DEPARTMENT_ID = dept_id; RETURN avgsal; END get_dept_avg; Which statement is true regarding the above function?()A
The cached result becomes invalid when any structural change is done to the EMPLOYEES table. B
If the function execution results in an unhandled exception,the exception result is also stored in the cache.C
Each time the function is invoked in a different session,the current result in the result cache gets overwritten.D
If the function is invoked with a different parameter value,the existing result in the result cache gets overwritten by the latest value.
考题
单选题Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?()A
V$VALID_NLS_VALUESB
NLS_VALID_VALUESC
NLS_VALUE_OPTIONSD
V$NLS_VALUE_OPTIONSE
V$NLS_VALID_VALUES
考题
多选题Given an EL function foo, in namespace func, that requires a long as a parameter and returns a Map,which two are valid invocations of function foo?()A${func(1)}B${foo:func(4)}C${func:foo(2)}D${foo(5):func}E${func:foo(easy)}F${func:foo(3).name}
考题
单选题Given an EL function foo, in namespace func, that requires a long as a parameter and returns a Map, which two are valid invocations of function foo?()A
${func(1)}B
${foo:func(4)}C
${func:foo(2)}D
${foo(5):func}E
${func:foo(“easy”)}F
${func:foo(“3”).name}
考题
单选题Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?()A
V$VALID_NLS_VALUESB
NLS_VALID_VALUESC
NLS_VALUE_OPTIONSD
V$NLS_VALUE_OPTIONSE
V$NLS_VALID_VALUES
热门标签
最新试卷