Loading...1.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
A - Each segment contains one or more extents
B - Mutiple tablespaces can share single datafile
C - A data block is a smallest unit of I/O for data files.
D - it is possible to have tablespaces of different blocks size in a database
E - Each data block in the database always corresponds to one OS block.
(Answer:A,C,D)
2.Which two operactoin can be flashed back using Flashback technology(choose two)
A - DROP USER SIMTH
B - DROP TABLE EMPLOYEES
C - DROP TABLESPACE USERS
D - ALTER TABLE SALES_REP DROP PARTITION P1
E - ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID
(Answer:A,B)
3.The junior DBA in your organisztion has accidentally deleted the alert log file.
What will you do to create a new alert log file?
A - Create the new text file as ALERT LOG
B - You have to recover the alert file from the valid backup
C - Change the value for the BACKGROUND_DUMP_DEST parameter
D - No action required .The file would be created automatically by the instance.
(Answer:B,D)
4.You executed the following command to back up your control file:
Which initialization parameter is used to specify the localtion of the trace file?
A - USER_DUMP_DEST
B - CORE_DUMP_DEST
C - TRACE_DUMP_DEST
D - BACKUP_DUMP_DEST
E - BACKGROUND_DUMP_DEST
(Answer:A)
5.Your database is in NOARCHIVELOG mode.After which two operations you should take the backup of control file?(choose two)
A - adding a new user to the database
B - dropping a user from the database
C - dropping a table from the database
D - dropping a data file from database
E - adding a new tablespace to the database
(Answer:D,E)
6.You specified extent management as local for a database.How will it affect space management in the tablespace?
A - All the extents will be of the same size
B - Bitmap will be used to record free and allocated extents
C - Free extents will be managed by the data dictionary tables
D - The tablespace will be system managed and the users cannot specify the extent size.
(Answer:B)
7.You execute the following set of command to create a database user and to grant the system privileges
in your production environment.
CREATE USER user01
IDENTIFIED BY oracle
DEFAULT TABLESPACE tbs1
TEPORARY TABLESPACE temp
PROFILE default
/
GRANT create sessoin,create table TO user01;
While executing the command to create table,the user gets the following error message and CREATE TABLE
command fails
ERROR at line 1:
ORA-01950:no privilege on tablespace
Which could be the possible reason for this error message?
A - The tablespace TBS1 is full
B - The user is not the owner of the SYSTEM tablespace.
C - The user dose not have quota on the TBS1 tablespace
D - The user dose not have sufficient system privileges to create table in the TBS1 TABLESPACE
E - The user dose not have sufficient privilege to create table on the default permanent tablespace
(Answer:C)
8.Which two are valid locking levels that are used by transactions in an Oracle database?(Choose two)
A - row level
B - block level
C - object level
D - schema level
E - database level
(Answer:A,C)
9.The user SCOTT executes the following command successfully to increase the salary values in one of this sessions
UPDATE emp SET sal=sal*5 WHERE deptno-20;
Before SCOTT ends the transaction,user HR who has the privileges on EMP table executes a query to fetch the salary
details but finds old salary values instead of the increased values.
Why dose HR still see the old data?
A - because of redo data from redo log file
B - because of data from database buffer cache
C - because of data from a temporary tablespace
D - because of undo data from the undo tablespace
(Answer:D
10.While running the Oracle Universal installer on a Unix platform to install Oracle Database 10g software.
You are prompted to run orainstRoot.sh.What dose the script accomplish?
A - It creates the pointer file
B - It creates the base directory
C - It creates the inventory pointer file
D - It creates the Oracle user to installaction
E - It modifies the Unix kernel parameters to match Oracle’s requirement.
Comment:
The other set of files created during install is the Oracle Inventory, found according to the OFA in /u01/app/oracle/oraInventory.
The Inventory is used by the Oracle Universal Installer to record what products have been installed, where the were installed,
and how. The Oracle Inventory doesn’t impact databases in any way and only impacts the installer. You can see a list of all the
products and options you have installed in the oraInventory/Components directory.
(Answer:B)
Popularity: 35% [?]