READ Free Dumps For Oracle- 1z0-007
| Question ID 8023 | Which is a valid CREATE TABLE statement?
|
| Option A | CREATE TABLE EMP9$# AS (empid number(2));
|
| Option B | CREATE TABLE EMP*123 AS (empid number(2));
|
| Option C | CREATE TABLE PACKAGE AS (packid number(2));
|
| Option D | CREATE TABLE 1EMP_TEST AS (empid number(2));
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation : Table names and column names must begin with a letter and be 1-30 characters long. Characters A-Z,a-z, 0-9, _, $ and # (legal characters but their use is discouraged). Incorrect answer : B Non alphanumeric character such as "*" is discourage in Oracle table name. D Table name must begin with a letter. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 9-4
| Question ID 8024 | A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?
|
| Option A | difference, projection, join
|
| Option B | selection, projection, join
|
| Option C | selection, intersection, join
|
| Option D | intersection, projection, join
|
| Option E | difference, projection, product
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation : choose rows from a table is SELECTION, Choose column from a table is PROJECTION Bring together data in different table by creating a link between them is JOIN. Incorrect answer : A answer should have SELECTION, PROJECTION and JOIN. C answer should have SELECTION, PROJECTION and JOIN. D answer should have SELECTION, PROJECTION and JOIN. E answer should have SELECTION, PROJECTION and JOIN. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 1-6