7484602
Descripción
Test por Jamonero Blanco, actualizado hace más de 1 año
|
Creado por Jamonero Blanco
hace más de 7 años
|
|
Pregunta 1
Pregunta
1. Which of the following statements about tablespaces is true?
Respuesta
-
A. A tablespace is the physical implementation of a logical structure called a namespace.
-
B. A tablespace can hold the objects of only one schema.
-
C. A bigfile tablespace can have only one data file.
-
D. The SYSAUX tablespace is an optional tablespace created only if you install certain database options.
Pregunta 2
Pregunta
2. Automatic segment space management on the tablespace causes which of the following
table attributes in that tablespace to be ignored?
Respuesta
-
A. The whole storage clause
-
B. NEXT and PCTINCREASE
-
C. BUFFERPOOL and FREEPOOL
-
D. PCTFREE and PCTUSED
Pregunta 3
Pregunta
3. Which is not a type of segment that is stored in a tablespace?
Respuesta
-
A. Undo
-
B. Redo
-
C. Permanent
-
D. Temporary
Pregunta 4
Pregunta
4. Which allocation unit is the smallest?
Respuesta
-
A. Data file
-
B. Extent
-
C. Data block
-
D. Segment
Pregunta 5
Pregunta
5. You performed the following statement in the database. What actions can you perform
on the CUST_INFO table in the CUST_DATA tablespace. (Choose all that apply.)
ALTER TABLESPACE CUST_DATA READ ONLY;
Respuesta
-
A. ALTER TABLE CUST_INFO DROP COLUMN xx;
-
B. TRUNCATE TABLE CUST_INFO;
-
C. INSERT INTO CUST_INFO VALUES (...);
-
D. DROP TABLE CUST_INFO;
-
E. RENAME CUST_INFO TO CUSTOMER_INFO;
Pregunta 6
Pregunta
6. If the tablespace is offline, which statements should be executed to make the USERS
tablespace read-only? (Choose all that apply.)
Respuesta
-
A. ALTER TABLESPACE USERS READ ONLY
-
B. ALTER DATABASE MAKE TABLESPACE USERS READ ONLY
-
C. ALTER TABLESPACE USERS ONLINE
-
D. ALTER TABLESPACE USERS TEMPORARY
Pregunta 7
Pregunta
7. How would you add more space to a tablespace? (Choose all that apply.)
Respuesta
-
A. ALTER TABLESPACE <TABLESPACE NAME> ADD DATAFILE SIZE < N >
-
B. ALTER DATABASE DATAFILE <FILENAME> RESIZE < N >
-
C. ALTER DATAFILE < FILENAME > RESIZE < N >
-
D. ALTER TABLESPACE < TABLESPACE NAME > DATAFILE < FILENAME > RESIZE < N >
Pregunta 8
Pregunta
8. The database is using automatic memory management. The standard block size for
the database is 8KB. You need to create a tablespace with a block size of 16KB.
Which initialization parameter should be set?
Respuesta
-
A. DB_8K_CACHE_SIZE
-
B. DB_16K_CACHE_SIZE
-
C. DB_CACHE_SIZE
-
D. None of the above
Pregunta 9
Pregunta
9. Which data dictionary view can be queried to obtain information about the files that
belong to locally managed temporary tablespaces?
Respuesta
-
A. DBA_DATA_FILES
-
B. DBA_TABLESPACES
-
C. DBA_TEMP_FILES
-
D. DBA_LOCAL_FILES
Pregunta 10
Pregunta
10. How would you drop a tablespace if the tablespace were not empty?
Respuesta
-
A. Rename all the objects in the tablespace, and then drop the tablespace.
-
B. Remove the data files belonging to the tablespace from the disk.
-
C. Use ALTER DATABASE DROP <TABLESPACE NAME> CASCADE .
-
D. Use DROP TABLESPACE <TABLESPACE NAME> INCLUDING CONTENTS .
Pregunta 11
Pregunta
11. Which command is used to enable the autoextensible feature for a file if the file is
already part of a tablespace?
Respuesta
-
A. ALTER DATABASE .
-
B. ALTER TABLESPACE .
-
C. ALTER DATA FILE .
-
D. You cannot change the autoextensible feature once the data file is created.
Pregunta 12
Pregunta
12. Which statement is true regarding the SYSTEM tablespace?
Respuesta
-
A. It can be made read-only.
-
B. It can be offline.
-
C. Data files can be renamed.
-
D. Data files cannot be resized.
Pregunta 13
Pregunta
13. The default critical threshold for a tablespace is set at 97 percent, and you think that
is too low. Which two options can you use to change the threshold value to 90 percent
for tablespace APPS_DATA ?
Respuesta
-
A. Use Oracle Enterprise Manager Database Express.
-
B. Use Oracle Enterprise Manager Cloud Control.
-
C. Use DBMS_SERVER_ALERT package.
-
D. Use DBMS_SPACE package.
Pregunta 14
Pregunta
14. Choose the statements that are resumable. (Choose three.)
Respuesta
-
A. ALTER TABLE ... SPLIT PARTITION
-
B. SELECT
-
C. INSERT INTO ... SELECT
-
D. CREATE TABLESPACE
-
E. ALTER TABLE ... SHRINK SPACE
Pregunta 15
Pregunta
15. How do you ensure you are notified when a resumable session is suspended?
(Choose two.)
Respuesta
-
A. You’ll be notified by email at the address registered in database properties.
-
B. Write a custom script to look for “statement in resumable session * was suspended” in the alert log and notify the DBA.
-
C. Create an AFTER SUSPEND trigger and a code notification.
-
D. A suspended session displays a message on the screen.
Pregunta 16
Pregunta
16. Which statement regarding reclaiming wasted space is true?
Respuesta
-
A. Segment shrink is accomplished using the ALTER TABLE ... MOVE and ALTER INDEX ... REBUILD statements.
-
B. Segment shrink and reorganize are similar operations.
-
C. When a table segment shrink operation is completed, the dependent indexes are in invalid state and need to be rebuilt.
-
D. A segment shrink operation is applicable only on tablespaces with automatic segment space management.
Pregunta 17
Pregunta
17. Which compression option should be specified to compress blocks of tables that are
used by the OLTP application?
Respuesta
-
A. COMPRESS
-
B. NOCOMPRESS
-
C. COMPRESS FOR OLTP
-
D. COMPRESS FOR ONLINE DML
Pregunta 18
Pregunta
18. Choose the best option regarding extents.
Respuesta
-
A. An extent is a grouping of Oracle blocks.
-
B. An extent is a grouping of OS blocks.
-
C. An extent is a grouping of segments.
-
D. An extent is allocated when a table is created.
Pregunta 19
Pregunta
19. You issue the statement CREATE TABLESPACE X; . Which of the following is the
best option?
Respuesta
-
A. The statement fails because mandatory properties are not defined.
-
B. The 100MB tablespace is created.
-
C. The mandatory DATAFILE clause is missing.
-
D. The tablespace name should be at least three characters long.
Pregunta 20
Pregunta
20. Choose the information that is not part of a ROWID.
Respuesta
-
A. Data object number
-
B. Relative file number
-
C. Segment ID where the block belongs
-
D. Block number in the file
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.