单选题Evaluate the following block of code： BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL （ acl = ’mycompany-com-permissions.xml’， principal = ’ACCT_MGR’， is_grant = TRUE， privilege = ’connect’）； DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL （ acl = ’mycompany-com-permissions.xml’， host = ’*.mycompany.com’）； END； What is the outcome of the above code？（）A It produces an error because a fully qualified host name needs to be specified.B It produces an error because the range of ports associated with the hosts has not been specified.C It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.D It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
单选题
Evaluate the following block of code： BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL （ acl => ’mycompany-com-permissions.xml’， principal => ’ACCT_MGR’， is_grant => TRUE， privilege => ’connect’）； DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL （ acl => ’mycompany-com-permissions.xml’， host => ’*.mycompany.com’）； END； What is the outcome of the above code？（）
A
It produces an error because a fully qualified host name needs to be specified.
B
It produces an error because the range of ports associated with the hosts has not been specified.
C
It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D
It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
参考解析
解析：
暂无解析
相关考题：
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
Evaluate the following block of code:What is the outcome of the above code?() A. It produces an error because a fully qualified host name needs to be specified.B. It produces an error because the range of ports associated with the hosts has not been specified.C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
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
Which expressions will evaluate to true if preceded by the following code？（） String a = "hello"； String b = new String（a）； String c = a； char[] d = { ’h’， ’e’， ’l’， ’l’， ’o’ }； A、（a == "Hello"）B、（a == b）C、（a == c）D、a.equals（b）E、a.equals（d）
You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted， but only once. Which three are possible mechanisms for performing this initialization code？（）A、In the init method.B、In the jspInit method.C、In the constructor of the JSP’s Java code.D、In a JSP declaration， which includes an initializer block.E、In a JSP declaration， which includes a static initializer block.
Which of the following will begin a new unit of work?（）A、The CONNECT statementB、The first FETCH of a cursorC、The BEGIN TRANSACTION statementD、The first executable SQL statement
Given that a static method doIt（） in a class Work represents work to be done， what block of code will succeed in starting a new thread that will do the work？ CODE BLOCK a： Runnable r = new Runnable（） { public void run（） { Work.doIt（）； } }； Thread t = new Thread（r）； t.start（）； CODE BLOCK b： Thread t = new Thread（） { public void start（） { Work.doIt（）； } }； t.start（）； CODE BLOCK c： Runnable r = new Runnable（） { public void run（） { Work.doIt（）； } }； r.start（）； CODE BLOCK d： Thread t = new Thread（new Work（））； t.start（）； CODE BLOCK e： Runnable t = new Runnable（） { public void run（） { Work.doIt（）； } }； t.run（）； A、Code block a.B、Code block B.C、Code block c.D、Code block d.E、Code block e.
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.
Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（） A、 It creates a task and workload， and executes the task.B、 It creates a task and workload but does not execute the task.C、 It produces an error because a template has not been created.D、 It produces an error because the SQL Tuning Set has not been created.
You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
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 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 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.
单选题In your web application，you need to execute a block of code whenever the session object is first created. Which design will accomplish this goal？（）ACreate an HttpSessionListener class and implement the sessionInitialized method with that block ofcode.BCreate an HttpSessionActivationListener class and implement the sessionCreated method with thatblock of code.CCreate a Filter class， call the getSession（false） method， and if the result was null， then execute that block of code.DCreate an HttpSessionListener class and implement the sessionCreated method with that block of code.
单选题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.
单选题What is wrong with the following code？（） class MyException extends Exception {} public class Qb4ab { public void foo（） { try { bar（）； } finally { baz（）； } catch （MyException e） {} } public void bar（） throws MyException { throw new MyException（）； } public void baz（） throws RuntimeException { throw new RuntimeException（）； } }ASince the method foo（） does not catch the exception generated by the method baz（）， it must declare the RuntimeException in its throws clause.BA try block cannot be followed by both a catch and a finally block.CAn empty catch block is not allowed.DA catch block cannot follow a finally block.EA finally block must always follow one or more catch blocks.
多选题You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted， but only once. Which three are possible mechanisms for performing this initialization code？（）AIn the init method.BIn the jspInit method.CIn the constructor of the JSP’s Java code.DIn a JSP declaration， which includes an initializer block.EIn a JSP declaration， which includes a static initializer block.
单选题Given that a static method doIt（） in a class Work represents work to be done， what block of code will succeed in starting a new thread that will do the work？ CODE BLOCK a： Runnable r = new Runnable（） { public void run（） { Work.doIt（）； } }； Thread t = new Thread（r）； t.start（）； CODE BLOCK b： Thread t = new Thread（） { public void start（） { Work.doIt（）； } }； t.start（）； CODE BLOCK c： Runnable r = new Runnable（） { public void run（） { Work.doIt（）； } }； r.start（）； CODE BLOCK d： Thread t = new Thread（new Work（））； t.start（）； CODE BLOCK e： Runnable t = new Runnable（） { public void run（） { Work.doIt（）； } }； t.run（）；ACode block a.BCode block B.CCode block c.DCode block d.ECode block e.
单选题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.
单选题You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY BEGIN TRANSACTION DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY BEGIN CATCH DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH； You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）AAdd a COMMIT TRANSACTION command to the CATCH block.BRemove the COMMIT TRANSACTION command from the TRY block.CAdd a ROLLBACK TRANSACTION command to the CATCH block.DAdd a ROLLBACK TRANSACTION command to the TRY block.
单选题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 expressions will evaluate to true if preceded by the following code？（） String a = "hello"； String b = new String（a）； String c = a； char[] d = { ’h’， ’e’， ’l’， ’l’， ’o’ }；A（a == Hello）B（a == b）C（a == c）Da.equals（b）Ea.equals（d）
单选题You are integrating a Windows Communication Foundation (WCF) service within an enterprise-wide Service Oriented Architecture (SOA).Your service has the following service contract: [ServiceContract]public class CreditCardConfirmationService { [OperationContract] boolean ConfirmCreditCard(string ccNumber); double OrderAmount(int orderNumber);} You need to allow the code in the ConfirmCreditCard method to participate automatically in existing transactions.If there is no existing transaction, a new transaction must be created automatically. What should you do?（）AInside the ConfirmCreditCard method, surround the code that must participate in the transaction with a using(new TransactionScope()) block.BInside the ConfirmCreditCard method, surround the code that must participate in the transaction with a using(new CommittableTransaction()) block.CAdd an [OperationBehavior(TransactionScopeRequired=true)] attribute to the ConfirmCreditCard method.DAdd an [OperationBehavior(TransactionAutoComplete=true)] attribute to the ConfirmCreditCard method.
单选题Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（）A It creates a task and workload， and executes the task.B It creates a task and workload but does not execute the task.C It produces an error because a template has not been created.D It produces an error because the SQL Tuning Set has not been created.