A. PLSQL_BLOCK PLSQL
B. EXECUTABLE
C. JAVA_STORED_PROCEDURE
D. STORED_PROCEDURE
E. EXTERNAL
您可能感兴趣的试卷
你可能感兴趣的试题
A. Schedule object
B. Program object
C. Job object
D. Resource plan
E. Resource consumer group
A. Update job log when a job completes
B. Spawn and remove job slaves
C. Write/read job info to/from memory cache
D. Query job table
E. Pass job information to job slaves
A. FREQ = MONTHLY; BYMONTHDAY = 31
B. FREQ = MONTHLY; BYMONTHDAY = -1
C. FREQ = DAILY; BYDAY = -1
D. FREQ = MONTHLY; BYDAY = 31
E. FREQ = DAILY; BYMONTHDAY = LAST_DAY
Consider the following code snippet:
If this code were executed, which of the following statements would be true?()
A. The priority of the lne_job1 job would be set to 1.
B. The lne_job1 job would be executed synchronously.
C. The lne_job1 job would run immediately in the user‟s current session.
D. The lne_job1 job would retain its current priority.
E. The job will immediately take priority over all running jobs.
A.It is executed first in the query execution
B.It must be the last clause in the SELECT statement
C.It cannot be used in a SELECT statement containing a HAVING clause
D.You cannot specify a column name followed by an expression in this clause
E.You can specify a combination of numeric positions and column names in this clause
A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME
A.A subquery that defines a view cannot include the GROUP BY clause
B.A view that is created with the subquery having the DISTINCT keyword can be updated
C.A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
D.A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D.PENDING
E. NULL
A.Subqueries can contain GROUP BY and ORDER BY clauses
B.Main query and subquery can get data from different tables
C.Main query and subquery must get data from the same tables
D.Subqueries can contain ORDER BY but not the GROUP BY clause
E.Only one column or expression can be compared between the main query and subquery
F. Multiple columns or expressions can be compared between the main query and subquery
A. SET_ATTRIBUTE_NULL
B. ALTER_JOB
C. ALTER_JOB_PARAMETERS
D. ALTER
E. SET_ATTRIBUTE
最新试题
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
Which three tasks can be performed using a duplicate database?()
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?()
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.()
Which two statements are true about a job chain?()