网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 Scheduller 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 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” 相关考题
考题
以下说法错误的是( )A.SELECT max(sal),deptno,job FROM EMP group by sal;B.SELECT max(sal),deptno,job FROM EMP group by deptno;C.SELECT max(sal),deptno,job FROM EMP;D.SELECT max(sal),deptno,job FROM EMP group by 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.
考题
In which case would you use a FULL OUTER JOIN? ()
A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.
考题
Which of the following Scheduler elements encourage object reuse?()
A. Schedule objectsB. Program argumentsC. Job classesD. Job argumentsE. All of the above
考题
You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect－traffic all command?()
A. When you want all unauthenticated traffic to be redirectedB. When you want all clear text traffic to be redirected.C. When you want all authenticated traffic to be redirected.D. When you want all encrypted traffic to be redirected.
考题
You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?A．Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.B．Select the Auto Update Statistics check box.C．Run the database maintenance plan wizard, and accept the default settings.D．Rebuild the primary key as a nonclustered primary key.E．Clear the Auto Create Statistics check box.
考题
If you want ___________ you have to get the fund somewhere.A.that the job is done
B.the job done
C.to have done the job
D.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
考题
Which of the following Scheduler elements encourage object reuse？（）A、 Schedule objectsB、 Program argumentsC、 Job classesD、 Job argumentsE、 All of the above
考题
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
考题
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 a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）A、Schedule the full backups to run after the nightly index is rebuilt.B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.
考题
单选题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.
考题
单选题You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect-traffic all command?（）A
When you want all unauthenticated traffic to be redirectedB
When you want all clear text traffic to be redirected.C
When you want all authenticated traffic to be redirected.D
When you want all encrypted traffic to be redirected.
考题
问答题Practice 3 You have read the job advertisement below in a newspaper and you want to apply for the job. Write a letter of application to the manager of the company, Mr. Meed, giving all the necessary personal information. You should write approximately 100 words. Do not sign your own name at the end of your letter. Use“Wang Lin” instead. You do not need to write the address.
考题
问答题Practice 2 Read the job advertisement below from a newspaper and suppose you want to apply for the job. Write a letter of application, giving all the necessary personal information. You should write approximately 100 words. Do not sign your own name at the end of your letter. Use “Wang Lin” instead.
考题
单选题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 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?（）A
Use the at command to schedule a weekly job to back up the boot partition.B
Use the at command to schedule a weekly job to run the system file checker.C
Use Windows backup to schedule a backup of the System State Data.D
Use 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（）A
the XML scriptB
the PL/SQL scriptC
the DBMS_SCHEDULER packageD
Enterprise 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？（）A
You should remove the schedule for Wednesday from Job5. B
You should add a new Job5 schedule for Wednesday and disable it. C
You should delete the schedule for Wednesday. D
You should disable the schedule for Wednesday.
考题
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A
By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB
By enabling the Error Log because not using indexes is an errorC
By enabling the Slow Query Log and using the – log-queries-not-using-indexes optionD
By enabling the Error Log and using the – log-queries-not-using-indexes option
考题
单选题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 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
考题
单选题Whom should the application form be sent to if you want to apply for SAL FFP Membership?A
SAL FFP Club.B
The SAL ticket office.C
The SAL headquarters.D
SAL Customer Service Center.
热门标签
最新试卷
