Which Scheduler view(s) can be queried...

多项选择题Which Scheduler view(s) can be queried to see which jobs are currently executing? （）

A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS DBA
C. DBA_SCHEDULER_CURRENT_JOBS
D. DBA_SCHEDULER_JOBS DBA
E. DBA_SCHEDULER_EXECUTING_JOBS

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Which statement is true regarding synonyms?（）

A.Synonyms can be created only for a table
B.Synonyms are used to reference only those tables that are owned by another user
C.A public synonym and a private synonym can exist with the same name for the same table
D.The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

点击查看答案

2.单项选择题Which of the following is not a valid calendaring syntax element?（）

A. FREQ
B. BYHOUR
C. RUNDATE
D. INTERVAL
E. BYMINUTE

点击查看答案

3.多项选择题Which two statements are true regarding the USING clause in table joins?（）

A.It can be used to join a maximum of three tables
B.It can be used to restrict the number of columns used in a NATURAL join
C.It can be used to access data from tables through equijoins as well as nonequijoins
D.It can be used to join tables that have columns with the same name and compatible data types

点击查看答案

4.多项选择题Which DBMS_SCHEDULER procedures can be used to enable a program?（）

A. ENABLE启用
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE设置属性
E. SET_ENABLED

点击查看答案

5.单项选择题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）

A. SET_JOB_ARGUMENT_VALUE
B. SET_JOB_VALUE_ANYDATA
C. SET_JOB_ANYDATA_VALUE
D. SET_SPECIAL_JOB_VALUE
E. SET_JOB_ANYTYPE_VALUE

点击查看答案

6.多项选择题You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

A.All data along with the table structure is deleted
B.The pending transaction in the session is committed
C.All indexes on the table will remain but they are invalidated
D.All views and synonyms will remain but they are invalidated
E.All data in the table are deleted but the table structure will remain

点击查看答案

7.单项选择题Within a resource-plan definition, what differentiates a top-level plan from a subplan?（）

A. A subplan has the PLAN_SUB parameter value set to SUB
B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition
C. There is no difference in the resource-plan definition
D. A subplan always has the CPU_MTH parameter value set to RATIO
E. The string TOP_LEVEL is appended to the name of top-level resource plans

点击查看答案

8.多项选择题Which two statements are true regarding working with dates?（）

A.The default internal storage of dates is in the numeric format
B.The default internal storage of dates is in the character format
C.The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century
D.The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

点击查看答案

9.单项选择题Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）

A.16
B.100
C.160
D.200
E.150

点击查看答案

10.单项选择题You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL> SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 >2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（）

A.an error because the ROUND function specified is invalid
B.an error because the WHERE condition specified is invalid
C.number of days since the promo started based on the current Chicago date and time
D.number of days since the promo started based on the current Singapore date and time

点击查看答案