Exam
: Oracle 1Z1-047
Title
: Oracle? Database SQL
Expert
Version : Demo
1. Which statements are true? (Choose all that apply.)
A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views can consist of joins of dictionary base tables and user-defined tables.
C. The usernames of all the users including the database administrators are stored in the data dictionary.
D. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a
constraint applies.
E. Both USER_OBJECTS and CAT views provide the same information about all the objects that are
owned by the user.
F. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base
tables from the data dictionary
Answer: CDF
2. View the Exhibit and examine the structure of the MARKS_DETAILS and MARKStables.
Which is the best method to load data from the MARKS_DETAILStable to the MARKStable?
A. Pivoting INSERT
B. Unconditional INSERT
C. Conditional ALL INSERT
D. Conditional FIRST INSERT
Answer: A
3. Evaluate the CREATE TABLE statement:
Which statement is true regarding the PROD_ID_PK constraint?
A. It would be created only if a unique index is manually created first.
B. It would be created and would use an automatically created unique index.
C. It would be created and would use an automatically created nonunique index.
D. It would be created and remains in a disabled state because no index is specified in the command.
Answer: B
4. Given below is a list of datetime data types and examples of values stored in them in a random order:
Identify the option that correctly matches the data types with the values.
A. 1-d, 2-c, 3-a, 4-b
B. 1-b, 2-a, 3-c, 4-d
C. 1-b, 2-a, 3-d, 4-c
D. 1-d, 2-c, 3-b, 4-a
Answer: A
5. Which three statements are true regarding single-row functions? (Choose three.)
A. They can accept only one argument.
B. They can be nested up to only two levels.
C. They can return multiple values of more than one data type.
D. They can be used in SELECT, WHERE, and