SQL command information

By PSR -

 1. Which is the subset of SQAL commands used to manipulate Oracle Database structures, including tables?

    Data Definition Language (DDL)

2. What operator performs patter matching?

    LIKE operator

3. What operator test column for the absence of data?

    IS NULL operator

4. Which command executes the contents of a specified file?

    START <filename> or @<filename>

5. What is the parameter substitution symbol used with INSERT INTO commands?

    &

6. Which command displays the SQL command in the SQL buffer, and then executes it?

    RUN

7. What are the wildcards used for pattern matching?

    _for single character substitution and % for multi-character substitution

8. State true or false. EXISTS, SOME, ANY are operators in SQL.

    true

9. State true or false, !=, < >, ^= all denote the same operation.

    True

10. What are the privileges that can be granted on a table by a user to others?

    Insert, update, delete, select, reference, index, execute, alter, all

11. What command is used to get back the privileges offered by the GRANT command?

    REVOKE

12. Which system tables contains information privileges granted and privileges obtained?

    USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD

13. Which system table contains information on constraints on all the tables created?

    USER_CONTRAINTS

14. TRUNCATE table emp;

    DELETE from emp;

    will the outputs of the above two commands differs?

    Both will result in deleting all the rows in the table EMP.

Comments

Post a Comment

Popular posts from this blog

By PSR -
Testing Guys please provide your valuable feedback, opinion on this blog spot. If you wish to share any new ideas,documentation on testing please your welcome.
Read more

Some more Testing Types

By PSR -
Image
Adhoc Testing : Testing is done without any formal test plan or test case creation. It helps tester in learning the application prior starting with any other testing. GUI : GUI testing is done to whether all the GUI standards are followed or not. Microsoft GUI standard are the best standard for GUI. Content: Section I: Windows compliance standards: 1. Application 2. For each window in the application 3. Text boxes 4. Options (Radio buttons) 5. Check boxes 6. Command button 7. Drop down list boxes 8. Combo boxes 9. List boxes Section 2: Tester’s screen validation checklist. 1. Aesthetic condition 2. Validation condition 3. Navigation condition 4. Usability condition 5. Data integrity condition 6. Modes (Editable read only) condition 7. General condition 8. Specific field tests 9. Data field test 10. Numeric field 11. Alpha field check Exploratory Testing : This testing is similar to ad-hoc testing and is done in order to explore the application to find out t...
Read more

Software Development Life Cycle

By PSR -
Image
Software Development Life Cycle: The software development life cycle begins with the identification of requirement for software and ends with the formal verification of the development software against that requirement. In V-Shaped model the development and testing phase are carried out parallel sequence i.e. Verification on one side and validation on other side. Advantage : As the verification and validation are done along with the test management. The outcome of V shaped model is a quality product. Drawback : Time consuming and costly model. Water fall model : in this model the development and testing phase are carried out step by step process and a base line document is prepared. Advantage : It’s simple model and easy to maintain, project implementation is very easy. Drawback : Can’t incorporate new changes in the middle of the project development. Base line document. Prototype Model (Rapid Prototype model) :- This is cyclic version of the linear model. In this model once...
Read more