|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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.)
Show comments for this question (1)
Add comments
Link to this question
|
|
|
|
 gen. 0.154
|
Server date 06:24 22-11-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump