网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME => ’JOB_A’, ATTRIBUTE => ’JOB_PRIORITY’, VALUE => 7); END; / After analyzing the above code, what conclusion will you draw?()
A
The code will be executed successfully.
B
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.
C
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
D
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
参考答案
参考解析
解析:
暂无解析
更多 “单选题You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME = ’JOB_A’, ATTRIBUTE = ’JOB_PRIORITY’, VALUE = 7); END; / After analyzing the above code, what conclusion will you draw?()A The code will be executed successfully.B The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.C The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.D The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.” 相关考题
考题
Which traversal method for a binary tree does the following Pascal code illustrate? Procedure traverse(p:pointer); Begin IfpNIL Then begin Traverse (p^.left); Process(p); Traverse(p^.right) End; End_A.pre_orderB.middle_orderC.noneD.last_order
考题
Which traversal method for a binary tree does the following Pascal code illustrate? procedure traverse (p:pointer); begin if pnil then begin traverse(p ↑ .left); process(p); traverse(p ↑ .right); end end;A.preorderB.postorderC.reorderD.inorder
考题
You executed the following command to perform a backup of the USERS tablespace: SQL ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error()A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.
考题
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a page that contains the following code fragment: You write the following code segment in the code-behind file for the page: void BindData(object sender, EventArgs e) { lstLanguages.DataSource = CultureInfo.GetCultures(CultureTypes.AllCultures); lstLanguages.DataTextField = "EnglishName"; lstLanguages.DataBind(); } You need to ensure that the lstLanguages ListBox control maintains the selection of the user during postback. Which line of code should you insert in the constructor of the page?()A、this.Init += new EventHandler(BindData); B、this.PreRender += new EventHandler(BindData); C、lstLanguages.PreRender += new EventHandler(BindData); D、lstLanguages.SelectedIndexChanged += new EventHandler(BindData);
考题
You work as an application developer at Certkiller .com. Certkiller .com wants you to develop an application that stores and retrieves client information by means of a unique account number.You create a custom collection class, which implements the IDictionary interface,named ClientDictionary. The following code have been included into the new application. //Create Client objects Client c1 = new Client ("AReid", "Andy Reid", Status.Current); Client c2 = new Client ("DAustin", "Dean Austin", Status.New); //Create ClientDictionary object IDictionary cData = new ClientDictionary (); cData.Add ("10001", c1); cData.Add ("10002", c2); You use the same method to add other Client objects to the collection. You need to ensure that you are able to retrieve client information associated with the account number 10111.What should you do?()A、 Use the following code: Client foundClient;foundClient = (Client) cData.Find ("10111"); B、 Use the following code: Client foundClient;if (cData.Contains ("10111")) foundClient = cData ["10111"]; C、 Use the following code: Client foundClient;if (cData.Contains ("10111"))foundClient =(Client) cData ["10111"]; D、 Use the following code: Client foundClient;foreach (string key in cData.Keys {if (key == "10111")foundClient = (Client) cData.Values ["10111"]; }
考题
You accepted the recommended SQL Profile by executing the following code: DECLARE sqlprofile_name varchar2(30); BEGIN sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE( task_name = ’my_task’, profile_name = ’my_profile’); END; Which advisor will analyze this profile?() A、 SQL Access AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor
考题
Consider the following code snippet: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( name = ,,lne_job1, attribute = ,,job_priority, value = 1); END; / If this code were executed, which of the following statements would be true?()A、 The priority of the lne_job1 job would be set to 1.B、 The lne_job1 job would be executed synchronously.C、 The lne_job1 job would run immediately in the users current session.D、 The lne_job1 job would retain its current priority.E、 The job will immediately take priority over all running jobs.
考题
You executed the following code: SQL CERATE TABLE COUNTRY (COUNTRY_ID CHAR(2) CONSTRAINT COUNTRY_ID_nn NOT NULL, COUNTRY_NAME VARCHAR2(20), CURRENCY_NAME VARCHAR2(20), CONSTRAINT COUNTRY_ID_PK PRIMARY KEY (COUNTRY_ID)) ORGANIZATION INDEX; Which types of tables will be created automatically?()A、 journal tableB、 clustered tableC、 mapping tableD、 partitioned table
考题
Where can you add your own PL/SQL code in relation-handling triggers?()A、Before the "End default relation program section" comment. B、After the "Begin default relation program section" comment. C、Before the "Begin default relation program section" comment. D、It is not possible to modify the relation-handling code that Forms automatically creates for relations.
考题
You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME = ’JOB_A’, ATTRIBUTE = ’JOB_PRIORITY’, VALUE = 7); END; / After analyzing the above code, what conclusion will you draw?() A、 The code will be executed successfully.B、 The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
考题
You issued the following block of code: SQLBEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP( ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE); END; SQL/ Which option is NOT a result of executing the above code?() A、 The switch privilege is granted to the PROG_ROLE role.B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.C、 The users cannot grant the switch privilege to other users.D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.
考题
You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?() A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
考题
You create a Web page named TestPage.aspx and a user control named TestUserControl.ascx. TestPage.aspx uses TestUserControl.ascx as shown in the following line of code. On TestUserControl.ascx, you need to add a read-only member named CityName to return the value "New York". You also must add code to TestPage.aspx to read this value. Which two actions should you perform?()A、Add the following line of code to the TestUserControl.ascx.cs code-behind file. public string CityName { get { return "New York"; } } B、Add the following line of code to the TestUserControl.ascx.cs code-behind file. protected readonly string CityName = "New York"; C、Add the following code segment to the TestPage.aspx.cs code-behind file. protected void Page_Load(object sender, EventArgs e) { string s = testControl.CityName; } D、Add the following code segment to the TestPage.aspx.cs code-behind file. protected void Page_Load(object sender, EventArgs e) { string s = testControl.Attributes["CityName"]; }
考题
You work as an application developer at Certkiller .com. Certkiller .com has instructed you to create a class named MetricFormula. This class will be used to compare MetricUnit and EnglishUnit objects.The MetricFormula is currently defined as follows (Line numbers are used for reference purposes only): 1. public class MetricFormula2. { 3. 4. } You need to ensure that the MetricFormula class can be used to compare the required objects. What should you do? ()A、 Add the following code on line 1: : IComparable {B、 Add the following code on line 1: : IComparer {C、 Add the following code on line 3: public int Compare (object x, object y) {// implementation code }D、 Add the following code on line 3: public int CompareTo (object obj) {// implementation code }
考题
You are developing a Windows Communication Foundation (WCF) service to replace an existing ASMX Web service.The WCF service contains the following code segment. (Line numbers are included for reference only.) 01 [ServiceContract( )] 02 03 public interface IEmployeeService 04 { 05 [OperationContract( )] 06 EmployeeInfo GetEmployeeInfo(int employeeID); 07 08 } 09 10 public class EmployeeService : IEmployeeService 11 { 12 13 public EmployeeInfo GetEmployeeInfo(int employeeID) 14 { 15 ... 16 } 17 } 18 19 20 public class EmployeeInfo 21 { 22 ... 23 public int EmployeeID { get; set; } 24 public string FirstName { get; set; } 25 public string LastName { get; set; } 26 27 }The existing Web service returns the EmployeelD as an attribute of the Employeelnfo element in the response XML.You need to ensure that applications can consume the service without code changes in the client. What should you do?()A、Insert the following code at line 02. [DataContractFormat()] Insert the following code at line 22. [DataMember()]B、Insert the following code at line 02. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAtttibute()]C、Insert the following code at line 09. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAttribute()]D、Insert the following code at line 19. [DataContractFormat()] Insert the following code at line 22. [DataMember()]
考题
You use the following declaration to add a Web user control named TestUserControl.ascx to an ASP.NET page named TestPage.aspx. You add the following code to the code-behind file of TestPage.aspx. private void TestMethod(){ ...}You define the following delegate. public delegate void MyEventHandler(); You need to add an event of type MyEventHandler named MyEvent to TestUserControl.ascx and attach the page’s TestMethod method to the event. Which two actions should you perform?()A、Add the following line of code to TestUserControl.ascx.cs. public event MyEventHandler MyEvent;B、Add the following line of code to TestUserControl.ascx.cs. public MyEventHandler MyEvent;C、Replace the TestUserControl.ascx reference in TestPage.aspx with the following declaration. uc:TestUserControl ID="testControl" runat="server" OnMyEvent="TestMethod"/D、Replace the TestUserControl.ascx reference in TestPage.aspx with the following declaration. uc:TestUserControl ID="testControl" runat="server" MyEvent="TestMethod"/
考题
单选题To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,’TASK1’); END; / BEGIN dbms_advisor.set_task_parameter(’TASK1’,’ANALYSIS_SCOPE’,’ALL’); dbms_advisor.set_task_parameter(’TASK1’,’MODE’,’COMPREHENSIVE’); END; / BEGIN dbms_advisor.execute_task(’TASK1’); dbms_output.put_line(dbms_advisor.get_task_script(’TASK1’)); END; / The blocks of code execute successfully;however,you do not get the required outcome. What could be the reason?()A
A template needs to be associated with the task.B
A workload needs to be associated with the task.C
The partial or complete workload scope needs to be associated with the task.D
The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
考题
单选题You are creating an ASP.NET Web site. The site has a master page named Custom.master. The code-behind file for Custom.master contains the following code segment.Partial Public Class Custom Inherits System.Web.UI.MasterPagePublic Property Region As String Protected Sub Page_Load(ByVal sender As Object,ByVal e As System.EventArgs) Handles Me.LoadEnd SubEnd Class You create a new ASP.NET page and specify Custom.master as its master page.You add a Label control named lblRegion to the new page. You need to display the value of the master pages Region property in lblRegion.What should you do? ()A
Add the following code segment to the Page_Load method of the page code-behind file. Dim custom As Custom = Me.Parent lblRegion.Text = custom.RegionB
Add the following code segment to the Page_Load method of the page code-behind file. Dim custom As Custom = Me.Master lblRegion.Text = custom.RegionC
Add the following code segment to the Page_Load method of the Custom.Master.vb code-behind file. Dim lblRegion As Label = Page.FindControl(lblRegion) lblRegion.Text = Me.RegionD
Add the following code segment to the Page_Load method of the Custom.Master.vb code-behind file. Dim lblRegion As Label = Master.FindControl(lblRegion) lblRegion.Text = Me.Region
考题
单选题You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?()A
The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.B
The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C
The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.D
The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
考题
单选题Where can you add your own PL/SQL code in relation-handling triggers?()A
Before the End default relation program section comment. B
After the Begin default relation program section comment. C
Before the Begin default relation program section comment. D
It is not possible to modify the relation-handling code that Forms automatically creates for relations.
考题
单选题You issued the following block of code: SQLBEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP( ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE); END; SQL/ Which option is NOT a result of executing the above code?()A
The switch privilege is granted to the PROG_ROLE role.B
The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.C
The users cannot grant the switch privilege to other users.D
The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.
考题
单选题You executed the following command to perform a backup of the USERS tablespace:SQL ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error()A
The MTTR Advisor is disabled.B
The database is in NOARCHIVELOG mode.C
The tablespace is already in backup mode.D
The Flash Recovery Area is not configured
考题
单选题You have created a resource plan, DAY. You execute the following code: SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE ( PLAN = ’DAY’, COMMENT = ’DEPARTMENTS PLAN’, GROUP_OR_SUBPLAN = ’DEPARTMENTS’, CPU_P1=0); END; Then, you issue the following code: SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE ( PLAN = ’DAY’, COMMENT = ’DEPARTMENTS PLAN’, GROUP_OR_SUBPLAN = ’DEVELOPERS’, CPU_P2=100); END; What will be the impact of executing the above code?()A
The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B
The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C
The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D
The second code will not execute because one resource plan cannot be used by more than one subplan.
考题
单选题Consider the following code snippet: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( name = ,,lne_job1, attribute = ,,job_priority, value = 1); END; / If this code were executed, which of the following statements would be true?()A
The priority of the lne_job1 job would be set to 1.B
The lne_job1 job would be executed synchronously.C
The lne_job1 job would run immediately in the users current session.D
The lne_job1 job would retain its current priority.E
The job will immediately take priority over all running jobs.
考题
单选题You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME = ’JOB_A’, ATTRIBUTE = ’JOB_PRIORITY’, VALUE = 7); END; / After analyzing the above code, what conclusion will you draw?()A
The code will be executed successfully.B
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.C
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.D
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
考题
单选题You created the ORDERS table in your database by using the following code: SQL CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE); Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’); SQL INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’); SQL COMMIT; Next, you issued the following statement to change the time zone for the database: SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’; What will be the result of executing the above statement?()A
The statement will fail.B
The statement will be executed successfully, and the new time zone will be set for the database.C
The statement will be executed successfully, but the new time zone will be set for the current session.D
The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
考题
多选题You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later you are asked to retrieve information from this application domain, which is the current application domain. What can you do to achieve this objective?()AUse the following code: AppDomain appInfo = ApplicationDomain.Current;BUse the following code: AppDomain appInfo = AppDomain.CurrentDomain ();CUse the following code: AppDomain appInfo = Thread.GetDomain ();DUse the following code: AppDomain appInfo = MainThread.GetDomain ();
考题
单选题You work as an application developer at Certkiller .com. You have recently created a multithreaded application to manage Certkiller .com’s inventory system. The fulfillment task has to be executed on a regular basis, while other tasks are performed in the application. The task does not need any input to start. You are required to create and start the fulfillment thread using the appropriate code.What code should you use?()A
AB
BC
CD
D
热门标签
最新试卷