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?()
第1题:
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
第2题:
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.
第3题:
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
第4题:
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?()
第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?()
第6题:
A.GRAPHIC
B.BINARY
C.IMAGE
D.BLOB
第7题:
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
第8题:
A. urlhash
B. url persistency
C. cookie persistency
D. default persistency
第9题:
What Cisco Switch feature best protects against CAM table overflow attacks?()
第10题:
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?()