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?()
第1题:
第2题:
第3题:
第4题:

第5题:
第6题:
Good Table Manners Manners play an important part in making a favorable impression at the dinner table. Here are some general rules: Napkin (餐巾) use The meal begins when the host unfolds his or her napkin. This is your signal to do the same, so place your napkin on your lap. Unfold it completely if it is a small napkin. Or in half, lengthwise (纵向地) ,if it is a large dinner napkin. If you need to leave the table during the meal, place your napkin on your chair as a signal to your server that you will be returning. Once the meal is over, place your napkin neatly on the table to the right of your dinner plate. Do not refold it. Use a napkin only for your mouth. Never use it for your nose, face or forehead. Use of utensils (餐具) Start with the knife, fork or spoon furthest from your plate, and work your way in, using one utensil for each course. If soup is served, remember to spoon away from yourself. This helps stop the drips. Do not put the entire soup spoon in your mouth. Instead, fill a soup spoon about 75 per cent with soup, and sip(啜饮)it from the side noiselessly. After finishing dinner, place the knife and fork parallel to one another across the plate with the knife blade facing inward toward the plate. Using your fingers Here's a list of finger foods: sandwiches, cookies, small fruits or berries with stems, French fries and potato chips, and hamburgers. Chew(咀嚼)with your mouth closed and don't make noise; don't talk with your mouth full. Bread must be broken with your hands. It is never cut with a knife. Don't pick something Out of your teeth. Instead, excuse yourself to the bathroom. If possible, try not to cough at the table. Do not put your elbows (肘) on the table. In France, it is essential to have both hands above the table at the same time. Do not put bones or anything else on the table. Things that are not eaten should be put on your plate. Where is the napkin normally placed during the meal?()
第7题:
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?()
第8题:
you prefer to talk to your friends at the table
you value your calls more than your friends
you are enjoying the company of your friends
you are polite and considerate of your friends
第9题:
You obtain the results retrieved from the public synonym HR created by the database administrator.
You obtain the results retrieved from the HR table that belongs to your schema.
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
第10题:
You must configure OMF in your database.
You must enable block change tracking feature in your database.
You must enable ROW MOVEMENT feature on the ORDERS table.
You must use the Flashback Version Query before using the Flashback Table feature.
第11题:
Using 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.
Using 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.
Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
Using 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.
Using 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.
第12题:
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
第13题:
第14题:
第15题:

第16题:
第17题:
第18题:
You issued the following statement in your SQL*Plus session: SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600; Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
第19题:
MERGE
SELECT …CROSS JOIN
INSERT ALL …SELECT
CREATE VIEW …CONSTRAINT
第20题:
Talking with your mouth full
Putting bones on your plate
Putting your elbows on the table
Chewing with your month open
第21题:
The knife
The fork
The spoon
The one farthest from the plate
第22题:
creating a table in your schema and you exceed your allocated space quota on the tablespace
executing a long query that involves a sort operation and the statement runs out of temporary space
loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
第23题:
you prefer to talk to your friends at the table.
you value your calls more than your friends.
you are enjoying the company of your friends.
you are polite and considerate of your friends.
第24题:
On your chair
On the table
On your lap
On your plate