Control Center
Development Center
Developer Workbench
Stored Procedure Builder
第1题:
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 found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?()
第2题:
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?()
第3题:
Which two PL/SQL8 features are supported in Oracle Forms?()
第4题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. What should you do? ()
第5题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.) 01 CREATE PROCEDURE Sales.Procedure1 02 AS 03 IF OBJECT_ID('Service.Table') IS NOT NULL 04 DROP TABLE Service.Table; 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 11 ... 12 GOThe following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions. What action should you do perform?()
第6题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?()
第7题:
Add a COMMIT TRANSACTION command to the CATCH block.
Remove the COMMIT TRANSACTION command from the TRY block.
Add a ROLLBACK TRANSACTION command to the CATCH block.
Add a ROLLBACK TRANSACTION command to the TRY block.
第8题:
Alias
Schema
Package
Routine Space
第9题:
Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause.
Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement.
You should give the user the ALTER permission on the Service schema
You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.
第10题:
Control Center
Development Center
Developer Workbench
Stored Procedure Builder
第11题:
You should create a policy that targets the name of the stored procedure that is evaluated on change.
You should create a policy that targets the name of the stored procedure that is evaluated on demand.
You should create a condition that targets the name of stored procedure that is evaluated on demand.
You should create a condition that targets the name of the stored procedure that isevaluated on change.
第12题:
one that uses an internal SQL Server Web service endpoint
one that runs a SQL Server Integration Services (SSIS) package
one that uses Service Broker
one that runs a user-defined function
第13题:
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?()
第14题:
A stored procedure object is created into which DB2 object?()
第15题:
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()
第16题:
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?()
第17题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?()
第18题:
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.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure.
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.
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.
Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
第19题:
Task Center
Command Editor
Developer Workbench
Command Line Processor
第20题:
You should create a job which is assigned to the Database Maintenance category
You should create an Alert which will run another to delete the maintenance job.
You should create a job. You schedule the job to run only once.
You should create a job. The job uses the Automatically delete job option
第21题:
You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.
第22题:
Join the two servers by using the four-part syntax of server.database.schema.table.
Reference SQL2 by using an alias.
Add SQL2 as a remote server to SQL1.
Add SQL2 as a linked server to SQL1.
第23题:
methods
object tables
object columns
collection types
object as stored procedure parameters
第24题:
A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.
A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.