雖然都沒有人理我的問題，不過我還是考過了
這些是我覺的有問題的答案，要不要信隨便你們
不用問我說為什麼要這樣寫，因為我以後也不會上來這個站了
1.Which steps should you take to gather information about checkpoints?
A. Set the LOG_CHECKPOINTS_TO_ALERT initialization parameter to TRUE.
Monitor the alert log file.
B. Set the LOG_CHECKPOINT_TIMEOUT parameter.
Force a checkpoint by using the FAST_START_MTTR_TARGET parameter.
Monitor the alert log file.
C. Set the LOG_CHECKPOINT_TIMEOUT parameter.
Force a log switch by using the command ALTER SYSTEM FORCE LOGSWITCH.
Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT.
Monitor the alert log file.
D. Set the FAST_START_MTTR_TARGET parameter to TRUE.
Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT.
Monitor the alert log file.
Answer:A
2.Your database is currently configured with the database character set to
WE8ISO8859P1 and national character set to AF16UTF16.
Business requirements dictate the need to expand language requirements beyond the
current character set, for Asian and additional Western European languages, in the
form of customer names and addresses.
Which solution saves space storing Asian characters and maintains consistent character
manipulation performance?
A.Use SQL CHAR data types and change the database character set to UTF8.
B.Use SQL NCHAR data types and change the national character set to UTF8.
C.Use SQL CHAR data types and change the database character set to AF32UTF8.
D.Use SQL NCHAR data types and keep the national character set to AF16UTF16.
Answer:D
3.Which type of constraint is EMP_JOB_NN?
A. check
B. unique
C. not null
D. primary key
E. foreign key
Answer: A
4.ABC Company consolidated into one office building, so the very large EMPLOYEES table no longer requires the OFFICE_LOCATION column. The DBA decided to drop the column using the syntax below:
ALTER TABLE hr.employees
DROP COLUMN building_location
CASCADE CONSTRAINTS;
Dropping this column has turned out to be very time consuming and is requiring a large amount of undo space.
What could the DBA have done to minimize the problem regarding time and undo space consumption?
A. Use the Export and Import utilities to bypass undo.
B. Mark the column as UNUSED.
Remove the column at a later time when less activity is on the system.
C. Drop all indexes and constraints associated with the column prior to dropping the column.
D. Mark the column INVALID prior to beginning the drop to bypass undo.
Remove the column using the DROP UNUSED COLUMNS command.
E. Add a checkpoint to the DROP UNUSED COLUMNS command to minimize undo space.
Answer: E
5.You are in the process of dropping the BUILDING_LOCATION column from the HR.EMPLOYEES table. The table has been marked INVALID until the operation completes. Suddenly the instance fails. Upon startup, the table remains INVALID.
Which step(s) should you follow to complete the operation?
A. Continue with the drop column command:
ALTER TABLE hr.employees DROP COLUMNS CONTINUE;
B. Truncate the INVALID column to delete remaining rows in the column and release unused space immediately.
C. Use the Export and Import utilities to remove the remainder of the column from the table and release unused space.
D. Mark the column as UNUSED and drop the column:
ALTER TABLE hr.employees
SET UNUSED COLUMN building location;
ALTER TABLE hr.employees
DPOP UNUSED COLUMN building_location
CASCADE CONSTRAINTS;
Answer: A
6.You are experiencing intermittent hardware problems with the disk drive on which your control file is located. You decide to multiplex your control file.
While your database is open, you perform these steps:
1. Make a copy of your control file using an operating system command.
2. Add the new file name to the list of files for the CONTROL FILES parameter in your text intialization parameter file using an editor.
3. Shut down the instance.
4. Issue the STARTUP command to restart the instance, mount, and open the database.
The instance starts, but the database mount fails. Why?
A. You copied the control file before shutting down the instance.
B. You used an operating system command to copy the control file.
C. The Oracle server does not know the name of the new control file.
D. You added the new control file name to the CONTROL_FILES parameter before shutting down the instance.
Answer: D
7.Examine the list of steps to rename the data file of a non-SYSTEM tablespace HR_TBS. The steps are arranged in random order.
1. Shut down the database.
2. Bring the HR_TBS tablespace online.
3. Execute the ALTER DATABASE RENAME DATAFILE command
4. Use the operating system command to move or copy the file
5. Bring the tablespace offline.
6. Open the database.
What is the correct order for the steps?
A. 1, 3, 4, 6; steps 2 and 5 are not required
B. 1, 4, 3, 6; steps 2 and 5 are not required
C. 2, 3, 4, 5; steps 1 and 6 are not required
D. 5, 4, 3, 2; steps 1 and 6 are not required
E. 5, 3, 4, 1, 6, 2
F. 5, 4, 3, 1, 6, 2
Answer: D
有字打錯啦~!第三項應該是: 3. Execute the ALTER TABLESPACE RENAME DATAFILE command
不過我考試的時候還是寫成 ALTER DATABASE 唉~
8.The server parameter file (SPFILE) provides which three advantages when managing initialization parameters? (Choose three.)
A. The Oracle server maintains the server parameter file.
B. The server parameter file is created automatically when the instance is started.
C. Changes can be made in memory and/or in the SPFILE with the ALTER SYSTEM command.
D. The use of SPFILE provides the ability to make changes persistent across shut down and start up.
E. The Oracle server keeps the server parameter file and the text initialization parameter file synchronized.
Answer: ACD
9.Evaluate the SQL command:
CREATE TEMPORARY TABLESPACE temp_tbs
TEMPFILE '/usr/oracle9i/OraHomel/temp_data.dbf'
SIZE 2M
AUTOEXTEND ON;
Which two statements are true about the TEMP_TBS tablespace? (Choose two.)
A. TEMP_TBS has locally managed extents.
B. TEMP_TBS has dictionary managed extents.
C. You can rename the tempfile temp_data.dbf.
D. You can add a tempfile to the TEMP_TBS tablespace.
E. You can explicitly create objects in the TEMP_TBS tablespace.
Answer: AD
再見啦!~
|
