-
Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file?()
A . COPY
B . BACKUP
C . CHANGE
D . DELETE
E . CATALOG
-
Which is the correct description of a pinned buffer in the database buffer cache()
A . The buffer is currently being accessed.
B . The buffer is empty and has not been used.
C . The contents of the buffer have changed and must be flushed to the disk by the DBWn process.
D . The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
-
In a high-availability deployment, when the Cisco CRS Administrator adds a JTAPI Call Control Group with 100 CTI ports, how many device records will be added to the Cisco Unified CallManager database?()
A . CTI Ports are not added by the creation of a Call Control Group.
B . CTI ports are no longer required to be added to the Cisco Unified CallManager database.
C . 100 devices will be added to the Cisco Unified CallManager database.
D . 200 devices will be added to the Cisco Unified CallManager database.
E . It depends upon how many port groups these ports will be split into.
F . It depends upon the number of server nodes within the Cisco Unified CallManager cluster.
-
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two)
A . Control files
B . Password files
C . Inactive online redo log file
D . Archived log files required to perform recovery
E . Newly created tablespace which is not backed u
-
Which two file types must be included in a closed database backup taken with operating system commands?()
A . data files
B . control file
C . password file
D . online redo log files
E . initialization parameter file
-
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform a transportable tablespace import?()
A . DB_4K_CACHE_SIZE only
B . DB_8K_CACHE_SIZE only
C . DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D . DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E . SGA_TARGET and DB_4K_CACHE_SIZE
F . DB_CACHE_SIZE only
-
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()
A . The database would open normally.
B . The database would not open, and it would stop at mount stage.
C . The database would open after automatically performing instance recovery.
D . The database would not open, and you have to perform database recovery to open it.
-
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?()
A . The CDB must be open.
B . The CDB must be in the mount stage.
C . The CDB must be in the nomount stage.
D . Alt existing PDBs must be closed.
-
The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()
A . control file
B . tnsnames.ora
C . data dictionary
D . initialization parameter file
-
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
A . loss of a tempfile
B . loss of a system data file
C . loss of one of the control files
D . loss of one of the tablespaces
E . loss of a member from each redo log group
F . loss of the only member of an unarchived redo log grou
-
You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()
A . Mount the database
B . Open the database in NORMAL mode
C . Open the database in RESTRICTED mode
D . Open the database with the RESETLOGS optio
-
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
A . loss of one of the tablespaces
B . loss of a system data file
C . loss of one of the control files
D . loss of a tempfile
E . loss of the only member of an unarchived redo log group
F . loss of a member from each redo log grou
-
When performing recover of a database in NOARCHIVELOG mode with RMAN, the target database must be in the () state to restore the control file.
A . OPEN
B . IDLE
C . MOUNT
D . NOMOUNT
-
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
A . SYSTEM
B . OUTLN
C . INTERNAL
D . SYS
-
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()
A . Control files
B . Password files
C . Inactive online redo log file
D . Archived log files required to perform recovery
E . Newly created tablespace which is not backed u
-
You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group?()
A . The au_size disk group attribute determines the size of allocation units in the disk group.
B . The allocation unit size may vary but the extent size is fixed.
C . The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
D . Extent management is completely automated.
-
View the Exhibit and examine the Flashback Database architecture.
Identify the missing component (shown with a "?") in the Flashback Database architecture.()
https://assets.asklib.com/images/image2/2018080210560571406.jpg
A . DBWn
B . RVWR
C . ARCH
D . RECO
E . TRWR
-
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;
A . $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B . Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C . $ mysql – u root – p – h localhost test < /tmp/t1.sql
D . Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql
-
What is the proper command to shut down the database in a consistent manner?()
A . shutdown abort
B . shutdown kill
C . Shutdown nowait
D . shutdown immediate
E . shutdown halt
-
A customer with IPCC Express Standard reports that a script using the Database steps is not working. What is the most likely root cause?()
A . The script probably has an error in the DSN configuration.
B . IPCC Express Standard is not licensed for Database steps.
C . The script probably has an error in the query string.
D . There is probably an interoperability problem between IPCC Express and the database.
-
You are evaluating the use of failover clusters with Cluster Shared Volumes (CSV) for the database servers. You need to recommend which hardware must be purchased. What should you include in the recommendation?()
A . a WAN accelerator
B . a hardware load balancer
C . Network Attached Storage (NAS)
D . a Storage Area Network (SAN)
-
In MLA style, to create an entry for a source taken from an online database, we should begin with the appropriate form, and conclude the entry with _________________.
-
You are connected to a pluggable database (PDB) as a common user with DBA privileges.The S
You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?()
A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
-
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:Which two statements are true regarding the tasks accomplished with these commands?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/fe48cb3c0725d56bce44108ab4437e61.jpg' />
A. They import all metadata from the RCAT10 catalog.
B. They unregister the database from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They register all databases registered in the RCAT10 catalog.