1z0-063 Exam Question 151
Which two statements are true about making RMAN image copies of a database? (Choose two.)
1z0-063 Exam Question 152
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
1z0-063 Exam Question 153
Which two statements are true about making RMAN image copies of a database? (Choose two.)
1z0-063 Exam Question 154
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
1z0-063 Exam Question 155
Your database supports a Decision Support System (DSS) workload that involves the execution of
complex queries. Currently, the database is running with peak workload. You want to analyze some of the
most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to
improve query performance?
complex queries. Currently, the database is running with peak workload. You want to analyze some of the
most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to
improve query performance?