1. Which statement is false about block size? A. It can be set at the tablespace
ID: 3866335 • Letter: 1
Question
1. Which statement is false about block size?
A. It can be set at the tablespace level
B. It can be set at the database level
C. Settings at the database level take precedence over settings at the tablespace level
D. Settings at the tablespace level take precedence over settings at the database level
2. You are using Data Pump to upload rows into a table, and you wish to use the direct path. Which of the following statements is correct?
A. You must include the “DIRECT” keyword in the Data Pump control file.
B. You must enable insert triggers on the table first.
C. You have no control over this; Data Pump will use the direct path automatically if it can.
D. Direct path is not available in Data Pump.
3. Which of the following is not a Data Pump file type?
A. Dump file
B. Log file
C. Control file
D. SQL file
4. You have decided to implement automatic undo management. Which of these steps is optional?
A. Set the parameter UNDO_MANAGEMENT.
B. Create an undo tablespace.
C. Set the parameter UNDO_RETENTION.
D. Restart the instance
5. You want to add a control file copy. Which of these sequences is correct and sufficient?
A. Copy the control file, and issue an alter system... command to change the CONTROL_FILES parameter.
B. Mount the database to read the control file, and issue an alter database... command to add a new copy.
C. Issue an alter system... with scope=spfile command to change the CONTROL_FILES parameter, shut down the database, copy the control file, and start up the database.
D. Copy the control file, shut down the database, start up in nomount mode, issue an alter system... command to change the CONTROL_FILES parameter, and open the database.
Explanation / Answer
1.
Block size can be defined as the in terms of change the settings at the database level.
Thus the correct option is (C) Settings at the database level take precedence over
settings at the tablespace level.
2.
When you pump the data in the form of rows into table.
Thus the correct option is (A) You must include the “DIRECT” keyword in the Data Pump control file.
3.
Pump the data into file type, we can follow the option Dump file
Thus the correct option is (A). Dump file
4.
Implementation of automatic undo management through the UNDO_MANAGANMENT.
Thus the correct option is (A). Set the parameter UNDO_MANAGEMENT.
5.
The following sequence is correct and sufficient in the case of add the controls to file copy.
Thus the correct option (A) Copy the control file, and issue an alter system... command to change the CONTROL_FILES parameter.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.