网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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” 相关考题
考题
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
考题
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 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
考题
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
考题
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.
考题
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.REFERENCESB.SELECTC.UPDATED.ALTER
考题
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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、indexorganized table （IOT）
考题
What Cisco Switch feature best protects against CAM table overflow attacks？（）A、 Storm ControlB、 Port securityC、 CAM table size definitionD、 IP spoof preventionE、 Network Based Application Recognition
考题
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、REFERENCESB、SELECTC、UPDATED、ALTER
考题
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.
考题
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
考题
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
考题
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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table （IOT）
考题
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.
考题
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、IpconfigD、DnsutilE、All of the above
考题
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.
考题
填空题Before (write) ____ an application letter, you should be aware what kind of people the employer needs.
考题
单选题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
考题
多选题Identify three features of shared entities.（） (Choose three.)Aenable one-time definition of objectsBare referenced by several Oracle Application modulesCare defined in each Oracle Application module separatelyDare owned by a single Oracle Application module for table purposes onlyEare owned by a single Oracle Application module to designate the primary user or decision maker
考题
单选题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.
考题
单选题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.
考题
单选题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 tableB
Object tableC
External tableD
Clustered tableE
Global temporary tableF
Index-organized table （IOT）
考题
多选题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（）ADnscmd.BNtdsutil.CIpconfigDDnsutilEAll of the above
考题
单选题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 appgrpB
GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C
GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD
GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
考题
单选题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 LOGGINGB
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.
考题
单选题What Cisco Switch feature best protects against CAM table overflow attacks？（）A
Storm ControlB
Port securityC
CAM table size definitionD
IP spoof preventionE
Network Based Application Recognition
考题
单选题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 tableB
object tableC
external tableD
clustered tableE
global temporary tableF
indexorganized table （IOT）
热门标签
最新试卷