资格证大类 - 计算机编程

You executed the following commands in a database session: What could have caused the recycle bin to clean up?（）

A、 There is demand for space from the new table

B、 The undo tablespace does not have sufficient free space

C、 The new table name is the same as the table name in the recycle bin

D、 The temporary tablespace that is assigned to you does not have sufficient free space

当需要更改视图的时候，可以使用（）语句，显式重新编译视图。

A、UPDATE VIEW

B、ALTER VIEW

C、DROP VIEW

D、MODIFY VIEW

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. 

A、a， b， f， g

B、c， f， g

C、a， d， f， g

D、a， f， g

E、a， e， g

You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）

A、It will display a list of files that need incremental backup

B、It will display a list of files that need backup after five days

C、It will display a list of files that were backed up in the last five days

D、It will display a list of files that have not been backed up in the last five days

E、It will apply the current retention policy to determine the files that need to be backed up

Which command will result in a trace file being created with the create controlfile command contained in it？（）  

A、 alter database backup controlfile

B、 alter database backup controlfile to trace

C、 alter database controlfile backup

D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

E、 alter database begin controlfile backup

Evaluate the following block of code：   BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL （ acl =>  ’mycompany-com-permissions.xml’， principal => ’ACCT_MGR’， is_grant => TRUE， privilege => ’connect’）；  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL （ acl => ’mycompany-com-permissions.xml’， host => ’*.mycompany.com’）； END；   What is the outcome of the above code？（）

A、 It produces an error because a fully qualified host name needs to be specified.

B、 It produces an error because the range of ports associated with the hosts has not been specified.

C、 It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.

D、 It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）

A、ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;

B、ALTER DISKGROUP dg1 UNDROP;

C、ALTER DISKGROUP dg1 UNDROP DISKS;

D、You cannot cancel the pending disk drops.

How many individual archive-log destination directories are supported by Oracle Database11g?（）

A、7

B、1

C、10

D、11

E、21

Which three elements can a job chain process involve？（）

 an event

 a schedule

 a program

 another chain

 a lightweight job

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）

A、using only the RMAN SWITCH command to set the new location for the data file

B、placing the database in the MOUNT state for the restore and recovery operations.

C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

D、configuring two channels: one for the restore operation and the other for the recovery operation