• 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
  • 相关阅读:
    nodejs/REPL环境命令行操作命令
    C++ Primer第五版学习笔记七 类简介(编译用到C++11特性,编译命令需要加-std=c++11参数,break结束while)
    C++ Primer第五版学习笔记六 控制流之if语句
    C++ Primer第五版学习笔记五 控制流之读取数量不定的输入数据
    C++ Primer第五版学习笔记四 控制流之while,for语句
    C++ Primer第五版学习笔记三 C++中的注释
    C++ Primer第五版学习笔记二 初识输入输出
    C++ Primer第五版学习笔记一 一个简单的C++程序
    QT学习笔记二 窗口和子部件
    QT学习笔记一 初识QT Creator 新建一个Dialog窗口
  • 原文地址:https://www.cnblogs.com/huanhuanang/p/5347806.html
Copyright © 2020-2023  润新知