Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

You omit the UNDO tablespace clause in your CREATE DATABASE statment. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement ?

  1. The oracle server creates no undo tablespace.

  2. The oracle server creates an undo segment in the system tablespace.

  3. The oracle server cerates one undo tablespace with the name SYS_UNDOTBS.

  4. Database creation fails because you did not specify an undo tablespace on the create database statment.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

John has created a procedure named SALARY_CALC. Which SQL query allow him to view text of procedure?

  1. SELECT text FROM user_source WHERE name = 'SALARY_CALC';

  2. SELECT * FROM user_source WHERE name='SALARY_CALC';

  3. SELECT * FROM user_objects WHERE object_name='SALARY_CALC';

  4. SELECT * FROM user_procedures WHERE object_name='SALARY_CALC';

  5. SELECT text FROM user_source WHERE name='SALARY_CALC' and owner='JOHN'
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

You discover that a disk failure occured on DISK3 where the data file belonging to the USER_DATA table is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2. what is the correct sequence RMAN commands to restore and recover the data file ?

  1. RUN { RESTORE TABLESPACE user_data; RECOVER TABLESPACE user_data; ALTER DATABASE OPEN; }

  2. RUN { ET NEWNAME FOR '/DISK3/user_data01.dbf' TO '/DISK2/user_data01.dbf'; RESTORE TABLESPACE user_data; SWITCH DATAFILE '/DISK3/user_data01.dbf';

  3. RUN { RESTORE TABLESPACE user_data; SET NEWNAME FOR '/DISK3/user_data01.dbf' TO '/DISK2/user_data01.dbf'; SWITCH DATAFILE '/DISK3/user_data01.dbf';

  4. RUN { SET NEWNAME FOR '/DISK3/user_data01.dbf' TO '/DISK2/user_data01.dbf'; RESTORE TABLESPACE user_data; RECOVER TABLESPACE user_data; ALTER DATABASE OPEN;}
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

When performing an incomplete recovery of the whole database, what must be true about the data files that are restored ?

  1. All of the data files must be from a backup taken prior to the point in time to which you want to recover.

  2. Only the data files belonging from the SYSTEM tablespace must be from a backup taken prior to the point in time to which you want to recover.

  3. Only the data files that need recovery must be from a backup taken prior to the point in time which you want to recover.

  4. Only the data files belonging to the SYSTEM tablespace and the data files that need recovery must be from a backup taken prior to the point in time to which you want to recover.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation