Exam information

Exam 1Z0-052: Oracle Database 11g, Administration I

Other exams

What could be the reason for the Block Size field is not enabled?

View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could be the reason for this?Exhibit:

What could be the reason for the following error?

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: […]


What could be the reason for the elimination of the other rows in the output?

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE […]

Identify two actions either of which will help you resolve this problem…

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) * ERROR at line 1: ORA-01653: unable to extend table […]

Which two statements are true regarding the LISTENER2 listener?

View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener? (Choose two.)Exhibit:

What do you infer from this?

View the Exhibit and examine the output of the query. What do you infer from this?Exhibit:

Which two statements are true regarding this user?

View the Exhibit1, which shows the options that are selected to create the user SL_REP. View the Exhibit2 and examine the contents of DATABASE_PROPERTIES. Which two statements are true regarding this user? (Choose two.)Exhibit1 (exhibit):Exhibit2 (exhibit):

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

Which statement describes the effect of the command?

View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_REP user executes this command to create a table : SQL> CREATE TABLE orders ( oid number(6), […]

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?Exhibit:

Page 1 of 1712345...10...Last »