What are three uses for record groups?（）A、To pass data to a pop-up menu. B、To populate a base table block. C、To pass data to other form modules. D、To pass data to other Oracle products. E、To dynamically construct SELECT statements. F、To server as the sour

题目

What are three uses for record groups?（）

  • A、To pass data to a pop-up menu. 
  • B、To populate a base table block. 
  • C、To pass data to other form modules. 
  • D、To pass data to other Oracle products. 
  • E、To dynamically construct SELECT statements. 
  • F、To server as the source for a FROM clause query. 
相似考题

1.Which three statements are true about Oracle Data Pump export and import operations?()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.

2.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.

3.You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)A．Apply a bulk update lock to the table.B．Use separate client connections to load the files into the table simultaneously.C．Create a clustered index on the table.D．Specify the Full Recovery model for the database.E．Specify the Bulk-Logged Recovery model for the database.

4.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

更多“What are three uses for record groups?（）A、To pass data to a pop-up menu. B、To populate a base table block. C、To pass data to other form modules. D、To pass data to other Oracle products. E、To dynamically construct SELECT statements. F、To server as the sour”相关问题

  • 第1题：

    ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）

    • A、vector 
    • B、database view 
    • C、database table 
    • D、transactional trigger 
    • E、PL/SQL table of records 
    • F、multi-dimensional array

    正确答案:B,C,D

  • 第2题：

    What does it mean for a variable in the Application Editor to be defined as a parameter?（）

    • A、The variable can be used to pass data to and from subflows.  
    • B、The value for that variable can be supplied via Application Configuration in Application Administration.  
    • C、The value for that variable is defined by the calling application.  
    • D、The variable can be used in conditional steps.  
    • E、The variable can be used to pass data to and from VoiceXML applications.

    正确答案:B

  • 第3题：

    You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

    • A、BFILE 
    • B、REF column 
    • C、Object table 
    • D、Column object 
    • E、INSTEAD-OF trigger

    正确答案:B,C,D

  • 第4题：

    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

    • A、Oracle Flashback uses undo information to construct consistent data. 
    • B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
    • C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
    • D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

    正确答案:A,B

  • 第5题：

    You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）

    • A、Built-in Packages 
    • B、Menus 
    • C、PL/SQL Libraries 
    • D、Object Libraries 
    • E、Form Module

    正确答案:E

  • 第6题：

    You are developing an ASP.NET Web application. The application must pass an object that contains user-specific data between multiple pages. The object ismore than 100 KB in size when serialized.You need to minimize the amount of data is sent to the user. What should you do？（）

    • A、Pass the object data in a hidden field.
    • B、Store the object instance in a session variable.
    • C、Use a cookie that contains the object data.
    • D、Encode the object data and pass it in a query string parameter.

    正确答案:B

  • 第7题：

    You have a server named Server1 that runs Windows Server 2012 R2. Server1 has the Hyper-V  server role installed. You need to configure storage for a virtual machine to meet the following requirements：  （1）Support up to 3 TB of data on a single hard disk.  （2）Allocate disk space as needed.  （3）Use a portable storage format.  What should you configure？（）

    • A、A pass-through disk
    • B、A fixed-size VHD
    • C、A dynamically expanding VHD
    • D、A fixed-size VHDX
    • E、A dynamically expanding VHDX

    正确答案:E

  • 第8题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）
    A

     Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

    B

     Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.

    C

     Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.

    D

     Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    How do objects pass messages in Java？（）
    A

    They pass messages by modifying each other’s member variables

    B

    They pass messages by modifying the static member variables of each other’s classes

    C

    They pass messages by calling each other’s instance member methods

    D

    They pass messages by calling static member methods of each other’s classes.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    What does it mean for a variable in the Application Editor to be defined as a parameter?（）
    A

    The variable can be used to pass data to and from subflows.  

    B

    The value for that variable can be supplied via Application Configuration in Application Administration.  

    C

    The value for that variable is defined by the calling application.  

    D

    The variable can be used in conditional steps.  

    E

    The variable can be used to pass data to and from VoiceXML applications.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）
    A

    Oracle Flashback uses undo information to construct consistent data.

    B

    You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.

    C

    You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.

    D

    Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.


    正确答案： D,B
    解析： 暂无解析

  • 第13题：

    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?（）

    • A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
    • D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

    正确答案:E

  • 第14题：

    How do objects pass messages in Java？（）   

    • A、They pass messages by modifying each other’s member variables
    • B、They pass messages by modifying the static member variables of each other’s classes
    • C、They pass messages by calling each other’s instance member methods
    • D、They pass messages by calling static member methods of each other’s classes.

    正确答案:C

  • 第15题：

    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? （）

    • A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
    • D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
    • F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

    正确答案:F

  • 第16题：

    Which three statements are true about Oracle Data Pump export and import operations?（）

    • 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.

    正确答案:A,B,D

  • 第17题：

    Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）

    • A、The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 
    • B、The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
    • C、The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 
    • D、The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

    正确答案:C

  • 第18题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第19题：

    单选题
    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? （）
    A

    Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 

    F

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.


    正确答案： E
    解析： 暂无解析

  • 第20题：

    单选题
    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）
    A

     Create a FOR trigger. 

    B

     Create an INSTEAD OF trigger. 

    C

     Create an AFTER trigger. 

    D

     Create a DDL trigger.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    Which three statements are true about Oracle Data Pump export and import operations?（）
    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.


    正确答案： A,D
    解析： 暂无解析

  • 第22题：

    单选题
    You are developing an ASP.NET Web application. The application must pass an object that contains user-specific data between multiple pages. The object ismore than 100 KB in size when serialized.You need to minimize the amount of data is sent to the user. What should you do？（）
    A

    Pass the object data in a hidden field.

    B

    Store the object instance in a session variable.

    C

    Use a cookie that contains the object data.

    D

    Encode the object data and pass it in a query string parameter.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    What are three uses for record groups?（）
    A

    To pass data to a pop-up menu.

    B

    To populate a base table block.

    C

    To pass data to other form modules.

    D

    To pass data to other Oracle products.

    E

    To dynamically construct SELECT statements.

    F

    To server as the source for a FROM clause query.


    正确答案： B,F
    解析： 暂无解析

相关内容