单选题Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）A V$VALID_NLS_VALUESB NLS_VALID_VALUESC NLS_VALUE_OPTIONSD V$NLS_VALUE_OPTIONSE V$NLS_VALID_VALUES

题目
单选题
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）
A

V$VALID_NLS_VALUES

B

NLS_VALID_VALUES

C

NLS_VALUE_OPTIONS

D

V$NLS_VALUE_OPTIONS

E

V$NLS_VALID_VALUES

相似考题

1.Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?()A. V$VALID_NLS_VALUESB. NLS_VALID_VALUESC. NLS_VALUE_OPTIONSD. V$NLS_VALUE_OPTIONSE. V$NLS_VALID_VALUES

2. Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）A、0B、1C、2D、3

3.You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP

4.Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3

更多“单选题Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）A V$VALID_NLS_VALUESB NLS_VALID_VALUESC NLS_VALUE_OPTIONSD V$NLS_VALUE_OPTIONSE V$NLS_VALID_VALUES”相关问题

  • 第1题：

    Which three values are valid parameters for the DO_KEY built-in?（）

    • A、ENTER 
    • B、GO_ITEM 
    • C、VALIDATE 
    • D、EXIT_FORM 
    • E、EXECUTE_QUERY

    正确答案:A,D,E

  • 第2题：

    Which view provides information on the backup status of the datafiles in the database？（）  

    • A、 V$BACKUP
    • B、 V$BACKUP_STATUS
    • C、 V$BACKUP_DATAFILE
    • D、 V$DATAFILE_BACKUP
    • E、 V$TABLESPCE_BACKUP

    正确答案:A

  • 第3题：

    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

    • A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
    • B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
    • C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
    • D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

    正确答案:A

  • 第4题：

    A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

    • A、granting SELECT privilege to SMITH on V$SESSION
    • B、granting SELECT privilege to SMITH on V_$SESSION
    • C、asking the user SMITH to run the catalog.sql script
    • D、granting SELECT privilege to SMITH on V$FIXED_TABLES
    • E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
    • F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

    正确答案:B,F

  • 第5题：

    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

    • A、 Create a backup of the database and recover all corrupted blocks found in the backup.
    • B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
    • C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
    • D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
    • E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

    正确答案:D

  • 第6题：

    单选题
    You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）
    A

     V$DATABASE

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$RECOVERY_FILE_DEST


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

  • 第7题：

    单选题
    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
    A

     Create a backup of the database and recover all corrupted blocks found in the backup.

    B

     Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

    C

     Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

    D

     Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

    E

     Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


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

  • 第8题：

    单选题
    Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）
    A

    0

    B

    1

    C

    2

    D

    3


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

  • 第9题：

    单选题
    Which view provides information on the backup status of the datafiles in the database？（）
    A

     V$BACKUP

    B

     V$BACKUP_STATUS

    C

     V$BACKUP_DATAFILE

    D

     V$DATAFILE_BACKUP

    E

     V$TABLESPCE_BACKUP


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

  • 第10题：

    单选题
    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
    A

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


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

  • 第11题：

    单选题
    A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）
    A

    When view V1 is created

    B

    Each time the REFRESH VIEW v1 statement is executed

    C

    Each time an SQL statement is executed against view V1

    D

    Only the first time an SQL statement is executed against view V1


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

  • 第12题：

    单选题
    You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）
    A

     V$SYSSTAT

    B

     V$SESSSTAT

    C

     V$RSRC_PLAN

    D

     V$RSRC_CONSUMER_GROUP


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

  • 第13题：

    Which statement regarding the contents of the V$PARAMETER view is true？（）

    • A、displays only the list of default values
    • B、displays only the list of all basic parameters
    • C、displays the currently in effect parameter values
    • D、displays only the list of all advanced parameters
    • E、displays the list of all the parameter files of a database

    正确答案:C

  • 第14题：

    Which view provides information on the backup status of the datafiles in the database?（）

    • A、V$BACKUP
    • B、V$BACKUP_STATUS 
    • C、V$BACKUP_DATAFILE 
    • D、V$DATAFILE_BACKUP 
    • E、V$TABLESPCE_BACKUP

    正确答案:A

  • 第15题：

    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

    • A、create a backup of the database and recover all corrupted blocks found in the backup
    • B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
    • C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
    • D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
    • E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

    正确答案:D

  • 第16题：

    Which dynamic view displays the status of block-change tracking?（）

    • A、V$BLOCK_CHANGE 
    • B、V$BLOCK_CHANGE_TRACKING 
    • C、V$BLOCKCHANGE 
    • D、V$BLOCK_TRACKING

    正确答案:B

  • 第17题：

    Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）

    • A、V$LOG
    • B、V$LOFHIST
    • C、V$LOGFILE
    • D、V$LOG_HISTORY

    正确答案:A

  • 第18题：

    多选题
    Which three values are valid parameters for the DO_KEY built-in?（）
    A

    ENTER

    B

    GO_ITEM

    C

    VALIDATE

    D

    EXIT_FORM

    E

    EXECUTE_QUERY


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

  • 第19题：

    单选题
    The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）
    A

     V$LOG

    B

     V$LOGFILE

    C

     DBA_LOG_GROUPS

    D

     V$LOG_HISTORY


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

  • 第20题：

    单选题
    Which statement regarding the contents of the V$PARAMETER view is true？（）
    A

    displays only the list of default values

    B

    displays only the list of all basic parameters

    C

    displays the currently in effect parameter values

    D

    displays only the list of all advanced parameters

    E

    displays the list of all the parameter files of a database


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

  • 第21题：

    单选题
    What view might you use to try to determine how long a particular backup will take？（）
    A

     V$SESSION_EVENT

    B

     V$SESSION

    C

     V$WAITS

    D

     V$WAITSTAT

    E

     V$SESSION_LONGOPS


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

  • 第22题：

    单选题
    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）
    A

    create a backup of the database and recover all corrupted blocks found in the backup

    B

    run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database

    C

    run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view

    D

    run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view

    E

    run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired


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

  • 第23题：

    单选题
    Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（）
    A

     V$VALID_NLS_VALUES

    B

     NLS_VALID_VALUES

    C

     NLS_VALUE_OPTIONS

    D

     V$NLS_VALUE_OPTIONS

    E

     V$NLS_VALID_VALUES


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

  • 第24题：

    单选题
    Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）
    A

    V$VALID_NLS_VALUES

    B

    NLS_VALID_VALUES

    C

    NLS_VALUE_OPTIONS

    D

    V$NLS_VALUE_OPTIONS

    E

    V$NLS_VALID_VALUES


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

相关内容