开发一个简单的网络考试系统测试题.doc

开发一个简单的网络考试系统一 需求简述：神东公司需要开发一套应用于网络考试的系统，要求做到可以随机抽题，多客户端并发访问时保证每一套题题量相同，但题目组成不同；考试过程中，刷新页面时，考试题组成内容不变，即每个客户端在考试期间的题目是持久化的；答题完成后，可通过点击“交卷”按钮直接提交考试结果，并马上自动阅卷并将阅卷结果输出，供考试者参考。二 数据库设计 数据库名称：NetExam 数据表（） 试题表：Question字段名中文含义数据类型约束qId题号int主键、标识列question题目nvarchar(2000)非空score分数int非空answer正确答案char(1)非空（） 选项表：Options字段名中文含义数据类型约束id编号int主键、标识列qId题号int非空，外键code选项代码char(1)非空opt选项nvarchar(200)非空 往试题表中插入测试数据（26条记录）insert into Question values(NLS_CHARSET_NAME returns the name of the NLS character set corresponding to ID number number. shendong 神东集团,The character set name is returned as a VARCHAR2 value in the database character set. If number is not recognized as a valid character set ID, this function returns null. ,2,A)insert into Question values(UNLESS OTHERWISE SPECIFICALLY DEFINED WITHIN THIS AGREEMENT, THIS LIMITED WARRANTY IS THE ONLY WARRANTY PROVIDED BY QUEST AND ITS LICENSORS EXPRESSLY DISCLAIM ALL OTHER WARRANTIES, EITHER EXPRESSED OR IMPLIED, 知识改变未来，梦想成就未来 INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE SOFTWARE AND ACCOMPANYING WRITTEN MATERIALS.,2,B)insert into Question values(Year 2000 Readiness. Quest warrants and represents that the Software is Year 2000 Ready. Year 2000 Ready means that the Software has the ability to (i) accept input and provide output of data involving dates correctly and without ambiguity as to the twentieth or twenty-first centuries; (ii) manage, store, manipulate, sort, sequence, and perform calculations (collectively process) with respect to data involving dates before, during, and after January 1, 2000 (including single century or multi-century date formulas) without malfunction or aborts; and (iii) correctly process leap years including the year 2000, provided that all other products (e.g., hardware, software, and firmware) used with the Software properly exchange date data with it. Functional errors will be accepted as problems and resolved only for customers with active maintenance support according to Quest抯standard maintenance policies. Quest抯entire liability and Licensee抯sole and exclusive remedy under this Paragraph 8 shall be repair o,2,D)insert into Question values(Limitation of Remedies and Damages. IN NO EVENT WILL QUEST, ITS SUBSIDIARIES OR ANY OF THE LICENSORS, DIRECTORS, OFFICERS, EMPLOYEES OR AFFILIATES OF ANY OF THE FOREGOING BE LIABLE TO LICENSEE WITH RESPECT TO ANY SUBJECT MATTER OF THIS AGREEMENT UNDER ANY CONTRACT, NEGLIGENCE, STRICT LIABILITY OR OTHER LEGAL OR EQUITABLE THEORY FOR ANY CONSEQUENTIAL, INCIDENTAL, INDIRECT OR SPECIAL DAMAGES WHATSOEVER (INCLUDING, BUT NOT LIMITED TO, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION AND THE LIKE), WHETHER FORESEEABLE OR UNFORESEEABLE, OR FOR COST OF PROCUREMENT OF SUBSTITUTE GOODS, TECHNOLOGY OR SERVICES, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE OR ACCOMPANYING WRITTEN MATERIALS, REGARDLESS OF THE BASIS OF THE CLAIM AND EVEN IF QUEST OR A QUEST REPRESENTATIVE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. QUEST扴LIABILITY TO LICENSEE FOR DAMAGES FOR ANY CAUSE WHATSOEVER, AND REGARDLESS OF THE FORM OF THE ACTION, WILL BE LIMITED TO NO GREATER THAN ,2,C)insert into Question values(THE AMOUNT OF MONEY PAID TO QUEST FOR THE SOFTWARE THAT CAUSED THE DAMAGES. NO ACTION MAY BE BROUGHT AGAINST QUEST LATER THAN ONE YEAR FROM THE TERMINATION OF THIS AGREEMENT.,2,A)insert into Question values(BFILENAME returns a BFILE locator that is associated with a physical LOB binary file on the servers file system. A directory is an alias for a full pathname on the servers file system where the files are actually located, and filename is the name of the file in the servers file system.,2,A)insert into Question values(The COALESCE function returns the first non-null expr in the expression list. At least one expr must not be the literal NULL. If all occurrences of expr evaluate to null, the function returns null. This function is a generalization of the NVL function.,2,C)insert into Question values(Translates expr to a return value. If expr equals value1, function returns Return1. If expr equals value2, function returns Return2. Etc. If expr does not equal any Value in the list, the default value is returned.,2,D)insert into Question values(DUMP returns a VARCHAR2 value containing the datatype code, length in bytes, and internal representation of expr. The returned result is always in the database character set.,2,C)insert into Question values(EMPTY_BLOB returns an empty LOB locator that can be used to initialize a LOB variable or in an INSERT or UPDATE statement to initialize a LOB column or attribute to EMPTY. EMPTY means that the LOB is initialized, but not populated with data.,2,D)insert into Question values(EMPTY_CLOB returns an empty LOB locator that can be used to initialize a LOB variable or in an INSERT or UPDATE statement to initialize a LOB column or attribute to EMPTY. EMPTY means that the LOB is initialized, but not populated with data.,2,A)insert into Question values(NLS_CHARSET_ID returns the NLS character set ID number corresponding to NLS character set name text. The text argument is a run-time VARCHAR2 value. The text value CHAR_CS returns the database character set ID number of the server. The text value NCHAR_CS returns the national character set ID number of the server.,2,B)insert into Question values(NLS_CHARSET_DECL_LEN returns the declaration width (in number of characters) of an NCHAR column. The byte_count argument is the width of the column. The char_set_id argument is the character set ID of the column.,2,A)insert into Question values(NLS_CHARSET_NAME returns the name of the NLS character set corresponding to ID number number. The character set name is returned as a VARCHAR2 value in the database character set. If number is not recognized as a valid character set ID, this function returns null. ,2,D)insert into Question values(The NULLIF function compares expr1 and expr2. If they are equal, the function returns null. If they are not equal, the function returns expr1. You cannot specify the literal NULL for expr1.,2,D)insert into Question values(If expr1 is not null, NVL2 returns expr2. If expr1 is null, NVL2 returns expr3. The argument expr1 can have any datatype. The arguments expr2 and expr3 can have any datatypes except LONG.,2,C)insert into Question values(If expr1 is not null, NVL2 returns expr2. If expr1 is null, NVL2 returns expr3. The argument expr1 can have any datatype. The arguments expr2 and expr3 can have any datatypes except LONG.,2,D)insert into Question values(SYS_CONTEXT returns the value of attribute associated with the context namespace. You can use this function in both SQL and PL/SQL statements.,2,B)insert into Question values(SYS_GUID generates and returns a globally unique identifier (RAW value) made up of 16 bytes. On most platforms, the generated identifier consists of a host identifier and a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.,2,D)insert into Question values(PLEASE READ THIS SOFTWARE LICENSE AGREEMENT CAREFULLY. BY INSTALLING OR USING THIS SOFTWARE, YOU INDICATE ACCEPTANCE OF AND AGREE TO BECOME BOUND BY THE TERMS AND CONDITIONS OF THIS LICENSE. IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT INSTALL OR USE THIS SOFTWARE AND PROMPTLY RETURN IT TO QUEST SOFTWARE.,2,D)insert into Question values(This agreement is made between Quest Software, Inc. (hereafter referred to as Quest) and you, the customer, (hereafter referred to as LICENSEE). For the purpose of this agreement, the purchased computer software program(s) and supporting documentation will be referred to as the Software.,2,A)insert into Question values(License. Subject to the terms and conditions of this Agreement, the Software listed on the applicable Order Form is licensed, not sold, to Licensee by Quest for the fees as outlined on said form. By using the Software you represent and warrant that you are not located in, under control of, or a national or resident of any country outside of the jurisdiction of the laws of the United States of America. The License granted hereunder shall be perpetual, non-exclusive, and non-sublicensable, and is defined as Licensee抯right to:,2,B)insert into Question values(Restrictions. Quest reserves any rights not expressly granted to Licensee and retains title and full ownership rights under the copyright laws of the United States or any other jurisdiction or under any federal, state, or foreign laws. Quest is not obligated to provide and Licensee acquires no right of any kind with respect to any source code for the Software. Licensee agrees that it has no right whatsoever to modify the Software or any portion thereof in any manner. Licensee shall not, nor permit any third party to reverse engineer, decompile, disassemble or otherwise reduce the Software to any other humanly perceivable form, and may not modify, adapt, rent, lease, loan or create derivative works based upon the Software or any part thereof.,2,C)insert into Question values(Export Law Assurances. Licensee shall not export or re-export, or allow the export or re-export of the Software or any copy, portion or direct product of the foregoing, in violation of any export laws, restrictions, national security controls or regulations of the United States or other applicable foreign agency or authority, without all required licenses and proper authorizations, to Cuba, Libya, North Korea, Iran, Iraq, or Rwanda or to any Group D:1 or E:2 country (or any national of such country) specified in the then current Supplement No. 1 to Part 740 of the U.S. Export Administration Regulations (or any successor supplement or regulations).Notwithstanding the foregoing, Licensee may export or re-export the Software between the United States and Canada, provided Licensee抯principle place of business is in North America.,2,D)insert into Question values(Maintenance. During any Maintenance Period and for the fees as outlined on the applicable Order Form, Quest shall provide the maintenance services as listed in this Paragraph 8. Maintenance Period shall be defined as the one (1) year period beginning on the date of the first invoice for the Software or from the conclusion of any previous Maintenance Period, provided Licensee is current on all fees due. Quest shall invoice Licensee annually for the maintenance fees. Either party may elect not to renew maintenance services by terminating maintenance in writing, in which case Quest will no longer be responsible for providing maintenance. Payment of any and all past maintenance fees, plus a re-instatement fee of 25% of the annual maintenance fee, shall be required before maintenance will be reinstated after it has lapsed. Maintenance services shall include the following,2,A)insert into Question values(Limited Warranty. Quest warrants that it or its licensors retain(s) all intellectual proper