Have&8194;you&8194;ever&8194;traveled&8194;on&8194;____&8194;train？&8194;
A. &8194;the&8194;
B. &8194;a&8194;’&8194;
C. &8194;an&8194;
D. &8194;/
查看答案
相关试题
换一换
Have&8194;you&8194;ever&8194;traveled&8194;on&8194;____&8194;train？&8194;
A.&8194;the&8194; B.&8194;a&8194;’&8194; C.&8194;an&8194; D.&8194;/
答案
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
A. Increase the value of the FAST_START_MTTR_TARGET initialization parameter. B. Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter. C. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter. D. Increase the value of the SGA_TARGET initialization parameter.
答案
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
A. Increase the value of the FAST_START_MTTR_TARGET initialization parameter. B. Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter. C. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter. D. Increase the value of the SGA_TARGET initialization parameter.
答案
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
A.add data files to the tablespace B.identify the segments that you should shrink C.modify the storage parameters for the tablespace D.automatically shrink the segments with unused space E.check the alerts generated for the tablespace that is running low on space
答案
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
A. A primary key must have been created. B. A mapping table must have been created. C. An overflow tablespace must have been specified. D. The PCTTHRESHOLD option must have been specified.
答案
You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
A.create baseline metrics for today’s performance B.write the current database metrics to a database table and create a trigger to compare with future database statistics C.write the current database metrics to a flat file and create an operating script to compare with future database statistics D.write the current database metrics to a database table and create a procedure to compare with future database statistics E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
答案
You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
A.create baseline metrics for today’s performance B.write the current database metrics to a database table and create a trigger to compare with future database statistics C.write the current database metrics to a flat file and create an operating script to compare with future database statistics D.write the current database metrics to a database table and create a procedure to compare with future database statistics E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
答案
You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
A.Segment Advisor B.SQL Tuning Advisor C.SQL Access Advisor D.Segment Resource Estimation E.Automatic Database Diagnostic Monitor (ADDM)
答案
You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
A.Segment Advisor B.SQL Tuning Advisor C.SQL Access Advisor D.Segment Resource Estimation E.utomatic Database Diagnostic Monitor (ADDM)
答案
As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）
A. Shut down the database B. Clear the online redo log C. Back up the database D. Checkpoint the database E. Call Oracle support
答案
热门试题
You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）
While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?（）
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）
Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
Which two roles or privileges must you have to export tables owned by another user？（）
Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）
You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）
You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）
You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
使用微信扫一扫登录
