An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming th

题目

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）

  • A、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
  • B、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
  • C、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
  • D、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
相似考题

1.Identify three features of shared entities.() (Choose three.)A.enable one-time definition of objectsB.are referenced by several Oracle Application modulesC.are defined in each Oracle Application module separatelyD.are owned by a single Oracle Application module for table purposes onlyE.are owned by a single Oracle Application module to designate the primary user or decision maker

2.An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

3.An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?()A.GRAPHICB.BINARYC.IMAGED.BLOB

4.An enterprise has an internal web application that needs stickiness managed by a Cluster. Allemployees access the application through a proxy. What is the correct sticky load balancing policy? ()A. urlhashB. url persistencyC. cookie persistencyD. default persistency

更多“An application needs a table fo”相关问题

  • 第1题：

    A client has a temporary deployment of a new static application that needs to run for a short period of time and is not going to change.How can this deployment be achieved with a minimum of effort and time?（）

    A.Run a system WPAR and deploy the application.

    B.Create a new LPAR and deploy the application.

    C.Create an application WPAR to deploy the application.

    D.Create an LPAR hosted by a VIO server and deploy the application.


    参考答案：C

  • 第2题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index­organized table （IOT）

    正确答案:A

  • 第3题：

    A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

    • A、REFERENCES
    • B、SELECT
    • C、UPDATE
    • D、ALTER

    正确答案:D

  • 第4题：

    An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?（）

    • A、GRAPHIC
    • B、BINARY
    • C、IMAGE
    • D、BLOB

    正确答案:D

  • 第5题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index-organized table （IOT）

    正确答案:A

  • 第6题：

    Certkiller.com has an active directory forest on a single domain.  Certkiller needs a distributed application that employs a custom application. The application is directory partition software named PARDAT. You need to implement this application for data replication.  Which two tools should you use to achieve this task（）

    • A、Dnscmd.
    • B、Ntdsutil.
    • C、Ipconfig
    • D、Dnsutil
    • E、All of the above

    正确答案:A,B

  • 第7题：

    填空题
    Before (write) ____ an application letter, you should be aware what kind of people the employer needs.

    正确答案： writing
    解析：
    本题考查动名词形式。句意：在写求职信之前，你应该明白老板需要什么样的人才。before引导时间状语，所以后面应该是名词或者动名词结构，故应填入writing。

  • 第8题：

    多选题
    Identify three features of shared entities.（） (Choose three.)
    A

    enable one-time definition of objects

    B

    are referenced by several Oracle Application modules

    C

    are defined in each Oracle Application module separately

    D

    are owned by a single Oracle Application module for table purposes only

    E

    are owned by a single Oracle Application module to designate the primary user or decision maker


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

  • 第9题：

    单选题
    Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
    A

    Oracle Data Pump.

    B

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

    C

    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

    D

    Online Table Redefinition.

    E

    Edition-Based Table Redefinition.


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

  • 第10题：

    多选题
    Certkiller.com has an active directory forest on a single domain.  Certkiller needs a distributed application that employs a custom application. The application is directory partition software named PARDAT. You need to implement this application for data replication.  Which two tools should you use to achieve this task（）
    A

    Dnscmd.

    B

    Ntdsutil.

    C

    Ipconfig

    D

    Dnsutil

    E

    All of the above


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

  • 第11题：

    单选题
    You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）
    A

     The index can be changed from NOLOGGING to LOGGING

    B

     The index cannot be recovered even in the ARCHIVELOG mode.

    C

     The index can only be created if the base table is created with the NOLOGGING option.

    D

     The index can be recovered if you perform a backup after the CREATE INDEX statement.


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

  • 第12题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
    A

    heap table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index­organized table （IOT）


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

  • 第13题：

    A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

    A.REFERENCES

    B.SELECT

    C.UPDATE

    D.ALTER


    参考答案：D

  • 第14题：

    What Cisco Switch feature best protects against CAM table overflow attacks？（）

    • A、 Storm Control
    • B、 Port security
    • C、 CAM table size definition
    • D、 IP spoof prevention
    • E、 Network Based Application Recognition

    正确答案:B

  • 第15题：

    A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

    • A、Code the application to issue a LOCK TABLE statement.  
    • B、Code the application to issue a LOCK ROW statement.  
    • C、Decrease the number of I/O servers.  
    • D、Increase the locklist parameter. 

    正确答案:A

  • 第16题：

    Identify three features of shared entities.（） (Choose three.)

    • A、enable one-time definition of objects
    • B、are referenced by several Oracle Application modules
    • C、are defined in each Oracle Application module separately
    • D、are owned by a single Oracle Application module for table purposes only
    • E、are owned by a single Oracle Application module to designate the primary user or decision maker

    正确答案:A,B,D

  • 第17题：

    An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）

    • A、 Use a single partition key for the table.
    • B、 Compress data before storing it in the table.
    • C、 Create additional partition keys for the table.
    • D、 Continually remove unnecessary data from the table.

    正确答案:C

  • 第18题：

    You are designing an application that will use Windows Azure Table storage to store millions of data points each day.  The application must retain each day’s data for only one week.   You need to recommend an approach for minimizing storage transactions.  What should you recommend？（）

    • A、 Use a separate table for each date.  Delete eachtable when it is one week old.
    • B、 Use a separate table for each week.  Delete each table when it is one week old.
    • C、 Use a single table， partitioned by date.  Use Entity Group Transactions to delete data when it is one week old.
    • D、 Use a single table， partitioned by week.  Use Entity Group Transactions to delete data when it is one week old.

    正确答案:A

  • 第19题：

    单选题
    An enterprise has an internal web application that needs stickiness managed by a Cluster. Allemployees access the application through a proxy. What is the correct sticky load balancing policy? （）
    A

    urlhash

    B

    url persistency

    C

    cookie persistency

    D

    default persistency


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

  • 第20题：

    单选题
    A client has a temporary deployment of a new static application that needs to run for a short period of time and is not going to change. How can this deployment be achieved with a minimum of effort and time?（）
    A

    Run a system WPAR and deploy the application.

    B

    Create a new LPAR and deploy the application.

    C

    Create an application WPAR to deploy the application.

    D

    Create an LPAR hosted by a VIO server and deploy the application.


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

  • 第21题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）
    A

     Heap table

    B

     Object table

    C

     External table

    D

     Clustered table

    E

     Global temporary table

    F

     Index-organized table （IOT）


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

  • 第22题：

    单选题
    Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）
    A

    GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

    B

    GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

    C

    GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

    D

    GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom


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

  • 第23题：

    单选题
    What Cisco Switch feature best protects against CAM table overflow attacks？（）
    A

     Storm Control

    B

     Port security

    C

     CAM table size definition

    D

     IP spoof prevention

    E

     Network Based Application Recognition


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

相关内容