it can be used to concatenate two strings.
it can be used to find out the total length of the string.
it can be used for string manipulation and searching operations.
it can be used to format the output for a column or expression having string data.
it can be used to find and replace operations for a column or expression having string data.
第1题:
Which two statements are true regarding the USING clause in table joins?()
第2题:
which one of the following accurately describes field names?()
第3题:
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
第4题:
Which three tasks can be performed using a duplicate database? ()(Choose three.)
第5题:
Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)
第6题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第7题:
It can be used to join a maximum of three tables
It can be used to restrict the number of columns used in a NATURAL join
It can be used to access data from tables through equijoins as well as nonequijoins
It can be used to join tables that have columns with the same name and compatible data types
第8题:
Both USING and ON clauses can be used for equijoins and nonequijoins
Amaximum of one pair of columns can be joined between two tables using the ON clause
The ON clause can be used to join tables on columns that have different names but compatible data types
The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
第9题:
Testing the backup and recovery procedures
Testing the upgrade of an Oracle database to a new release
Testing the effect of an application changes on database performance
Continuously updating archive log files from the target database to support failover
第10题:
It can be used to allow the access privilege settings for users but not roles.
It can be used to allow the access privilege settings for users as well as roles.
It can be used to control the time interval for which the access privilege is available to a user.
It can be used to selectively restrict the access for each user in a database to different host computers.
It can be used to selectively restrict a user's access to different applications in a specific host computer.
第11题:
The ADR base keeps all diagnostic information in binary format
SQL*Plus provides the ADRI script, which can be used to work with ADR
The ADR can be used for problem diagnosis only when the database is open
The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
The ADR can be used for problem diagnosis even when the database instance is down
The ADR base is shared across multiple instances
第12题:
Testing the backup and recovery procedures
Testing the upgrade of an Oracle database to a new release
Testing the effect of an application changes on database performance
Continuously updating archive log files from the target database to support failover
第13题:
NBAR is a Cisco IOS feature that can be used to perform three tasks?
第14题:
Which two statements regarding external authentication servers for firewall userauthentication are true?()
第15题:
Which three tasks can be performed using regular expression support in Oracle Database 10g?()
第16题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
第17题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).
第18题:
Which three tasks can be performed using a duplicate database?()
第19题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
第20题:
It can be used to back up all data on ASM disks.
It can be used to recover the damaged ASM disk group along with the data.
It can be used to gather information about a preexisting ASM disk group with disk paths,disk name,failure groups,attributes templates,and alias directory structure.
It can be used to re-create the ASM disk group with its attributes.
第21题:
Up to three external authentication server types can be used simultaneously.
Only one external authentication server type can be used simultaneously.
If the local password database is not configured in the authentication order, and the configured authentication server is unreachable, authentication is not performed.
If the local password database is not configured in the authentication order, and the configured authentication server rejects the authentication request, authentication is not performed
第22题:
The ADR base keeps all diagnostic information in binary format
SQL*Plus provides the ADRI script, which can be used to work with ADR
The ADR can be used for problem diagnosis only when the database is open
The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
The ADR can be used for problem diagnosis even when the database instance is down
The ADR base is shared across multiple instances
第23题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database