×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You want to start a global service on your database. Which three conditions must be met?
2.
Which statement regarding Oracle Active Data Guard 12c is false?
3.
Examine the command:
sqlplus /nolog
In which scenario would this command execute successfully?
sqlplus /nolog
In which scenario would this command execute successfully?
4.
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?
5.
In this SQL statement, what is the partitioning criteria?
CREATE TABLE books_part
PARTITION BY RANGE (cell_id) (
PARTITION p0l VALUES LESS THAN (2),
PARTITION p02 VALUES LESS THAN (3) ,
. . .
PARTITION pl4 VALUES LESS THAN (15),
PARTITION pl5 VALUES LESS THAN (16),
PARTITION pl6 VALUES LESS THAN (MAXVALUE)
)
AS SELECT * FROM books;
CREATE TABLE books_part
PARTITION BY RANGE (cell_id) (
PARTITION p0l VALUES LESS THAN (2),
PARTITION p02 VALUES LESS THAN (3) ,
. . .
PARTITION pl4 VALUES LESS THAN (15),
PARTITION pl5 VALUES LESS THAN (16),
PARTITION pl6 VALUES LESS THAN (MAXVALUE)
)
AS SELECT * FROM books;
6.
Which four statements about users in Oracle Database 12c are correct?
7.
Which three DBA operations can be performed by using Oracle SQL Developer?
8.
Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?
9.
When executing shutdown abort in a pluggable database (PDB), you ____________.
10.
Which is the default isolation level in Oracle Database 12c?