单选题Where is the run date for an ‘at’ job located?（）AWithin the job environment set upBWithin the user data of the at jobCIn the file name preceeded with a useridDIn 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
参考解析
解析：
暂无解析
相关考题：
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;
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?() 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
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
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.
New Zealand is the first country in the world to get the new day because（）A、it is just east of the International Date LineB、it is just west of the International Date LineC、it is located halfway between the equator and the South PoleD、it is located in the Southern Pacific Ocean
数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）A、Select * From EmpB、Select * From Emp Where EmpNO Like '%%'C、Select * From Emp Where Name = '%%'D、Select * From Emp Where Name Like '%%'
数据库中有一张表名为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!=’办事员’
日期型变量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 #
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
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
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
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.
单选题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?（）ASpecify Monday as the start date of the job.BReconfigure the job schedule to run the backup every Monday at 1:00 a.m.CAdd an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.DUse the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.
单选题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? （）ASELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;BSELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;CSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;DSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
单选题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？（）ACreate 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.BCreate 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.CCreate 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.DCreate 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
单选题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.
单选题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
单选题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.
单选题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? （）ASELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;BSELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;CSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;DSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
单选题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?（）AUPDATE 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);BUPDATE 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';CUPDATE 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);DUPDATE 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';EUPDATE 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);
单选题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?（）AUPDATE 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);BUPDATE 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';CUPDATE 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);DUPDATE 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';EUPDATE 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);
单选题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?（）Aan error because the ROUND function specified is invalid Ban error because the WHERE condition specified is invalid Cnumber of days since the promo started based on the current Chicago date and time Dnumber of days since the promo started based on the current Singapore date and time
单选题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?（）ACreate 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.BCreate 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.CCreate 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.DCreate 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.
单选题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? （）AUse the RUNAS feature to run the at /delete command as the Server1/Administrator account.BLog on by using your Administrator account and run the ntbackup /D command.CLog on by using your Administrator account and run the schtasks /delete command.DUse the RUNAS feature to run the taskkill command as the Server1/Administrator account.
单选题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?（）AUse the RUNAS feature to run the at /delete command as the Server1/Administrator account.BLog on by using your Administrator account and run the ntbackup /D command.CLog on by using your Administrator account and run the schtasks /delete command.DUse the RUNAS feature to run the taskkill command as the Server1/Administrator account.