单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBSCDBA_SCHED

题目
单选题
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）
A

 DBA_SCHEDULER_JOB_RUN_DETAILS

B

 DBA_SCHEDULER_RUNNING_JOBS

C

 DBA_SCHEDULER_JOBS

D

 DBA_SCHEDULER_JOB_LOG

相似考题

1.Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()A. To find the tax percentage for each of the employees.B. To list the name, job id, and manager name for all the employees.C. To find the name, salary, and department name of employees who are not working with Smith.D. To find the number of employees working for the Administrative department and earning less then 4000.E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

2.You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

3.Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control

4.Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()A.to find the tax percentage for each of the employeesB.to list the name, job_id, and manager name for all the employeesC.to find the name, salary, and the department name of employees who are not working with SmithD.to find the number of employees working for the Administrative department and earning less than 4000E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A  DBA_SCHEDULER_JOB_RUN_DETAILSB  DBA_SCHEDULER_RUNNING_JOBSC  DBA”相关问题

  • 第1题：

    The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

    • A、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
    • B、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
    • C、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "/";
    • D、SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

    正确答案:A

  • 第2题：

    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

    • A、enable index monitoring and query the DBA_OBJECTS view
    • B、enable index monitoring and query the DBA_INDEXES view
    • C、enable index monitoring and query the V$OBJECT_USAGE view
    • D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

    正确答案:C

  • 第3题：

    Which two statements are correct regarding the Oracle Flashback Drop feature？ （）

    • A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
    • B、 You can flash back a dropped table provided row movement has been enabled on the table.
    • C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
    • D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
    • E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
    • F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

    正确答案:A,C

  • 第4题：

    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
    • C、 DBA_SCHEDULER_CURRENT_JOBS
    • D、 DBA_SCHEDULER_JOBS
    • E、 DBA_SCHEDULER_EXECUTING_JOBS

    正确答案:B,D

  • 第5题：

    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

    正确答案:B,D

  • 第6题：

    At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）

    • A、 DBA_PENDING_TRANSACTIONS
    • B、 DBA_AUDIT_STATEMENT
    • C、 V$FLASHBACK_DATABASE_STATS
    • D、 FLASHBACK_TRANSACTION_QUERY

    正确答案:D

  • 第7题：

    单选题
    At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
    A

     DBA_PENDING_TRANSACTIONS

    B

     DBA_AUDIT_STATEMENT

    C

     V$FLASHBACK_DATABASE_STATS

    D

     FLASHBACK_TRANSACTION_QUERY


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）
    A

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';

    B

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

    C

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;

    D

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）
    A

     Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

    B

     Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.

    C

     Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.

    D

     Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）
    A

     EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；

    B

     EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；

    C

     EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；

    D

     EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
    A

    RMAN only

    B

    Flashback Table only

    C

    Flashback Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
    A

     Query the V$FLASHBACK_DATABASE_LOG view.

    B

     Query the V$FLASHBACK_DATABASE_STAT view.

    C

     Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    D

     Query the V$RECOVERY_FILE_DEST view.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Which view will you use to view information regarding the jobs that are currently running in a database？（）

    • A、DBA_SCHEDULER_RUNNING_JOBS
    • B、DBA_SCHEDULER_JOB_RUN_DETAILS
    • C、DBA_SCHEDULER_JOBS
    • D、DBA_SCHEDULER_JOB_LOG

    正确答案:A

  • 第14题：

    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

    • A、Use the DESCRIBE command on the EMP_DEPT_VU view.
    • B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
    • C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
    • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
    • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
    • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

    正确答案:D

  • 第15题：

    You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

    • A、 DBA_SCHEDULER_JOB_RUN_DETAILS
    • B、 DBA_SCHEDULER_RUNNING_JOBS
    • C、 DBA_SCHEDULER_JOBS
    • D、 DBA_SCHEDULER_JOB_LOG

    正确答案:C

  • 第16题：

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

    • A、 Query the V$FLASHBACK_DATABASE_LOG view.
    • B、 Query the V$FLASHBACK_DATABASE_STAT view.
    • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • D、 Query the V$RECOVERY_FILE_DEST view.

    正确答案:B

  • 第17题：

    Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）

    • A、To find the tax percentage for each of the employees.
    • B、To list the name, job id, and manager name for all the employees.
    • C、To find the name, salary, and department name of employees who are not working with Smith.
    • D、To find the number of employees working for the Administrative department and earning less then 4000.
    • E、To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

    正确答案:A

  • 第18题：

    You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）

    • A、In Event Viewer， view the system log.
    • B、In Event Viewer， view the application log.
    • C、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.
    • D、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.
    • E、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.

    正确答案:A,B,D

  • 第19题：

    单选题
    The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）
    A

     V$LOG

    B

     V$LOGFILE

    C

     DBA_LOG_GROUPS

    D

     V$LOG_HISTORY


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    Which view will you use to view information regarding the jobs that are currently running in a database？（）
    A

    DBA_SCHEDULER_RUNNING_JOBS

    B

    DBA_SCHEDULER_JOB_RUN_DETAILS

    C

    DBA_SCHEDULER_JOBS

    D

    DBA_SCHEDULER_JOB_LOG


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）
    A

     DBA_SCHEDULER_JOB_RUN_DETAILS

    B

     DBA_SCHEDULER_RUNNING_JOBS

    C

     DBA_SCHEDULER_JOBS

    D

     DBA_SCHEDULER_JOB_LOG


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    Which version of a view would you use if you just want a quick， easy view within your XPage？（）
    A

    Data Table Control

    B

    View Control

    C

    Repeat Control

    D

    Filter by category View Control


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You 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;


    正确答案： A
    解析： 暂无解析

相关内容