1z0-063 Exam Question 131
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?
1z0-063 Exam Question 132
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.
1z0-063 Exam Question 133
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
1z0-063 Exam Question 134
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)
1z0-063 Exam Question 135
View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?
You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?