| Reviewing It |
1: | What is Oracle's main character-mode interface? |
2: | What is the syntax of the CHANGE command to change text in the SQL buffer? |
3: | The DESCRIBE command is useful for what? |
4: | What will the command SELECT * FROM EMP do? |
5: | In the table EMP, give the ORDER BY clause that will return the rows in the order of DEPTNO ascending and within DEPTNO, SAL descending. |
6: | What is the difference between a NULL and a 0 field? |
7: | When using substitution characters (say in an INSERT statement), what is the difference between & and &&? |
8: | What is the difference between the DELETE command and the TRUNCATE command? |
9: | Tablespaces are used for what? |
10: | Show the syntax to create an index on ename for the table EMP. |
11: | What is an EXTENT? |
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.