单选题You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）AOn the Oracle server. BLocally in each form module. CIn an attached PL/SQL library DOn your file network server.
单选题
You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）
A
On the Oracle server.
B
Locally in each form module.
C
In an attached PL/SQL library
D
On your file network server.
参考解析
解析：
暂无解析
相关考题：
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?() A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.C. All the components may be moved into SYSAUX tablespace.D. All the components may be moved from the SYSAUX tablespace.
You have borrowed a book from Professor Thomas and find that you can't give it back to him two days later as scheduled.Write him an email to ask whether you can keep the book for a few days more and make an apology.You should write about 100 words neatly on the ANSWER SHEET.Do not use your own name at the end of the email.Use"Ii Ming"instead.（10 points）
Write a memo in about 50 words. You are Human Resources Manager. Your company is going to provide the staff with training in E-Commerce. There will be two course levels: intermediate level and advanced level. The training course will be given on Saturdays for five weeks. Write a memo to department managers: ·Informing them of the coming training course; ·Asking them to encourage the staff to participate; ·Asking them to help obtain the names of the interested staff.
从水面到甲板之间的高度称之为干舷。（）A、The height from the bottom of a vessel to the weather deck is called freeboard.B、The depth from water level to the bottom of a vessel is called freeboard.C、The length from the bow to stern of a vessel is called freeboard.D、The height from water level to the main deck is called freeboard.
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A、12; only top-level statements and stored procedure events are loggedB、111; top-level statements and all lower-level statements are loggedC、3; only the top-level statements are loggedD、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）A、On the Oracle server. B、Locally in each form module. C、In an attached PL/SQL library D、On your file network server.
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. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）A、The sp_executesql batches are not being recovered from the procedure cache.B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.C、One new stored procedure is created by a database administrator.D、Ad hoc batches are not being recovered from the procedure cache.
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?（） A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header D、You should alter Procedure01 and add the EXECUTE AS USER = apos;dboapos; option immediately before the call to the sp_executesql stored procedure.
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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（） A、You should configure the database for Read Committed Snapshot isolation. B、You should modify the stored procedure to use the Snapshot isolation level C、You should configure the database for Auto Update Statistics asynchronously D、You should modify the stored procedure to use the Repeatable Read isolation level
单选题You develop a service application named PollingService that periodically calls long-running procedures.These procedures are called from the DoWork method.You use the following service application code： When you attempt to start the service， you receive the following error message： Could not start the PollingService service on the local computer.Error 1053： The service did not respond to the start or control request in a timely fashion. You need to modify the service application code so that the service starts properly.What should you do？（）A Move the loop code into the constructor of the service class from the OnStart method.B Drag a timer component onto the design surface of the service. Move the calls to the long-running procedure from the OnStart method into the Tick event procedure of the timer， set the Enabled property of the timer to True， and call the Start method of the timer in the OnStart method.C Add a class-level System.Timers.Timer variable to the service class code. Move the call to the DoWork method into the Elapsed event procedure of the timer， set the Enabled property of the timer to True， and call the Start method of the timer in the OnStart method.D Move the loop code from the OnStart method into the DoWork method.
问答题Practice 3 You should spend about 40 minutes on this task. Write about the following topic: Students at schools and universities learn far more from lessons with teachers than from other sources (such as the Internet and television). To what extent do you agree or disagree? You should write at least 250 words.
问答题Write a memo in about 50 words. You are Human Resources Manager. Your company is going to provide the staff with training in E-Commerce. There will be two course levels: intermediate level and advanced level. The training course will be given on Saturdays for five weeks. Write a memo to department managers: ·Informing them of the coming training course; ·Asking them to encourage the staff to participate; ·Asking them to help obtain the names of the interested staff.
问答题Practice 1 You should spend no more than 20 minutes on this task. In the city of Plonkers the people have developed a game called Aerial Ping Pong, derived from Gaellic football. The graph below shows spectator numbers for the 3 codes of football layed in Plonkers. Write a report for a university lecturer describing the information in the graph. You should write at least 150 words.
问答题Practice 1 ●You work for a company which is going to buy a set of equipment from China, You are asked to translate a lot of specifications and instructions within four months, which is impossible. Therefore you decide to advertise for two experienced translators as soon as possible. ● Write a short note to Mr. Max Remington, the Public Relation’s manager. Ask for an advertisement for two translators. ● Explain the reason. ● Mention your urgency. ● Write 30-40 words on your Answer Sheet.
问答题Directions: You will graduate from university and are hunting for a job. After reading a job ads, write a letter to the Personnel Resources Department to （1）state your reason to write the application, （2）describe your relevant education background, （3）introduce your English level, and （4）state your way of contact. You should write about 100 words neatly on the ANSWER SHEET. Do not sign your own name. Use “Li Ming” instead. You do not need to write the address.
单选题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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）AYou should configure the database for Read Committed Snapshot isolation. BYou should modify the stored procedure to use the Snapshot isolation level CYou should configure the database for Auto Update Statistics asynchronously DYou should modify the stored procedure to use the Repeatable Read isolation level
单选题You create a Windows Communication Foundation (WCF) service and deploy it with wsHttpBinding and message security enabled.You create an intermediate WCF service for logging messages sent to the primary service.The intermediate service is called via endpoint behaviour. The primary service is receiving malformed data from a client application.You need to enable inspection of the malformed data and prevent message tampering. What do you do?（）ASpecify a protection level of None in the contract for the intermediate service. Disable message and transport security from the client application configuration file.BSpecify a protection level of Sign in the contract for the intermediate service. Disable transport security from the client application configuration file.CModify the binding on the intermediate service to use netNamedPipeBinding.DModify the binding on the intermediate service to use webHttpBinding.
多选题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）AGrand privileges on the interim table.BInvoke the dbms_redefinition.can_redef_table procedure.CInvoke the dbms_redefinition.sync_interim_table procedure.DCreate any triggers， indexes， or constraints on the interim table.ECreate an empty interim table with all the desired characteristics.
单选题The height from water level to the weather deck is called（）.AheightBfreeboardCdraftDwaterline
单选题Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A12; only top-level statements and stored procedure events are loggedB111; top-level statements and all lower-level statements are loggedC3; only the top-level statements are loggedD102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
多选题You write a logging function for a Web Form. You call the logging function from the Page_Unload event handler. You test the Web Form and notice that the Page_Unload event handler does not call the logging function. You need to ensure that the logging function is called. What are two possible ways to achieve this goal? （）ASet the Page attribute to AutoEventWireup=False. Remove the attribute onunload=Page_Unload from the Web Form element.BSet the Page attribute to AutoEventWireup=False. Add the attribute OnUnload=Page_Unload to the Web Form element.CSet the Page attribute to AutoEventWireup=False. Add the Web Form attribute autocomplete=on.DSet the Page attribute to AutoEventWireup=True.
单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）AJoin the two servers by using the four-part syntax of server.database.schema.table.BReference SQL2 by using an alias.CAdd SQL2 as a remote server to SQL1.DAdd SQL2 as a linked server to SQL1.
单选题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. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）AThe sp_executesql batches are not being recovered from the procedure cache.BA database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.COne new stored procedure is created by a database administrator.DAd hoc batches are not being recovered from the procedure cache.
问答题The extract below comes from an article which appeared in a magazine called Society Today. You read the extract and have strong feelings about its contents, and decide to write an article, in which you respond to the points made and express your own views. You should write the article in no fewer than 120 words. Now write your letter on the answer sheet.
单选题You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）ADBCC DBREINDEXBSELECT * FROM sys.dm_db_index_physical_statsCDBCC INDEXDEFRAGDSELECT * FROM sys.indexes
单选题从水面到甲板之间的高度称之为干舷。（）AThe height from the bottom of a vessel to the weather deck is called freeboard.BThe depth from water level to the bottom of a vessel is called freeboard.CThe length from the bow to stern of a vessel is called freeboard.DThe height from water level to the main deck is called freeboard.