单选题Where is the run date for an ‘at’job located?（）A Within the job environment set upB Within the user data of the at jobC In the file name preceeded with a useridD In a special file used by the cron daemon

题目
单选题
Where is the run date for an ‘at’job located?（）
A

Within the job environment set up

B

Within the user data of the at job

C

In the file name preceeded with a userid

D

In a special file used by the cron daemon

相似考题

1.The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

2.Where is the run date for an ‘at’ job located?()A.Within the job environment set upB.Within the user data of the at jobC.In the file name preceeded with a useridD.In a special file used by the cron daemon

3.New Zealand is the first country in the world to get the new day because（）Ait is just east of the International Date LineBit is just west of the International Date LineCit is located halfway between the equator and the South PoleDit is located in the Southern Pacific Ocean

4.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?()A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEB. The job will only be disabled if the value of the AUTO_DROP attribute is FALSEC. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSED. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUEE. The STATE column of the job table will be set to COMPLETED for the job

更多“Where is the run date for an ‘at’job located?（）”相关问题

  • 第1题：

    While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）

    • A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
    • B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
    • C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
    • D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.

    正确答案:A

  • 第2题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）

    • A、Select * From Emp 
    • B、Select * From Emp Where EmpNO Like '%%' 
    • C、Select * From Emp Where Name = '%%' 
    • D、Select * From Emp Where Name Like '%%'

    正确答案:A,B,D

  • 第3题：

    日期型变量rq已经被赋值，要在数据表users中查询在rq表示的日期值之后注册的用户，下面SQL语句正确的是（）。

    • A、str=<"Select * From users Where reg_date># rq #
    • B、str=<"Select * From users Where reg_date>#" & rq & "#"
    • C、str=<"Select * From users Where reg_date>" & "#" & rq & "#"
    • D、str=<"Select * From users Where reg_date>" & # rq #

    正确答案:B,C

  • 第4题：

    When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）

    • A、The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
    • B、The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
    • C、The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
    • D、All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE
    • E、The STATE column of the job table will be set to COMPLETED for the job

    正确答案:A,B,E

  • 第5题：

    You are the network administrator for your company. All network servers run Windows Server 2003. A member server named Server1 hosts several hundred folders, which are located on multiple volumes on the server. A backup job on Server1 is configured to run a normal backup of the folders every Saturday at 1:00 A.M. On Wednesday morning, you discover that you need to install a new application on Server1 before the close of business that day. You need to back up all folders on Server1 as quickly as possible so you can install the new application. What should you do? （）

    • A、Create a new backup job that specifies the folders and runs once only.
    • B、Run the existing backup job.
    • C、Enable Volume Shadow Copy for the volumes that contain the folders.
    • D、Create an Automated System Recovery (ASR) set.

    正确答案:B

  • 第6题：

    单选题
    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
    A

    SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

    B

    SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

    C

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

    D

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


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

  • 第7题：

    单选题
    You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do？（）
    A

    Create a job schedule that runs every Sunday.Assign weekly tasks to this schedule.Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.

    B

    Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month， execute the code.

    C

    Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month， execute the jobs.

    D

    Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month


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

  • 第8题：

    单选题
    New Zealand is the first country in the world to get the new day because（）
    A

    it is just east of the International Date Line

    B

    it is just west of the International Date Line

    C

    it is located halfway between the equator and the South Pole

    D

    it is located in the Southern Pacific Ocean


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

  • 第9题：

    单选题
    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
    A

    SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

    B

    SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

    C

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

    D

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


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

  • 第10题：

    单选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）
    A

    UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee _id IN (103,115);

    B

    UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';

    C

    UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);

    D

    UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';

    E

    UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);


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

  • 第11题：

    单选题
    You are the network administrator for TestKing. You manage a Windows Server 2003 computer named TestKing4 that functions as an application server. TestKing4 will be used for development during the next 30 days. You need to back up all data on TestKing4 every day for the next 30 days. You need to automate the backups of TestKing4 to meet these business requirements. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）
    A

    Create a scheduled backup job as a normal backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.

    B

    Create a scheduled backup job as a daily backup. Set the start date of the job for today, and set the end date for 30 days from today.

    C

    Create a scheduled backup job as a copy backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.

    D

    Create a scheduled backup job as a normal backup. Set the start date of the job for today, and set the end date for 30 days from today.


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

  • 第12题：

    单选题
    You are the network administrator for your company. All network servers run Windows Server 2003. All client computers run Windows XP Professional. A member server named Server1 is located at a branch office that does not permit the use of Remote Desktop Protocol. Another administrator uses the Backup utility to create a scheduled backup job on Server1. The backup job performs a normal backup of an application server. The application server is removed from the network. You need to use a client computer to remove the backup job from Server1. You cannot travel to the branch office. What should you do? （）
    A

    Use the RUNAS feature to run the at /delete command as the Server1/Administrator account.

    B

    Log on by using your Administrator account and run the ntbackup /D command.

    C

    Log on by using your Administrator account and run the schtasks /delete command.

    D

    Use the RUNAS feature to run the taskkill command as the Server1/Administrator account.


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

  • 第13题：

    New Zealand is the first country in the world to get the new day because（）

    • A、it is just east of the International Date Line
    • B、it is just west of the International Date Line
    • C、it is located halfway between the equator and the South Pole
    • D、it is located in the Southern Pacific Ocean

    正确答案:B

  • 第14题：

    数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。查询出职位不为“办事员”的雇员信息是（）

    • A、Select *From Emp Where Job>="办事员"
    • B、Select* From Emp Where Job==’办事员’
    • C、Select* From Emp Where Job<>’办事员’
    • D、Select* From Emp Where Job!=’办事员’

    正确答案:C,D

  • 第15题：

    Where is the run date for an ’at’ job located？（）

    • A、Within the job environment set up
    • B、Within the user data of the at job
    • C、In the file name preceeded with a userid
    • D、In a special file used by the cron daemon

    正确答案:A

  • 第16题：

    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 

    正确答案:C

  • 第17题：

    单选题
    You are the network administrator for All network servers run Windows Server 2003. A member server named TESTKING1 hosts several hundred folders, which reside in various locations on the server. TESTKING1 is configured to run a normal backup of the folder every Saturday at 1:00 A.M. You discover that users edit the contents of the folders on Saturday and Sunday. You need to use the Backup utility to reschedule the backup job so that it runs every Monday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve this goal by using the minimum amount of administrative effort. What should you do?（）
    A

    Specify Monday as the start date of the job.

    B

    Reconfigure the job schedule to run the backup every Monday at 1:00 a.m.

    C

    Add an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.

    D

    Use the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.


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

  • 第18题：

    填空题
    Where is the hotel located on the island of Oahu?On ____.

    正确答案： Waikiki Beach
    解析：
    细节题。定位到文章第一句“Location: On Waikiki Beach facing the ocean on one of the main beaches on the island of Oahu”，位置:威基基海滩，面朝大海在欧胡岛的海滩上，由此可知答案为Waikiki Beach。

  • 第19题：

    单选题
    While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）
    A

     Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.

    B

     Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.

    C

     Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.

    D

     Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.


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

  • 第20题：

    单选题
    William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（）
    A

     Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.

    B

     Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.

    C

     Detailed information regarding each run of each job in the class will be written in the job log， and every operation  performed on the job class will be logged.

    D

     Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.


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

  • 第21题：

    单选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）
    A

    UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee_id IN (103,115);

    B

    UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';

    C

    UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);

    D

    UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';

    E

    UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);


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

  • 第22题：

    单选题
    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 


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

  • 第23题：

    单选题
    Where is the run date for an ‘at’ job located?（）
    A

    Within the job environment set up

    B

    Within the user data of the at job

    C

    In the file name preceeded with a userid

    D

    In a special file used by the cron daemon


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

  • 第24题：

    单选题
    You are the network administrator for your company. All network servers run Windows Server 2003. All client computers run Windows XP Professional. A member server named Server1 is located at a branch office that does not permit the use of Remote Desktop Protocol. Another administrator uses the Backup utility to create a scheduled backup job on Server1. The backup job performs a normal backup of an application server. The application server is removed from the network. You need to use a client computer to remove the backup job from Server1. You cannot travel to the branch office. What should you do?（）
    A

    Use the RUNAS feature to run the at /delete command as the Server1/Administrator account.

    B

    Log on by using your Administrator account and run the ntbackup /D command.

    C

    Log on by using your Administrator account and run the schtasks /delete command.

    D

    Use the RUNAS feature to run the taskkill command as the Server1/Administrator account.


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

相关内容