Which of the following are schema objects? (Choose all that apply.)
Answer
SEQUENCE
PASSWORD
INDEX
ROLE
Question 3
Question
A CONSTRAINT is assigned to which of the following?This
Answer
TABLE
SYNONYM
SEQUENCE
INDEX
Question 4
Question
Which of the following are valid CREATE TABLE statements? (Choose three.)
Answer
CREATE TABLE $ORDERS
(ID NUMBER,
NAME VARCHAR2(30));
CREATE TABLE CUSTOMER_HISTORY
(ID NUMBER,
NAME VARCHAR2(30));
CREATE TABLE "Boat Inventory"
(ID NUMBER,
NAME VARCHAR2(30));
CREATE TABLE workSchedule
(ID NUMBER,
NAME VARCHAR2(30));
Question 5
Question
Which of the following options can be used with the reserved word CREATE to form the beginning of a complete SQL statement? (Choose three.)
Answer
TABLE
VIEW
CONSTRAINT
SEQUENCE
Question 6
Question
You are logged in to user FINANCE. It is currently the only schema in the entire database. The following exist in the database:
A VIEW named VENDORS
A CONSTRAINT named VENDORS
An INDEX named CUSTOMER#ADDRESS
The question is flawed because you cannot have an INDEX named CUSTOMER#ADDRESS.
The question is flawed because you cannot have a VIEW and a CONSTRAINT with identical names in the same schema.
The SQL statement will fail to execute and result in an error message because you cannot create a TABLE name with the # character.
The SQL statement will fail to execute and result in an error message because you cannot create a TABLE that has the same name as an INDEX in the same schema.
The SQL statement will execute, and the TABLE will be created.
Question 7
Question
You have a single database, with only one schema. The following four objects exist in the database:
A TABLE named PRODUCT_CATALOG
A TABLE named ADS
A USER named PRODUCT_CATALOG
A VIEW named CONFERENCE_SCHEDULE
How many of the four objects are owned by the schema?
Answer
0
2
3
4
Question 8
Question
Which of the following is true about ROLES?
Answer
Roles are schema objects but only when created from within a user account.
Roles are in the same namespace as CONSTRAINTS.
Roles are in the same namespace as TABLES.
Roles are in the same namespace as USERS.
Question 9
Question
The DESC command can be used to do which of the following?
Answer
Show a table's columns and the data types of those columns
Show a brief paragraph describing what the table does
The statement will fail because you cannot create two primary key constraints on the table.
The statement will successfully create the table and the first primary key but not the second.
The statement will successfully create a single table and one composite primary key consisting of two columns.
The statement will successfully create the table and two primary keys.
Question 15
Question
The difference between dropping a column from a table with DROP and setting a column to be UNUSED is:
Answer
An UNUSED column can be recovered.
The UNUSED column and its data are retained within the table's storage allocation and counts against the total limit on the number of columns the table is allowed to have.
A column that is dropped with DROP no longer appears within the table's description as shown with the DESC or DESCRIBE statement, whereas a column that is set to UNUSED still appears in the table's structure as shown in the output of the DESC statement.
Nothing.
Question 16
Question
The purpose of the CREATE DIRECTORY statement is to create a named object in the database:
Answer
That lists names of user accounts that have external privileges
That contains lookup reference material for queries
That identifies the root directory of the Oracle server installation
That points to a directory you choose somewhere within the Oracle server's file system