1Z0-053

单选题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

参考答案和解析
正确答案： E
解析： 暂无解析
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：C, D, E

第2题：

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

第3题：

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

第4题：

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

第5题：

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

第6题：

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

第7题：

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

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容