a table name which has 100s of records
a table name which has 10s of records
a table name which has empty records
a table name which has 1000s of records
never use a table name
第1题:
A. Phase
B. Status
C. Source Type
D. Rule Function
E. Customization Level
第2题:
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()
第3题:
A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.
第4题:
You want to migrate an application that was developed for OAS/OC4J to WebLogic. The application uses Oracle Streams Advanced Queuing (AQ). You configured a Foreign JMS Server and Data Source but you are not able to send messages to the AQ destination and see them reach the database. Which two things are missing in this configuration?()
第5题:
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()
第6题:
You are configuring for Oracle Shared Server. Which service is required? ()
第7题:
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()
第8题:
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?()
A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
第9题:
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()
第10题:
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()