Note the following structures in your database server: 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
第1题:
ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
第2题:
The staff is not able to access a database server. The server has an ’Operating System not found’error and is set to boot from a fiber channel SAN. All other database servers are set to boot from the SAN and access the same switch and data as this database server. Which of the following is the MOST likely cause of the problem?()
第3题:
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?()
第4题:
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?()
第5题:
Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’;To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()
第6题:
Which three statements are true regarding the logical structure of the Oracle database?()
第7题:
The block change tracking data will be used only from the next incremental 0 backup.
The incremental backup will use change tracking data for accomplishing the backup.
The incremental backup will not use change tracking data for accomplishing the backup.
The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
第8题:
2, 5, 1, 4, 3
1, 2, 3, 4, 5
5, 2, 1, 3, 4
2, 1, 5, 4, 3
第9题:
Each segment contains one or more extents.
Multiple tablespaces can share a single data file.
A data block is the smallest unit of input/output (I/O) in data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one operating system block.
第10题:
The Oracle database will perform block checking for the index blocks only
The Oracle database will not perform block checking for any of the data blocks
The Oracle database will perform block checking for the default permanent tablespace only
The Oracle database will perform block checking for the data blocks in all user tablespaces
The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
第11题:
The Oracle database will not perform block checking for any of the data blocks.
The Oracle database will perform block checking for the default permanent tablespace only.
The Oracle database will perform block checking for the data blocks in all user tablespaces.
The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
第12题:
The Oracle database will perform block checking for the index blocks only
The Oracle database will not perform block checking for any of the data blocks
The Oracle database will perform block checking for the default permanent tablespace only
The Oracle database will perform block checking for the data blocks in all user tablespaces
The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
第13题:
Which of the following are not BGRP data structures? (Choose all that apply.)()
第14题:
When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation, which of the following are true about the staging server?()
第15题:
The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?()
第16题:
Which statements are true about logical structures of the Oracle database()
第17题:
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
第18题:
Which three statements are true about logical structures of the Oracle database()
第19题:
EIGRP database table
EIGRP CEF table
EIGRP neighbor table
EIGRP adjacency table
EIGRP interface table
EIGRP topology table
第20题:
The database has a subset of the tables in the production server database.
The database has a copy of selected data from the production database
The database logs changes for later propagation.
The database is accessed as read-only to prevent data corruption.
The database includes all user and order data for offline processing.
第21题:
2,5,1,4,3
1,2,3,4,5
5,2,1,3,4
2,1,5,4,3
第22题:
Each segment contains one or more extents.
Multiple tablespaces can share a single data file
A data block is the smallest unit of input/output (I/O) in data files.
It is possible to have tablespaces of different block sizes in a database.
Each data block in the database always corresponds to one operating system block
第23题:
An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks