You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）A、Create both jobs by using events raised by the schedulerB、Create both jobs by using events raised by the applicationC、Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerD、Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
- A、Create both jobs by using events raised by the scheduler
- B、Create both jobs by using events raised by the application
- C、Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
- D、Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application
相关考题：
What are you recommended to answer the question tell me about yourself, if you are seeking for your first job?A.Speak much about how that job appeals to you and caused you to apply for it.B.Speak much about how your enthusiasm about an area has driven you to want that job.C.Speak much about how a book you’ve read or a person you’ve known motivated you to get that job.D.Speak much about how your past experiences made you decide to compete for that job.
Why do you want to leave your previous job?().A. I'm hoping to have a better position.B. I don't want to work at all.C. You won't understand it.
Before sending your resume to prospective employersor scheduling any interviews , you need to analyze the job market. Analyzing the job market involves determining actual jobopenings and gathering information about organizations for which you want to work.
If a job references a schedule that has been disabled, what will be the result?() A. The job will be automatically disabled.B. The job will never execute.C. The job will attempt to execute but will fail.D. The job will inherit the DEFAULT_SCHEDULE schedule.E. A schedule object cannot be disabled.
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
Why do you want a new job ______you've got such a good one already?A. thatB. whereC. whichD. when
If you want ___________ you have to get the fund somewhere.A.that the job is doneB.the job doneC.to have done the jobD.the job that is done
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）A、configure the database to run in ARCHIVELOG modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager （RMAN） commands after creating the databaseE、schedule the database backup using Database Configuration Assistant （DBCA） while creating the database
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’）；
If a job references a schedule that has been disabled， what will be the result？（） A、 The job will be automatically disabled.B、 The job will never execute.C、 The job will attempt to execute but will fail.D、 The job will inherit the DEFAULT_SCHEDULE schedule.E、 A schedule object cannot be disabled.
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）A、the XML scriptB、the PL/SQL scriptC、the DBMS_SCHEDULER packageD、Enterprise Manager to schedule the backup
Identify four uses of the Oracle Scheduler.（）A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
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_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A、 LOGGING_OFFB、 LOGGING_RUNSC、 LOGGING_FULLD、 LOGGING_NULL
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
单选题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.
单选题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
单选题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.
单选题You are the administrator of your company's network. You are preparing to deploy 20 new Windows 2000 Professional computers on your network. You want to be able to recover from disk failures and corrupt system files on the new computers. You want to configure the computers to automatically update their system configuration and emergency repair files on a scheduled bases. What should you do?（）AUse the at command to schedule a weekly job to back up the boot partition.BUse the at command to schedule a weekly job to run the system file checker.CUse Windows backup to schedule a backup of the System State Data.DUse Windows backup to schedule a backup of the system partition and the boot partition.
单选题You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）Athe XML scriptBthe PL/SQL scriptCthe DBMS_SCHEDULER packageDEnterprise Manager to schedule the backup
单选题You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A LOGGING_OFFB LOGGING_RUNSC LOGGING_FULLD LOGGING_NULL
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You must make sure that a job named Job4 doesn'；t run Wednesday. So what action should you perform to achieve this goal？（）AYou should remove the schedule for Wednesday from Job5. BYou should add a new Job5 schedule for Wednesday and disable it. CYou should delete the schedule for Wednesday. DYou should disable the schedule for Wednesday.
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
单选题You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）ACreate both jobs by using events raised by the schedulerBCreate both jobs by using events raised by the applicationCCreate a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerDCreate a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
单选题If a job references a schedule that has been disabled， what will be the result？（）A The job will be automatically disabled.B The job will never execute.C The job will attempt to execute but will fail.D The job will inherit the DEFAULT_SCHEDULE schedule.E A schedule object cannot be disabled.
单选题You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs？（）A Create both jobs by using events raised by the schedulerB Create both jobs by using events raised by the applicationC Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerD Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）AYou should create a job which is assigned to the Database Maintenance categoryBYou should create an Alert which will run another to delete the maintenance job.CYou should create a job. You schedule the job to run only once.DYou should create a job. The job uses the Automatically delete job option
单选题If you want a job of taking care of children, which ad will you answer?ALOST AND FOUNDBROOMMATESCFOR SALEDHELP WANTED