Syntax when writing queries involving JOINS
Memory usage when working with the data
Character set mapping index hash size
Disk usage when storing data
第1题:
Automatic data conversion will occur if which of the following happens?()
第2题:
In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?()
第3题:
Automatic data conversion will occur if which of the following happens?()
第4题:
Which two tasks can your perform by using the TO_CHAR function? ()
第5题:
Which component of the Oracle networking architecture provides character set and data type conversion between different character sets on the client and server? ()
第6题:
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? ()(Choose three.)
第7题:
You are developing a class library. Portions of your code need to access system environment variables. You need to force a runtime SecurityException only when callers that are higher in the call stack do not have the necessary permissions. Which call method should you use?()
第8题:
Your computer has a wired network adapter and a wireless network adapter. You use the wireless network adapter only when you are traveling. You need to configure the network adapter profile settings to ensure that the computer discovers other network devices only when you are at home. Which two actions should you perform?()
第9题:
Syntax when writing queries involving JOINS
Memory usage when working with the data
Character set mapping index hash size
Disk usage when storing data
第10题:
VARCHAR2
CHAR
NVARCHAR2
CLOB
LONG
第11题:
Convert 10 to 'TEN'
Convert '10' to 10
Convert '10' to '10'
Convert 'TEN' to 10
Convert a date to a character expression
Convert a character expression to a date
第12题:
You can see the contents of the log file by entering the show log <filename> command
Trace options will send information to your screen automatically
Trace options are limited to one protocol at a time
The file name and set of flags may be specified when enabling trace options
第13题:
Which statement would prevent the sending of redundant route advertisements when your route reflector cluster is fully meshed?()
第14题:
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16?()
第15题:
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
第16题:
In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?()
第17题:
Which is not a valid locale definition file type?()
第18题:
What does the Character Set Scanner command line utility do?()
第19题:
You need to design a method to encrypt confidential data. Your solution must address the concerns of the chief information officer. What should you do?()
第20题:
the query transaction rate
numeric data versus character data
extent size
the cardinality of the candidate columns
prefetch size
第21题:
The size of the card.
The right color scheme.
A unique design of the card.
A friendlier logo of your company.
第22题:
The client and server have different NLS_LANGUAGE settings
The client and server character sets are not the same,and the database character set is not a strict superset of the client character set
The client and server are in different time zones
The client requests automatic data conversion
The AUTO_CONVERT initialization parameter is set to TRUE
第23题:
by using the RMAN utility
by using the export/import utility
by using the ALTER DATABASE command
by enabling the change tracking feature
第24题:
The client and server have different NLS_LANGUAGE settings.
The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
The client and server are in different time zones.
The client requests automatic data conversion.
The AUTO_CONVERT initialization parameter is set to TRUE.