计算机网络中的有线网和无线网是按照（)划分的。A．距离B．通信媒体C．传播方式D．通信速率

same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target

A.YoumustensurethattheSALESdatabaseismountedoropen.

B.Youmustrestoreabackupcontrolfiletoperformablockmediarecovery.

C.Youmusttakethetools01.dbfdatafileofflinebeforeyoustartablockmediarecovery.

D.YoumustputthedatabaseinNOARCHIVELOGmodetoperformablockmediarecovery.

E.Youcanperformonlyacompletemediarecoveryofindividualblocks；point-in-timerecoveryofindividualdatablocksisnotsupported.

A. SQL Access Advisor recommendations are automatically implemented.

B. Individual SQL Access Advisor recommendations can be scheduled for implementation.

C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.

D. SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.

E. None of the above.

Inyourdatabaseinstance，theusersessionsareconnectedtothedatabaseserverfromtheremotemachines.Youwanttoachievethefollowingfortheseusers：1.Theuseraccountmustbelockedafterfourunsuccessfulloginattempts.2.Theusermustbepromptedtochangethepasswordatregularintervals.3.Theusermaynothavemorethanthreesimultaneoussessions.4.Theusersessionmustautomaticallybeloggedoffifmorethan10minuteselapsedtimeused.Howwouldyouaccomplishtheabove（）

A.Byassigningprofilesfortheusers

B.ByimplementingFine-GrainedAuditing（FGA）

C.Bygrantingasecureapplicationroletotheusers

D.ByimplementingtheDatabaseResourceManagerplan

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.

A.restore

B.repair

C.copy

D.recover

E.replace

A. Create new indexes.

B. Modify existing indexes.

C. Implement partitioning on a nonpartitioned table.

D. Create materialized views.

E. All of the above

A. It cannot generate recommendations that support multiple workload queries.

B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

C. It can recommend partitioning only on tables that have at least 10,000 rows.

D. It can recommend only B-tree indexes and not bitmap or function-based indexes

NotethefollowingpointsdescribingvariousutilitiesinOracleDatabase1g：1.Itenablesthehigh-speedtransferofdatafromonedatabasetoanother.2.Itprovidesacompletesolutionforthebackup，restoration，andrecoveryneedsoftheentiredatabase.3.ItenablestheloadingofdatafromanexternalfileintoanOracledatabase.4.ItprovidesatapebackupmanagementfortheOracleecosystem.WhichpointdescribesOracleSecureBackup（）

A.1

B.2

C.3

D.4

E.1，2，and4

F.1，2，3，and4

have only the customer name and address. The CUSTOMERS table has these columns:CUST_ID NUMBER(4) NOT NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_ADDRESS VARCHAR2(150)CUST_PHONE VARCHAR2(20)Which SELECT statement accomplishes this task?（）

A. SELECT* FROM customers;

B. SELECT name, address FROM customers;

C. SELECT id, name, address, phone FROM customers;

D. SELECT cust_name, cust_address FROM customers;

E. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;