1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 19

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1Z0-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#181. Which SQL statement displays the date March 19, 2001 in a format that appears as “Nineteenth of March 2001 12:00:00 AM”?

#182. Which one is a system privilege?

#183. You need to perform these tasks:
1. Create and assign a MANAGER role to Blake and Clark
2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark
Which set of SQL statements achieves the desired results?

#184. You intend to use only password authentication and have used the password file utility to create a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE.
You created a user and granted only the SYSDBA privilege to that user as follows:

 CREATE USER dba_user 
 IDENTIFIED BY dba_pass; 
 GRANT sysdba TO dba_user;

The user attempts to connect to the database as follows:
connect dba_user/dba_pass as sysdba;
Why does the connection fail?

#185. John has created a procedure named SALARY_CALC. Which SQL query allows him to view the text of the procedure?

#186. You issue the following queries to obtain information about the redo log files:

You immediately issue this command:

 ALTER DATABASE DROP LOGFILE MEMBER 
 '/databases/DB01/ORADATA/u03/log2b.rdo';

Why does the command fail?

#187. You are in the process of dropping the BUILDING_LOCATION column from the HR.EMPLOYEES table. The table has been marked INVALID until the operation completes. Suddenly the instance fails. Upon startup, the table remains INVALID.
Which step(s) should you follow to complete the operation?

#188. You create a new table named DEPARTMENTS by issuing this statement:

 CREATE TABLE   departments( department_id NUMBER(4), 
 department_name VARCHAR2(30), manager_id NUMBER(6), 
 location_id NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K 
 PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 5);

You realize that you failed to specify a tablespace for the table. You issue these queries:

In which tablespace was your new DEPARTMENTS table created?

#189. The user Smith created the SALES HISTORY table. Smith wants to find out the following information about the SALES HISTORY table:
The size of the initial extent allocated to the sales history data segment
The total number of extents allocated to the sales history data segment
Which data dictionary view(s) should Smith query for the required information?

#190. You are going to re-create your database and want to reuse all of your existing database files. You issue the following SQL statement:

 CREATE DATABASE sampledb 
 DATAFILE 
 '/u01/oradata/sampledb/system0l.dbf' 
 SIZE 100M REUSE 
 LOGFILE 
 GROUP 1 ('/u01/oradata/sampledb/logla.rdo', 
 '/u02/oradata/sampledb/loglb.rdo') 
 SIZE 50K REUSE, 
 GROUP 2 ('/u01/oradata/sampledb/log2a.rdo', 
 '/u02/oradata/sampledb/log2b.rdo') 
 SIZE 50K REUSE 
 MAXLOGFILES 5 
 MAXLOGHISTORY 100 
 MAXDATAFILES 10;

Why does the CREATE DATABASE statement fail?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [85]

gen. 0.076

Server date 06:16 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump