Oracle Funda 1 Exam IZO-031 (Trial) Online Test

When UNDO tablespace clause in the CREATE DATABASE statement is ommited and the UNDO_MANAGEMENT parameter is set to AUTO. What is the result of CREATE DATABASE statement?
The Oracle server creates no undo tablespaces.
The Oracle server creates an undo segment in the SYSTEM tablespace.
The Oracle server creates one undo tablespace with the name SYS_UNDOTBS.
Database creation fails because you did not specify an undo tablespace on the CREATE DATABASE statement.
A SYSDBA have created the PAYCLERK role and granted the role to User A. User A in turn attempts to modify the authentication method of the PAYCLERK role from SALARY to NOT IDENTIFIED, but when doing so he receives the insufficient privilege error shown below. SQL> connect User A/Password Connected. SQL> alter role payclerk not identified; alter role payclerk not identified * ERROR at line 1: ORA-01031: insufficient privileges Which privilege does User A require to modify the authentication method of the PAYCLERK role?
MANAGE ANY ROLE
CREATE ANY ROLE
ALTER ANY ROLE
UPDATE ANY ROLE
When attemted to re-create the database and supposed to reuse all of existing database files. following SQL statement is isued: CREATE DATABASE sampledb DATAFILE '/u01/oradata/sampledb/system0l.dbf' SIZE 100M REUSE LOGFILE GROUP 1 ('/u01/oradata/sampledb/log01.rdo', '/u02/oradata/sampledb/log01.rdo') SIZE 50K REUSE, GROUP 2 ('/u01/oradata/sampledb/log02.rdo', '/u02/oradata/sampledb/log02.rdo') SIZE 50K REUSE MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10; Why does the CREATE DATABASE statement fail?
The MAXLOGFILES is set too low.
The CONTROLFILE REUSE clause cannot be omiited.
The online redo log files cannot be resued.
The data file belonging to the SYSTEM tablespace cannot be resued.
Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?
LGWR
PMON
CKPT
DBWn
SMON
Based on the following profile limits, if a user attempts to log in and fails after five tries, how long must the user wait before attempting to log in again? ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 60 PASSWORD_GRACE_TIME 10 PASSWORD_REUSE_TIME 1800 PASSWORD_REUSE_MAX UNLIMITED FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LOCK_TIME 1/1440 PASSWORD_VERIFY_FUNCTION verify_function;
1 minutes
5 minutes
10 minutes
14 minutes
60 minutes
Which storage structure provides a way to physically store rows from more than one table in the same data block?
Cluster Table
Partined Table
Index - Oraganized Table
Un clustered Table
Select the memory structure(s) that would be used to store the parse information and actual value of the bind variable id for the following set of commands: VARIABLE id NUMBER; BEGIN : id: =1; END; /
PGA only
Row cache and PGA
Shared pool only
PGA and library cache
What will be size for the fifth extent in the syntax below, While creating a table named as DEPARTMENTS : CREATE TABLE hr.departments( department_id NUMBER(2), department_name VARCHAR2(20), manager_id NUMBER(4), location_id NUMBER(2)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE data;
200 K
300 K
450 K
675 K
A DBA has issued the following SQL statement: SELECT max_blocks FROM dba_ts_quotas WHERE tablespace_name='USERS' AND username='USER A'; User A has unlimited quota on the USERS tablespace. Which value will the query return?
Unlimited
0
1
-1
When the STARTUP command is issued. Which file is checked to determine the state of the database?
The most recently created archived redo log file
The first member of redo log file group 1
The data file belonging to the SYSTEM tablespace
The control file




















































Description:

This test is not conducted by Oracle Corporation, and is only Oracle DBA exam preperation. We donot issue any certificate or whatsover required/ requisite for the Online Test. ORACLE is registered trademarks of Oracle Corporation INC and we are nowhere associated with the same. We are not reponsible under any circumtances for any problem/error encountered while using the site/questions.

Discussion

Umam

• Jika terkena udara basah akan terbentuk karat (Fe2O3. nH2O).
Reaksi http://goo.gl/TLJKhQ http://bit.ly/2bgLGS7
pembentukan karat, yaitu

1192 days 8 hours 15 minutes ago

Umam

a. http://goo.gl/AfxmL4 http://bit.ly/2c5pYC8
Besi kasar : kadar karbon lebih besar dari 3,5%, tidak dapat ditempa.
b. Besi : kadar karbon lebih besar dari 2,5%, tidak dapat ditempa.

1192 days 8 hours 18 minutes ago

Himanshu Mathur

when the free space of one block gets full

1633 days 1 hours 22 minutes ago

shri

good

3642 days 4 hours 8 minutes ago

shri

good

3642 days 4 hours 8 minutes ago

1 Follower
Tests: 2

Your Facebook Friends on WizIQ

More Tests By Author

Title : Trail Internet Test
5 Questions | 24 Attempts