中国人民银行授权外汇交易中心对外每日公布人民币对美元、欧元等的（)。A．买入价B．中间价C．卖出价D．

ma and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.

Youwanttocreatearoletomeettheserequirements：1.Theroleistobeprotectedfromunauthorizedusage.2.Thepasswordoftheroleisnottobeembeddedintheapplicationsourcecodeorstoredinatable.methodwouldyouusetorestrictenablingofsuchroles（）

A.Createtherolewithexternalauthentication.

B.Createtheroleasasecureapplicationrole.

C.Createtheroleasapassword-protectedrole.

D.CreatearoleanduseFine-GrainedAccessControl（FGAC）tosecuretherole

YouworkasadatabaseadministratorforSupportcenter.cn.Whilegrantingarole，SELECT_CATALOG_ROLE，toauser，SupportCenter，usingOracleEnterpriseManager10gDatabaseControl，youhaveclearedtheDEFAULTcheckbox.Whatwillbetheresult？（）

A.Theusercannotusetheroleatall.

B.Therolewouldnotbegrantedtotheuser.

C.Theuserneedstoenabletheroleexplicitly.

D.Theusercanstartusingtheroleimmediately.

E.Theuserwouldhavetheadminoptionfortherole.

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.

A.Databaseisnotopen

B.Listenerisnotrunning

C.Servicenameisnotcorrect

D.WrongportnumberusedinURL

E.Usersysdoeshavethemediaprivilege

A.RECOVERY_CATALOG_OWNER

B.DBA

C.RESOURCE

D.SELECTANYDICTIONARY

E.CONNECT

, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）

A. parallel image copy backup

B. backup with MAXPIECESIZE configured for the channel

C. parallel backup with MAXPIECESIZE configured for the channel

D. intrafile parallel backup

A. You can join a maximum of two tables through an equijoin.

B. You can join a maximum of two columns through an equijoin.

C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.

D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.

E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.

B. The virtual private catalog owner cannot create and modify the stored scripts.

C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

A.ItmustbeusedbecauseallRMAN-relatedbackupandrecoverymetadatainformationiscontainedinit.

B.Itprovidesaconvenient，optional，repositoryofbackup-andrecovery-relatedmetadata.

C.ItprovidestheabilitytostoreRMANscriptsforglobalusebyanydatabasethathasaccesstotherepository.

D.ItprovidesameansofstoringallRMANbackupsetsphysicallyinanOracledatabaseserver.

E.Itprovidestheabilitytostorebackuprecordsformorethanayear.