-
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 u
-
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 u
-
You issue the following RMAN command to set a retention policy on a database： RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of the above command？（）
A . After two days， the backup will be marked obsolete.
B . After two days， the backup will be deleted from the media.
C . If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.
D . If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.
-
You issued the RMAN>SHOW ALL； command. The output of this command is as follows：
https://assets.asklib.com/images/image2/2018080116074760626.jpg
After analyzing the output， which conclusion will you draw？（）
A . The current control file is not automatically backed up every time you perform a backup.
B . The backups save space on the storage media.
C . While performing backups across a network， the network bandwidth is reduced.
D . The backups consist of backup pieces.
-
You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）
A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B . The command will not execute successfully because resumable space allocation is enabled at the session level.
C . The command will execute successfully and resumable space will be allocated at the session level.
D . The command will execute successfully and resumable space will be allocated at the instance level.
-
You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）
A . The control file will be multiplexed.
B . The control file will be recreated.
C . The script containing the CREATE CONTROLFILE statement will be created.
D . The binary backup of the control file will be created.
-
You issued the following RMAN command to back up the database:
https://assets.asklib.com/images/image2/2018080209472183076.jpg
Which two statements are true regarding the backup performed?（）
A . Archived redo log files are backed up along with data files.
B . Only data files are backed up and a restore point named FY06Q4 is created.
C . Archived log files are backed up along with data files, and the archived log files are deleted.
D . The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
-
While logged into a Company switch you issue the following command： CompanySwitch（config-mst）# instance 10 vlan 11-12 What does this command accomplish？（）
A . It enables a PVST+ instance of 10 for vlan 11 and vlan 12
B . It enables vlan 11 and vlan 12 to be part of the MST region 10
C . It maps vlan 11 and vlan 12 to the MST instance of 10.
D . It creates an Internal Spanning Tree （IST） instance of 10 for vlan 11 and vlan 12
E . It create a Common Spanning Tree （CST） instance of 10 for vlan 11 and vlan 12
F . It starts two instances of MST， one instance for vlan 11 and another instance for vlan 12.
-
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）
A . Immediately following statement execution
B . After the ALTER TABLE DROP UNUSED COLUMNS command is issued
C . After the ALTER TABLE SET UNUSED COLUMN command is issued
D . After the ALTER TABLE MODIFY command is issued
-
You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）
A . The client RDBMS instance can access the file as a read-only file.
B . A new disk cannot be added to a disk group.
C . A disk in a disk group can be taken offline.
D . The client RDBMS instance cannot access the files in the disk group.
-
You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）
A . The operating system local time zone will be set for a user session using the operating system environment variable.
B . The database local time zone will be set for a user session using the operating system environment variable.
C . The operating system local time zone will be set for the database using the operating system environment
D . The database local time zone will be set for the database using the operating system environment variable.
-
You need to create a partitioned table to store historical data and you issued the following command:
https://assets.asklib.com/images/image2/2018080209263145770.jpg
What is the outcome of the above command?（）
A . It returns an error because the range partitions P1 and P2 should be of the same range.
B . It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C . It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D . It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.
-
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
A . when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
B . when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C . when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
D . when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E . never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
-
You issued the following RMAN command： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）
A . When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
B . When a structural change is made to the database， then a backup of the current control file is performed.
C . When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
D . When a structural change is made to the database， then a backup of the alert log file will be performed.
-
You issue the following command： RMAN>CONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）
A . An incremental backup strategy will be used automatically.
B . Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
C . RMAN will configure itself for maximum performance at the cost of CPU.
D . RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
E . RMAN will automatically compress backups.
-
In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；
A . when all the control files are missing and only a binary backup of the current control file exists
B . when a multiplexed copy of the current control file is missing
C . when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D . when the SPFILE is missing
-
In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
A . to configure RMAN to maintain backup information in the RMAN repository for seven days
B . to configure RMAN to maintain backup information in the control file for at least seven days
C . to display the list of files that have not been backed up for the last seven days
D . to display the list of files that must be backed up within seven day
-
You issued the RMAN>SHOW ALL； command. The output of the command is as follows：
https://assets.asklib.com/images/image2/2018080116014456210.jpg
After analyzing this output， what conclusion can you draw？ （）
A . If you perform a backup across a network， then the backup will reduce the bandwidth.
B . If you perform a backup of a datafile， then the backup will be the same as the operating system copy of the datafile.
C . If you perform a backup of a single datafile， then the control file will not be backed up.
D . The maximum size of each backup set is 10MB
E . The backups will be performed on the disk.
-
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A . All data along with the table structure is deleted
B . The pending transaction in the session is committed
C . All indexes on the table will remain but they are invalidated
D . All views and synonyms will remain but they are invalidated
E . All data in the table are deleted but the table structure will remai
-
You issue the following command on the RMAN prompt. RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE； 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.
-
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? （）
A . After two days, a backup will be marked obsolete
B . After two days, a backup will be deleted from the media
C . If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D . If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
-
Examine the following query output:You issue the following command to import tables into the hr schema:$ ＞ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hrTRANSFORM=DISABLE_ARCHIVE_LOGGING: YWhich statement is true？（）
A. All database operations performed by the impdp command are logged.
B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
-
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.
-
While troubleshooting connectivity issues, you log into a remote router. From there,you wish to see the layer 1 and layer 2 status of the interface.Which of the following IOS commands would you issue to check the current IP addressing, as well as theyer 1 and layer 2 status of an interface？（）
A. TK1 show version
B. TK1 show protocols
C. TK1 show interfaces
D. TK1 show controllers
E. TK1 show ip interface
F. TK1 show startup-config
