网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）
A
DBMS_SERVER_ALERT
B
DBMS_ADVISOR
C
DBMS_RESOURCE_MANAGER
D
DBMS_REPAIR
参考答案
参考解析
解析：
暂无解析
更多 “单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）A DBMS_SERVER_ALERTB DBMS_ADVISORC DBMS_RESOURCE_MANAGERD DBMS_REPAIR” 相关考题
考题
If you()in taking exercise, you're more likely to have a long and energetic life.
A、insistB、persist
考题
Hello, David! I haven't heard from you for a long time. How have you been recently?()A. That's okB. Long time no seeC. Not bad, thank you
考题
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly.You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）A.AB.BC.CD.D
考题
－ Are you going on holiday for a long time? － _________
A、It was a long time.B、Two weeks ago.C、No. Only a couple of days.D、Not long time ago.
考题
Are you going on holiday for a long time?（）AIt was a long time.BTwo weeks ago.CNo. Only a couple of days.DNot long time ago.
考题
A:Hello, David! I haven't heard from you for a long time. How have you been recently? B:（）A、That's okB、Long time no seeC、Not bad, thank you
考题
In which scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
In which scenario will you create a hash cluster？（）A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables
考题
You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（） A、SQL Access AdvisorB、 Memory AdvisorC、SQL Tuning AdvisorD、 Segment Advisor
考题
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A、 REBUILDB、 CASCADEC、 TRUNCATED、 ROW MOVEMENTE、 SHRINK SPACE COMPACTF、 SHRINK SPACE CASCADE
考题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
考题
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.
考题
单选题--Would you mind answering some questions on education?--_______.A
Yes, it's worth the time.B
Yes, with great pleasure.C
No, as long as it doesn't take long.D
No, I'm afraid I can't make it.
考题
单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）A
DBMS_SERVER_ALERTB
DBMS_ADVISORC
DBMS_RESOURCE_MANAGERD
DBMS_REPAIR
考题
单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）A
Java poolB
Large poolC
Shared poolD
Streams poolE
Library cacheF
Redo log bufferG
Data dictionary cacheH
Database buffer cache
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A
You must configure OMF in your database.B
You must enable block change tracking feature in your database.C
You must enable ROW MOVEMENT feature on the ORDERS table.D
You must use the Flashback Version Query before using the Flashback Table feature.
考题
单选题In which scenario will you create a hash cluster？（）A
when you want the data to be returned automatically in chronological orderB
if the application uses queries joining tables only occasionallyC
if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD
if the full table scan is executed often on only one of the clustered tables
考题
多选题A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）AUsing a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.BUsing a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.CUsing a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.DConverting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnEUsing a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.FUsing a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
考题
单选题You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）A
SQL Access AdvisorB
Memory AdvisorC
SQL Tuning AdvisorD
Segment Advisor
考题
单选题You manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）A
sys.dm fts index populationB
sys.dm exec query statsC
sys. dm db index usage statsD
sys.dm db index physical stats
考题
单选题One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）A
execute the command， ALTER SESSION KILL ..， to kill the blocking sessionB
execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC
execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD
execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE
execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）A
Monitor thealert.logfileB
Enable server-side SQL tracing for user sessionsC
Enable fine-grained auditing for the customer tableD
Enable Fine-Grained Access Control （FGAC） for the customer tableE
Write a database trigger on the customer table on the SELECT event
考题
单选题For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A
Set the CPU time per call in the users profile.B
Set the CPU time per session in the users profile.C
Set the CPU levels for the user’s group using Resource Manager.D
Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
考题
单选题In which scenario will you use the Flashback Transaction Query feature？（）A
when you want to restore an important table that is dropped from the Recycle BinB
when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC
when you want to restore a dropped user’s schemaD
when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）A
create a plan directive in the SYS_GROUPB
create the pending area for the consumer groupC
activate the provided SYSTEM_PLAN in Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter fileE
set the execution time limit for all users， except SYS and SYSTEM， in their profiles
考题
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A
set the CPU time per call in the users profileB
set the CPU time per session in the users profilesC
set the CPU levels for the users’ group using Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter file
热门标签
最新试卷
