SQL1 - SQL 1 Which is the subset of SQL commands used to manipulate Oracle Database structures including tables?Data Definition Language(DDL 2 What

SQL1 - SQL 1 Which is the subset of SQL commands used to...

This preview shows page 1 - 3 out of 7 pages.

SQL 1. Which is the subset of SQL commands used to manipulate Oracle Databasestructures, including tables?Data Definition Language (DDL) 2.What operator performs pattern matching?LIKE operator 3. 4. What operator tests column for the absence of data IS NULL operator 5.Which command executes the contents of a specified file? 6.What is the parameter substitution symbol used with INSERT INTO command? 7.Which command displays the SQL command in the SQL buffer, and then executesit?RUN 8.What are the wildcards used for pattern matching?_ for single character substitution and % for multi-character substitution 9. State true or false. EXISTS, SOME, ANY are operators in SQL. True 10. State true or false. !=, <>, ^= all denote the same operation. True 11. What are the privileges that can be granted on a table by a user to others? 12. What command is used to get back the privileges offered by the GRANTcommand? 13. Which system tables contain information on privileges granted and privilegesobtained? 14. Which system table contains information on constraints on all the tables created? 15. TRUNCATE TABLE EMP;DELETE FROM EMP;Will the outputs of the above two commands differ? 16. What the difference is between TRUNCATE and DELETE commands? 1. TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. 1
Image of page 1
2 . WHERE clause can be used with DELETE and not with TRUNCATE. 17. What command is used to create a table by copying the structure of anothertable? 18. What will be the output of the following query?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 7 pages?

  • Summer '12
  • emp

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes