多选题Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects?()AIt readily responds to dynamic changes for concurr

题目
多选题
Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects?()
A

It readily responds to dynamic changes for concurrent access.

B

It improves performance and space utilization in a multiple-instance environment.

C

It requires fewer space related options then freelist managed structures.

D

It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which three features are benefits of using GRE tunnels in conjunction with IPsec for building site-to-site VPNs?()

  • A、allows dynamic routing over the tunnel
  • B、supports multi-protocol (non-IP) traffic over the tunnel
  • C、reduces IPsec headers overhead since tunnel mode is used
  • D、simplifies the ACL used in the crypto map
  • E、uses Virtual Tunnel Interface (VTI) to simplify the IPsec VPN configuration

正确答案:A,B,D

第2题:

Which two changes and their effect on the system can be tested by using the Database Replay feature?()

  • A、 multiplexing of the control file
  • B、 adding the redo log member to the database
  • C、 database and operating system upgrades
  • D、 changing the database storage to ASM-managed storage

正确答案:C,D

第3题:

Which of the following database objects is considered executable using SQL?()

A.View

B.Table

C.Routine

D.Package


参考答案:C

第4题:

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?()

  • A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
  • B、 executing a long query that involves a sort operation and the statement runs out of temporary space
  • C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
  • D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

正确答案:D

第5题:

Which three tasks can be performed using a duplicate database? ()(Choose three.)

  • A、Testing the backup and recovery procedures
  • B、Testing the upgrade of an Oracle database to a new release
  • C、Testing the effect of an application changes on database performance
  • D、Continuously updating archive log files from the target database to support failover

正确答案:A,B,C

第6题:

Which of the following database objects is considered executable using SQL?()

  • A、View
  • B、Table
  • C、Routine
  • D、Package

正确答案:C

第7题:

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this?()

  • A、run a procedure to check the tablespace space usage
  • B、define the warning threshold for the tablespace at 75% in Database Control
  • C、create a trigger to be executed when tablespace space usage reaches 75%
  • D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
  • E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

正确答案:B

第8题:

Which three are benefits of A virtualized data center solution over A typical implementation?()

  • A、simplified cabling
  • B、more efficient routing
  • C、fewer applications per server
  • D、more efficient power consumption
  • E、more control over each server
  • F、less rack space

正确答案:A,D,F

第9题:

Which two are characteristics of user-managed backup and recovery operations?()

  • A、Recovery is initiated using SQL*Plus.
  • B、Database files are backed up using SQL commands.
  • C、Database files are backed up with Recovery Manager.
  • D、Database files are restored using Recovery Manager.
  • E、Database files are backed up using operating system commands.

正确答案:A,B

第10题:

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects?()

  • A、It readily responds to dynamic changes for concurrent access. 
  • B、It improves performance and space utilization in a multiple-instance environment. 
  • C、It requires fewer space related options then freelist managed structures. 
  • D、It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

正确答案:A,C,D

更多相关问题