The ____________________ view can be used to verify the existence of an index owned by a user.
user_indexes
An index is not implicitly created when which type of constraint is created
not null
Which of the following contains the ROWID of referenced rows
index
If more than ____________________ percent of a table is expected to be returned in the results of a query, then an index will probably not speed up the process
10
Which of the following commands is used to create a function-based index
CREATE INDEX...ON
Indexes can speed up row retrieval, but can slow down ____________________ operations because the index must also be updated
DML
A Bitmap index is useful for improving queries on columns that have low cardinality
true
An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table
Index Organized Table
A basic CREATE INDEX command will create a B-Tree index
true
The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached
cycle
If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default
private
Which of the following can be used to provide an alternative, simplified name, to identify database objects
synonym
The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command
true
Which command will create a synonym for a table
CREATE SYNONYM synonymname FOR tablename;
A synonym is an alternate name assigned to database instances
false
If a sequence is set to pre-generate sequential values, ____ values will be generated at one time by default.
20
The ____________________ value of a sequence cannot be changed if the sequence has already generated a number greater than that value
MAXVALUE
With a MERGE statement, a series of ____ actions can occur with a single SQL statement
merge
A single-row subquery can return several columns, but only one row, of results to the outer query
false
A subquery nested in a SELECT clause cannot contain an ORDER BY clause
true
When a multiple-column subquery is used in the WHERE clause of the outer query, the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks
true
A group function can be used in a(n) inline view
false
IN is not a valid operator for a multiple-column subquery
false
The ____ function is used to determine how widely data are spread out within a group
VARIANCE
The MIN function can be used with numeric, date, and character columns
tRUE
LOWER, UPPER, and INITCAP functions are all character manipulation functions
false
To calculate the difference between two date columns, you must use the TO_DATE function
false
Based upon the contents of the ORDERS table, which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped
SELECT order#, TO_CHAR(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL
The outer join operator is placed on the side of the joining condition that has ____________________ rows.
missing
A full outer join cannot be created in the ____________________ clause.
where
The outer join operator in the WHERE clause cannot be used with which of the following operators
AND , IN
To display rows from one table that do not have a corresponding row in the other table, you must create a(n) ____________________ join
outer
table alias can have a max of ____ characters
30
Data stored in separate tables can be reconstructed through the use of
Joins
When you add a new row to a database table, it is immediately visible to other users.
false
Logical operators are evaluated in the order of NOT, AND, and OR
true
The order in which NULL values appear in the results can be overridden by which of the following keywords
null last , null first
INSERT INTO acctmantable
AS (SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDATE);
is this right commandment : yes
DELETE pubid = 4 FROM publisher
vs
DELETE FROM publisher WHERE pubid = 4;
DELETE FROM publisher WHERE pubid = 4;
Deleting columns from a table is a(n) ____ action
unrestricted
Adding a check condition constraint to a table is a
restricted action
If the column S_ID is the primary key of the STUDENT table, the constraint name would be pk_STUDENT_S_ID according to the constraint naming convention
false
Which of the following column data type changes is permitted?
VARCHAR2 to CHAR
ALTER TABLE customers
MODIFY (city (20), lastname (14));
vs
ALTER TABLE customers
MODIFY (city VARCHAR2(20), lastname VARCHAR2(14));
ALTER TABLE customers
MODIFY (city VARCHAR2(20), lastname VARCHAR2(14));
You cannot delete the last column in a table.
true
A DATE column consists of ____________________ bytes
7
The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.
AS
The VARCHAR2 data type stores variable-length character data up to a maximum of ____________________ characters
4000
Which of the following is not required when creating a table
table size
In which format does Oracle10g display a date value
DD-MON-YY
The column definition of NUMBER(7, 4) indicates a precision of
7
A fixed-point number contains a specific number of decimal places
true
The CHAR and VARCHAR2 data types store Unicode character data
false it uses ASCII