单选题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
参考解析
解析：
暂无解析
相关考题：
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
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
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.
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
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
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]；
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 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 3B、2， 3， and 5C、1， 2， and 3D、2， 3， 4， and 5
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 tablesB、object tablesC、partitioned tablesD、indexorganized tables （IOTs）
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）A、fixed tablesB、heap tablesC、external tablesD、temporary tablesE、Index-Organized Tables (IOTs)
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.
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
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、 ownerB、 touserC、 attachD、 remap_schema
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.
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
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.
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
单选题In which case would you use a FULL OUTER JOIN?（）ABoth tables have NULL values.BYou want all unmatched data from one table.CYou want all matched data from both tables.DYou want all unmatched data from both tables.EOne of the tables has more data than the other.FYou want all matched and unmatched data from only one table.
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP
单选题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.A1 and 3B2， 3， and 5C1， 2， and 3D2， 3， 4， and 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 ownerB touserC attachD remap_schema
单选题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 expressions are correct to declare an array of 10 String objects？ （）A char str[]；B char str[][]；C String str[]；D String str[10]；
多选题In which two cases would you use an outer join? （）AThe tables being joined have NOT NULL columns.BThe tables being joined have only matched data.CThe columns being joined have NULL values.DThe tables being joined have only unmatched data.EThe tables being joined have both matched and unmatched data.FOnly when the tables have a primary key-foreign key relationship.
单选题Which statement is true regarding the INTERSECT operator?（）AIt ignores NULL values BReversing the order of the intersected tables alters the result CThe names of columns in all SELECT statements must be identical DThe number of columns and data types must be identical for all SELECT statements in the query
单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）ADBA_USERS BDBA_OBJECTS CDBA_TS_QUOTAS DDBA_TAB_PRIVS
单选题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
单选题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 tablesB object tablesC partitioned tablesD index-organized tables （IOTs）