To pass data to a pop-up menu.
To populate a base table block.
To pass data to other form modules.
To pass data to other Oracle products.
To dynamically construct SELECT statements.
To server as the source for a FROM clause query.
第1题:
The corporate head office of TestKing has a teleconferencing system that uses VOIP (voice over IP) technology. This system uses UDP as the transport for the data transmissions. If these UDP datagrams arrive at their destination out of sequence,what will happen?()
A. UDP will send an ICMP Information Request to the source host.
B. UDP will pass the information in the datagrams up to the next OSI layer in the order that they arrive.
C. UDP will drop the datagrams.
D. UDP will use the sequence numbers in the datagram headers to reassemble the data in the correct order.
E. UDP will not acknowledge the datagrams and wait for a retransmission of the datagrams.
第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. You can detach from a data pump export job and reattach later.
B. Data pump uses parallel execution server processes to implement parallel import.
C. Data pump import requires the import file to be in a directory owned by the oracle owner.
D. The master table is the last object to be exported by the data pump.
E. You can detach from a data pump import job and reattach later.
第4题:
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? ()
第5题:
How do objects pass messages in Java?()
第6题:
You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?()
第7题:
What does it mean for a variable in the Application Editor to be defined as a parameter?()
第8题:
You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.
You want to prevent any loss of data during the import operations. What should you do?
A.Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.
B.Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.
C.Set a flag on each DTS transformation to require an exact match between source and destination columns.
D.Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.
E.Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.
第9题:
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()
第10题:
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()