It applies to a single data server.
It is a recoverable sequence of operations.
Its value can be queried from the system catalog tables.
It begins when the application connects to the data server.
第1题:
Which of the following is the main feature of an OLTP application?()
第2题:
When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server,which of the following can be used as valid values for the -method command line parameter?()
第3题:
Which of the following is a feature of a unit of work?()
第4题:
Which two statements about subqueries are true?()
第5题:
Which three statements are true about logical structures of the Oracle database()
第6题:
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal?()
第7题:
Operating environment
Parallel access volumes
Point-in-time copy
Count Key Data
第8题:
After a ROLLBACK is issued
After the sequence is altered
After the sequence is dropped
After the current session ends
第9题:
Strategic security planning
Disaster recovery
Implementation security
Operations security
第10题:
create
import
load
sqlimport
update
第11题:
Determine backups available, restore backups, and verify data.
Restore applications, restore data, and verify data.
Restore OS, restore system applications, and restore data.
Contact end users of outage, restore backup data, and verify data.
第12题:
To achieve the goal, a Linked Server connection should be configured to the application database.
To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.
To achieve the goal, a Remote Server connection to the application database should be configured.
To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.
第13题:
What does it mean for a variable in the Application Editor to be defined as a parameter?()
第14题:
Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?()
第15题:
Which statements are true about logical structures of the Oracle database()
第16题:
Which two requirements would lead towards a high availability solution?()
第17题:
Your data recovery strategy must meet the following requirements: Back up all data files and folders in C:///Data. Restore individual files and folders in C:///Data. Ensure that data is backed up to and restored from external media. What should you do?()
第18题:
Which two statements are true regarding single row functions?()
第19题:
Summarized queries
Granular transactions
Voluminous historical data
Heterogeneous data sources
第20题:
Only the data files.
All of the data files and the control files.
Only the data files belonging to the SYSTEM tablespace.
Only the data files belonging to the SYSTEM tablespace and the control files.
第21题:
A single row subquery can retrieve data from only one table.
A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
A single row subquery can retrieve data from more than one table.
A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
第22题:
The variable can be used to pass data to and from subflows.
The value for that variable can be supplied via Application Configuration in Application Administration.
The value for that variable is defined by the calling application.
The variable can be used in conditional steps.
The variable can be used to pass data to and from VoiceXML applications.
第23题:
Determine backups available, restore backups, and verify data.
Restore applications, restore data, and verify data.
Restore OS, restore system applications, and restore data.
Contact end users of outage, restore backup data, and verify data.
第24题:
It applies to a single data server.
It is a recoverable sequence of operations.
Its value can be queried from the system catalog tables.
It begins when the application connects to the data server.