资格证大类 - 计算机编程

Which of the following is not a valid linguistic sort element？（）

A、 Accent expansion

B、 Canonical equivalence

C、 Reverse secondary sorting

D、 Ignorable characters

E、 Character rearrangement

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

A、 You cannot perform the TSPITR with the constraints enabled.

B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.

C、 You can perform TSPITR only on the USERS tablespace.

D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.

E、 The TSPITR will only be successful if the constraint is enabled.

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.

A、1，3，6，7

B、2，3，6，8

C、1，2，3，6，7

D、1，2，3，6，，7，8

E、2，3，6，5，7

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER；   Which two statements are true regarding the tasks accomplished with these commands？（）

 They import all metadata from the RCAT10 catalog.

 They unregister the database from the RCAT10 catalog.

 They do not register the databases registered in the RCAT10 catalog.

 They register all databases registered in the RCAT10 catalog.

Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）

A、120M

B、320M

C、480M

D、600M

How long will this backup be allowed to run？（）  Backup as compressed backupset duration 2：00 minimize load database

A、 2 minutes

B、 2 hours

C、 2 days

D、 The command will generate an error.

E、 This backup is not constrained by any time limitation.

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to （）

A、 identify the segments that you should shrink

B、 modify the storage parameters for the tablespace

C、 automatically shrink the segments with unused space

D、 check the alerts generated for the tablespace that is running low on space

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

Reregistering the target database in recovery catalog

Transporting the new tablespaces to the recovery catalog database

Syncronizing the recovery catalog with the target database control file

Performing a fresh backup of the target database to include the new data files in the catalog database

During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation？（）  

A、 The installation terminates with an error.

B、 The installation proceeds with the default value without warnings and errors.

C、 The installation proceeds with the default value but it would not be an OFA-compliant database.

D、 The installation proceeds with the default value but a message would be generated in the alert log file.

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）

A、Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

B、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

C、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

D、Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.