ࡱ> HJEFG'` p bjbjDD .&&_."<.>>>>>>@hC>]AAA>>A: >A>W-2^ @4[?{ '/4> ?0> 0 AND SAL <= 100000 THEN 1 WHEN sal > 100000 AND SAL < 250000 THEN 2 WHEN sal > 250000 AND SAL < 5000000 THEN 3 ELSE 99 END AS emp_category FROM EMP Q. Decode function Decode : facilitates conditional inquires by doing the work of a case or if then else statement SELECT supplier_name, decode(supplier_id, 10000, 'IBM', 10001, 'Microsoft', 10002, 'Hewlett Packard', 'Gateway') result FROM suppliers; Q. How you will avoid duplicating records in a query? A By using DISTINCT Q. What is difference between Rename and Alias? Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed. Q. What is a view ? A view is a virtual table based on one or more tables. Why Use views ? To restrict data access To make complex queries easy To provide data independence To present different views of the same data Q. What are the advantages of Views ? Views restrict access to the data because the view can display selective columns from the table. Views can be used to make simple queries to retrieve the results of complicated queries. For example, views can be used to query information from multiple tables without the user knowing how to write a join statement. Views provide data independence for ad hoc users and application programs. One view can be used to retrieve data from several tables. Views provide groups of users access to data according to their particular criteria. Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. Hide data complexity. Simplify commands for the user. Present the data in a different perpecetive from that of the base table. Store complex queries. Q. What are various privileges that a user can grant to another user? SELECT CONNECT RESOURCES Q. What is schema? A schema is collection of database objects of a User. Q. what is Table ? A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns. Q. Do View contain Data? Views do not contain or store data. Q. Can a View based on another View ? Yes. Q. What is a Sequence ? A sequence generates a serial list of unique numbers for numerical columns of a database's tables. Q. What is a Synonym ? A synonym is an alias for a table, view, sequence or program unit. There are two types of Synonyms Private and Public. A Private Synonyms can be accessed only by the owner. A Public synonyms can be accessed by any user on the database. Synonyms are used to : Mask the real name and owner of an object. Provide public access to an object Provide location transparency for tables,views or program units of a remote database. Simplify the SQL statements for database users. Q. What is difference between TRUNCATE & DELETE ? TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATE DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE. Advantages of COMMIT and ROLLBACK Statements With COMMIT and ROLLBACK statements, you can: Ensure data consistency Preview data changes before making changes permanent Group logically related operations Q. Difference between SUBSTR and INSTR ? INSTR (String1,String2(n,(m)), INSTR returns the position of the mth occurrence of the string 2 in string1. The search begins from nth position of string1. SUBSTR (String1 n,m) SUBSTR returns a character string of size m in string1, starting from nth postion of string1. Q. Explain UNION, MINUS, UNION ALL, INTERSECT ? INTERSECT returns all distinct rows selected by both queries. MINUS - returns all distinct rows selected by the first query but not by the second. UNION - returns all distinct rows selected by either query UNION ALL - returns all rows selected by either query, including all duplicates. Union The union clause places two separate queries together forming one table. A union works best when using two tables with similar columns because each column must have the same data type SELECT dno FROM emp UNION SELECT dno FROM dept; UNION ALL selects all rows from each table and combines them into a single table The Difference between UNION and UNION ALL, The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table Q. What is ROWID ? ROWID is a pseudo column attached to each row of a table. It is 18 character long, blockno, rownumber are the components of ROWID. Q. What is the fastest way of accessing a row in a table ? Using ROWID. Q. What is difference between CHAR and VARCHAR2 ? , What is the maximum SIZE allowed for each type ? CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2. Q. How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ? A Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause. Q. What is Database Link ? A database link is a named object that describes a "path" from one database to another. Private Database Link, Public Database Link & Network Database Link. Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures. Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition. Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition. Q. Which is more faster - IN or EXISTS? EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value. Q. What is a join? A. Join is a process of retrieve pieces of data from different sets (tables) and returns them to the user or program as one Sjoined collection of data. Join & Union JOIN The join clause combines columns of one table to that of another to create a single table A join query does not alter either table, but temporarily combines data from each table to be viewed as a single table 3 different types of Join Inner Left Right Inner join An inner join returns all rows that result in a match such as the example above. SELECT a.ename,b.dname,e.sal,e.mgr FROM emp a, dept b WHERE a.dno = b.dno Types of Joins Equijoins Non-equijoins Outer joins Self joins Cross joins Natural joins Full or outer joins Equijoins To determine an employees department name, you compare the value in the DEPARTMENT_ID column in the EMPLOYEES table with the DEPARTMENT_ID values in the DEPARTMENTS table. The relationship between the EMPLOYEES and DEPARTMENTS tables is an equijointhat is, values in the DEPARTMENT_ID column on both tables must be equal. Frequently, this type of join involves primary and foreign key complements. Note: Equijoins are also called simple joins or inner joins. Non-Equijoins A non-equijoin is a join condition containing something other than an equality operator. The relationship between the EMPLOYEES table and the JOB_GRADES table has an example of a non-equijoin. A relationship between the two tables is that the SALARY column in the EMPLOYEES table must be between the values in the LOWEST_SALARY and HIGHEST_SALARY columns of the JOB_GRADES table. The relationship is obtained using an operator other than equals (=). SELECT e.last_name, e.salary, j.grade_level FROM employees e, job_grades j WHERE e.salary BETWEEN j.lowest_sal AND j.highest_sal; Outer join : to also see rows that do not meet the join condition Returning Records with No Direct Match with Outer Joins If a row does not satisfy a join condition, the row will not appear in the query result. For example, in the equijoin condition of EMPLOYEES and DEPARTMENTS tables, employee Grant does not appear because there is no department ID recorded for her in the EMPLOYEES table. Instead of seeing 20 employees in the result set, you see 19 records. SELECT e.last_name, e.department_id, d.department_name FROM employees e, departments d WHERE e.department_id = d.department_id; SELECT e.last_name, e.department_id, d.department_name FROM employees e, departments d WHERE e.department_id(+) = d.department_id ; Self Join : Joining a Table to Itself Sometimes you need to join a table to itself. To find the name of each employees manager, you need to join the EMPLOYEES table to itself, or perform a self join. For example, to find the name of Whalens manager, you need to: Find Whalen in the EMPLOYEES table by looking at the LAST_NAME column. Find the manager number for Whalen by looking at the MANAGER_ID column. Whalens manager number is 101. Find the name of the manager with EMPLOYEE_ID 101 by looking at the LAST_NAME column. Kochhars employee number is 101, so Kochhar is Whalens manager.In this process, you look in the table twice. The first time you look in the table to find Whalen in the LAST_NAME column and MANAGER_ID value of 101. The second time you look in the EMPLOYEE_ID column to find 101 and the LAST_NAME column to find Kochhar. SELECT worker.last_name || works for || manager.last_name FROM employees worker, employees manager WHERE worker.manager_id = manager.employee_id ; Left Outer Join : This query retrieves all rows in the EMPLOYEES table, which is the left table even if there is no match in the DEPARTMENTS table.This query was completed in earlier releases as follows: SELECT e.last_name, e.department_id, d.department_name FROM employees e, departments d WHERE d.department_id (+) = e.department_id; SELECT e.last_name, e.department_id, d.department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id) ; Left Outer Join Syntax A Left join returns all rows of the left of the conditional even if there is no right column to match SELECT a.eno, a.ename,d.dname FROM emp a LEFT OUTER JOIN dept b ON a.dno = b.dno; Right Outer Join : SELECT e.last_name, e.department_id, d.department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id) ; Example of RIGHT OUTER JOIN This query retrieves all rows in the DEPARTMENTS table, which is the right table even if there is no match in the EMPLOYEES table. This query was completed in earlier releases as follows: SELECT e.last_name, e.department_id, d.department_name FROM employees e, departments d WHERE d.department_id = e.department_id (+); Right Outer Join A Right join returns all rows of the Right of the conditional even if there is no right column to match SELECT a.eno, a.ename,b.dno,b.dname FROM emp a RIGHT OUTER JOIN dept b ON a.dno = b.dno; Full outer join SELECT e.last_name, e.department_id, d.department_name FROM employees e FULL OUTER JOIN departments d ON (e.department_id = d.department_id) ; Example of FULL OUTER JOIN This query retrieves all rows in the EMPLOYEES table, even if there is no match in the DEPARTMENTS table. It also retrieves all rows in the DEPARTMENTS table, even if there is no match in the EMPLOYEES table. Cartesian Products A Cartesian product results in all combinations of rows displayed. This is done by either omitting the WHERE clause or specifying the CROSS JOIN clause. Table Aliases Table aliases speed up database access. Table aliases can help to keep SQL code smaller, by conserving memory. Q. What kinds of joins do you know? Give examples. A. We have self join, outer joint (LEFT, RIGHT), , cross-join ( Cartesian product n*m rows returned) Exp: outer joint SELECT Employee.Name, Department. DeptName FROM Employee, Department WHERE Employee.Employee_ID = Department.Employee_ID; cross-join SELECT * FROM table1, table2; self join SELECT e1.name | | "!  | | e2.ename FROM emp e1, emp e2 WHERE e1. emp_no = e2.emp_no; Q. How do you add record to a table? A. INSERT into table_name VALUES ( ALEX "! , 33 , M "!); Q. How do you add a column to a table? A. ALTER TABLE Department ADD (AGE, NUMBER); Q. How do you change value of the field? A. UPDATE EMP_table set number = 200 where item_munber = CD "!; update name_table set status = 'enable' where phone = '4161112222'; update SERVICE_table set REQUEST_DATE = to_date ('2006-03-04 09:29', 'yyyy-mm-dd hh24:MI') where phone = '4161112222'; What does COMMIT do ? COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed. What does ROLLBACK do ? ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction Q. What is the highest value that can be stored in a BYTE data field? A. The highest value that can be stored in a BYTE field is 255. or from -128 to 127. Byte is a set of Bits that represent a single character. Usually there are 8 Bits in a Byte, sometimes more, depending on how the measurement is being made. Each Char requires one byte of memory and can have a value from 0 to 255 (or 0 to 11111111 in binary). What is a Procedure ? A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks. Q. What is a stored procedure? A. A procedure is a group of PL/SQL statements that can be called by a name. Procedures do not return values they perform tasks. Q. Describe how NULLs work in SQL? A. The NULL is how SQL handles missing values. Arifthmetic operation with NULL in SQL will return a NULL. What is a SNAPSHOT ? Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table. 135. What is a SNAPSHOT LOG ? A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated in the master table. Snapshot logs are used in updating the snapshots based on the master table. Q. What is Normalization? A. The process of table design is called normalization. Q. What is referential integrity constraints? A. Referential integrity constraints are rules that are partnof the table in a database schema. What is Database Trigger ? A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table. Q. What are the uses of Database Trigger ? Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations. Q. What are the differences between Database Trigger and Integrity constraints ? A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. A trigger does not apply to data loaded before the definition of the trigger, therefore, it does not guarantee all data in a table conforms to the rules established by an associated trigger. A trigger can be used to enforce transitional constraints where as a declarative integrity constraint cannot be used. Q. Which of the following WHERE clauses will return only rows that have a NULL in the PerDiemExpenses column? A. WHERE PerDiemExpenses <> B. WHERE PerDiemExpenses IS NULL C. WHERE PerDiemExpenses = NULL D. WHERE PerDiemExpenses NOT IN (*) A. B is correct � When searching for a NULL value in a column, you must use the keyword IS. No quotes are required around the keyword NULL. Q. You issue the following query: SELECT FirstName FROM StaffList WHERE FirstName LIKE'_A%' Which names would be returned by this query? Choose all that apply. A. Allen B. CLARK C. JACKSON D. David A. C is correct � Two wildcards are used with the LIKE operator. The underscore (_) stands for any one character of any case, and the percent sign (%) stands for any number of characters of any case including none. Because this string starts with an underscore rather than a percent sign, it won't return Allen or Clark because they represent zero and two characters before the "A". If the LIKE string had been "%A%", both of these values would have been returned. David was not returned because all non-wild card characters are case sensitive. Therefore, only strings with an uppercase "A" as their second letter are returned Q. Write a SQL SELECT query that only returns each city only once from Students table? Do you need to order this list with an ORDER BY clause? A. SELECT DISTINCT City FROM Students; The Distinct keyword automatically sorts all data in ascending order. However, if you want the data sorted in descending order, you have to use an ORDER BY clause Q. Write a SQL SELECT sample of the concatenation operator. A. SELECT LastName ||',' || FirstName, City FROM Students; Q. How to rename column in the SQL SELECT query? A. SELECT LastName ||',' || FirstName AS "Student Name", City AS "Home City" "FROM StudentsORDER BY "Student Name" Q. Write SQL SELECT example how you limiting the rows returned with a WHERE clause. A. SELECT InstructorID, Salary FROM Instructors WHERE Salary > 5400 AND Salary < 6600; Q. Write SQL SELECT query that returns the first and last name of each instructor, the Salary, and gives each of them a number. A. SELECT FirstName, LastName, Salary, ROWNUM FROM Instructors; Q. Which of the following functions can be used only with numeric values? (Choose all that apply.) A. AVG B. MIN C. LENGTH D. SUM E. ROUND A. A and D � Only A and D are correct. The MIN function works with any character, numeric, or date datatype. The LENGTH function is a character function that returns the number of letters in a character value. The ROUND function works with both numeric and date values. Q. Which function do you use to remove all padded characters to the right of a character value in a column with a char datatype? A. RTRIM B. RPAD C. TRIM A. C � The TRIM function is used to remove padded spaces. LTRIM and RTRIM functions were included in earlier versions of Oracle, but Oracle 8i has replaced them with a single TRIM function Q. Which statement do you use to eliminate padded spaces between the month and day values in a function TO_CHAR(SYSDATE,'Month, DD, YYYY') ? A. To remove padded spaces, you use the "fm" prefix before the date element that contains the spaces. TO_CHAR(SYSDATE,'fmMonth DD, YYYY') Q. Is the WHERE clause must appear always before the GROUP BY clause in SQL SELECT ? A. Yes. The proper order for SQL SELECT clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY. Only the SELECT and FROM clause are mandatory. Q. How Oracle executes a statement with nested subqueries? A. When Oracle executes a statement with nested subqueries, it always executes the innermost query first. This query passes its results to the next query and so on until it reaches the outermost query. It is the outermost query that returns a result set. Q. Which operator do you use to return all of the rows from one query except rows are returned in a second query? A. You use the MINUS operator to return all rows from one query except where duplicate rows are found in a second query. The UNION operator returns all rows from both queries minus duplicates. The UNION ALL operator returns all rows from both queries including duplicates. The INTERSECT operator returns only those rows that exist in both queries. Q. Which of the following statements are Data Manipulation Language commands? A. INSERT B. UPDATE C. GRANT D. TRUNCATE E. CREATE A. A and B � The INSERT and UPDATE statements are Data Manipulation Language (DML) commands. GRANT is a Data Control Language (DCL) command. TRUNCATE and CREATE are Data Definition Language (DDL) commands Q. What is Oracle locking? A. Oracle uses locking mechanisms to protect data from being destroyed by concurrent transactions. Q. What Oracle lock modes do you know? A. Oracle has two lock modes: shared or exclusive. Shared locks are set on database resources so that many transactions can access the resource. Exclusive locks are set on resources that ensure one transaction has exclusive access to the database resource Q. What is query optimization? A. Query optimization is the part of the query process in which the database system compares different query strategies and chooses the one with the least expected cost Q. What is transaction? A. A transaction is a collection of applications code and database manipulation code bound into an indivisible unit of execution.it consists from: BEGIN-TRANSACTION Name Code END TRANSACTION Name Q. What databases do you know? Informix DB2 SQL Oracle Q. Explain SQL SELECT example: select j.FILE_NUM from DB_name.job j, DB_name.address a where j.JOB_TYPE ='C' AND j.COMPANY_NAME = 'TEST6' AND j.OFFICE_ID = '101' AND j.ACTIVE_IND = 'Y' AND a.ADDRESS_STATUS_ID = 'H' AND a.OFFICE_ID = '101' AND a.FILE_NUM = j.FILE_NUM order by j.FILE_NUM; Answer: j and a aliases for table names. this is outer joint select statament from two tables. Q. Describe some Conversion Functions that you know A. TO_CHAR converts a number / date to a string. TO_DATE converts a string (representing a date) to a date. TO_NUMBER converts a character string containing digits to a numeric data type, it accepts one parameter which is a column value or a string literal Q. In what sequence SQL statement are processed? A. The clauses of the subselect are processed in the following sequence (DB2): 1. FROM clause 2. WHERE clause 3. GROUP BY clause 4. HAVING clause 5. SELECT clause 6. ORDER BY clause 7. FETCH FIRST clause Q. What is a pseudo column. Give some examples? It is a column that is not an actual column in the table. Eaxmple USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Q. Suppose a customer table is having different columns like customer no, payments. What will be the query to select top three max payments? SELECT customer_no, payments from customer C1 WHERE 3<=(SELECT COUNT(*) from customer C2 WHERE C1.payment <= C2.payment) Q. Find out nth highest salary from emp table SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); Q. What are the difference between DDL, DML and DCL commands? DDL is Data Definition Language statements. Some examples: CREATE - to create objects in the database ALTER - alters the structure of the database DROP - delete objects from the database TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed COMMENT - add comments to the data dictionary GRANT - gives user's access privileges to database REVOKE - withdraw access privileges given with the GRANT command DML is Data Manipulation Language statements. Some examples: SELECT - retrieve data from the a database INSERT - insert data into a table UPDATE - updates existing data within a table DELETE - deletes all records from a table, the space for the records remain CALL - call a PL/SQL or Java subprogram EXPLAIN PLAN - explain access path to data LOCK TABLE - control concurrency DCL is Data Control Language statements. Some examples: COMMIT - save work done SAVEPOINT - identify a point in a transaction to which you can later roll back ROLLBACK - restore database to original since the last COMMIT SET TRANSACTION - Change transaction options like what rollback segment to use Can we drop a column from a table? yes. ALTER TABLE table_name DROP COLUMN column_name; Q. Describe some Group Functions that you know A. 1) The COUNT function tells you how many rows were in the result set. SELECT COUNT(*) FROM TESTING.QA 2) The AVG function tells you the average value of a numeric column. SELECT MAX(SALARY) FROM TESTING.QA 3) The MAX and MIN functions tell you the maximum and minimum value of a numeric column. SELECT MIN(SALARY) FROM TESTING.QA 4) The SUM function tells you the sum value of a numeric column. SELECT SUM(SALARY) FROM TESTING.QA Group functions: Group functions operate on sets of rows to give one result per group Count function : COUNT(*) returns the number of rows in a table. SELECT COUNT(*)FROM employees WHERE department_id = 50; Having clause If you restrict rows based on the result of a group function, you must have a GROUP BY clause as well as the HAVING clause. SELECT department_id, MAX(salary) FROM employees GROUP BY department_id HAVING MAX(salary)>10000 ; Query Syntax Write a query to display the name, who is getting the max salary from EMP table SELECT ename FROM EMP WHERE sal=(SELECT MAX(sal) FROM EMP) Select ename, max( sal) from emp ( Wrong) Write a query to display the employee name and respective manager name in the Emp table SELECT a.ename, b.ename FROM EMP a , EMP b WHERE a.MGR= b.EMPNO Write a query to display the employee name and respective manager name in the Emp table including the manager is null SELECT a.ename ||' is working under '||b.ename FROM EMP a,EMP b WHERE a.mgr=b.empno UNION SELECT 'There is no manager to '||ename FROM EMP WHERE mgr IS NULL Write a query to sum all the positive and negative values in the column Table name tab1 COL1 12-1-2 1)To get 2,3,N maximum salaries with complete row select * from emp where sal=(select min(sal) from( select * from (select * from emp order by sal desc) where rownum<=2)) (Replace 2 with the desired Number) 2) To get 2 Max Salary with complete row select * from emp where sal= (select max(sal) mx from emp where (Sal) <(select max(sal) from emp)) 4)To Get Top N rows select * from (select * from emp order by sal desc) where rownum<=5)) (replace 5 with the desired Number) 5)To Get Nth Row select * from emp where 7=(Select count(Rowid) from emp x where emp.rowid>=x.rowid) (Replace 7 with the Desired Number) 6)To Get Employees whose salary is greater the the avg salary of dept select empno,emp.deptno,sal,a.av from emp, (select Deptno,avg(sal) av from emp group by deptno) a where a.deptno=emp.deptno and emp.sal>a.av Other way SELECT * FROM EMP WHERE SAL>(sELECT AVG(SAL) FROM EMP X WHERE X.DEPTNO=EMP.DEPTNO) ORDER BY EMPNO 7)Deletion of Duplicate Records Delete from emp where rowid in(select min(rowid) from emp x where x.rowid=emp.rowid) --Select Case Example select ename,sal, case when sal between 500 and 1000 then 'D' when sal between 1001 and 1500 then 'C' when sal between 1501 and 2500 then 'B' else 'A' end Rank from emp ,salgrade where emp.sal between losal and hisal --Rows from emp and Salgrade tables select ename,sal,grade from emp,salgrade where emp.sal between losal and hisal --Use of Rank to Retervie top rows1v~  - . C L N O | } ǹxgVE44 h9KhwVOJQJ^JnH tH  h9KhRBxOJQJ^JnH tH  h9KhL~OJQJ^JnH tH  h9Kh,NOJQJ^JnH tH  h9Kh:OJQJ^JnH tH  h9Kh<vOJQJ^JnH tH  h9KhLVeOJQJ^JnH tH h9KhK OJQJ\^Jh9KhK 5OJQJ^J$jh9KhK 5OJQJU^J$jh9KhK 5OJQJU^J$jh9KhK 5OJQJU^J12uv" / U ^  # ~  8^8gd<v & FgdLVe & FgdLVegdLVe & FgdLVe & FgdLVe & FgdLVegd&%.p  - . N O    W h | } gdf}gdLVe & FgdLVe & FgdLVegdwVh^hgdL~ & FgdLVe8^8gd!| & FgdLVe} [ \ ] ^ _ u`O;O&h9KhAl6OJQJ]^JnH tH  h9KhAlOJQJ^JnH tH (h9KhAlOJQJ^JmH nH sH tH +h9KhAl5OJQJ^JmH nH sH tH h9KhAlOJQJ\^Jh9Kh qOJQJ\^Jh;Gh qOJQJ^Jh qmH sH h qh qOJQJ\^JhOJQJ\^Jh9KhGCOJQJ\^Jh9KhOJQJ^Jh9Khf}OJQJ\^J \ ] ^ YzP^BCgdGC & F gdAl & F gdAlgdAlgd qgdf}C\]^aOP[\m  LM'(\]ʿ{m__Q_m__h9Kh=OJQJ\^Jh9Kh$oOJQJ\^Jh9Kh'OJQJ\^Jh9KhOJQJ^Jh;GOJQJ\^J$jh qhu\OJQJU\^Jh qhu\OJQJ\^Jh qOJQJ\^Jhu\OJQJ\^Jhf}OJQJ\^Jh9Khf}OJQJ\^Jh9KhGCOJQJ\^Jh9Khm0OJQJ\^JC]^mn LM&'\] 8 7$8$H$gdS[gd$ogd&%.gdgd qgdf}ghitw=Vj@aQXijXcd "7ŷ~~~q~q~q~qq~qqh9KhxCJ^JaJh9Khx>*OJQJ^J h9KhxCJOJQJ^JaJh9Khm0OJQJ^Jh9KhxOJQJ^Jh9Khx5OJQJ^Jh9KhS[OJQJ\^Jh9KhS[6OJQJ]^Jh9KhS[OJQJ^Jh9KhS[5OJQJ\^J*-hivw=UVjk ~= z9!h1$^hgdx & F ~= z9!1$gdxgdx ~= z9!1$gdx 7$8$H$gdS[9:acklQRijgdx ^`gdx ~= z9!1$gdxPQRcd "7gdx  gdx L~= z9!"1$^`"gdx  Lgdx ~= z9!1$gdx  ~= z9!"1$^`"gdx78QR H 6!$a$gdD 7$8$H$gdS[  gdx  Lgdx ~= z9!1$gdx !4!6!7!!!##%#&#(#;#C###$#$$$ȻȰȰȢȗȉ{m_m_m_mQh9KhAlOJQJ\^Jh9Kh*pOJQJ\^Jh9Khf}OJQJ\^Jh9Kh=OJQJ\^Jh9KhDOJQJ\^Jh9Kh]nCJaJh9KhS[OJQJ\^Jh9Kh,NCJaJh9KhDOJQJ^Jh9KhDCJaJh9KhS[5OJQJ\^Jh9Kh,NOJQJ\^Jh9KhxOJQJ\^J6!7!!!!!""##%#&#;#$$$$$$$7%8%_%`%}%%% & F gdAlgdAlgdf}gd$o$a$gdD$$%%%%%%&&&!&A&D&&&&&&''1'5''''''(}rdWJh9KhygOJQJ^Jh9KhOJQJ^Jh9KhbOJQJ\^JhbOJQJ\^Jh'OJQJ\^Jh9Kh'OJQJ\^Jh9KhGCOJQJ\^Jh9Khf}OJQJ\^Jh9Kh=OJQJ\^Jh9Kh$oOJQJ\^Jh9KhAlOJQJ\^J h9KhAlOJQJ^JnH tH #h9KhAl5OJQJ^JnH tH %%%%&&A&&&& ''1''''''(e(f(g(v(w((=)>)gd:gdgdGCgd'gd$ogdf}(e(f(g(v(~((((((>)y)z))))) * *n*++8+;+N+O+-,/,z,榑wi[M[i[i[h9Kh{HOJQJ\^Jh9Kh$oOJQJ\^Jh9Kh=OJQJ\^Jh9Kh;OJQJ^Jh9Kh&OJQJ^J(h9KhqOJQJ^JmH nH sH tH (h9Kh:OJQJ^JmH nH sH tH h9Kh:6OJQJ]^Jh9Kh:5OJQJ^Jh9Kh*pOJQJ^Jh9Kh:OJQJ^Jh9KhOJQJ^J>)M)z))))))) * *n*o******++8+M+N+++,-,C,z,gd$ogd;gdgd:z,{,,,,,,--8--w..V/// 0S0j0k0000000`gd{Hgd&%.gd{HgdS[ 7$8$H$gdS[gd$oz,{,--8---W.X.U/j0k0l00011111111222 2?2@222445556667伮vfvh9KhS[5OJQJ\^Jh9KhuOJQJ\^Jh9KhOJQJ\^Jh9Kh3OJQJ\^Jh9Kh=OJQJ\^Jh9Kh$oOJQJ\^Jh9Kh{HOJQJ^Jh9Kh&OJQJ^Jh9Kh{HOJQJ\^Jh9KhS[OJQJ^Jh9KhS[OJQJ\^J'011*11112292>2?2W222233L33334'4}44444`gd{Hgd$o4V5W55555,6F6}66666687q7r777788W888@9A9gdS[ 7$8$H$gdS[gd$o777788W8j89/9@9A9G9L9Q9{;|;};~;<<g<h<<<R=S====4>5>>>A㹧ttftXftth9Kh&OJQJ\^Jh9Kh{HOJQJ\^Jh9KhOJQJ\^J&h9KhLVe6OJQJ]^JnH tH  h9KhLVeOJQJ^JnH tH #h9KhLVe5OJQJ^JnH tH h9KhLVeOJQJ\^Jh9Kh8OJQJ\^Jh9KhpOJQJ\^Jh9Kh$oOJQJ\^Jh9Kh-4OJQJ\^J"A9G9H9::::1:2::::{;|;};;;<<Y<f<g<<<Q=R=gd$o & FgdLVe & FgdLVe & FgdLVegdLVeR===3>4>P>Q>>>>>??@@AAABBBCC D DDjD & F gdg & F gdggdggd&%.gd$oAABCC DDDEEEEEE=F>FHFFǵǂrdVF9h9Kh= FOJQJ^Jh9Kh= F5OJQJ\^Jh9Kh{HOJQJ\^Jh9Kh{H5OJQJ^Jh9Kh{H5OJQJ\^Jh9Kh= FOJQJ\^J&h9Khg6OJQJ]^JnH tH  h9KhgOJQJ^JnH tH #h9Khg5OJQJ^JnH tH h9KhgOJQJ\^Jh9KhK OJQJ\^Jh9Kh$oOJQJ\^Jh9KhOJQJ\^JjDkDDDDEEEEEEmEEEEEEEEEEE FF 7$8$H$gd{Hgd&%. & Fgdg & Fgdg & Fgdg & FgdggdgF'F=F>FHFFGHH%H~HHImIIIIIJ4JCJkJlJJJJ=L>L 7$8$H$gd= Fgd&%. 7$8$H$gd{HFF9GAGQGRGGGGGGGH HHH%HIjJlJvJJJPKQKKK L LLBMDMPMjMMM-N.NNNOOPOPPOPPPP1QEQQQRRh9KhwkOJQJ^Jh9Kh= FOJQJ\^JhqTOJQJ^Jh9Kh{HOJQJ^Jh9Kh= F5OJQJ^Jh9Kh= F5OJQJ\^Jh9Kh= F6OJQJ]^Jh9Kh= FOJQJ^Jh9KhqOJQJ^J4>LuLLLLLMCMDMPMjMMNNOPPPPQ1Q2QEQQ6RVRRRRR 7$8$H$gd= FRRSS+S,SSSSSSSSSS4TETdTTTT-UfUUUUUUUgdg 7$8$H$gd= FRSS#S*S+SSSSTTUUUUUVVVVW8X9XRXeXXXX YYY]]4^ѿѮ񞑄wѮwi[ih9KhzOJQJ\^Jh9KhK OJQJ\^Jh9KhgOJQJ^Jh9KhzOJQJ^Jh9Kh= FOJQJ^Jh9Kh= F5OJQJ\^J h9KhgOJQJ^JnH tH #h9Khwk5OJQJ^JnH tH #h9Khg5OJQJ^JnH tH h9KhgOJQJ\^Jh9Kh= FOJQJ\^J!UfVgVVVVVVV WW;WdWeWWWQXRXeXX Y6YYYY0Z:ZRZgd&%. 7$8$H$gd= FgdgRZZZH[J[`[[[[j\l\\4]6]]]]4^6^^^L_N_``5`3a4aLa$a$gd]ngd&%.4^6^^^`^`aaac cKcLcMcNcddd;eggkglghhhiikkmmmmmmmmmmqq㱦ʊʊʂʂʊttttfh9KhDOJQJ\^Jh9KhHhOJQJ\^JhqTCJaJh9Kh]nOJQJ\^Jh9KhqTOJQJ\^JhqTOJQJ\^Jh]nOJQJ\^Jh9Kh&OJQJ\^Jh9Kh]nCJaJh9KhzOJQJ\^Jh9KhK OJQJ\^Jh9KhqOJQJ\^J(LaaaaaaJcKcLcMcNcdcddd$ddddd:e;ePeeefggggd&%.$a$gd]ng3gkglggghhhhhhiiijjkkkkl>lollllll$a$gd]ngd&%.lCmmmmmm*n3nspsqssssttUttttttgd&%.t/uHuOuVu`ugupuquuu#vZvvvvww!w)w*wmwwwww-xxxxgd&%.qZvvw/wsyty}}ہ܁:;#$'񲠲vvvvhZhh9Kh&OJQJ\^Jh9Kh$oOJQJ\^Jh9KhjI1OJQJ\^Jh9KhDOJQJ\^Jh9Kh=OJQJ\^J#h9KhK OJQJ\^JmH sH #h9KhDOJQJ\^JmH sH h9Kh,NOJQJ\^J#h9KhK OJQJ\^JmH sH h9KhK OJQJ^Jh9KhK OJQJ\^J#xxyyjykysytyyyzz>z?z{z>{?{w{{{}}}`}j}t}}}}}}gd&%.}}}(~h~i~~~~~F3݀ހ(ہ[gd&%.[rƂ45̓΃CDcrʅgd&%.gd=OJŇƇ"9:xy>܉VgdjI1gd&%.VYŊjË#>ь#$%&'JK"#gdyggd$ogdjI1#l!"h-.Lfgv$;VWegdCU 7$8$H$gdcgdjI1gdyg.fvSVWe2yz{Ƹ֨Ƙ}hSh>h>(h9KheOJQJ^JmH nH sH tH (h9KhcOJQJ^JmH nH sH tH (h9KhCUOJQJ^JmH nH sH tH h9KhCUOJQJ^Jh9KhCU5OJQJ^Jh9Khh 5OJQJ\^Jh9Kh,N5OJQJ\^Jh9KhcOJQJ\^Jh9Khc5OJQJ\^Jh9KhcOJQJ^Jh9Kh&OJQJ\^Jh9KhygOJQJ\^Jefϑ !z{345duӓԓՓgdq2 7$8$H$gdq2 7$8$H$gdCU 7$8$H$gdcgdCU{ӓԓՓDv@%5g|X|͙KL  zzzzzzzzxzcUch9Kh&OJQJ\^J(h9KhdOJQJ^JmH nH sH tH Uh9KhO9\OJQJ^Jh9KhO9\5OJQJ\^Jh9KhO9\OJQJ\^Jh9KhoOJQJ\^Jh9Kh^OJQJ\^J(h9Kh^OJQJ^JmH nH sH tH (h9KheOJQJ^JmH nH sH tH (h9Khq2OJQJ^JmH nH sH tH ./4679zikd $$IflU  t0644 la$ $Ifgdq2 ^`gd|gdq29:=>"ikdM $$IflU  t0644 la$ $Ifgdq2ikd $$Ifl'U  t0644 la$ >ABCDv@JKLj }}xxgd&gddgdO9\gdq2ikd $$IflU  t0644 la$ $Ifgdq2 select e.*,rank() over(order by sal desc)rank from emp e where rownum<=5 Q. Describe TO_DATE function. A. The TO_DATE function returns a timestamp from a character string that has been interpreted using a character template.TO_DATE is a synonym for TIMESTAMP_FORMAT. Write a syntax for To_Date function To_date('2003/07/09', 'yyyy/mm/dd') would return a date value of July 9, 2003. To_date('070903', 'MMDDYY') would return a date value of July 9, 2003. To_date('20020315', 'yyyymmdd') would return a date value of Mar 15, 2002. SELECT TO_DATE('January 15','MONTH DD') "Sample" FROM DUAL   4 5     T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h gdBgdd 3 4    ' ( 4 5 ? @ A I J N S T V a m n p vvveWh9KhoOJQJ\^J h9KhdOJQJ^JnH tH 1h9KhWpB*OJQJ^JmH nH phsH tH 1h9KhWpB*OJQJ^JmH nH phsH tH 1h9KhWpB*OJQJ^JmH nH phsH tH (h9KhWpOJQJ^JmH nH sH tH (h9KhdOJQJ^JmH nH sH tH (h9KhBOJQJ^JmH nH sH tH h i j k l m n o p gdq2gdd,1h/ =!"#$% Dd,h  c :ANormalFax01C"ú0<!-- google_ad_client = "pub-7042471392556119"; google_ad_width = 336; google_ad_height = 280; google_ad_format = "336x280_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "DFF2FD"; google_color_bg = "DFF2FD"; google_color_link = "0000CC"; google_color_url = "008000"; google_color_text = "000000"; //--> type="text/javascript"b!X󆡑NBDnX󆡑NBPNG  IHDRfsRGB@}0PLTE{bIDATE!0Eq^uM&VUp\ &C|)"3.8̴(6 jPtsʄ&)NU- \^w& ^eyƾ_c|_^9IENDB`Dd,0  c :ANormalFax01C"ì src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"b!X󆡑NB!nX󆡑NBPNG  IHDRfsRGB@}0PLTE{bIDATE!0Eq^uM&VUp\ &C|)"3.8̴(6 jPtsʄ&)NU- \^w& ^eyƾ_c|_^9IENDB`'Dd,  c :ANormalFax013"L: window.google_render_ad(); b!X󆡑NBnX󆡑NBPNG  IHDRfsRGB@}0PLTE{bIDATE!0Eq^uM&VUp\ &C|)"3.8̴(6 jPtsʄ&)NU- \^w& ^eyƾ_c|_^9IENDB`P$$If$ !vh5#v:Vl t65a$ P$$If$ !vh5#v:Vl' t65a$ P$$If$ !vh5#v:Vl t65a$ P$$If$ !vh5#v:Vl t65a$ @@@ NormalCJ_HaJmH sH tH R@R K  Heading 1dd@&[$\$5CJ0KH$\aJ0DA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No Liste@ K HTML Preformatted7 2( Px 4 #\'*.25@9CJOJQJ^JaJ4U@4 K  Hyperlink >*phj@j O9\ Table Grid7:V0vC@"v xBody Text Indent+ # ~= z9!1$CJOJQJaJR@2 xBody Text Indent 2; # ~= z9!"1$^`"CJOJQJaJS@B xBody Text Indent 38 L~= z9!|1$^`|CJOJQJaJ&@& ]nTOC 1B^`bB u\ Normal (Web)dd[$\$_12uv"/U^ #~-.NO Wh|}\]^YzP^B C ] ^   m n  L M & ' \ ] 8-hivw=UVjk9:acklQRijPQRcd "78QR H67%&;78_`}A 1 e f g v w =!>!M!z!!!!!!! " "n"o""""""##8#M#N##+$-$C$z${$$$$$$%%8%%w&&V''' (S(j(k((((((())*))))**9*>*?*W****++L++++,',},,,,,V-W-----,.F.}......8/q/r////00W000@1A1G1H122221222222{3|3}33344Y4f4g444Q5R5553646P6Q666667788999H:I:\::: ; ;;j;k;;;;<<<<<<m<<<<<<<<<<< =='===>=H==>??%?~??@m@@@@@A4ACAkAlAAAA=C>CuCCCCCDCDDDPDjDMEEFGGGGH1H2HEHH6IVIIIIIIJJ+J,JJJJJJJJJJ4KEKdKKKK-LfLLLLLLLfMgMMMMMMM NN;NdNeNNNQOROeOO P6PPPPQQ)QUQoQQQQQQQ5R6R\RRRRRRSS`SaSSSTT5T3U4ULUUUUUUJWKWLWMWNWdWXXX$XXXXX:Y;YPYYYZ[[[3[k[l[[[\\\\\\]]]^^____`>`o``````Caaaaaa*b3bgpgqgggghhUhhhhhh/iHiOiVi`igipiqiii#jZjjjjkk!k)k*kmkkkkk-lllllmmjmkmsmtmmmnn>n?n{n>o?owoooqqq`qjqtq}qqqqqq(rhrirrrrrsFstt3tttt(uuuuuuuuuuv[vrvvvvvww4w5wwwwwwCxDxxxycyryyyyyyyyyzOzzzz{{J{{{{{{"|9|:|x|y|||}>}}}}~V~Y~~~~j#>р#$%&'JK"#l!"h-.Lfgv$;VWefυ !z{345duӇԇՇ./4679:=>ABCDv@9:;Y#$tCDEFGHIJKLMNOPQRSTUVWXYZ[\]^a0000 0 0v 0 0 0 0v 0" 0v 0U 0v 0 00 0 00 0 0 0 0 00 00 00 0 0 0 0 0 0 0 0 0 0 0 000000@00000 0 0 0 0 0 0 0 0 0 0 000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000000000000000000000000 0 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 000000 00 0 00000000000000000000000000000000000000 0 00 00 0 0 0 0000 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0 0 0 0 0 0 0 0000000000000000000000000000000000000000000000012uv"/U^ #. Wh|}\]^YzP^B C ^  m n  M & ' ] 8-h7%&;78_`}A 1 =!>!M!!!!!! """"""#8#M#N##+$-$C$z${$$$$$$%%8%%&V''' (S(j(k((((((())*))))**9*>*?*W****++L++++,',},,,,V-W-----,.F.}......8/q/r////00W00022221222222{3|3}33344Y4f4g444Q5R553646P6Q666667788999H:I:\:;j;k;;;;<<<m<<<<<<<<<<< =='===>=H==>??%?~??@m@@@@@A4ACAkAlAAAA=C>CuCCCCCDCDDDPDjDMEEFGGGGH1H2HEHH6IVIIIIIIJJJJJJJJJ4KEKdKKKK-LfLLLfMgMMMMMMM NN;NdNeNNNQOROeOO P6PPPPQQ)QUQoQQQQQQQ5R6R\RRRRRRS`SaSSSTT5TLUUUUUJWKWNWdWX$XXXX:YYYZ[[[3[l[[[\\^____`>`o``````Caa*b3bgpgqgggghhUhhhhhh/iHiOiVi`igipiqiii#jZjjjjkk!k)k*kmkkkkk-lllllmmjmkmtmmmnn>n?n{n>o?owoooqqq`qjqtq}qqqqq(rhrirrrrrsFstt3tttt(uuuuuuuuuuv[vrvvvvvw4w5wwwwwwCxDxxxycyryyyyyyyyyzOzzzz{{J{{{{{{"|9|:|x|y|||}>}}}}~V~Y~~~~j#>р#'JK"#l!"h-.Lfgv$;VWfυ!z{345u@9Y#$tCUVWXYZ[a@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@00%0@0@0@00)0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@00708pp00@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0K0a0bHK0a0K0a0@0@0K0o0pHK0o0K0o0@0@0K0n0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0p@0p@0@0@0@0@0@0@0@0@0@0@0@0K00K00K00K02 HK02 K02K00@0@0@0@0 K00!HK00K00@0K00@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0p@0@0@0@0@0@0@0@0@0@0@0@@0@@0@@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0K083 9HK083 @0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0p@0p@0p@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0K01l@0@0@0@0@0@0@0K01_K01]@0@0@0@0@0@0K01\DHK01[K01Y@0@0@0@0@0@0@0@0@0K01QEHK01PK01N@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@@0@@0@@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0H@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0K02YH@ 0 @0@0K02pYHK02K02@0@0K02 K02@0@0K024ZHK02K02@0K02ZHK02K02@0@0@0K0738xjHK073@0K00K00K00K00@0@0@0@0@0@0@0@0} $(z,7AFR4^q{ p MQSUZ\^adgjmpv} C76!%>)z,04A9R=jDF>LRURZLaglhqtx}[V#e9> h p NPRTVWXY[]_`bcefhiklnoqrstuwxyz{|~p O O [ _X8A9A<$:At;A\bALԢ?Al@A\RAALBAcCAHDA<EAeFAGAHAIA#!!!00A12226b?b?b)g.g2g2g7ga     !!!00F1222;bFbFb-g0g6g;g;ga 9*urn:schemas-microsoft-com:office:smarttagsState=*urn:schemas-microsoft-com:office:smarttags PlaceType9*urn:schemas-microsoft-com:office:smarttagsplace8*urn:schemas-microsoft-com:office:smarttagsCity _ea g !-2chWaELPST\g|OX^g E!J!X![!!!!!!!v""""*(5(I,U,//////2 222"2%23333::u<<<<<<<<@@@AAA'A1A:ABAKAWA\AiAECPCRCaCcCtCCCCCCCCCCCD+D1D@DXFaF}FFFFGGGGGGHHH.HHHIII"I$I5I\IkIrIIIIIIIIIIJJJJJJJJJJJJKKK K"K3KhKwKzKKmLxLzLLLLLLLLoMtMvMMMMMMMMMMMMM N?NNNQN`N0Q=QKQSQuQQQQR RRR!R'RkRuR~RRRR%S.SHSSSVS\ShSrSSSSSSSXXX Y[[\\W`f`x````````aaaaaaffffffg gOg\ggghhhhiikkelsllm2nG 2PTlq9@%05FG M "!1!M!W! """"##:$@$$$0%7%''V'a'S(i(")))))2*8*L*V*W*b***++++O,U,,,W-e-......//// 0000223333Q4X4Y4e4k4s44444W5`55555<6H667=7K79999|<<<<<<==??@%@m@p@@@rAxA)D,DIDODDDDDFFGG,H0H=HCHJJJJJJJJKKLLM M}MMMM`NcNNNPPQ"QQQQQR RRR)S3SaSgSSS0T4TTTGUKULU^U1V3VXWcWXXEYOYPY^YZ ZZZZZt[[[[\\E\M\\\\]]]]^__?`C` aaDaGakbnbbb ccHcNcccccccddodrdddeeeeuffffUhYhhhhhii#j&jZjbjjjjjkk&l,l.l5lllllamimmm{n}nqouowo{orr(u,u#v)v[v`vw$wGwHwbwfwxxyyR{T{{{}}KNz~w{5; BF؅څor nrDHw}\_ ',w|ďa33333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333[\    GGOGPGHHHHHHKWMWXX\\]]aa<&v16ԗ p^ .}rVEN4"D;Sp@#)6LbK$jIb d9p>#& - Z)l_I̜XP:4P|SP|ZWҦng YJnMYb°2pP1n(2q43 vV`yQz ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo( pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo( ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( PP^P`OJQJo( ^`OJQJo(n ^`OJQJo( pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L. ^`OJQJo(n ^`OJQJo( pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo( ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( PP^P`OJQJo( ^`OJQJo( ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( PP^P`OJQJo( ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo( ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( PP^P`OJQJo(^`5o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo(n ^`OJQJo( pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n ^`OJQJo( ^`OJQJo( pp^p`OJQJo( @ @ ^@ `OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( ^`OJQJo( PP^P`OJQJo(^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. ^`OJQJo(n ^`OJQJo(n pp^p`OJQJo(n @ @ ^@ `OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n ^`OJQJo(n PP^P`OJQJo(n|ZWg Y|S#);pIbE16MYb&r^ _I(2qXPK- Z)4<`yd9p43 v./.0(mb7j6Xpoط(aH`J(&LR4l|8YTVBJ~`Y~%T"v*Tbe0h4Xb(8ز4;8wd{0&̋$~vpVJ@kH}r~PДE8r4 ␭eޅءTFkd¬frAyl(*lDN:ܛ,b#HZ0E~FNq>.)|t8,9H$ހ԰nSdk:H0tV6j 6"tϨFQ=ЊDn."`ͶbVFfS(q_ji8H&N碫4 :ܣ g¢LhXZj4@ &k:yĖ&RT?\L.v̒>hߊf>aPd`t'F5kYB%=8+̇xC}DJBThCL䞲Hlq^N        ΅ F Tv~ J@2dzF!%;.d$g Ѓ2V )zSXOF.,SX Lv_a wB~"(DkL^{t`{v1Rf        =APT IIJܝb2f(j1Zb?3uW0cfHJ9C!]F"fHJW0/6-mH i]/6u'AF[]j;]rt95x]x-L GO#^T E/C mH oL# x,oW0o5$8IxE30eD`D%:FmH \U30(ETW0D7mH yq'<)R? P ) :M2mH 0q']WZbj;} )S3YeV>\f7R )mH !BT8dd HT307Tq'\TP ) U16&y#U30WOV Sd\HfZmH 8T]T}]E g]9:'H]Sj]30z^^J^$~,,,,s^H7afHJPc30@Xc ) SdhAvE gxHg)biIg ))biJj.-&[k UDkfHJ kx:l30wnE gZ9nP )Lrn}~)qmH BDs]]rt^~t{&u30!uC;(vzlp!hAvk_%Ox30{,b{/u~E g*&~^~ $~SRK xzqL~'b:h *&%.m0jI1q2-4= F;G{H9KZRCU~LXS[O9\u\LVeHhwk]nhgn*p qWu<vRBx!|f}q|=g3&Al=wVp=aD?^ygy71DBuo8esU;GCc3VWp,NqT:dgC$o07w&uՇ./4679:=>ABa@X:;QST_`@`B`@`Z`^`@`@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New;Wingdings?Wingdings 2"qhʆǚ15zIzI!24 2qHX)?K 2-SQL Interview Questions For Software Testers gunaseka Y00025406h                  Oh+'0 ,8 X d p|0SQL Interview Questions For Software Testers  gunasekaNormal Y00025406305Microsoft Office Word@~%@:@zsC?z՜.+,D՜.+,` hp   TruelinkI' .SQL Interview Questions For Software Testers Title 8@ _PID_HLINKSAXMhttp://searchsqlserver.techtarget.com/sDefinition/0,,sid87_gci902812,00.html  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./012346789:;<>?@ABCDIRoot Entry F%\?KData 1Table$DWordDocument.SummaryInformation(5DocumentSummaryInformation8=CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q