Automatic data conversion will occur if which of the following happens？（）A、 The client and server have different NLS_LANGUAGE settingsB、 The client and server character sets are not the same，and the database character set is not a strict superset of the c

题目

Automatic data conversion will occur if which of the following happens？（）

  • A、 The client and server have different NLS_LANGUAGE settings
  • B、 The client and server character sets are not the same，and the database character set is not a strict superset of the client character set
  • C、 The client and server are in different time zones
  • D、 The client requests automatic data conversion
  • E、 The AUTO_CONVERT initialization parameter is set to TRUE
相似考题

1.在通信专业中，DSP的英文全称是（），“自适应的”通常翻译为英文是（）。A．Data Signal Pulse B．Digital Signal Processing C．Data Stream Property D．Digital Spectrum ProgrammingA．adaptive B．autonomous C．automatic D．active

2.Automatic data conversion will occur if which of the following happens?()A. The client and server have different NLS_LANGUAGE settings.B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.C. The client and server are in different time zones.D. The client requests automatic data conversion.E. The AUTO_CONVERT initialization parameter is set to TRUE.

3.Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

4.You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

更多“Automatic data conve”相关问题

  • 第1题：

    A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?（）

    A. The keep pool is not configured.

    B. Automatic Workarea Management is not configured.

    C. Automatic Shared Memory Management is not enabled.

    D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

    E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view


    参考答案：D

  • 第2题：

    You want the size of the tablespace to increase when it is full. Which option would you use？（）

    • A、use automatic extent allocation
    • B、disable threshold for the tablespace
    • C、use freelists to manage the free space
    • D、use automatic segment space management
    • E、create the tablespace as a bigfile tablespace
    • F、use the RESIZE clause while creating the tablespace
    • G、enable AUTOEXTEND for at least one of the data files in the tablespace

    正确答案:G

  • 第3题：

    英译中：Automatic data collection(ADC)


    正确答案: 自动数据采集

  • 第4题：

    Which three JUNOS software features allow for increased security on your network？（）

    • A、firewall filters
    • B、data encryption
    • C、routing protocol authentication
    • D、support for BGP path mtu discovery
    • E、automatic discovery for IPSEC neighbors

    正确答案:A,B,C

  • 第5题：

    A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）

    • A、The keep pool is not configured.
    • B、Automatic Workarea Management is not configured.
    • C、Automatic Shared Memory Management is not enabled.
    • D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
    • E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

    正确答案:D

  • 第6题：

    Which two are the prerequisites to enable Flashback Data Archive？（）

    • A、 Database must be running in archivelog mode.
    • B、 Automatic undo management must be enabled.
    • C、 Undo retention guarantee must be enabled.
    • D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.

    正确答案:B,D

  • 第7题：

    单选题
    You want the size of the tablespace to increase when it is full. Which option would you use？（）
    A

    use automatic extent allocation

    B

    disable threshold for the tablespace

    C

    use freelists to manage the free space

    D

    use automatic segment space management

    E

    create the tablespace as a bigfile tablespace

    F

    use the RESIZE clause while creating the tablespace

    G

    enable AUTOEXTEND for at least one of the data files in the tablespace


    正确答案： F
    解析： 暂无解析

  • 第8题：

    多选题
    Which two are the prerequisites to enable Flashback Data Archive？（）
    A

    Database must be running in archivelog mode.

    B

    Automatic undo management must be enabled.

    C

    Undo retention guarantee must be enabled.

    D

    The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.


    正确答案： B,D
    解析： 暂无解析

  • 第9题：

    单选题
    In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）
    A

    It collects data from SGA and compares it with a preserved snapshot.

    B

    It collects data from SGA, analyzes it, and provides a report.

    C

    It collects data from SGA and compares it with the latest snapshot.

    D

    It collects data from both SGA and PGA, analyzes it, and provides a report


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）
    A

    Enable Memory Access Mode, which reads performance data from SGA.

    B

    Use emergency monitoring to fetch data directly from SGA analysis.

    C

    Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

    D

    Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

    E

    Run ADDM in diagnostic mode.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）
    A

    Enable supplemental logging for the database.

    B

    Specify undo retention guarantee for the database

    C

    Create Flashback Data Archive in the tablespace where the tables are stored.

    D

    Create Flashback Data Archive and enable Flashback Data Archive for specific tables


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    ADC（automatic data collection）是（）
    A

    自动信息收集

    B

    自动数据采集

    C

    自动数据处理

    D

    自动信息控制


    正确答案： D
    解析： 暂无解析

  • 第13题：

    In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

    A. It collects data from SGA and compares it with a preserved snapshot.

    B. It collects data from SGA, analyzes it, and provides a report.

    C. It collects data from SGA and compares it with the latest snapshot.

    D. It collects data from both SGA and PGA, analyzes it, and provides a report


    参考答案：B

  • 第14题：

    英译中：Automatic Data Collection


    正确答案: 自动数据采集

  • 第15题：

    ADC（automatic data collection）是（）

    • A、自动信息收集
    • B、自动数据采集
    • C、自动数据处理
    • D、自动信息控制

    正确答案:B

  • 第16题：

    Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

    • A、Flash recovery area must be defined
    • B、Undo retention guarantee must be enabled.
    • C、Database must be running in archivelog mode.
    • D、Automatic undo management must be enabled.
    • E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

    正确答案:D,E

  • 第17题：

    What are three benefits of using ASM？（） 

    • A、 Ease of disk administration and maintenance
    • B、 Load balancing across physical disks
    • C、 Software RAID-1 data redundancy with double or triple mirrors
    • D、 Automatic recovery of failed disks

    正确答案:A,B,C

  • 第18题：

    名词解释题
    英译中：Automatic data collection(ADC)

    正确答案： 自动数据采集
    解析： 暂无解析

  • 第19题：

    名词解释题
    英译中：Automatic Data Collection

    正确答案： 自动数据采集
    解析： 暂无解析

  • 第20题：

    单选题
    Automatic data conversion will occur if which of the following happens？（）
    A

     The client and server have different NLS_LANGUAGE settings

    B

     The client and server character sets are not the same，and the database character set is not a strict superset of the client character set

    C

     The client and server are in different time zones

    D

     The client requests automatic data conversion

    E

     The AUTO_CONVERT initialization parameter is set to TRUE


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
    A

    The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

    B

    The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

    C

    The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.

    D

    The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)
    A

    Database must be running in archivelog mode.

    B

    Automatic undo management must be enabled.

    C

    Undo retention guarantee must be enabled.

    D

    The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).


    正确答案： C,D
    解析： 暂无解析

  • 第23题：

    单选题
    Automatic data conversion will occur if which of the following happens?（）
    A

    The client and server have different NLS_LANGUAGE settings.

    B

    The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.

    C

    The client and server are in different time zones.

    D

    The client requests automatic data conversion.

    E

    The AUTO_CONVERT initialization parameter is set to TRUE.


    正确答案： E
    解析： 暂无解析

相关内容