Q.1 Which two parameters might affect the concurrency of transactions on a data block? (choose 2)

A.
PCTUSED
* B. PCTFREE
* C. INITRANS
D. MAXEXTENTS
E. NEXTEXTENT


Q.2 Which two statements about tempfiles are true? (choose 2)

* A.
Media recovery doesnt recover tempfiles
B. Tempiles can contain permanent segments
C. Tempfiles are always set to LOGGING Mode
D. Tempfiles
are used for all types of temporary space
* E. You cannot create a tempfile with the ALTER DATABASE command
F. BACKUP CONTROLFILE generates
commands to recreate lost tempfiles


Q.3 When creating rollback segments, what is considered the value for the OPTIMAL storage parameter?


A. 500k
B. 10 * MINEXTENTS
C. average undo size * 4
* D. This must be calculated by running the largest transaction and checking rollback
segment size


Q.4 From data dictionary know that a user A has a profile Test_Proof assigned, and the IDLE_TIME resource shows DEFAULT as value.
What does this mean?

* A. The actual limit depends on the setting in the profile called DEFAULT
B. ...
C. ...
D. ...


Q.5 Which
syntax about creating a role is wrong?

A. CREATE ROLE xyz;
B. CREATE ROLE xyz NOT IDENTIFIED;
C. CREATE ROLE xyz IDENTIFIED BY abc;
D.
CREATE ROLE xyz IDENTIFIED EXTERNALLY;
* E. CREATE ROLE xyz IDENTIFIED INTERNALLY;


Q.6 What are two effects of setting
REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE? (choose 2)

A. Passwordfile can be stored remotely
B. Passwordfile access is restricted to local users

* C. Only one instance on the database can use the passwordfile
* D. Remote connection using the SYSDBA privileges are allowed
E. Remote
connection using the SYSDBA privileges are prohibited


Q.7 Question shows output from ARCHIVE LOG LIST command:

Database Log Mode No
Archive Mode
Automatic Archival Enabled
Archive Destination C:\ora\...
Oldest Online Sequence 1059
Current Online Sequence 1061

Q.8
What ist the value of LOG_ARCHIVE_START?

A. TRUE
* B. FALSE
C. Enabled
D. No_Archive_Log

---