• 052(十五)


    71、

    71.You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration
    Assistant (DBCA).
    Some of the requirements set for your database creation task are:
    1. Configure the database to operate in shared server mode. 
    2. Disable automatic maintenance tasks such as optimizer statistics collection. 
    3. Configure a naming method to help the remote user connect to the database instance. 
    4. Use Automatic Storage Management (ASM) for storing the database files. 
    5. Configure daily database backup to flash recovery area.  
    6. Configure Enterprise Manager Database Control to manage the database. 
    Which of these requirements can be met while creating the database? 
    A. 4 and 6 
    B. 2, 3, 4, and 6 
    C. 1, 2, 4, 5, and 6 
    D. 1, 2, 3, 4, 5, and 6
    Answer: C 
    View Code

    72、

    72.Examine the following output: 
    SQL> SELECT index_name,status 
    FROM dba_indexes 
    WHERE status='UNUSABLE'; 
    INDEX_NAME STATUS 
    EIND UNUSABLE 
    Which two statements about the above index are true? (Choose two.) 
    A. It is ignored by the query optimizer. 
    B. It is not used while the index is being rebuilt. 
    C. The index cannot be rebuilt, and has to be re-created. 
    D. The index is automatically rebuilt when used the next time. 
    Answer: AB
    View Code

    73、

    73.In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement. 
    What would you do to automate this configuration for the memory components with change in mode of working? 
    A. Set the SGA_TARGET initialization parameter to zero. 
    B. Set the PRE_PAGE_SGA initialization parameter to TRUE. 
    C. Set the MEMORY_MAX_TARGET initialization parameter to zero. 
    D. Set the SGA_TARGET initialization parameter to a nonzero value.
    Answer: D
    View Code

    74、

    74.You have executed this command to change the size of the database buffer cache: 
    SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; 
    System altered. 
    To verify the change in size, you executed this command: 
    SQL> SHOW PARAMETER DB_CACHE_SIZE 
    NAME TYPE VALUE 
    -----------   -----------   -----------db_cache_size big integer 4194304 
    Why is the value set to 4194304 and not to 2516582? 
    A. Because 4194304 is the granule size 
    B. Because 4194304 is the standard block size  
    C. Because 4194304 is the largest nonstandard block size defined in the database 
    D. Because 4194304 is the total size of data already available in the database buffer cache
    Answer: A
    View Code

    75、

    75.Identify two situations in which the block header grows in a data block. (Choose two.) 
    A. When row directories need more row entries 
    B. When there is row migration in the data block 
    C. When there is an increase in the PCTFREE value for the data block 
    D. When more transaction slots are required than are initially configured 
    Answer: AD
    View Code
  • 相关阅读:
    AJAX请求 $.post方法的使用
    通过jQuery Ajax使用FormData对象上传文件
    iframe跨域访问
    js编码解码
    ajax头像上传
    无边框窗体和用户控件以及权限
    只开启一个窗体和进程以及多线程的操作
    通过一个窗体操作另一个窗体
    流和打印控件用法
    listview和简单的记事本操作
  • 原文地址:https://www.cnblogs.com/huanhuanang/p/5347806.html
Copyright © 2020-2023  润新知