Skip to content

Tag: 1Z0-031 certification dumps

Passleader Latest Sample Questions for Oracle 1Z0-031 Test (101-110)

Published May 7, 2014

QUESTION 101:
You decide to grant the SYSDBA privilege to SCOTT and execute the following command:
SQL> GRANT SYSDBA TO SCOTT;
GRANT SYSDBA TO SCOTT
*
ERROR at line 1:
ORA-01994: GRANT failed: cannot add users to public password file
What could be the reason for this error?

A.The REMOTE_OS_AUTHENT parameter is set to TRUE.
B.The REMOTE_OS_AUTHENT parameter is set to FALSE.
C.The REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED.
D.The REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE.
E.The maximum number of entries in the password file has been exceeded.

Continue readingPassleader Latest Sample Questions for Oracle 1Z0-031 Test (101-110)
Comments closed

Passleader Latest Sample Questions for Oracle 1Z0-031 Test (91-100)

Published May 6, 2014

QUESTION 91:
In your database, the MAX_DUMP_FILE_SIZE initialization parameter is set as follows:
MAX_DUMP_FILE_SIZE=1000
What would be the effect of this command?

A.The size of the alert log file cannot exceed 1,000 MB.
B.The size of the alert log file cannot exceed 1,000 Oracle database blocks.
C.The total size of all the trace files and the alert log file cannot exceed 1,000 MB.
D.The size of a user trace file or a background trace file cannot exceed 1,000 operating system blocks.

Continue readingPassleader Latest Sample Questions for Oracle 1Z0-031 Test (91-100)
Comments closed

Passleader Latest Sample Questions for Oracle 1Z0-031 Test (41-50)

Published April 11, 2014

QUESTION 41:
While querying the DBA_TS_QUOTAS view, you find that a user, USER01, has a value, -1, in the MAX_BYTES column for all tablespaces in the database. Which statement is true for the user?

A.The user has used more space than what has been allocated.
B.The user has not been allocated space in any of the tablespaces.
C.The user has been given unlimited quota on tablespaces with an alter user command.
D.The user has been created using the QUOTA UNLIMITED clause for the SYSTEM tablespace in the CREATE USER statement.

Continue readingPassleader Latest Sample Questions for Oracle 1Z0-031 Test (41-50)
Comments closed

Passleader Latest Sample Questions for Oracle 1Z0-031 Test (31-40)

Published April 10, 2014

QUESTION 31:
You want to create a database that uses the Oracle Managed Files (OMF) feature for your database. You specified the following parameters in the initialization parameter file to achieve this: 
DB_CREATE_ONLINE_LOG_DEST_1 = ‘/u02/oradata/techdb’
DB_CREATE_ONLINE_LOG_DEST_2 = ‘/u03/oradata/techdb’
The DB_CREATE_FILE_DEST parameter is not specified.
Which statement in this scenario is correct?

A.The OMF feature will not be used because the DB_CREATE_FILE_DEST parameter is not specified.
B.The OMF feature will be used and all the database files are created as Oracle-managed files.
C.The OMF feature will be used, but only online redo log files are created as Oracle-managed files.
D.The OMF feature will be used, but only online redo log files and control files are created as Oracle-managed files.

Continue readingPassleader Latest Sample Questions for Oracle 1Z0-031 Test (31-40)
Comments closed