| Help w/study questions [message #373746] |
Thu, 03 May 2001 22:11  |
Brenda
Messages: 3
Registered: May 2001
|
Junior Member |
|
|
1. Dropping a table has which of the following effects on a nonunique index
created for the table?
A. No effect.
B. The index will be dropped.
C. The index will be rendered invalid.
D. The index will contain NULL values.
2. Which of the following statements about indexes is true?
A. Columns with low cardinality are handled well by B_tree indexes.
B. Columns with low cardinality are handled poorly by bitmap indexes.
C. Columns with high cardinality are handled well by B_tree indexes.
3. To increase the number of nullable columns for a table:
Use the alter table statement.
Ensure that all column values are NULL for all rows.
C. First, increase the size of adjacent column clatatypes, and then add the column.
D. Add the column, populate the column, and then add the NOT NULL constraint.
4. To add the number of columns selected by a view:
A. Add more columns to the underlying table.
B. Issue the alter view statement.
C. Use a correlated subquery in conjunction with the view.
Drop and re_create the view with references to select more columns.
5. A user issues the statement select count (*) f rom EMPLOYEE. The
query takes an inordinately long time and returns a count of zero. The
most cost_effective solution is
A. Upgrade the hardware.
B. Truncate the table.
C. Upgrade the version of Oracle.
D. Delete the highwatermark.
6. Which of the following choices are valid parameters for sequence
creation?
A. identified by
B. using temporary tablespace
C. maxvalue
D. on delete cascade
7. The following statement is issued against the Oracle database. Which line will produce an error?
A. create view EMP_VIEW_01
B. as select E.EMPID, E.LASTNAME, E.FIRSTNAME, A.ADDRESS
C. from EMPLOYEE E, EMPL_ADDRESS A
D. where E.EMPID = A.EMPID
E. with check option;
F. This statement contains no errors.
8. The following statement is issued on the database: comment on table EMPL is ‘Do not use this table. ‘ How can this data be viewed?
A. Using the describe command
B. Issuing a select * from empl statement
C. Selecting from ALL_COMMENTS
D. Selecting from ALL_TAB_COMMENTS
9. Which system privilege allows the user to connect to a database in
restricted session mode?
A. create table
B. create user
C. restricted session
D. create session
10. Which of the following statements is true about roles? (Choose three)
A. Roles can be granted to other roles.
B. Privileges can be granted to roles.
C. Roles can be granted to users.
D . Roles can be granted to synonyms.
11. User MANN has granted the create any view with admin option privilege to user SNOW. User SNOW granted the same privilege with admin option to user REED. User MANN revokes the privilege from user SNOW. Which statement is true about privileges granted to users REED, MANN, and SNOW?
A. REED and MANN have the privilege, but SNOW does not.
B. REED and SNOW have the privilege, but MANN does not.
C. MANN and SNOW have the privilege, but REED does not.
D. MANN has the privilege, but SNOW and REED do not.
12. After referencing NEXTVAL, the value in CURRVAL
A. Is incremented by one
B. Is now in PREVVAL
C. Is equal to NEXTVAL
D. Is unchanged
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
