We're so confident of our products that we provide no hassle product exchange.
Oracle9i dba new features for Oracle7.3 and Oracle9 ocps Sample Questions:
1. The TYPE clause used in the creation of an external table defines which access driver is used to convert the data when needed by SQL statements inside the database. Which type of access driver is supported for external tables?
A) ORACLE LOADER
B) Metadata API
C) Direct path export
D) Import
2. The database was started up using a text parameter file.
What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?
A) Both init<SID>.ora parameters and SPFILE values are updated.
B) Both SPFILE and MEMORY memory values are updated.
C) Only init<SID>.ora parameters are updated.
D) Only MEMORY is updated.
E) Only SPFILE values are updated.
3. Click the Exhibit button and examine the code.
Which three statements correctly describe the Secure Application role definition?
(Choose three.) (The SYS_CONTEXT calls returns whether or not the session is a true DBA session.)
A) app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label.
B) No user or application has to remember or hide a password.
C) It prevents everyone except a true DBA session from acquiring the READWRITE role.
D) app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.
4. Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery? (Choose three.)
A) skipping unused blocks
B) partial database backups
C) detection of corrupted blocks during backup
D) online backups
E) incremental block-level backup
5. What is one benefit of using the ALTER TABLE ... MOVE command rather than a CREATE TABLE ... AS SELECT command?
A) row chaining is eliminated.
B) duplicate space is not required while the command executes.
C) all operations, such as INSERT, UPDATE, DELETE, and SELECT can be performed while the operation completes.
D) index definitions are retained.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: D | Question # 3 Answer: B,C,D | Question # 4 Answer: A,C,E | Question # 5 Answer: D |
By King
