单选题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（）A2， 5， 1， 4， 3B1， 2， 3， 4， 5C5， 2， 1， 3， 4D2， 1， 5， 4， 3
单选题
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（）
A
2， 5， 1， 4， 3
B
1， 2， 3， 4， 5
C
5， 2， 1， 3， 4
D
2， 1， 5， 4， 3
参考解析
解析：
Oracle存储模型，逻辑结构在左，物理结构在右。 逻辑结构由大到小database-->tablespace-->segment-->extent-->oracle data block
1、数据库是由多个表空间组成。
2、每个表空间只属于一个数据库，包含一个或多个数据文件，每个数据文件只属于一个表空间，
3、每个段包括一个或多个extents区
4、extent（区），由相邻的数据块的组成。
5、块BLOCK:是数据库中最小的I/O单元,db_block_size
1、数据库是由多个表空间组成。
2、每个表空间只属于一个数据库，包含一个或多个数据文件，每个数据文件只属于一个表空间，
3、每个段包括一个或多个extents区
4、extent（区），由相邻的数据块的组成。
5、块BLOCK:是数据库中最小的I/O单元,db_block_size
相关考题：
Your network contains a database server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 has the following hardware configurations:·A single processor that supports hyper-threading·Dual processor motherboard·Two hard disks·2 GB of RAMThe first disk contains all the files for the operating system and applications. The second disk is empty.Hyper-threading is disabled in the BIOS.Users report a slow response when they query the database on Server1.You monitor Server1 for one day and receive the performance statistics shown in the following table.You need to improve database performance.What should you do? （）A. Upgrade the RAM to 4 gb.B. Install a second processor.C. Enable hyper-threading in the bios.D. Move the database to the second disk.
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)
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（）A、2，5，1，4，3B、1，2，3，4，5C、5，2，1，3，4D、2，1，5，4，3
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（）A、2， 5， 1， 4， 3B、1， 2， 3， 4， 5C、5， 2， 1， 3， 4D、2， 1， 5， 4， 3
You executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs， so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".
A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）A、The application server，firewall，and database server on the same VLANB、The application server and firewall on one VLAN，and the database server on a second VLANC、The application server on one VLAN，and the database server and firewall on a second VLAND、The application server and firewall on one VLAN，and the firewall and database server on a second VLAN
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A、User processB、Server processC、System Monitor (SMON)D、Process Monitor (PMON)E、Checkpoint process (CKPT)
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
Your database is not configured for session failover. Your tnsnames.ora file contains the following details： test.us.oracle.com= （DESCRIPTION= （ADDRESS_LIST= （LOAD_BALANCE=off） （FAILOVER=ON） （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521）） （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521））） （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com））） Which feature is enabled in this case？（）A、Load balancingB、Instance failoverC、Database failoverD、Connect-time failoverE、Transparent Application Failover （TAF）
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
Which of the following is a feature that enables an Exchange 2010 mailbox database to be moved to and mounted 2010 Mailbox server in the same organization？（）A、Dial tone portabilityB、Recovery databaseC、Database mobilityD、Database portability
In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）A、Database client and database serverB、WebSphere Application Server and Database ServerC、WebSphere Commerce Server and WebSphere Application ServerD、Web server and WebSphere Application Server
多选题In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）ADatabase client and database serverBWebSphere Application Server and Database ServerCWebSphere Commerce Server and WebSphere Application ServerDWeb server and WebSphere Application Server
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）ATo achieve the goal， DBCC DBREINDEX should be utilized.BTo achieve the goal， SELECT * FROM sys.indexes should be utilized.CTo achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.DTo achieve the goal， DBCC INDEXDEFRAG should be utilized.
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）A User processB Server processC System Monitor （SMON）D Process Monitor （PMON）E Checkpoint process （CKPT）
单选题You executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）AIt terminates all user sessions.BIt prevents users from logging in to the database remotely.CIt halts the server until all user transactions are completed.DThe server hangs， so users will receive an error asking them to login again.EConnected users would get an error with the message End of communication channel.
单选题If you create your database using Oracle Managed Files （OMF）， what is true？（）AYou must use Oracle predefined names to identify raw partitions that will hold OMF structures. BYou must define directories for two online redo log groups and three copies of the control file. CIf your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. DYou must use only OMF data files when adding new tablespaces or data files to your database in the future.
单选题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（）A2，5，1，4，3B1，2，3，4，5C5，2，1，3，4D2，1，5，4，3
单选题A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）AThe application server，firewall，and database server on the same VLANBThe application server and firewall on one VLAN，and the database server on a second VLANCThe application server on one VLAN，and the database server and firewall on a second VLANDThe application server and firewall on one VLAN，and the firewall and database server on a second VLAN
单选题You need to design a Windows Server Update Services （WSUS） infrastructure that meets the following requirements： èThe updates must be distributed from a central location. èAll computers must continue to receive updates in the event that a server fails. What should you include in your design？（）AConfigure two WSUS servers in a Microsoft SQL Server 2008 failover cluster. Configure each WSUS server to use a local database.BConfigure a single WSUS server to use multiple downstream servers. Configure each WSUS server touse a RAID 1 mirror and a local database.CConfigure a single WSUS server to use multiple downstream servers. Configure each WSUS server to use a RAID 5 array and a local database.DConfigure a Microsoft SQL Server 2008 failover cluster. Configure two WSUS servers in a Network Load Balancing cluster. Configure WSUS to use the remote SQL Server 2008 database instance.
单选题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（）A2，5，1，4，3B1，2，3，4，5C5，2，1，3，4D2，1，5，4，3
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题You use a Windows 2000 Professional computer at home. You need to access shared files on a server named server1. This server is on your company’s network and is not accessible from the internet. Your company’s network also includes a third party VPN server that is accessible from the internet. You dial in to your internet service provider and then create a VPN connection to your company’s VPN server. After the connection is successfully established， you run the net view//server1 command and receive the following error ‘the server is inaccessible or could not be found’. You need to access the shared files on server 1. What should you do？ （）AStop and then start the TCP/IP NetBIOS helper service on your computer.BStop and then start the DNS client service on your computer.CAdd a HOSTS entry for server1 to your computer.DAdd a LMHOSTS entry for server1 to your computer.
多选题Which of the following are not BGRP data structures？ （Choose all that apply.）（）AEIGRP database tableBEIGRP CEF tableCEIGRP neighbor tableDEIGRP adjacency tableEEIGRP interface tableFEIGRP topology table
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile