如果希望横向合并后的数据文件只包括第一个数据文件中的个案，则应当选择（）A、Both  file  iprovide  casesB、External  file  is  keyed  tableC、Working  data  file  is  keyed  tableD、Indicate  case  source  as  variable

第1题：

第2题：

第3题：

阅读FORTRAN程序：
OPEN(8，FILE=FILE2 DAT,STATUS=NEW)
DO 10 I=1，3
WEITE(8，(4I4)JI+I,J=1，4)
10 CONTINUE
CLOSE(8)
END
程序运行后，数据文件FILE2，DAT的内容是：

第4题：

第5题：

Which four actions are possible during an Online Data file Move operation?（）

• A、Creating and dropping tables in the data file being moved
• B、Performing file shrink of the data file being moved
• C、Querying tables in the data file being moved
• D、Performing Block Media Recovery for a data block in the data file being moved
• E、Flashing back the database
• F、Executing DML statements on objects stored in the data file being moved

第6题：

Which of the following is a correct statement about how the user environment is configured at login?（）

• A、If present, the settings in the $HOME/.profile file will override the settings in the /etc/profile file.
• B、If both $HOME/.profile and $HOME/.env files are present, the settings in the $HOME/.profile file will take precedence.
• C、The settings in the /etc/environment file are system-wide and will override user customized settings in the $HOME/.profile.
• D、The settings in the /etc/profile file will override settings in the $HOME/.profile file unless the $LOCAL_PROFILE variable is set to 'true'.

第7题：

The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）

• A、The data file cannot be recovered.
• B、The date file can be restored from theSYSTEMauto backup.
• C、Take thetablespaceoffline，drop，kand re-create it.
• D、Recovery Manager （RMAN） is used to recover the data file.
• E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

第8题：

Which statement describes the ROWID data type? （）

• A、Binary data up to 4 gigabytes.
• B、Character data up to 4 gigabytes.
• C、Raw binary data of variable length up to 2 gigabytes.
• D、Binary data stored in an external file, up to 4 gigabytes.
• E、A hexadecimal string representing the unique address of a row in its table.

第9题：

ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

• A、Use the database link.
• B、Use the SQL*Loader utility.
• C、Use the Oracle Data Pump utility.
• D、Create an external table and leave the data in the flat file

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

第16题：

Which file characteristic cannot be used in the Cisco IronPort Data Security policies？（） 

• A、 file type
• B、 file size
• C、 file age
• D、 file  name

第17题：

在APG40的FMS中支持的文件类型有（）.

• A、Simple file
• B、Composite file
• C、Infinite file
• D、Keyed file

第18题：

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

• A、Use the database link.
• B、Use the SQL*Loader utility.
• C、Use the Oracle Data Pump utility.
• D、Create an external table and leave the data in the flat file

第19题：

In which case would you use the Flashback Database feature to perform a recovery？（）

• A、to recover a dropped tablespace
• B、to recover data from a truncated table
• C、to recover a data file that has been shrunk
• D、to recover a database to the state that existed before the RESETLOGS operation

第20题：

The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）

• A、The data file cannot be recovered.
• B、The date file can be restored from the SYSTEM auto backup.
• C、Take thetablespaceoffline，drop，kand re-create it.
• D、Recovery Manager （RMAN） is used to recover the data file.
• E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

第21题：

Your company has two branch offices that connect by using a WAN link. Each office contains a server that runs Windows Server 2008 R2 and that functions as a file server.   Users in each office store data on the local file server. Users have access to data from the other office.   You need to plan a data access solution that meets the following requirements： èFolders that are stored on the file servers must be available to users in both offices. èNetwork bandwidth usage between offices must be minimized.   èUsers must be able to access all files in the event that a WAN link fails. What should you include in your  plan？（）

• A、On both servers， implement DFS Replication.
• B、On both servers， install and configure File Server Resource Manager （FSRM） and File Replication  service （FRS）.
• C、On one server， install and configure File Server Resource Manager （FSRM）. On the other server，install and configure File Replication Service （FRS）.
• D、On one server， install and configure Distributed File System （DFS）. On the other server， install and configure the Background Intelligent Transfer Service （BITS）.

第22题：

第23题：