1Z0-031 Oracle - Braindumps.com.ua: список вопросов для "Oracle9i: Database Fundamentals I", страница: 2

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

Oracle 1Z0-031: Oracle9i: Database Fundamentals I

#11. 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?

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

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

 SQL> SELECT GROUP#, TYPE, member FROM v$logfile; 
 GROUP# TYPE MEMBER

------ ------- --------------------------------------
1 ONLINE /databases/DB01/ORADATA/u02/log1a.rdo
1 ONLINE /databases/DB01/ORADATA/u03/log1b.rdo
2 ONLINE /databases/DB01/ORADATA/u02/log2a.rdo
2 ONLINE /databases/DB01/ORADATA/u03/log2b.rdo
3 ONLINE /databases/DB01/ORADATA/u02/log3a.rdo
3 ONLINE /databases/DB01/ORADATA/u03/log3b.rdo

 SQL> SELECT GROUP#, SEQUENCE#, status FROM v$log; 
 GROUP# SEQUENCE# STATUS

------ --------- ---------
1 250 INACTIVE
2 251 CURRENT
3 249 INACTIVE
You immediately issue this command:

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

Why does the command fail?

#14. 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?

#15. 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:

 SQL> SELECT username, default_tablespace, 
 TEMPORARY TABLESPACE 
 2> FROM user_users;

 USERNAME      DEFAULT_TABLESPACE       TEMPORARY_TABLESPACE 
 HR            SAMPLE                   TEMP

 SQL> SELECT * FROM user_ts_quotas;

 TABLESPACE_NAME    BYTES         MAX_BYTES     BLOCKS      MAX_BLOCKS 
 SAMPLE             28311552      -1            6912        -1 
 INDX               0             -1            0           -1

In which tablespace was your new DEPARTMENTS table created?

#16. 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?

#17. 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?

#18. Evaluate the SQL statement:

 CREATE TABLESPACE hr_tbs 
 DATAFILE '/usr/oracle9i/OraHomel/hr_data.dbf' SIZE 2M 
 AUTOEXTEND ON 
 MINIMUM EXTENT 4K 
 NOLOGGING 
 DEFAULT STORAGE (INITIAL 5K NEXT 5K PCTINCREASE 50) 
 EXTENT MANAGEMENT DICTIONARY 
 SEGMENT SPACE MANAGEMENT AUTO;

Why does the statement return an error?

#19. You query DBA_CONSTRAINTS to obtain constraint information on the HR_EMPLOYEES table:

 SQL> SELECT constraint_name, constraint_type, deferrable, 
 2> deferred, validated 
 3> FROM dba_constraints 
 4> WHERE owner = 'HR' AND table_name='EMPLOYEES';

 CONSTRAINT_NAME    C    DEFERRABLE        DEFERRED     VALIDATED 
 EMP_DEPT_FK        R    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_EMAIL_NV       C    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_EMAIL_UK       U    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_EMP_ID_PK      P    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_HIRE_DATE_NN   C    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_JOB_FK         R    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_JOB_NN         C    DEFERRABLE        DEFERRED     NOT VALIDATED 
 EMP_LAST_NAME_NN   C    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_MANAGER_FK     R    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_SALARY_MIN     C    NOT DEFERRABLE    IMMEDIATE    VALIDATED

Which type of constraint is EMP_JOB_NN?

#20. Evaluate the following SQL:

 CREATE USER sh IDENTIFIED BY sh; 
 GRANT 
 CREATE ANY MATERIALIZED VIEW 
 CREATE ANY DIMENSION 
 DROP ANY DIMENSION 
 QUERY REWRITE 
 GLOBAL QUERY REWRITE 
 TO dw_manager 
 WITH ADMIN OPTION;
 GRANT dw_manager TO sh WITH ADMIN OPTION;

Which three actions is the user SH able to perform? (Choose three.)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37]

ген. 0.159

Дата сервера 09:51 09-01-2009

Oracle 1Z0-031