×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
What is one reason for using the package DBMS_TTS?
DATA01 has
DATA01 has
2.
Which export option will generate code to create an initial extent that is equal to the sum of the sizes of all the
extents currently allocated to an object?
extents currently allocated to an object?
3.
A DBA performs the query:
SELECT tablespace_name, max_blocksFROM dba_tablespace_quotasWHERE username= "SCOTT;
That returns the result:
TABLESPACE_NAME MAX_BLOCKS
------------------------------ ------------------
DATA01 -1
What does -1 indicate?
SELECT tablespace_name, max_blocksFROM dba_tablespace_quotasWHERE username= "SCOTT;
That returns the result:
TABLESPACE_NAME MAX_BLOCKS
------------------------------ ------------------
DATA01 -1
What does -1 indicate?
4.
Consider the following command to create the user 'peter'.
CREATE USER peter
IDENTIFIED by panTEMPORARY TABLESPACE temp
PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command executed?
CREATE USER peter
IDENTIFIED by panTEMPORARY TABLESPACE temp
PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command executed?
5.
When creating rollback segments, what is the recommended value for MINEXTENT minimize dynamic
extension?
extension?
6.
MINEXTENT must be at least _____ when a rollback segment is created.
7.
You are creating a database with a character set other than US7ACII. Which operating system environmental
variable needs to be set to specify the directory location of the NLS support files?
variable needs to be set to specify the directory location of the NLS support files?
8.
Given the statement:
CREATE DATABASE orc1 LOGFILE GROUP 1 'u01/oracle/dba/logla.rdo' SIZE 1M, GROUP 2 'u01/oracle/dba/
log2a.rdo' SIZE 1M
DARAFILE'u01/oracle/dbs/sys_01.dbf'REUSE;
Which statement is true?
CREATE DATABASE orc1 LOGFILE GROUP 1 'u01/oracle/dba/logla.rdo' SIZE 1M, GROUP 2 'u01/oracle/dba/
log2a.rdo' SIZE 1M
DARAFILE'u01/oracle/dbs/sys_01.dbf'REUSE;
Which statement is true?
9.
What is a default role?
10.
Who is the owner of a role?