一抹曦阳-Oracle

501.Note the output of the following query;SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve; 此处表名有点错误，应该为DBA_FLASHBACK_ARCHIVEFLASHBACK_ARCHIEVE_NAME STATUSFLA1You execu

701. A user receives the following error while performing a large volume of inserts into a table: The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the

709. A database has three online redo log groups wi th one member each. A redo log member with thestatus ACTIVE is damages while the database is running.What is the first step you should take to s

702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE).When you tried to start the database instance, you received the following error: Why di

707. Because of a logical corruption in the EMPLOYES tables, you want to perform TablespacePoint-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, youqueried t

705. View Exhibit1 to examine the DATA disk group when all the disks are online.    Why is the rebalancing not performed and the content of  the disk group not empty in Exhibit2?A.Because the di

694. As part of archiving the historical data, you want to trans fer data from one database to anotherdatabase, which is on another server. All tablespaces in the source database are read/write and

QUESTION 206What happens if you shutdown abort ASM instance?A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance recovery after startupAnswer

486.You execute the following Recovery Manager (RMAN) commands in (he following order:BACKUP VALIDATE DATABAERECOVER CORRUPTION LIST;Which (two tasks are performed by these commands? (Choose two

498.The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You wantto perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task,y

481.Which statement is true about a running session that belongs to the online transaction processing(OLTP) group?A. It permanently switches to the low_group consumer group if the session ex

505.You configured the default backup device type as disk for RMAN backups. In your database, becauseof business requirements, you have to take a simultaneous duplicate backup of the data files wh

379.Users notify you that their application is failing every time they try to add new records. Because ofpoor application design, the actual ORA error message is unavailable. What might be the probl

508.You want to set the following Initialization parameters for your database InstanceLOG_ARCHIVE_DEBT_1 = ,,LOCATION=/disk1/archLOG_ARCHIVE_DBST_2 = ,,LOCATION=/disk2/archLOC_ARCHIVB DBST_3 = ,

683. Your production database it f unctional on the SHOST1 host. Y ou are backing up the productiondatabase by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate thepro

703. Given below are RMAN commands to enable ba ckup optimization and set  the retention policy: The USERS tablespace has never been backed up. Y ou take the USERS tablespace offline on Monday.V

QUESTION 104The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. Youexecuted the following command to startup the Automatic Storage Management (ASM) instanc

512.Which two statements correctly describe the relationship among the Scheduler components: job,program, and schedule? (Choose two)A. A job is specified as part of a program definitionB. A prog

687. Users are connected to a database instance that is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the ASM instance:SQL> SHUTDOWN IMMEDIATE;

32.In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regularintervals Set the control file autobackup to "on"-Are mai

24.Which of the following information will be gathered by the SQL Test Case Builder for the problemspertaining to SQL-related problems? (Choose all that apply.)A. ADR diagnostic filesB. all the

681. The environmental variable ORACLE-BASE is set.  You want to check the diagnostic files created aspart of the Automatic Diagnostic Repository (ADR). Vi ew the Exhibit and note the various parame

699. Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default temporary tablspace. A user issues a query on the

695. Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuring control  file autobackup to be ONB. ba

686. You execute the following FLASHBACK TABLE command: Which two statements are correct?(Choose two.)A.The EMP table that was dropped by  mistake earlier is restored.B.The FLASHBACK TABLE sta

39. Evaluate the following command: CREATE TABLE employees(employee_id      NUMBER(2) PRIMARY KEY, last_name        VARCHAR2(25) NOT NULL, department_id    NUMBER(2)NOT NULL, job_id

86.Your production database is running in archivelog mode and you are using recovery manager (RMAN)with recovery catalog to perform the database backup at regular intervals. When you attempt to re

682. Identify the scenarios in which the RMAN CROSSCHECK comm and is useful. (Choose all thatapply.)A.To check that the obsolete backups are deleted from the repository records and from the disk.

684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.  You are informed that some important tables in  the BILLING tablesp

700. Which two statements are true  about a duplicate database that is created by  using the DUPLICATEcommand in RMAN? (Choose two.)A.It is a copy or a subset of the target database.B.It is open

134.You are managing an Oracle Database 11g database. You want to take a backup on tape drives ofthe USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To

154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receivesthe following error message:Which is the recommended sequence of operations you need to perform

510.You executed the following command in Recovery Manager (RMAN):RMAN> REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files that require a backup within three daysB

185.A shoot-out has erupted between your MS development teams using .NET and your Linuxdevelopment teams using Java. Knowing that your database is in danger, which command would you useto back up

25.You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported onthe table after enabling Flashback Data Archive?A. Drop the table.B. Partition the tableC. Tr

25.You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported onthe table after enabling Flashback Data Archive?A. Drop the table.B. Partition the tableC. Tr

685. In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOARCHIVELOG mode-One of the data files is

502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each grouphas one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In th