Oracle认证考试
You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）A、Extents would be managed by the freelists.B、The segment would be managed by bitmaps.C、The segment would be managed by the freelists.D
题目
You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）
- A、Extents would be managed by the freelists.
- B、The segment would be managed by bitmaps.
- C、The segment would be managed by the freelists.
- D、Free space would be managed by the data dictionary.
相似问题和答案
第1题：
Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）
A.
B.
C.
D.
E.
第2题：
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？（）
- 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.
正确答案:B
第3题：
What quantities of the specified item can you regularly deliver ()short notice?
A、at
B、on
C、in
D、for
第4题：
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 Bin
- B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
- C、when you want to restore a dropped user’s schema
- D、 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
正确答案:B
第5题：
Which three route filtering statements are true?（）
- A、After the router ospf 10 and passive - interface s0/0 commands have been issued , the s0/0 interface will not send any OSPF updates, but will receive routing updates on that interface
- B、When you use the passive - interface command with RIPv2, multicasts are sent out the specified interface
- C、After the router rip and passive -interface s0/0 commands have been issued, the s0/0 interface will not send any RIP updates, but will receive routing updates on that interface
- D、When you use the passive - interface command with EIGRP, hel lo messages are not sent out the specified interface
- E、After the router eigrp 10 and passive - interface s0/0 commands have been issued, the s0/0 interface will not send any EIGRP updates, but will receive routing updates on that interface
- F、When you use the passive - interface command with OSPF, hello messages are not sent out the specified interface
正确答案:C,D,F
第6题：
Which two of these are differences between traffic policing and traffic shaping？（）
- A、with traffic shaping，a router stores excess traffic in packet buffers until bandwidth is available again
- B、with policing you can tune the buffer usage for traffic exceeding the specified CIR
- C、with shaping you can tune the buffer usage for traffic exceeding the specified CIR
- D、shaping should only be applied for ingress traffic，policing only for egress
- E、policing uses a token bucket algorithm，shaping uses an SPD algorithm
正确答案:A,C
第7题：
In the Expression Editor panel of CRS Script Editor, why would you use the Java tab? （）
- A、to execute a specified method of a Java class
- B、to reference a variable or invoke a method of a custom Java Object
- C、to pass variables between two different workflows
- D、to create an object for the purpose of executing methods on a remote computer
- E、to get a reference to the Contact and Session states
- F、to allow for arguments to be passed to a specified method
正确答案:A,B,E
第8题：
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?（）
A. Only one channel is allocated and the backup is created in the flash recovery area
B. Only one channel is allocated and the backup is created in the destination specified for channel
C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
第9题：
Which three statements describe the functionality of the DO_KEY built-in?（）
- A、It accepts both a built-in and a key name as argument.
- B、If no key trigger is defined, the specified built-in executes.
- C、Its parameter must be specified in upper case, enclosed in single quotation marks.
- D、It performs the same task as if you pressed the function key associated with the specified argument.
- E、It executes the key trigger that corresponds to the built-in specified as its parameter.
正确答案:B,D,E
第10题：
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.
正确答案:B