ࡱ>  [ Ybjbj 4*ΐΐxQ  UUUUUiii8ei({{{$HFAU{YY"{{AUUHV+++{UU+{++B-BnŠ#iKfl0W00&0U{{+{{{{{AA{{{{{{{0{{{{{{{{{ :  SQL Server Interview Questions 1. Explain the use of WITH ENCRYPTION keyword. Create a store procedure with encryption. It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets modified and once it is encrypted then it is not possible to get original text of the stored procedure from stored procedure itself. CREATE PROCEDURE abc WITH ENCRYPTION AS << SELECT statement>> GO 2. What is a linked server in SQL Server? It enables SQL server database engine to execute commands against OLE DB data source. It allows the remote server access and has the ability to issue distributed queries, updates, commands and transactions. 3. What are the features and concepts of Analysis Services? Analysis Services is a middle tier server of OLAP (online analytical processing) and Data mining. It manages multidimensional cubes of data and provides access to the heaps of information including the aggregation of data which can create data mining models from data sources and use it for business intelligence. Some of the key features are: Ease of use with a lot of wizards and designers. Flexible data model creation and management. Scalable architecture to handle OLAP. Provides integration of administration tools, data sources, security, caching, and reporting etc. Provides extensive support for custom applications. 4. What is analysis service repository? Every analysis server has a repository to store metadata for the objects like cubes, data sources etc. It is by default stored in a MS-Access database which can be also migrated to a SQL Server database. 5. What is SQL service broker? Service broker allows internal and external processes to send and receive guaranteed asynchronous messages. Messages can also be sent to remote servers that are hosting databases as well. The concept of queues is used by the broker to put a message in a queue and continue with other applications asynchronously. This enables client applications to process messages at their leisure without blocking the broker. Service Broker uses the concepts of message ordering, coordination, multithreading and receiver management to solve some major message queuing problems. It allows for loosely coupled services for database applications. 6. What are the user defined data types and when are they used? User defined data types are based on the system data types. They should be used when multiple tables need to store the same type of data in a column and you need to ensure that all these columns are exactly the same including length, and nullability. Parameters for user defined data type: Name: System data type on which user defined data type is based upon. Nullability: For example, a user-defined data type called post_code that could be created based on char system data type. 7. What is a bit data type? A bit data type is an integer data type which can store either a 0 or 1 or null value. 8. Describe the XML support SQL server extends. The SQL Server (server-side) support has 3 major elements are as follows: Creation of XML fragments: This is done from the relational data using FOR XML to the select query. Ability to shared XML data to be stored in the database. Finally, storing the XML data. Client-side XML support in SQL Server is in the form ofSQLXML. It can be described in terms of: XML Views: Providing bidirectional mapping between XML schemas and relational tables. Creation of XML Templates: It allows creation of dynamic sections in XML. 9. What is SQL Server English Query? English query allows accessing the relational databases through English Query applications. Such applications permit the users to ask the database to fetch the data which is based on simple English instead of using SQL statements. 10. What is the purpose of SQL Profiler in SQL server? SQL profiler is a tool which monitors the performance of various stored procedures. It is used to debug the queries and procedure which is based on the performance. It identifies the slow executing queries. If there is any problem, then it captures the events on the production environment so that they can be solved. 11. What is XPath? XPathis an expression to select the xml node in an XML document. It allows the navigation on the XML document to the straight element where we need to reach and access the attributes. 12. What are the authentication modes in SQL Server? Windows Authentication Mode(Windows Authentication): It uses user windows account. Mixed Mode (Windows Authentication and SQL Server Authentication): It uses either windows or SQL server. 13. Explain Data Definition Language (DDL), Data Control Language (DCL) and Data Manipulation Language (DML). Data Definition Language (DDL) -It defines the database structure. Example: CREATE: It is used to create a table in a database. ALTER: It is used to add, delete or modify columns in an existing table. DROP: It is used to remove a table definition and all the data, indexes, triggers, constraints, and permission specifications for that table. (Note: You have to be careful while using this command because once a table is deleted then all the information available in the table would also be lost forever.) TRUNCATE: This command is used to delete complete data from an existing table. COMMENT: It adds comment to the table, view or column-level data dictionary objects. RENAME: It is used to rename a table. Data Manipulation Language(DML) It is used for manipulate or edit the data. Example: SELECT Retrieve data from the database. INSERT Insert data into the table. UPDATE Modify the existing data within a table. DELETE It is used to delete data from a table. This command can also be used with condition to delete a particular row. MERGE It is used to select rows from one or more sources for update or insertion into a table or view. You can specify conditions to determine whether to update or insert into the target table or view. CALL It calls a PL/SQL or Java subprogram. EXPLAIN PLAN These statements are supported in PL/SQL only when executed dynamically. LOCK TABLE Control concurrency. Data Control Language(DCL) - These statements to take care of the security and authorization. It is used to create privileges to allow users access and manipulation of the database. Examples: GRANT To grant a privilege to a user. REVOKE To revoke (remove) a privilege from a user. 14. What are the steps to process a single SELECT statement? Steps: The select statement is broken into logical units. A sequence tree is built and it is based on the keywords and expressions in the form of the logical units. Query optimizer checks for various permutations and combinations to figure out the fastest way of using minimum resources to access the source tables. The best found way is called as an execution plan. Relational engine executes the plan and process the data 15. Explain GO Command. It is a signal command which is used to execute the entire batch of SQL statements after previous Go command. 16. What is the significance of NULL value and why should it be avoided for permitting null values? NULL value means that no entry has been made into the column. It states that the corresponding value is either unknown or undefined and it is different from zero (0) or " ". They should be avoided for the complexity in select & update queries and also because columns which have constraints like primary or foreign key constraints which cannot contain a NULL value. 17. What is the difference between UNION and UNION ALL? UNION: It selects only distinct values. Syntax: SELECT column_names FROM table_name1 UNION SELECT column_names FROM table_name2 UNION ALL: It selects all values and not just distinct ones. Syntax: SELECT column_names FROM table_name1 UNION ALL SELECT column_names FROM table_name2 18. What is the use of DBCC Commands? DBCC (Database Consistency Checker) acts as a database console commands for SQL Server to check database consistency. They are grouped as: Maintenance Miscellaneous Informational Validation Maintenance: Maintenance tasks on a database, file group, index. Maintenance Commands: DBCC CLEANTABLE DBCC INDEXDEFRAG DBCC DBREINDEX DBCC SHRINKDATABASE DBCC DROPCLEANBUFFERS DBCC SHRINKFILE DBCC FREEPROCCACHE DBCC UPDATEUSAGE Miscellaneous: Miscellaneous tasks such as enabling trace flags or removing DLL file from memory. Miscellaneous Commands: DBCC dllname DBCC HELP DBCC FREESESSIONCACHE DBCC TRACEOFF DBCC FREESYSTEMCACHE DBCC TRACEON Informational: Informational tasks that gather and display various types of information. Informational Commands: DBCC INPUTBUFFER DBCC SHOWCONTIG DBCC OPENTRAN DBCC SQLPERF DBCC OUTPUTBUFFER DBCC TRACESTATUS DBCC PROCCACHE DBCC USEROPTIONS DBCC SHOW_STATISTICS Validation: Validation operations on a database, index, table, catalog etc. Validation Commands: DBCC CHECKALLOC DBCC CHECKFILEGROUP DBCC CHECKCATALOG DBCC CHECKIDENT DBCC CHECKCONSTRAINTS DBCC CHECKTABLE DBCC CHECKDB 19. What is Log shipping? Log shipping defines the process for automatically taking backup of the database and transaction files on a SQL Server and then restoring them on a standby/backup server. This keeps the two SQL Server instances in sync with each other. In case the production server fails, user simply needs to be pointed to the standby/backup server. Log shipping primarily consists of 3 operations: Backup transaction logs of the production server. Copy these logs on the standby/backup server. Restore the log on standby/backup server. 20. What is the difference between a Local and a Global temporary table? Temporary tables are used to allow short term use of the data in SQL Server. They are of two types: Local temporary table Global temporary table. Local temporary tableGlobal temporary tableIt is only available to the current database connection for the current user.Global temporary table is available to any connection once it is created. They are cleared when the connection is closed.They are cleared when the last connection is closed.Multiple users cannot share a local temporary table.It can be shared by multiple users. 21. What is the STUFF? And how does it differ from the REPLACE function? STUFF function: The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position. STUFF Syntax: STUFF (character_expression, start, length, replaceWith_expression) REPLACE function: The REPLACE function replaces all occurrences of a specified string value with another string value. Both STUFF and REPLACE function are used to replace the characters in a string. REPLACE Syntax: REPLACE (string_expression,string_pattern,string_replacement) 22. What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column? Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list. 23. What are the actions used to prevent once the referential integrity is enforced? Actions prevented are: Breaking of the relationship is used to prevent once the referential integrity is enforced on a database. Cannot delete a row from primary table if there are related rows in a secondary table. Cannot update primary tables primary key if row being modified has related rows in secondary table. Cannot insert a new row in the secondary table if there are not related rows in the primary table. Cannot update secondary tables foreign key if there is no related row in the primary table. 24. What are the commands available for summarizing the data in the SQL Server? Commands for summarizing data in SQL Server: CommandDescriptionSyntax/ExampleSUMReturns the total sum of a numeric value.SELECT SUM(Sal) as Tot from Table1;AVGReturns the average value of a numeric column.SELECT AVG(Sal) as Avg_Sal from Table1;COUNTReturns the number of rows of a resultset.SELECT COUNT(*) from Table1;MAXReturns the maximum value from a resultset.SELECT MAX(Sal) from Table1;MINReturns the minimum value from a resultset.SELECT MIN(Sal) from Table1;GROUP BYArrange resultset in groups.SELECT ZIP, City FROM Emp GROUP BY ZIPORDER BYIt sorts the resultsetSELECT ZIP, City FROM Emp ORDER BY City 25. List out the difference between CUBE operator and ROLLUP operator CUBE OperatorROLLUP OperatorIt is an additional switch to GROUP BY clause. It can be applied to all aggregation functions to return cross tabular resultsets.It is an extension to GROUP BY clause. It is used to extract statistical and summarized information from resultsets. It creates groupings and then applies aggregation functions on them. Produces all possible combinations of subtotal.Produces only some possible combinations of subtotal. 26. What are the guidelines to use bulk copy program (BCP) utility of SQL Server? BCP utility is an API that allows interacting with SQL Server to export/import data in one of the two data formats. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns. Bulk copy needs sufficient system credentials. Need INSERT permissions on destination table while importing. Need SELECT permissions on source table while exporting. Need SELECT permissions on sysindexes, sysobjects and syscolumns tables. 27. What are the capabilities of cursors? Capabilities of cursors: Cursor reads every row one by one. Cursors can be used to update a set of rows or a single specific row in a resultset Cursors can be positioned to specific rows. Cursors can be parameterized and hence are flexible. Cursors lock row(s) while updating them. 28. What are the ways to control the cursor behavior? There are two ways to control Cursor behavior: Cursor types: The data access APIs usually specify the behavior of cursors by dividing them into four cursor types: 1. Forward-only 2. Static 3. Keyset-driven 4. Dynamic Cursor behaviors: The keywords such as SCROLL and INSENSITIVE along with the cursor declaration define scrollability and sensitivity of the cursor. 29. What are the advantages of stored procedures? Advantages of stored procedures: They are easier to maintain and troubleshoot as they are modular. Stored procedures are enabled for better tuning of performance. Using stored procedure is much easier from a GUI end than building or using complex queries. They can be a part of separate layer which allows separating the concerns. Hence Database layer can be handled by separate developers proficient in database queries. It helps in reducing network usage. It provides more scalability to an application. Reusable and hence reduce code. 30. What are the ways to code efficient transactions? Do not ask for an input from a user during a transaction. Get all the input needed for a transaction before starting the transaction. Transaction should be atomic. Transaction should be as short and small as possible. Rollback a transaction if a user intervenes and re-starts the transaction. Transaction should involve a small amount of data as it needs to lock the number of rows involved. Avoid transactions while browsing through data. 31. What are the differences among batches, stored procedures, and triggers? BatchStored ProcedureTriggersCollection or group of SQL statements. All statements of a batch are compiled into one executional unit called execution plan. It is a collection or group of SQL statements that is compiled once but used many times.It is a type of Stored procedure that cannot be called directly. Instead it fires when a row is updated, deleted or inserted. 32. What security features are available for stored procedures? Security features for stored procedures: Grant user permission to execute a stored procedure irrespective of the related tables. Grant user permission to work with a stored procedure to access a restricted set of data yet no give them permissions to update or select underlying data. Stored procedures can be granted and execute the permissions rather than setting permissions on data itself. It provides more granular security control through the stored procedures rather than complete the control on underlying data in tables. 33. What are the instances when triggers are fire? Scenarios for using triggers: To create an audit log of database activity. To apply business rules. To apply some calculation on data from tables that is not stored in database. To enforce referential integrity. To alter the data in a third party application. To execute the SQL statements as a result of an event or condition automatically. 34. What are the restrictions applicable while creating views? Restrictions applicable while creating views: A view cannot be indexed. A view cannot be altered or renamed. Its columns cannot be renamed. To alter a view, it must be dropped and re-created. ANSI_NULLS and QUOTED_IDENTIFIER options should be turned on to create a view. All tables referenced in a view must be a part of the same database. Any user defined functions referenced in a view must be created with SCHEMABINDING option. Cannot use ROWSET, UNION, TOP, ORDER BY, DISTINCT, COUNT (*), COMPUTE, COMPUTE BY in views. 35. What are the events recorded in a transaction log? Events recorded in a transaction log: Broker event: It includes event produced by service broker. Cursor event: It includes cursor operation events. CLR event: It includes event fired by .Net CLR objects. Database event: It includes events of data.log files shrinking or growing on their own. Errors and Warning event: It includes SQL Server warnings and errors. Full text event: It includes event that has occurred when text searches are started, interrupted, or stopped. Locks event: It includes event that are caused when a lock is acquired, released, or cancelled. Object event: It includes event of database objects which is being created, updated or deleted. OLEDB event: It includes event that are caused by OLEDB calls. Performance event: It includes event that are caused by DML operators. Progress report event: It includes online index operation events. Scans event: It includes event notifying table/index scanning. Security audit event: It includes audit server activities. Server event: It includes server events. Sessions event: It includes connecting and disconnecting events of clients to the SQL Server. Stored procedures event: It includes event of execution of stored procedures. Transactions event: It includes event which is related to the transactions. T-SQL event: It includes event that are generated while executing the T-SQL statements. User configurable event: It includes user defined events. 36. Describe when checkpoints are created in a transaction log? Activities causing checkpoints are: When a checkpoint is explicitly executed. A logged operation is performed on the database. Database files have been altered using alter database command. SQL Server has been stopped explicitly or on its own. SQL Server periodically generates checkpoints. Backup of a database is taken. 37. Define Truncate and Delete commands. TRUNCATEDELETEThis is also a logged operation but in terms of deallocation of data pages.This is a logged operation for every row.Cannot TRUNCATE a table that has foreign key constraints.Any row not violating a constraint can be deleted.It resets identity column to the default starting value.It does not reset the identity column. Starts where it left from last.It removes all rows from a table.It is used to delete all or selected rows from a table based on WHERE clause.Cannot be Rolled back.Need to Commit or RollbackDDL commandDML command For more questions with answers, follow the link below:  HYPERLINK "http://www.careerride.com/SQLServer-Interview-Questions.aspx" http://www.careerride.com/SQLServer-Interview-Questions.aspx We do not warrant the correctness of content. The risk from using it lies entirely with the user. While using this document, you agree to have read and accepted the  HYPERLINK "http://www.careerride.com/Termsofuse.aspx" terms of use and privacy policy.      "#$9:;Jt+ һzzzcN9N)hfh uB*CJOJPJQJaJph)hfhB*CJOJPJQJaJph,hfhC5B*CJOJPJQJaJph,hfh u5B*CJOJPJQJaJph)hfh}"B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh'5B*CJOJPJQJaJph,hfh}"5B*CJOJPJQJaJph"#$x ' & F 2( Px 4 #\'*.25@9dgdt$ 2( Px 4 #\'*.25@9dgdt+ / ^ v x z  î홮mV?,hfhC5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh u5B*CJOJPJQJaJph)hfh`0JB* CJOJQJaJph)hfhB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfh uB*CJOJPJQJaJph)hfhB*CJOJPJQJaJph#htB*CJOJPJQJaJph  " : A G M N O P Q Z `     Y j l ծծծՙՈvdvdRAA hfhCJOJPJQJaJ#hfhC5CJOJPJQJaJ#hfh`5CJOJPJQJaJ#hfh5CJOJPJQJaJ hfh`CJOJPJQJaJ)hfh$VTB*CJOJPJQJaJph#htB*CJOJPJQJaJph)hfh}S>S>)hfh`B*CJOJPJQJaJph333)hfh~*GB*CJOJPJQJaJph333#h5uB*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph,hfh~*G5B*CJOJPJQJaJph hfh~*GCJOJPJQJaJ hfh`CJOJPJQJaJ hfhCCJOJPJQJaJ#hfh~*G5CJOJPJQJaJ#hfh`5CJOJPJQJaJ:f  vR$ 2( Px 4 #\'*.25@9dgdt & Fddd[$\$gdt & Fddd[$\$gdtddd[$\$gdt & Fdxd\$gd6 & Fddd[$\$gd6ddd[$\$gd5u$ 2( Px 4 #\'*.25@9dgd6 56>U\efprs ծooWBWB)hfh'UB*CJOJPJQJaJph333/hfh`5B*CJOJPJQJ\aJph333)hfh'U0JB*CJOJQJaJph333)hfh`0JB*CJOJQJaJph333)hfh`0JB*CJOJQJaJph333#h5u0JB*CJOJQJaJph333)hfh~*GB*CJOJPJQJaJph333)hfh`B*CJOJPJQJaJph333)h6h6B*CJOJPJQJaJph333  01TU(' & F! 2( Px 4 #\'*.25@9dgd,' & F! 2( Px 4 #\'*.25@9dgd;Y$ 2( Px 4 #\'*.25@9dgdt  01%TUez{Ӽuu`I44)hfh)?RB*CJOJPJQJaJph,hfh)?R5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph hfh)?RCJOJPJQJaJh;YCJOJPJQJaJ hfh`CJOJPJQJaJ,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh'U5B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph'(5?EFIOQ]^`dkTC hfh`CJOJPJQJaJ,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh)?R5B*CJOJPJQJaJph)hfh,B*CJOJPJQJaJph#h,B*CJOJPJQJaJph)h,h,B*CJOJPJQJaJph)hfh)?RB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph(jkl' & F" 2( Px 4 #\'*.25@9dgd,$ 2( Px 4 #\'*.25@9dgdt) & F! 2( Px 4 #\'*.25@9dxgd, .klɴs\E.E,hfh`0J5B*CJOJQJaJph,hfh)?R0J5B*CJOJQJaJph,hfh`5B*CJOJPJQJaJph,hfh)?R5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph)hfh"<B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfh)?RB*CJOJPJQJaJph hfh`CJOJPJQJaJ hfh)?RCJOJPJQJaJ:;>_`bcҽ~~gҽU@)hfhB*CJOJPJQJaJph#h}70JB*CJOJQJaJph,hfh)?R0J5B*CJOJQJaJph)hfh)?R0JB*CJOJQJaJph)hfhL.c0JB*CJOJQJaJph)hfhx0JB*CJOJQJaJph)hfh`0JB*CJOJQJaJph,hfh`0J5B*CJOJQJaJph,hfh`0J5B*CJOJQJaJphbc!tf hd`hgdt & Fdgdt dgdt$ 2( Px 4 #\'*.25@9dgdt( 2( Px 4 #\'*.25@98d^8gdt' & F# 2( Px 4 #\'*.25@9dgd}7 cgһһһҤt]H3)hfh`B*CJOJPJQJaJph333)hfh5nB*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph333/hfh5n5B*CJOJPJQJ\aJph333/hfh`5B*CJOJPJQJ\aJph333,hfhB*CJOJPJQJ\aJph333,hfh5n5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh)?R5B*CJOJPJQJaJph&(TUY[,.34վ{fվ{fվ{fWf@fWf{,hfhk45B*CJOJPJQJaJph333hfhk4CJOJQJaJ)hfhk4B*CJOJPJQJaJph333&h25B*CJOJPJQJaJph333/hfh`5>*B*CJOJPJQJaJph333,hfhzKi>*B*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph333)hfh`B*CJOJPJQJaJph333)hfhzKiB*CJOJPJQJaJph333!U uCu@ b ! & Fdd[$\$gdt & F%dxd\$gd2 d`gdt dgdt & Fdgdt & F$dxd\$^gd2 &(,<@tuz|ƯیƯw_H3)hfh+B*CJOJPJQJaJph333,hfh5n5B*CJOJPJQJaJph333/hfh`5B*CJOJPJQJ\aJph333)hfh7pB*CJOJPJQJaJph333hfh7pCJOJQJaJ&h25B*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph333)hfh`B*CJOJPJQJaJph333hfhk4CJOJQJaJ)hfhk4B*CJOJPJQJaJph333 $վzePz?(,hfhfg5B*CJOJPJQJaJph333 hfh`CJOJPJQJaJ)hfh)?RB*CJOJPJQJaJph333)hfhfgB*CJOJPJQJaJph333)hfh\B*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph333/hfh`5>*B*CJOJPJQJaJph333,hfh+>*B*CJOJPJQJaJph333)hfh`B*CJOJPJQJaJph333)hfh5nB*CJOJPJQJaJph333$'(;ABCILRSWstu{|꫔իhSDhShfhCJOJQJaJ)hfhB*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph333)hfh.:B*CJOJPJQJaJph333,hfhfg5B*CJOJPJQJaJph333)hfh`B*CJOJPJQJaJph333)hfh)?RB*CJOJPJQJaJph333)hfhfgB*CJOJPJQJaJph333)hfh\B*CJOJPJQJaJph333? @ J K N a b w } ~  Ʊꋱvv^G,hfh.:5B*CJOJPJQJaJph333/hfh`5B*CJOJPJQJ\aJph333)hfhC] B*CJOJPJQJaJph333hfhC] CJOJQJaJ,hfh`5B*CJOJPJQJaJph333)hfh`B*CJOJPJQJaJph333hfhybCJOJQJaJ)hfhB*CJOJPJQJaJph333)hfhybB*CJOJPJQJaJph333 !!#!)!+!J!K!Q!R!T!!կraJ5)hfhkzB*CJOJPJQJaJph333,hfh@&5B*CJOJPJQJaJph333 hfh`CJOJPJQJaJhfhCJOJQJaJ,hfhkz5B*CJOJPJQJaJph333,hfh`5B*CJOJPJQJaJph333,h2h`5B*CJOJPJQJaJph333hfh@&CJOJQJaJ)hfh`B*CJOJPJQJaJph333)hfh+B*CJOJPJQJaJph333 !#!K!!!!!!!"k"5#n#o#p#) & F 2( Px 4 #\'*.25@9dxgd2$ 2( Px 4 #\'*.25@9dgdt & F&dxd\$gd2 & F&dxd\$gd2 hd`hgdt!!!!!!!!!!!"#"""Ӽ|e|P;&)hfhQB*CJOJPJQJaJph)hfh_B*CJOJPJQJaJph)hfhjNB*CJOJPJQJaJph,h2hjN5B*CJOJPJQJaJph,h2h`5B*CJOJPJQJaJph#h2B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh)?R5B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph"F#d#p#t############$꾧{fQfQf:,hfh5B*CJOJPJQJaJph)hfh*0JB*CJOJQJaJph)hfh`0JB*CJOJQJaJph)hfh*B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh*5B*CJOJPJQJaJph)hfhQB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJphp#####]$^$$$%%%%%%%%%&& dgdt' & F' 2( Px 4 #\'*.25@9dgd2$ 2( Px 4 #\'*.25@9dgdt$8$>$D$]$^$$$$$$$% % %%%%&%*%%%%%%%ҽlZH#hB*CJOJPJQJaJph#h`B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJphhfhseCJOJQJaJhfh bCJOJQJaJhfhCJOJQJaJhfh`CJOJQJaJ)hfhB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfhi45B*CJOJPJQJaJph%%%%&&&&&6&8&9&:&A&վՐydOdO:*hfh b5CJOJQJaJ)hfh!B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfh bB*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfh b5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph)hfhB*CJOJPJQJaJph &&9&:&C&D&&&&&&&0'1'2'X'Y''''''( & Fdgdt & F)dgd d^gd & Fdgd dgdtA&B&C&D&&&&&&&&&/'0'2'6'îwwfQ:,hfhO5B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph hfh`CJOJPJQJaJhfh b5CJOJQJaJhfh!5CJOJQJaJ,hfh b5B*CJOJPJQJaJph)hfh bB*CJOJPJQJaJphhfh`CJOJQJaJhfh5CJOJQJaJh b5CJOJQJaJhfh`5CJOJQJaJ6'>'B'X'Y'h'i't''''''''''''''黦||gRgR@#hB*CJOJPJQJaJph)hfhU'XB*CJOJPJQJaJph)hfhseB*CJOJPJQJaJph)hfhdB*CJOJPJQJaJph)hfhSB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfhO5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph'((((((('(G(M(N([(\(](h(~(ìkVA,)hhseB*CJOJPJQJaJph)hfhseB*CJOJPJQJaJph)hfhSB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfh`2B*CJOJPJQJaJph,hfh`25B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph)hfhU'XB*CJOJPJQJaJph#hB*CJOJPJQJaJph)hhU'XB*CJOJPJQJaJph((((\(](~(((((()1)P)m)n)))))*&*I*d* dgd & F*dgd dgdt & Fdgdt~((((((((((()!)1)=)P)\)l)m)n)|)))))ñp[F)hfh<B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfhHlB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph)hfh qB*CJOJPJQJaJph#h`2B*CJOJPJQJaJph)hfhseB*CJOJPJQJaJph#hB*CJOJPJQJaJph)hfhU'XB*CJOJPJQJaJph)))))*****&*2*G*H*I*U*b*c*d*p**************+mXm)hfh&B*CJOJPJQJaJph)hfhe&pB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph#hB*CJOJPJQJaJph)hfh<B*CJOJPJQJaJph)hh`B*CJOJPJQJaJph)hh<B*CJOJPJQJaJph!d******++0+G+\+o+++++++5,6,K,L,`,x,,,,, dgdt dgd++++++0+6+E+F+G+M+Z+[+\+b+o+u++++++++++++++++++m,hfh`5B*CJOJPJQJaJph)hfh`2B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph#hB*CJOJPJQJaJph)hfhe&pB*CJOJPJQJaJph)hh`B*CJOJPJQJaJph)hhe&pB*CJOJPJQJaJph"+ , ,,,3,4,6,A,I,J,K,L,P,`,d,x,|,,,,,,,,,,,,o]]]]]]]K#h`B*CJOJPJQJaJph#hB*CJOJPJQJaJph)hhB*CJOJPJQJaJph#hPMB*CJOJPJQJaJph)hh`B*CJOJPJQJaJph)hhPMB*CJOJPJQJaJph)hfhPMB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfhjB*CJOJPJQJaJph,,,,,----N..... / /T/U//// & F+dgdOt & Fdgdt & F*dxgd q & F*dgd q dgdt,,,,,-------.. .M.N....... /Ӽ{{{{{fQ{{{)h qh`B*CJOJPJQJaJph)h qh qB*CJOJPJQJaJph)hfhoB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfho5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph / / //T/U///////////00Ӽ{f{f{Q{f?-?-#hfhE)05CJOJPJQJaJ#hfh`5CJOJPJQJaJ)hfhB*CJOJPJQJaJph)hfh$B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh$5B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph)hhB*CJOJPJQJaJph////000f00\}kd$$Ifl0H%V t0 &644 laytE)0d$Ifgdt dgdt & Fdgdt000D0T0X0d0e0f00000011*1,1M1Q1n1o1p1q1r1s1t1x11ͼͼͼͼͼͭͼ޼v_H,hfh`5B*CJOJPJQJaJph,hfh)95B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph hfhBSeCJOJPJQJaJ hfh)9CJOJPJQJaJhfhCJOJQJaJ hfh`CJOJPJQJaJ hfhCJOJPJQJaJhfh`CJOJQJaJ#hfh`5CJOJPJQJaJ0001ssd$Ifgdt}kd$$Ifl0H%V t0 &644 laytE)011M1q1ssd$Ifgdt}kd0$$Ifl0H%V t0 &644 laytE)0q1r1s1t11111 2222wwwwwwjjww & F,dgdOt dgdt}kd$$Ifl0H%V t0 &644 laytE)0 11111122222 3 33233վs\G9(s\s hfh 0CJOJQJ^JaJhOtCJOJQJ^JaJ)hfh 0B*CJOJQJ^JaJph,hfh 05B*CJOJPJQJaJph)hfh 0B*CJOJPJQJaJphhfh 0CJOJQJaJhfh 05CJOJQJaJ,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph&h5B*CJOJPJQJaJph,hfhj5B*CJOJPJQJaJph22 3 3333333333&4'444555t5 & F/dgdOt( 2( Px 4 #\'*.25@9d^gdOt & F-dgdOt dgdtgdt3333333333333&4'4+44ծkZI5k&hOt5B*CJOJPJQJaJph hfh 0CJOJPJQJaJ hfhFMCJOJPJQJaJ,hfh`5B*CJOJPJQJaJph,hfh 05B*CJOJPJQJaJph)hfhOtB*CJOJQJ^JaJph#h`B*CJOJQJ^JaJph)hfh5QB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfh 0B*CJOJPJQJaJph44555!5(5+57585G5H5M5Q5t5u55ԯjSjj>j)hfhB*CJOJPJQJaJph,hfh@5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfhF5B*CJOJPJQJaJph,hfhn<75B*CJOJPJQJaJph&hOt5B*CJOJPJQJaJph hfh`CJOJPJQJaJ)hfh`B*CJOJPJQJaJph,hfh| /5B*CJOJPJQJaJpht5u5555N667s7t7u77777788d$Ifgdt  & Fdgdt dgdt555555555555;6=6M6N6S66666677777`7d7r7s7u7w7y77իիիիիիիիիoX,hfh`5B*CJOJPJQJaJph,hfh]45B*CJOJPJQJaJph&hOt5B*CJOJPJQJaJph hfh`CJOJPJQJaJ)hfh`B*CJOJPJQJaJph)hfh-TB*CJOJPJQJaJph)hfh:nB*CJOJPJQJaJph)hfhn<7B*CJOJPJQJaJph"7777777777888E8j8k8o8|8888888888899"9&9)9-9D9һҦ|mXmXXmXXXmXX)hfhQB*CJOJPJQJaJphhfh`CJOJQJaJ)hfhn_B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph,hfh(5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfhn_5B*CJOJPJQJaJph"888F8j8tfffd$Ifgdtkd`$$IflF $x x x t06    44 laj8k8o888tfffd$Ifgdtkd$$IflF $x x x t06    44 la88889tfffd$Ifgdtkdn$$IflF $x x x t06    44 la999F9c9tfffd$Ifgdtkd$$IflF $x x x t06    44 laD9E9c9d9p9t9w9{999999999999: : ::::: :+:,:H:I:K:M:O::ձձՈqZ,hfh`5B*CJOJPJQJaJph,hfh 5B*CJOJPJQJaJph&hOt5B*CJOJPJQJaJph(hfhn_0JCJOJPJQJ^JaJ(hfh`0JCJOJPJQJ^JaJhfh`CJOJQJaJ)hfh`B*CJOJPJQJaJph)hfhQB*CJOJPJQJaJph"c9d9h999tfffd$Ifgdtkd|$$IflF $x x x t06    44 la99999tfffd$Ifgdtkd$$IflF $x x x t06    44 la9: : :H:tfffd$Ifgdtkd$$IflF $x x x t06    44 laH:I:J:K::::::tjjjjj\\d$Ifgdt dgdtkd$$IflF $x x x t06    44 la::::::::::;3;6;8;];_;;;;;<<<<L<V<W<Y<[<]<<òòãòòòòãòòãԏxa,hfh`5B*CJOJPJQJaJph,hfh95B*CJOJPJQJaJph&hOt5B*CJOJPJQJaJphhfh`CJOJQJaJ hfh V6CJOJPJQJaJ hfh`CJOJPJQJaJ)hfh`B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph::4;;yyd$Ifgdtxkd$$Ifl0H$ t0644 la;; <V<yyd$Ifgdtxkd$$Ifl0H$ t0644 laV<W<X<Y<<<!="===>>}}}}p}p}p} & F0dgdOt dgdtxkd$$Ifl0H$ t0644 la <<<<< =!="====>>E>F>һ|gXIg|8*hOtCJOJPJQJaJ hfh`CJOJPJQJaJhfh9CJOJQJaJhfhHCJOJQJaJ)hfhHB*CJOJPJQJaJph)hfh9B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfhaB*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfha5B*CJOJPJQJaJph>F>>>>>> ??1????@@@G@H@w@x@@@ A dgdt  & Fdgdt  & Fdgdt dgdt  & FdgdOtF>~>>>>>>>>>> ??@@йw``K:%)hfhB*CJOJPJQJaJph hfh`CJOJPJQJaJ)hfhOB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfhcF5B*CJOJPJQJaJph,hfhO5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph hOthCJOJPJQJaJhOtCJOJPJQJaJ hOth`CJOJPJQJaJ@@@@5@>@G@H@U@w@x@@@վվ}hSA/#hfh`5CJOJPJQJaJ#hfh6ns5CJOJPJQJaJ)hfh FB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfh9mB*CJOJPJQJaJph)hfhB*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh:5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJph @@@@$A%A&A7A8A=AsAtAAAAAAAϽlU>,hfh`5B*CJOJPJQJaJph,hfhl}5B*CJOJPJQJaJph,hfhZ5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph hfh6nsCJOJPJQJaJ#hfh`5CJOJPJQJaJ hfhF.OCJOJPJQJaJhfhF.OCJOJQJaJ hfh`CJOJPJQJaJ AA%A&AAAAAABBSBBBCCC D D DBDCD hd^hgdt  & Fdgdt dgdt  & Fdgdt dgdtAAABBBeBiBoBBBBBBBC"C,CCCCCCC DDDBDCDDybK,hfh`5B*CJOJPJQJaJph,hfhOW5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJph hfhDmCJOJPJQJaJ hfhOWCJOJPJQJaJ hfh`CJOJPJQJaJ)hfhl}B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph)hfhB*CJOJPJQJaJphCD}DDDEhEEEEEEKFMFSFdFmFd$Ifgdt dgdt  & FdgdtDDDDEEEFFMFmFnFFFG"GGGKGGGGGGGGGG Hɴr`QQ޴rhfh`CJOJQJaJ#hfh`5CJOJPJQJaJ,hfh`5B*CJOJPJQJaJph,hfh 5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph hfh`CJOJPJQJaJ hfh CJOJPJQJaJmFnFFGGGtfffd$Ifgdtkd$$IflF $x x x t06    44 laGGGGG H H3H4HH'Itjjjjjjj]]  & Fdgdt dgdtkd$$IflF $x x x t06    44 la H H3H4H>HHHHHHILITIXIIIIIIIIIJJJ J"J6JOJQJҽu^J^^&hEWz5B*CJOJPJQJaJph,hfhpt5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJph hfh CJOJPJQJaJ hfh`CJOJPJQJaJ hfhptCJOJPJQJaJ)hfh9B*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfh5B*CJOJPJQJaJph'IIJJJQJRJpJqJJJK'KXKKKKKKLL5LyLLL  & F dgdt  & Fdgdt dgdt  & FdgdtQJRJpJqJ|J}JJJJK'K+K0K4KUKVKcKgKnKKKKKӾzzzzeN,hfhpt5B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJph hfha*_CJOJPJQJaJ hfhfCJOJPJQJaJ hfhptCJOJPJQJaJ hfh`CJOJPJQJaJ)hfhptB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph)hfhB*CJOJPJQJaJphKKKKKLL5LGL$M&MMMMMMMMMMN3N4NZNվ՘ykZCC,hfh3^5B*CJOJPJQJaJph hfhEWzCJOJPJQJaJhEWzCJOJPJQJaJh`CJOJPJQJaJ hfha*_CJOJPJQJaJ hfh`CJOJPJQJaJ)hfhB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfhpt5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJphLAMMMMMMM3N4NZN[NNNOZOOPnPP QTQQQR & F dxgd) dgdt dgdEWz  & F dgdtZN[NgNiNlNzNNNNNNNNNNNOOOOOZOmOrOsOtOwOOOOOOOOOOOOPPPPP-P6PnPzP{P|P~PPƵƵƤƤƤؒؒؒ hfhu|0CJOJPJQJaJ#hfhu|05CJOJPJQJaJ hfh`CJOJPJQJaJ hfh3^CJOJPJQJaJ#hfh3^5CJOJPJQJaJ#hfh`5CJOJPJQJaJ)hfh3^B*CJOJPJQJaJph2PPPPPPPPP QQQ Q#Q1Q:QTQiQjQkQxQQQQQQQQQQQQRRRRR R9RGRHRIRLRRRRRRRRRRRR SSS#S1S2S3SO`>O>O` hfhCJOJPJQJaJ hfh`CJOJPJQJaJhfh`CJOJQJaJ#hfh`5CJOJPJQJaJ)hfhB*CJOJPJQJaJph,hfh`5B*CJOJPJQJaJph,hfhC~5B*CJOJPJQJaJph&hEWz5B*CJOJPJQJaJph)hfhEWzB*CJOJPJQJaJph#hEWzB*CJOJPJQJaJphOUxUyUUUUUVlzkd# $$Ifl0H$ t0644 lad$Ifgdt dgdtVV;VnVvvd$Ifgdtzkd $$Ifl0H$ t0644 lanVoVVVvvd$Ifgdtzkd+ $$Ifl0H$ t0644 laVVW`Wvvd$Ifgdtzkd $$Ifl0H$ t0644 laVVWWW W`WaWWWWWWWWWW5X6X7XsXtXYYSY޺s]Lss hfh}"0JCJOJQJaJ+j hfh}"CJOJQJUaJhfh}"CJOJQJaJ%jhfh}"CJOJQJUaJhfh}"5CJOJQJaJ)hfh}"B*CJOJPJQJaJph)hfh`B*CJOJPJQJaJphhfh`CJOJQJaJ hfh`CJOJPJQJaJ hfhF.OCJOJPJQJaJ`WaWxWWvvd$Ifgdtzkd3 $$Ifl0H$ t0644 laWWWWvvd$Ifgdtzkd $$Ifl0H$ t0644 laWWWWWWWuXwYxYzY{Y}Yzzzzuuuzkik dgdnugdt dgdtzkd; $$Ifl0H$ t0644 la SYTYUYtYuYwYxYyY{Y|Y~YYYYYYYYYYֶjhu|0UmHnHtHuhu|0hexjhexU)hfh}"B*CJOJPJQJaJphhfh}"CJOJQJaJ hfh}"0JCJOJQJaJ%jhfh}"CJOJQJUaJ+j@hfh}"CJOJQJUaJ}Y~YYYYYYYYYYYYYYYYYYY dgdt dgdnu21h:p`/ =!"#$% $$If!vh55V#v#vV:V l t0 &655VytE)0$$If!vh55V#v#vV:V l t0 &655VytE)0$$If!vh55V#v#vV:V l t0 &655VytE)0$$If!vh55V#v#vV:V l t0 &655VytE)0$$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x }$$If!vh55#v:V l t065}$$If!vh55#v:V l t065}$$If!vh55#v:V l t065$$If!vh5x 5x 5x #vx :V l t065x $$If!vh5x 5x 5x #vx :V l t065x $$If!vh55#v:V l t065$$If!vh55#v:V l t065$$If!vh55#v:V l t065$$If!vh55#v:V l t065$$If!vh55#v:V l t065$$If!vh55#v:V l t065$$If!vh55#v:V l t065DyK =http://www.careerride.com/SQLServer-Interview-Questions.aspxyK http://www.careerride.com/SQLServer-Interview-Questions.aspxyX;H,]ą'cDyK yK lhttp://www.careerride.com/Termsofuse.aspxyX;H,]ą'c^ 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH V`V `Normal d$CJOJPJQJ_HaJmH sH tH DA`D Default Paragraph FontRi@R  Table Normal4 l4a (k (No List Bb@B ` HTML CodeCJOJPJQJ^JaJD@D `List Paragraph ^m$e@ `0HTML PreformattedA 2( Px 4 #\'*.25@9dCJOJPJQJ^JaJ`!` `0HTML Preformatted CharOJQJ^J_HmH sH tH (1( `bodycode(A( `textcode8OQ8 `apple-style-spanBOaB `apple-converted-space4U@q4 }" Hyperlink >*ph4@4 nu0Header  H$BB nu0 Header CharCJOJPJQJaJ4 @4 nu0Footer  H$BB nu0 Footer CharCJOJPJQJaJPK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] Q * +  S c$ !"$%A&6''~()++, /013457D9:<F>@@AD HQJKZNPSLUVSYY-/024578:<=?@BCEFGHIKLNOQRSUVXY[\^bdeghmrvxyz|~  (!!p#&(d*,/01q12t58j889c999H::;V<> ACDmFG'ILROUVnVV`WWW}YY.1369;>ADJMPTWZ]_`acfijklnopqstuw{}O6PsPQTQtQQXX@  @ 0(  B S  ?\D(     ;Dā@ CareerRide.comCalibriPowerPlusWaterMarkObject2336007c"$?1#`@KWv""**+,,,,$,xQxQzQzQ{Q{Q}Q~QQQQQQQ4%:%=J>xQxQzQzQ{Q{Q}Q~QQQQQQQ3333668899 <<=>??B BCCEEEEKKKMNMPMQMwQQ668899 <<=>??B BCCEEEEKKKMNMPMQMtPQ0D\_,T2^^;$^^Ilr X cp?ra/Xxc,I5 *z w#zPl @\AZ"ծS$2%Ȇ-t0-*B,fRr{u/4T0PlX1f(gu2Tbb3p4&&Ə5n(O=T%t>JQJpY?Rlt5mHvDII  XLOQ.OL0"ER2qZSZVLyVk2W6Xf]MY RQ[ Zja[") X\^^mz]Ig?^ʁ^ `eyegd+1h*|,Sk"~@n濐O |y&y^^e{8zkh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`CJOJQJo(hH^`CJOJQJo(opp^p`CJOJQJo(o@ @ ^@ `CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(oPP^P`CJOJQJo(oh^`CJOJQJo(hH^`CJOJQJo(opp^p`CJOJQJo(o@ @ ^@ `CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(oPP^P`CJOJQJo(oh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo( ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`CJOJPJQJ^Jo(.^`CJOJQJo(opp^p`CJOJQJo(o@ @ ^@ `CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(oPP^P`CJOJQJo(oh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh8^8`CJOJQJo(hHh^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh!8^8`CJOJPJQJ^Jo(hH.h^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH8^8`OJPJQJ^Jo(-^`OJQJ^Jo(hHo ^ `OJQJo(hH ^ `OJQJo(hHx^x`OJQJ^Jo(hHoH^H`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH^`o(. ^`hH. pL^p`LhH. @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PL^P`LhH.h8^8`CJOJQJo(hHh^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH^`o(. p^p`hH. @ L^@ `LhH. ^`hH. ^`hH. L^`LhH. ^`hH. P^P`hH.  L^ `LhH.^`o(. p^p`hH. @ L^@ `LhH. ^`hH. ^`hH. L^`LhH. ^`hH. P^P`hH.  L^ `LhH.h8^8`OJQJo(hH^`OJQJ^Jo(hHo ^ `OJQJo(hH ^ `OJQJo(hHx^x`OJQJ^Jo(hHoH^H`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`OJQJo(hH ^`hH. pL^p`LhH. @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PL^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo( ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH^`OJPJQJ^J.^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh^`CJOJQJo(hH^`CJOJQJo(hHopp^p`CJOJQJo(hHo@ @ ^@ `CJOJQJo(hHo^`CJOJQJo(hHo^`CJOJQJo(hHo^`CJOJQJo(hHo^`CJOJQJo(hHoPP^P`CJOJQJo(hHoh!8^8`CJOJPJQJ^Jo(hH.h^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH ^`OJQJo(p^p`OJQJ^Jo(o @ ^@ `OJQJo( ^`OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(P^P`OJQJ^Jo(o  ^ `OJQJo( ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(^`OJQJo(hH^`OJQJ^Jo(hHop^p`OJQJo(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJQJo(hH ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH^`5o(. ^`hH. pL^p`LhH. @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PL^P`LhH. ^`OJQJo(^`OJQJ^Jo(o p^p`OJQJo( @ ^@ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( ^`OJQJo(^`OJQJ^Jo(o P^P`OJQJo(h^`CJOJQJo(hH^`CJOJQJo(opp^p`CJOJQJo(o@ @ ^@ `CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(o^`CJOJQJo(oPP^P`CJOJQJo(o^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(0B,g?^LyV]MY `ea/OQc1hZV |y w#T0mz] X\(O=e{ c@nt5mHDIpY?5Ib3gu2|,SkI5 l XL"ERD\Ilr u/eg$2%%t>;$&y,T2t0-*4a[Q[ ZAZ"lX1W2qZS00                                                                                                                              bz                                                                                                                                                        L@                                                                                        ;:                 8^M;"]; u+ 'GMM C] 3 RM "6 {55[n quH}"&d#&}|&> *mo,+- ;-p-| /N/ 0E)0u|0['20373i4k4BI5 V6n<7}789"<v>=j=o=#?C}?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~  Root Entry F06tŠ# Data 1TableWordDocument 4*SummaryInformation(DocumentSummaryInformation8MsoDataStorepMŠ#BnŠ#1VE4E4BO4Q==2pMŠ#BnŠ#Item  PropertiesUCompObj y   F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q