Pl Sql Questions

http://www.techinterviews.com/interview-questions/unixlinux


 

SQL AND PL/SQL Read the following code: Read the following code: 22. CREATE OR REPLACE TRIGGER update_show_gross 23. {trigger information} 24. BEGIN 25. {additional code} 26. END; The trigger code should only execute when the column, COST_PER_TICKET, is greater than $3. Which trigger information will you add? 1. WHEN (new.cost_per_ticket > 3.75) 2. WHEN (:new.cost_per_ticket > 3.75 3. WHERE (new.cost_per_ticket > 3.75) 4. WHERE (:new.cost_per_ticket > 3.75) What's SQL What's SQL*Plus What's NVL What's Date Functions What's Character Functions What's TTITLE & BTITLE What's COLUMN What's BREAK What's COMPUTE What's SET What's SPOOL What's JOIN What's Union What's Intersect What's Minus What's Correlated Subquery What's Multiple columns What's Sequences What's Synonyms What's Indexes What's Data types Order of SQL statement execution What's Transaction What's Commit What's Posting What's Rollback What's Savepoint Set Transaction What's Locking What's Consistency What's Integrity What's Deadlock What's Mutating Table What's SQL*Loader The most important DDL statements in SQL are: Operators used in SELECT statements. SELECT statements: The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records. The INSERT INTO Statements: The Update Statement: The Delete Statements: Sort the Rows: The IN operator may be used if you know the exact value you want to return for at least one of the columns. BETWEEN ... AND What is the use of CASCADE CONSTRAINTS? Why does the following command give a compilation error? Which system tables contain information on privileges granted and privileges obtained? Which system table contains information on constraints on all the tables created?obtained? What is the difference between TRUNCATE and DELETE commands? State true or false. !=, <>, ^= all denote the same operation? State true or false. EXISTS, SOME, ANY are operators in SQL? What will be the output of the following query? What does the following query do? What is the advantage of specifying WITH GRANT OPTION in the GRANT command? Which command executes the contents of a specified file? What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;? Which command displays the SQL command in the SQL buffer, and then executes it? What command is used to get back the privileges offered by the GRANT command? What will be the output of the following query? Which date function is used to find the difference between two dates? What operator performs pattern matching? What is the use of the DROP option in the ALTER TABLE command? What operator tests column for the absence of data? What are the privileges that can be granted on a table by a user to others? Which function is used to find the largest integer less than or equal to a specific value? Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? What is the use of DESC in SQL? What command is used to create a table by copying the structure of another table? TRUNCATE TABLE EMP; DELETE FROM EMP; Will the outputs of the above two commands differ? What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL;? What are the wildcards used for pattern matching.? What is the parameter substitution symbol used with INSERT INTO command? What's an SQL injection? What is difference between TRUNCATE & DELETE What is a join? Explain the different types of joins? What is the sub-query? What is correlated sub-query? Explain CONNECT BY PRIOR? Difference between SUBSTR and INSTR? Explain UNION, MINUS, UNION ALL and INTERSECT? What is ROWID? What is the fastest way of accessing a row in a table? What is an integrity constraint? What is referential integrity constraint? What is the usage of SAVEPOINTS? What is ON DELETE CASCADE? What are the data types allowed in a table? What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type? How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY? What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint? Where the integrity constraints are stored in data dictionary? How will you activate/deactivate integrity constraints? If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE? What is a database link? How to access the current value and next value from a sequence? Is it possible to access the current va If want more things for interview questions followed by below link: http://dev.fyicenter.com/Interview-Questions/SQL/_Read_the_following_code__109.html