单选题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR？（）AAll objects in the databaseBTables owned by SYS and SYSTEMCData dictionary tablesDNCHAR columnsECHAR columns

题目
单选题
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR？（）
A

 All objects in the database

B

 Tables owned by SYS and SYSTEM

C

 Data dictionary tables

D

 NCHAR columns

E

 CHAR columns

相似考题

1.Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS

2.In which three cases would you use the USING clause?()A.You want to create a nonequijoin.B.The tables to be joined have multiple NULL columns.C.The tables to be joined have columns of the same name and different data types.D.The tables to be joined have columns with the same name and compatible data types.E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

3.In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）A、DBA_USERS B、DBA_OBJECTS C、DBA_TS_QUOTAS D、DBA_TAB_PRIVS 

4.Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?()A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data dictionary tablesD. NCHAR columnsE. CHAR columns

更多“单选题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR？（）A  All objects in the databaseB  Tables owned by SYS and SYSTEMC  Data dictionary tablesD  NCHAR columnsE  CHAR columns”相关问题

  • 第1题：

    Which statement is true regarding the INTERSECT operator?（）

    • A、It ignores NULL values 
    • B、Reversing the order of the intersected tables alters the result 
    • C、The names of columns in all SELECT statements must be identical 
    • D、The number of columns and data types must be identical for all SELECT statements in the query 

    正确答案:D

  • 第2题：

    Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）

    • A、All objects in the database
    • B、Tables owned by SYS and SYSTEM
    • C、Data dictionary tables
    • D、NCHAR columns
    • E、CHAR columns

    正确答案:E

  • 第3题：

    While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）

    • A、heap tables
    • B、object tables
    • C、partitioned tables
    • D、index­organized tables （IOTs）

    正确答案:D

  • 第4题：

    In which case would you use a FULL OUTER JOIN?（）

    • A、Both tables have NULL values.
    • B、You want all unmatched data from one table.
    • C、You want all matched data from both tables.
    • D、You want all unmatched data from both tables.
    • E、One of the tables has more data than the other.
    • F、You want all matched and unmatched data from only one table.

    正确答案:D

  • 第5题：

    The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）  

    • A、 owner
    • B、 touser
    • C、 attach
    • D、 remap_schema

    正确答案:D

  • 第6题：

    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

    • A、V$DATABASE 
    • B、DBA_TABLES 
    • C、SYSAUD$ 
    • D、EMP

    正确答案:B

  • 第7题：

    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

    • A、SYSTEM 
    • B、OUTLN 
    • C、INTERNAL 
    • D、SYS

    正确答案:D

  • 第8题：

    单选题
    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）
    A

    V$DATABASE 

    B

    DBA_TABLES 

    C

    SYSAUD$ 

    D

    EMP


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

  • 第9题：

    单选题
    The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）
    A

     owner

    B

     touser

    C

     attach

    D

     remap_schema


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

  • 第10题：

    多选题
    In which two cases would you use an outer join? （）
    A

    The tables being joined have NOT NULL columns.

    B

    The tables being joined have only matched data.

    C

    The columns being joined have NULL values.

    D

    The tables being joined have only unmatched data.

    E

    The tables being joined have both matched and unmatched data.

    F

    Only when the tables have a primary key-foreign key relationship.


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

  • 第11题：

    单选题
    In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
    A

    DBA_USERS 

    B

    DBA_OBJECTS 

    C

    DBA_TS_QUOTAS 

    D

    DBA_TAB_PRIVS 


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

  • 第12题：

    单选题
    While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）
    A

     heap tables

    B

     object tables

    C

     partitioned tables

    D

     index-organized tables （IOTs）


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

  • 第13题：

    Which expressions are correct to declare an array of 10 String objects？ （）   

    • A、 char str[]；
    • B、 char str[][]；
    • C、 String str[]；
    • D、 String str[10]；

    正确答案:C

  • 第14题：

    Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.

    • A、1 and 3
    • B、2， 3， and 5
    • C、1， 2， and 3
    • D、2， 3， 4， and 5

    正确答案:A

  • 第15题：

    On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）

    • A、fixed tables
    • B、heap tables
    • C、external tables
    • D、temporary tables
    • E、Index-Organized Tables (IOTs)

    正确答案:B,E

  • 第16题：

    Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）

    • A、USER_CONSTRAINTS
    • B、USER_OBJECTS
    • C、ALL_CONSTRAINTS
    • D、USER_CONS_COLUMNS
    • E、USER_COLUMNS

    正确答案:D

  • 第17题：

    You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

    • A、All the objects of scott are moved to the Recycle Bin.
    • B、Any objects in the Recycle Bin belonging to scott are purged.
    • C、All the objects owned by scott are permanently dropped from the database.
    • D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
    • E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

    正确答案:B,C

  • 第18题：

    In which two cases would you use an outer join? （）

    • A、The tables being joined have NOT NULL columns.
    • B、The tables being joined have only matched data.
    • C、The columns being joined have NULL values.
    • D、The tables being joined have only unmatched data.
    • E、The tables being joined have both matched and unmatched data.
    • F、Only when the tables have a primary key/foreign key relationship.

    正确答案:C,E

  • 第19题：

    单选题
    In which case would you use a FULL OUTER JOIN?（）
    A

    Both tables have NULL values.

    B

    You want all unmatched data from one table.

    C

    You want all matched data from both tables.

    D

    You want all unmatched data from both tables.

    E

    One of the tables has more data than the other.

    F

    You want all matched and unmatched data from only one table.


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

  • 第20题：

    单选题
    Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.
    A

    1 and 3

    B

    2， 3， and 5

    C

    1， 2， and 3

    D

    2， 3， 4， and 5


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

  • 第21题：

    单选题
    Which expressions are correct to declare an array of 10 String objects？ （）
    A

     char str[]；

    B

     char str[][]；

    C

     String str[]；

    D

     String str[10]；


    正确答案： A
    解析： 严格来说这个题目没有给出一个正确的答案，唯一比较正确的是c，而完全满足题目要求的应该是：String str[]=new String[10]; 注意答案d的形式是不对的，这和c++也是不同的。

  • 第22题：

    单选题
    Which statement is true regarding the INTERSECT operator?（）
    A

    It ignores NULL values 

    B

    Reversing the order of the intersected tables alters the result 

    C

    The names of columns in all SELECT statements must be identical 

    D

    The number of columns and data types must be identical for all SELECT statements in the query 


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

  • 第23题：

    单选题
    Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）
    A

    All objects in the database

    B

    Tables owned by SYS and SYSTEM

    C

    Data dictionary tables

    D

    NCHAR columns

    E

    CHAR columns


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

相关内容