1Z0-235英文认证题库

Q1.Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup(OSB):1. RMAN initiates backup and passes the database backup storage selector to OSB.RMAN2. RMAN creates the backup job.3. OSB creates the backup job with an OSB user4. RMAN updates its repository.5. RMAN executes the job and transfers data from a client to media.6. OSB executes the job and transfers data from a client to media7. OSB updates its repository. Identify the required steps in the correct order.A. 2,1,6,4,7B. 1,3,6,7,4C. 1,3,6,4,7D. 1,3,5,7,4Answer: BQ2.In your database, the user scott wants to retrieve the dropped HR.EMPLOYEES table by using the command:SQL>FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;What are three prerequisites for this command to succeedA. scott should have the FLASHBACK ANY TABLE privilege.B. No duplicates of the HR.EMPLOYEES table should exist in the recycle bin of the HR schema.C. scott should have the SELECT privilege on the HR schema and its recycle binD. Undo retention guarantee must be enabled.E. No other table with the same name should exist in the HR schema HRF. The recycle bin should be enabledAnswer: AEFQ3.Examine the RMAN commands:RMAN> CONNECT TARGET "sbu@prod as SYSBACKUP";RMAN> CONNECT AUXILIARY "sbu@dup_db as SYSBACKUP";RMAN> DUPLICATE TARGET DATABASE TO dup_dbFROM ACTIVE DATABASEPASSWORD FILESECTION SIZE 400M;Which statement is true about the DUPLICATE commandA. It succeeds only if the target database is in MOUNT state.B. It succeeds and creates multisection backup sets that are used for active database duplication.C. It fails because there is no connection to a recovery catalogD. It fails because no parallel channels are allocated for the auxiliary databaseAnswer: BQ4.Which two are prerequisites for performing Flashback TransactionA. Undo retention guarantee must be configured for the database.B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.C. A supplemental log must be enabled for the primary key.D. Row movement must be enabled.E. Fast Recovery Area must be enabled for the database.Answer: BCQ5.You use RMAN to take regular backups for your database. Examine the RMAN commands: RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP£»Which statement is trueA. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.B. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.C. All backups that have exceeded the age set by the RMAN retention policy are deleted.D. All backups and archived redo log files that are not recovery are deleted and the repository is updated.Answer: BQ6.Examine the RMAN command: RMAN> RUN {ALLOCATE CHANNEL c1 DEVICE TYPE sbt;ALLOCATE CHANNEL c2 DEVICE TYPE sbt;ALLOCATE CHANNEL c3 DEVICE TYPE sbt;BACKUP INCREENTAL LEVEL = 0(DATAFILE 1, 4, 5 CHANNEL c1)(DATAFILE 2, 3, 9 CHANNEL c2)(DATAFILE 6, 7, 8 CHANNEL c3);SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';}which statement is true about the commandA. It uses parallelization for the backupset.B. It uses multisection backup.C. It uses asynchronous I/O for the backup.D. It creates compressed backup setsAnswer: AQ7.Your database is running in ARCHIVELOG mode and flashback is enabledIn which scenario must you use RMAN backups for recovering tables and table partitionsA. when recovering a table to a point in timeB. when recovering a table that has been logically corruptedC. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undoD. when recovering dropped tables that are present in the recycle binE. when recovering data that was lost after a DDL operation modified the structure of atableAnswer:EQ8.You issue the RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users:Which statement is true about the execution of the commandA. The backup succeeds only if the users tablespace is locally managed.B. RMAN uses multiplexing to perform the backup.C. The resulting backupset has backup pieces that cannot exceed 300 MB.D. RMAN always performs this type of backup in parallel.E. The backup set size is limited to 300 MB.Answer: CQ9.you enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for Keeping transactions from four to two years .You execute the following command to change the requirement:SQL>ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTTON 2 YEAR;What is the outcomeA. All historical data older than two years, if any, is purged from the flashback archiveFDA1.B. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.C. An error is returned because the retention period cannot be reduced.D. AIl the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.Answer: AQ10.Which three types of backups can be performed for a database running in NOARCHIVELOG modeA. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is openB. consistent whole database backupC. backup of the database without shutting down the instanceD. backup of only those blocks that have changed since the last backup while the databaseis mountedE. backup of noncritical tablespaces without shutting down the instanceAnswer: BDEQ11.You are administering a multitenant container database (CDB. CDB1 with two pluggable databases(PDBs),PDB1 and PDB2.Your execute the following commands on CBD$ROOT as the sys user:SQL>CREATE USER C##scott IDENWTIFTED BY scottorcl1; SQL>GRANT CREATESESSION TO c##scott£»Which statement is true about the c##scott userA. It is created and has the CREATE SESSION privilege only in a PDB that is open.B. It is created in all the PDBs with the CREATE SESSTON privilege.C. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB $ROOT.D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.Answer: CQ12.Your multitenant container database(CDB. CDB1 has two pluggable databases,PDB1 and PDB2.The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable database(PDBs), PDB1 and PDB2 ,respectively . Examine the commands to change the value of the PDB modifiable initialization parameter: $>sqlplus sys/oracle_4U@pdb1 AS SYSDBASQL>ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH£»SQL>CONN sys/ oracle_4U@pdb2 AS SYSDBASQL>ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;SQL>CONN sys/ oracle_4U@cdb 1 AS SYSDBASOL>ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;Which statement is true about the OPTIMTZER_USE_SQL_PLAN_BASELINES parameterA. It gives an error because it cannot be set for the root database.B. It is set to TRUE for the root database and the pluggable database PDB2 , because values can be set for this parameter at the PDB level in a PDB.C. It is set to TRUE for the root database and all the PDBs, because the value set at theroot level has higher precedence.D. It is set to TRUE for the root database and all the PDBs, but is effective only when the CDB is restarted and the PDBs are reopenedAnswer: BQ13.You execute the RMAN commands:RMAN >CONEIGURE DEFAULT DEVICE TYPE TO disk;RMAN> CONEIGURE DEVICE TYPE disk PARALLELISM 2;RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk1/%U;RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/disk2/%U;RMAN>BACKUP DATABASE£»Which statement is true about the backup set created by the backup commandA. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL2.B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.C. The default channel is allocated and the backup set is created in only one destination.D. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.Answer: BQ14.Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10AM after the last backup. After that, a few important transactions are performed on the database.which two best methods for recovering the truncated table dataA. Flashback DatabaseB. Flashback Transaction BackoutC. Table Point-in-Time RecoveryD. Database Point-in-Time RecoveryE. Tablespace Point-in-Time RecoveryAnswer: CEQ15.Which three statements are true about unplugging a pluggable database (PDB)A. PDB data files are automatically removed from disk.B. An unplugged PDB can be plugged into the same or another container database (CDB) .C. A PDB must be in closed state before it can be unplugged.D. A PDB must be in MOUNT state before it can be unplugged.E. A PDB must have been opened at least once after creation.Answer: BDEQ16.Which two statements are true about RMAN duplexed backupsA. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.B. It is only supported for backups to tape via the media management interface.C. Duplex backups can contain only data files and control files.D. It is not supported for image copies.E. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.Answer: ADQ17.Which three requirements should be successfully met by an Oracle Secure Backup (OSB) userso that OSB performs RMAN backup or restore requestsA. RMAN preauthorization on the hostB. OSB encryption for data in transport and on tapeC. scheduling of the RMAN backup to occur automatically at user-defined intervalsD. assigned to a class with rights to browse all directories and catalogsE. assigned to a class with rights to back up or restore Oracle databaseF. matching the OS user identity of the Oracle instance associated with the database usernameAnswer: AEFQ18.You database supports an online transaction processing (OLTP) workload and it needs to be up 24x7 .You want to perform a complete database backup by using RMAN. Identify the minimumrequirement for accomplishing the task.A. The database must be configured in ARCHIVELOG mode.B. An RMAN channel must be configured to device-type disk.C. All tablespaces in the database must be locally managed.D. Redo log groups must have at least two members each.Answer: AQ19.Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery startA. from the beginning of the current redo log file until the instance failureB. from the last committed transactionC. from the most recent incremental checkpointD. from the beginning of the current redo log file to the checkpoint positionE. from the last complete checkpoint positionAnswer: CQ20.Which two statements are true about Resource Manager plans for individual pluggable databases(PDB plans)in a multitenant container database(CDB)A. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.B. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.D. If no PDB plan is enabled for a pluggable database , then all sessions for that PDB are treated to an equal share of resources.E. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan Answer: BDQ21.Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database(CDB)A. Clone an existing PDB.B. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.C. use Enterprise Manager Database Express to create a PDB in an existing CDB.D. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.E. Use PDB$SEED for creating a PDB.Answer: ADEQ22.You are administering a multitenant container database (CDB) that contains multiple pluggable databases(PDBs). RMAN is connected to CDB$ROOT.Examine the command:RMAN>LIST FAILURE;Which statement is true about this commandA. It lists failures only for the CDB root database.B. It lists failures for a PDB only When RMAN is connected to a recovery catalog.C. It lists failures for the CDB and all the PDBs in this CDB.D. It lists failures only if RMAN is connected to a PDB.Answer: AQ23.Which three statements are true aboutA. A table enabled for Flashback Data Archive cannot be dropped unless FlashbackData Archive is disabled or disassociated first.B. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.D. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.E. To use Flashback Data Archive, users must have unlimited quota on the FlashbackData Archive tablespace.Answer: ABCQ24.You create a new database by using the CREATE DATABASE command in SQL*plus, with the ENABLE PLUGGABLE DATABASE Clause specified.Which statement is true about the database that is createdA. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database(PDB).B. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.C. It is created as a non-CDB that becomes a CDB after the first POB is plugged in.D. It is created as a PDB that must be plugged into an existing CDB.Answer: BQ25.Which two statements are true about encrypted backups performed by using RMANA. Transparent encryption of backups uses an encryption wallet.B. Encrypted backups can only be written to disk.C. A database uses the same encryption key for every encrypted backup.D. Image copy backups can be created by using password encryption.E. A password encryption of backups uses the password while creating and restoring backups.Answer: AEQ26.You plan to duplicate the multitenant container database(CDB) cdb1 that contains the pluggable database(PDB)SALES :RMAN> DUPLICATE TARGET DATABASE TO cdbdupPLUGGABLE DATABASE sales FROM ACTIVE DATABASE PASSWORD FILESPFILE NOFILENAMECHECK£»Which two statements are trueA. Only the SALES PDB is duplicated as the non-CDB CDBDUP.B. The root and seed databases are included in the duplication.C. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.D. A backup of the SALES PDB must exist before the execution of the command.E. RMAN must be connected to a recovery catalog for the execution of command. Answer: BCQ27.Which two operations are NOT performed by the DUPLICATE command in RMAN whileduplicating a database that is openA. creating a control file for the duplicate database.B. copying online redo log files from the target database to the duplicate databaseC. performing complete recovery by using all available backupsD. restoring target data files to the duplicate databaseE. generating a new, unique database identifier (DBID) for the duplicate database Answer: BCQ28.Examine the statements that use flashback technologies:1. FLASHBACK TABLE customers TOTIMESTAMP TO_TIMESTAMP("2013-02-0409:30:00','YYYY-MM-DD HH:MT:SS')£»2. SELECT * FROM customers AS OF SCN 123456;3. FLASHBACK TABLE customers TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMPA("2013-02-0409:30:00','YYYY-MM-DD HH:MT:SS')5. SELECT*FROM customers VERSTONS BETWEEN SCN 123456 AND 123999;6. ALTER TABLE customers FLASHBACK ARCHTVEWhich set of statements depends on the availability of relevant undo data in the undo tablespaceA. 1,2,5B. 3,4,5C. 1,3,6D. 2,3,5,6Answer: AQ29.Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours.After a regular maintenance task when you attempt to restart the instance,it halts in MOUNT state with an error indicating that one of the datafiles belonging to the EXAMPLE tablespace is lostYou want to recover the data file as quickly as possible while maximizing availability for the database.Examine the possible steps involved in the recovery process:1. Mount the database.2. Take the data file offline.3. Bring the tablespace online.4. Use the RMAN Switch command to switch to the image copy.5. Recover the tablespace.6. Open the database.7. Use the RMAN RESTORE command to switch to the image copy. Identify the correct sequence of the required steps.A. 1,2,4,6,3B. 2,7,5,3C. 2,4,5,3,6D. 1,2,7,5,3,6E. 2,6,4,5,3Answer: EQ30.You are performing regular backups of your production database by using a recovery catalog.You add two new tablespaces to your production database after performing a backup. They must be included in future backups.Which action should you performA. Synchronize the recovery catalog with the target database control file.B. Add the tablespaces in the recovery catalog by using the CATALOG command.C. Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSCHECK command.D. Create a new database incarnation record.Answer: AQ31.Which two statements are true about roles in multitenant container databases(CDBs) A. A common user can create a local role by default in any pluggable database(PDB) that is plugged in to a CDBB. The root container can have both local and common roles.C. A local role can be assigned to a common role in a PDB.D. A common role can be granted only system privileges.E. Local roles can be granted to local and common users.F. A common role can be granted only to a common user.Answer: CEQ32. You are connected to a recovery catalog and target database. You execute the command: RMAN>CATALOG START WITH' /disk1/backups';Which statement is trueA. Only valid data file copies, existing in the/disk1/backups directory, are cataloged.B. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the/disk1/backups directory and its subdirectories.C. It lists and catalogs all valid data file copies, backup pieces, and archived logs that existin all Directory paths with the prefix/disk1/backups and their subdirectories.D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are catalogedAnswer: CQ33.You want to migrate your Oracle 11g database as a pluggable database(PDB) in a multitenant container database(CDB)Examine the steps required to perform the migration: 1. Use Data Pump export to perform a full transportable export on the source databasewith the export parameter VERSION=12.2. Place all tablespaces in read-only mode on the source database.3. Upgrade the source database to Oracle Database 12c.4. Copy the dump file and data files to the desired location in the target database.5. Create a new PDB in the target CDB.6. synchronize the PDB on the target CDB7. Use Data Pump import on the new PDB by using the full transportable import options. Identify the required steps in the correct order.A. 2,5,1,4,7, and 6B. 2,1,3,5,7, and 6C. 3,2,5,1,4, and7D. 1,5,4,7, and 6Answer: AQ34.On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:S>sqlldr hr/hr@pdb table=employeesWhich two statements are true about the commandA. It succeeds with default settings if the employees table exists in the hr schema.B. It fails because no SQL*Loader datafile location is specified.C. It fails if the hr user does not have the create any directory privilege.D. It fails because no SQL*Loader control file location is specified.E. It succeeds and creates the employees table in the HR schema.Answer: ACQ35.Which three types of failures are detected by the Data Recovery Advisor (DRA)A. loss of a non-critical data fileB. loss of a control fileC. physical data block corruptionD. logical data block corruptionE. loss of an archived redo log fileAnswer: ABCQ36.You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. Which two backup solutions can be usedA. RMAN recovery catalogB. RMAN Media Management LibraryC. Enterprise Manager Cloud ControlD. Enterprise Manager Database ExpressE. Oracle Secure BackupAnswer: ACQ37.Which three RMAN persistent settings can be set for a databaseA. backup retention policyB. default backup device typeC. default section size for backupsD. default destinations for backupsE. multiple backup device types for a single backupAnswer: ABDQ38.Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an AdministratorA. A base recovery catalog must exist.B. The owner of the VPC cannot own recovery catalog.C. At least one target database should be registered in the recovery catalog.D. The REGISTER DATABASE privilege should be granted to the virtual catalog owner.E. The DBA role must be granted to the virtual catalog owner.Answer: ABDQ39.Examine the following set of RMAN commands:RMAN> CONFIGURE CHANNEL dcl DEVICE TYPE DISK FORMAT'/u02/backup/%U';RMAN> RUN{ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;EXECUTE SCRIPT arc_backup;}Which statement is true about the RMAN RUN block executionA. The script is executed and both DC1 and CH1 channels are used for script execution.B. The execution of the script fails because multiple channels cannot exist simultaneously.C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.D. The new channel, CH1, is ignored because a channel has been configured already. Answer: CQ40.Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command: SQL> STARTUPWhich two statements are true about the successful execution of the command (Choose two.)A. All redo log files are opened.B. The root, the seed, and all the PDBs are opened in read-write mode.C. All the PDBs are opened in read-write mode.D. All the PDBs are in closed state.E. Only the root database is opened in read-write mode.Answer: AEQ41.Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN. Identify the minimum requirement for accomplishing the task.A. An RMAN channel must be configured to device-type disk.B. The database must be configured in ARCHIVELOG mode.C. Redo log groups must have at least two members each.D. All tablespaces in the database must be locally managed.Answer: BQ42.Examine the command:SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;In which two scenarios is this command requiredA. All the control files are missing.B. All the datafiles are missing.C. The current online redo log is missing.D. A data file belonging to a noncritical tablespace is missing.E. The control file backup is older than the database backup.Answer: ACQ43.You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.Examine the steps required to recover the database:1. Restore an autobackup of the server parameter file.2. Restore the control file.3. Start up the database instance in NOMOUNT state.4. Mount the database.5. Restore the data files.6. Open the database with the RESETLOGS option.7.Recover the data files.8. Set DBID for the database.Identify the required steps in the correct order.A. 1, 8, 3, 2, 4, 5, 7, 6B. 8, 1, 3, 2, 4, 5, 7, 6C. 1, 3, 2, 4, 8, 5, 6, 7D. 8, 3, 2, 4, 5, 7, 6E. 8, 1, 3, 2, 4, 5, 6Answer: BQ44.Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)A. The PDB is closed and requires media recovery at the PDB level.B. The PDB is closed and the temp file is re-created automatically when the PDB is opened.C. The PDB does not close and starts by using the default temporary tablespace defined for the CDB.D. The PDB does not close and the temp file is re-created automatically whenever the container database(PDB)is opened.Answer: DQ45.Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1and PDB2_2.RMAN is connected to the target database PDB2_1.Examine the command executed to back up PDB2_1:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of this commandA. It fails because archive log files cannot be backed up using a connection to a PDB.B. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.C. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.D. It fails because the PLUGGABLE clause is missing.Answer: BQ46.Examine the RMAN commands executed in your database:RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;RMAN> CONFIGURE DEVICE TYPE DISK ;RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;You issue the command: RMAN> BACKUP DATABASE;Which two statements are true about the command (Choose two.)A. It performs a log switch.B. It creates compressed backup sets by using binary compression by default.C. It backs up only the used blocks in data files.D. It backs up data files, the control file, and the server parameter file.E. It creates a backup of only the control file whenever the database undergoes a structural change.Answer: CDQ47.In which situation can you use Flashback DatabaseA. when undoing a shrink data file operationB. when retrieving a dropped tablespaceC. when returning to a point in time before the restoration or re-creation of a control fileD. when returning to a point in time before the most recent OPEN RESETLOGS operation Answer: DQ48.Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database(CDB) plan using Oracle Database Resource Manager (Choose two.)A. maximum undo per consumer groupB. maximum idle time for a session in a PDBC. parallel server limitD. CPUE. maximum number of sessions for a PDBAnswer: CDQ49.A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:RMAN> BACKUPAS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;Which statement is true about the execution of the commandA. The backup succeeds only if all the tablespaces are locally managed.B. The backup succeeds only if the RMAN default device for backup is set to disk.C. The backup fails because you cannot specify section size for a compressed backup.D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.Answer: DQ50.Which two statements are true about scheduling operations in a pluggable database (PDB)A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.B. A job defined in a PDB runs only if that PDB is open.C. Scheduler attribute setting is performed only at the CDB level.D. Scheduler objects created by users can be exported or imported using Data Pump.E. Scheduler jobs for a PDB can be created only by common users.Answer: BDQ51.You are administering a multitenant container database(CDB)CDB1 that has multiple pluggable databases(PDBs).。

TRANSACTION/SAVEPOINTWhich statement is true regarding transactions? (Choose all that apply.)A.A transaction can consist only of a set of DML and DDL statements.B.A part or an entire transaction can be undone by using ROLLBACK command.C.A transaction consists of a set of DML or DCL statements.D.A part or an entire transaction can be made permanent with a COMMIT.E.A transaction can consist of only a set of queries or DML or DDL statements. Answer: BCWhen does a transaction complete? (Choose all that apply.)A.when a DELETE statement is executedB.when a ROLLBACK command is executedC.when a PL/SQL anonymous block is executedD.when a data definition language (DDL) statement is executedE.when a TRUNCATE statement is executed after the pending transactionAnswer: BDEWhich statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose allthat apply.)A.It locks only the columns specified in the SELECT list.B.It locks the rows that satisfy the condition in the SELECT statement.C.It can be used only in SELECT statements that are based on a single table.D.It can be used in SELECT statements that are based on a single or multiple tables.E.After it is enforced by a SELECT statement, no other query can access the same rows until a COMMITor ROLLBACK is issued.Answer: BDView the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.Evaluate the following SQL command:Which two statements are true regarding the outcome of the above query? (Choose two.)A.It locks all the rows that satisfy the condition in the statement.B.It locks only the columns that satisfy the condition in both the tables.C.The locks are released only when a COMMIT or ROLLBACK is issued.D.The locks are released after a DML statement is executed on the locked rows. Answer: ACWhich two statements are true regarding savepoints? (Choose two.)A.Savepoints are effective only for COMMIT.B.Savepoints may be used to ROLLBACK.C.Savepoints can be used for only DML statements.D.Savepoints are effective for both COMMIT and ROLLBACK.E.Savepoints can be used for both DML and DDL statements.Answer: BCWhich statement is true regarding transactions? (Choose all that apply.)A.A transaction can consist only of a set of DML and DDL statements.B.A part or an entire transaction can be undone by using ROLLBACK command.C.A transaction consists of a set of DML or DCL statements.D.A part or an entire transaction can be made permanent with a COMMIT.E.A transaction can consist of only a set of queries or DML or DDL statements. Answer: BCWhich three statements/commands would cause a transaction to end? (Choose three.)MITB.SELECTC.CREATED.ROLLBACKE.SAVEPOINTAnswer: ACDThe SQL statements executed in a user session are as follows:Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT acommand in the session? (Choose two.)A.The rollback generates an error.B.No SQL statements are rolled back.C.Only the DELETE statements are rolled back.D.Only the second DELETE statement is rolled back.E.Both the DELETE statements and the UPDATE statement are rolled back.Answer: ABDBAView the Exhibit and examine the attributes of an undo tablespace.In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error?A.The query is unable to get a read-consistent image.B.There is not enough space in Flash Recovery Area.C.There is not enough free space in the flashback archive.D.The query is unable to place data blocks in undo tablespaceAnswer: AWhich two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A.All AWR tables belong to the SYSTEM schema.B.The AWR contains systemwide tracing and logging information.C.The snapshots collected by the AWR are accessible through data dictionary views.D.The snapshots collected by the AWR are used by self-tuning components in the database. Answer: CDYour test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of backups that can be performed on the database?A.You can perform online whole database backups.B.You can perform offline whole database backups.C.You cannot perform schema-level export/import operations.D.You can perform the backup of only the SYSTEM tablespace when the database is open. Answer: B优先级View the Exhibit; examine the structure of the PROMOTIONS tableEach promotion has a duration of at least seven days.Your manager has asked you to generate a report, which provides the weekly cost for each promotion done tol date.Which query would achieve the required result?A.SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7FROM promotions;B.SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7FROM promotions;C.SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7)FROM promotions;D.SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7)Answer: DView the Exhibit and examine the structure of the PRODUCTS table.All products have a list price.You issue the following command to display the total price of each product after a discount of 25% and a tax of 15% are applied on it. Freight charges of $100 have to be applied to all the products.SQL>SELECT prod_name, prod_list_price -(prod_list_price*(25/100))+(prod_list_price -(prod_list_price*(25/100))*(15/100))+100AS ―TOTAL PRICE‖ FROM products;What would be the outcome if all the parentheses are removed from the above statement?A.It produces a syntax error.B.The result remains unchanged.C.The total price value would be lower than the correct value.D.The total price value would be higher than the correct value.Answer: B||View the Exhibit and examine the structure of the PRODUCTS table.You need to generate a report in the following format:CATEGORIES———————————————5MP Digital Photo Camera‘s category is PhotoY Box‘s category is ElectronicsEnvoy Ambassador‘s category is HardwareWhich two queries would give the required output? (Choose two.)A.SELECT prod_name || q”‟s category is … || prod_category CATEGORIESFROM products;B.SELECT prod_na me || q‟['s ]…category is … || prod_category CATEGORIESFROM products;C.SELECT prod_name || q‟\‟s\‟ || … category is … || prod_category CATEGORIESFROM products;D.SELECT prod_name || q‟<‟s >‟ || …category is … || prod_category CATEGORIESFROM products;Answer: CDUsing the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.Which query would give the required result?A.SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50AS “50% Credit Limit” FROM customers;B.SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50AS “50% Credit Limit” FROM customers;C.SELECT DISTINCT cust_income_level || … … || cust_cred it_limit * 0.50AS “50% Credit Limit” FROM customers;D.SELECT cust_income_level ||‟ …|| cust_credit_limit * 0.50 AS “50% Credit Limit”Answer: CEvaluate the following query:SQL> SELECT promo_name || q‘{‘s start date was }‘ || promo_begin_dateAS ―Promotion Launches‖ FROM promotions;What would be the outcome of the above query?A.It produces an error because flower braces have been used.B.It produces an error because the data types are not matching.C.It executes successfully and introduces an ‟s at th e end of each promo_name in the output.D.It executes successfully and displays the literal ” {‟s start date was } ” for each row in the output.Answer: CDATA TYPEExamine the structure proposed for the TRANSACTIONS table:Which statements are true regarding the creation and storage of data in the above table structure?(Choose all that apply.)A.The CUST_STATUS column would give an error.B.The TRANS_VALIDITY column would give an error.C.The CUST_STATUS column would store exactly one character.D.The CUST_CREDIT_LIMIT column would not be able to store decimal values.E.The TRANS_VALIDITY column would have a maximum size of one character.F.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds,and fractions of seconds.Answer: BCExamine the structure proposed for the TRANSACTIONS table:Which two statements are true regarding the storage of data in the above table structure? (Choose two.)A.The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.B.The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.C.The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, andseconds.D.The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000characters.Answer: BCYou need to create a table for a banking application. One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period.2) The data in the column should be stored in a format such that it can be easily added and subtracted with DATE data type without using conversion functions.3) The maximum period of the credit provision in the application is 30 days.4) The interest has to be calculated for the number of days an individual has taken a credit for.Which data type would you use for such a column in the table?A.DA TEB.NUMBERC.TIMESTAMPD.INTERV AL DAY TO SECONDE.INTERV AL YEAR TO MONTHAnswer: DEvaluate the following query:SELECT INTERV AL ‗300′ MONTH,INTERV AL ‗54-2′ YEAR TO MONTH,INTERV AL ‗11:12:10.1234567′ HOUR TO SECONDFROM dual;What is the correct output of the above query?A.+25-00 , +54-02, +00 11:12:10.123457B.+00-300, +54-02, +00 11:12:10.123457C.+25-00 , +00-650, +00 11:12:10.123457D.+00-300 , +00-650, +00 11:12:10.123457Answer: AWhich three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A.Only one LONG column can be used per table.B.A TIMESTAMP data type column stores only time values with fractional seconds.C.The BLOB data type column is used to store binary data in an operating system file.D.The minimum column width that can be specified for a V ARCHAR2 data type column is one.E.The value for a CHAR data type column is blank-padded to the maximum defined column width.Answer: ADECONSTRAINTWhich two statements are true regarding constraints? (Choose two.)A.A table can have only one primary key and one foreign key.B.A table can have only one primary key but multiple foreign keys.C.Only the primary key can be defined at the column and table levels.D.The foreign key and parent table primary key must have the same name.E.Both primary key and foreign key constraints can be defined at both column and table levels.Answer: BEWhich two statements are true regarding constraints? (Choose two.)A.A foreign key cannot contain NULL values.B.A column with the UNIQUE constraint can contain NULL values.C.A constraint is enforced only for the INSERT operation on a table.D.A constraint can be disabled even if the constraint column contains data.E.All constraints can be defined at the column level as well as the table level.Answer: BDWhich two statements are true regarding constraints? (Choose two.)A.A foreign key cannot contain NULL values.B.The column with a UNIQUE constraint can store NULLS.C.A constraint is enforced only for an INSERT operation on a table.D.You can have more than one column in a table as part of a primary key.Answer: BDCREATE TABLEExamine the following SQL commands:Which statement is true regarding the execution of the above SQL commands?A.Both commands execute successfully.B.The first CREATE TABLE command generates an error because the NULL constraint is not valid.C.The second CREATE TABLE command generates an error because the CHECK constraint is not valid.D.The first CREATE TABLE command generates an error because CHECK and PRIMARY KEYconstraints cannot be used for the same column.E.The first CREATE TABLE command generates an error because the column PROD_ID cannot be usedin the PRIMARY KEY and FOREIGN KEY constraints.Answer: BWhich two statements are true regarding tables? (Choose two.)A.A table name can be of any length.B.A table can have any number of columns.C.A column that has a DEFAULT value cannot store null values.D.A table and a view can have the same name in the same schema.E.A table and a synonym can have the same name in the same schema.F.The same table name can be used in different schemas in the same database. Answer: EFEvaluate the following CREATE TABLE commands:CREATE TABLE orders(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE,cust_id NUMBER(4));CREATE TABLE ord_items(ord_no NUMBER(2),item_no NUMBER(3),qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200),expiry_date date CHECK (expiry_date > SYSDATE),CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));The above command fails when executed. What could be the reason?A.SYSDATE cannot be used with the CHECK constraint.B.The BETWEEN clause cannot be used for the CHECK constraint.C.The CHECK constraint cannot be placed on columns having the DA TE data type.D.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is alsothe FOREIGN KEY.Answer: AExamine the description of the EMP_DETAILS table given below:NAME NULL TYPE—————–—————–—————————EMP_ID NOT NULL NUMBEREMP_NAME NOT NULL V ARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two.)A.An EMP_IMAGE column can be included in the GROUP BY clause.B.An EMP_IMAGE column cannot be included in the ORDER BY clause.C.You cannot add a new column to the table with LONG as the data type.D.You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column. Answer: BCYou need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employee2. Employee Name (character data type) that stores the employee name3. Hire date, which stores the date of joining the organization for each employee4. Status (character data type), that contains the value ‗ACTIVE‘ if no data is entered5. Resume (character large object [CLOB] data type), which contains the resume submitted by the employeeWhich is the correct syntax to create this table?A.CREATE TABLE EMP_1(emp_id NUMBER(4),emp_name VARCHAR2(25),start_date DATE,e_status V ARCHAR2(10) DEFAULT …ACTIVE‟,resume CLOB(200));B.CREATE TABLE 1_EMP(emp_id NUMBER(4),emp_name VARCHAR2(25),start_date DATE,emp_status VARCHAR2(10) DEFAULT …ACTIVE‟,resume CLOB);C.CREATE TABLE EMP_1(emp_id NUMBER(4),emp_name VARCHAR2(25),start_date DATE,emp_status VARCHAR2(10) DEFAULT “ACTIVE”,resume CLOB);D.CREATE TABLE EMP_1Answer: DView the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tablesThe PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table. Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.Evaluate the following CREATE TABLE command:CREATE TABLE new_sales(prod_id, cust_id, order_date DEFAULT SYSDATE)ASSELECT prod_id, cust_id, time_idFROM sales;Which statement is true regarding the above command?A.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.B.The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.C.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.D.The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.Answer: BWhich is the valid CREATE TABLE statement?A.CREATE TABLE emp9$# (emp_no NUMBER(4));B.CREATE TABLE 9emp$# (emp_no NUMBER(4));C.CREATE TABLE emp*123 (emp_no NUMBER(4));D.CREATE TABLE emp9$# (emp_no NUMBER(4), date DATE);Answer: AEvaluate the following SQL commands:SQL>CREATE SEQUENCE ord_seqINCREMENT BY 10START WITH 120MAXV ALUE 9999NOCYCLE;SQL>CREATE TABLE ord_items(ord_no NUMBER(4)DEFAULT ord_seq.NEXTV AL NOT NULL,item_no NUMBER(3),qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200),expiry_date date CHECK (expiry_date > SYSDATE),CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));The command to create a table fails. Identify the reason for the SQL statement failure?(Choose all that apply.)A.You cannot use SYSDA TE in the condition of a CHECK constraint.B.You cannot use the BETWEEN clause in the condition of a CHECK constraint.C.You cannot use the NEXTV AL sequence value as a DEFAULT value for a column.D.You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the FOREIGN KEY.Answer: ACWhich CREATE TABLE statement is valid?A.CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMARY KEY,ord_date DATE NOT NULL);B.CREATE TABLE ord_details(ord_no NUMBER(2) UNIQUE, NOT NULL,item_no NUMBER(3),ord_date DA TE DEFAULT SYSDA TE NOT NULL);C.CREATE TABLE ord_details(ord_no NUMBER(2) ,item_no NUMBER(3),ord_date DATE DEFAULT NOT NULL,CONSTRAINT ord_uq UNIQUE (ord_no),CONSTRAINT ord_pk PRIMARY KEY (ord_no));D.CREATE TABLE ord_details(ord_no NUMBER(2),item_no NUMBER(3),ord_date DATE DEFAULT SYSDATE NOT NULL,CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no)); Answer: DYou want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:1) The order ID will be unique and cannot have null values.2) The order date cannot have null values and the default should be the current date.3) The order amount should not be less than 50.4) The order status will have values either shipped or not shipped.5) The order payment mode should be cheque, credit card, or cash on delivery (COD). Which is the valid DDL statement for creating the ORD_DETAIL table?A.CREATE TABLE ord_details(ord_id NUMBER(2) CONSTRAINT ord_id_nn NOT NULL,ord_date DATE DEFAULT SYSDATE NOT NULL,ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_minCHECK (ord_amount > 50),ord_status V ARCHAR2(15) CONSTRAINT ord_status_chkCHECK (ord_status IN (‟Shipped‟, …Not Shipped‟)),ord_pay_mode V ARCHAR2(15) CONSTRAINT ord_pay_chkCHECK (ord_pay_mode IN (‟Cheque‟, …Credit Card‟,…Cash On Delivery‟)));B.CREATE TABLE ord_details(ord_id NUMBER(2) CONSTRAINT ord_id_uk UNIQUE NOT NULL,ord_date DATE DEFAULT SYSDATE NOT NULL,ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_minCHECK (ord_amount > 50),ord_status V ARCHAR2(15) CONSTRAINT ord_status_chkCHECK (ord_status IN (‟Shipped‟, …Not Shipped‟)),ord_pay_mode V ARCHAR2(15) CONSTRAINT ord_pay_chkCHECK (ord_pay_mode IN (‟Cheque‟, …Credit Card‟,…Cash On Delivery‟)));C.CREATE TABLE ord_details(ord_id NUMBER(2) CONSTRAINT ord_id_pk PRIMARY KEY,ord_date DATE DEFAULT SYSDATE NOT NULL,ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_minCHECK (ord_amount >= 50),ord_status V ARCHAR2(15) CONSTRAINT ord_status_chkCHECK (ord_status IN (‟Shipped‟, …Not Shipped‟)),ord_pay_mode V ARCHAR2(15) CONSTRAINT ord_pay_chkCHECK (ord_pay_mode IN (‟Cheque‟, …Credit Card‟,…Cash On Delivery‟)));D.CREATE TABLE ord_detailsAnswer: CDROPYou issued the following command to drop the PRODUCTS table:SQL> DROP TABLE products;What is the implication of this command? (Choose all that apply.)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 remain.Answer: ABDVIEWWhich three statements are true regarding views? (Choose three.)A.Views can be created only from tables.B.Views can be created from tables or other views.C.Only simple views can use indexes existing on the underlying tables.D.Both simple and complex views can use indexes existing on the underlying tables.plex views can be created only on multiple tables that exist in the same schema.plex views can be created on multiple tables that exist in the same or different schemas.Answer: BDFView the Exhibit to examine the description for the SALES table.Which views can have all DML operations performed on it? (Choose all that apply.)A.CREATE VIEW v3B.CREATE VIEW v1C.CREATE VIEW v2D.CREATE VIEW v4Answer: ABWhich two statements are true regarding views? (Choose two.)A.A simple view in which column aliases have been used cannot be updated.B.Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.C.Rows added through a view are deleted from the table automatically when the view is dropped.D.The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.E.The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.Answer: BDEvaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY,last_name V ARCHAR2(25) NOT NULL,department_id NUMBER(2)NOT NULL,job_id V ARCHAR2(8),salary NUMBER(10,2));You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization:CREATE OR REPLACE VIEW sales_staff_vu ASSELECT employee_id, last_name,job_idFROM employeesWHERE job_id LIKE ‗SA_%‘WITH CHECK OPTION;Which two statements are true regarding the above view? (Choose two.)A.It allows you to insert rows into the EMPLOYEES table.B.It allows you to delete details of the existing sales staff from the EMPLOYEES table.C.It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table.D.It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements.Answer: BDView the Exhibit to examine the description for the SALES and PRODUCTS tables.You want to create a SALE_PROD view by executing the following SQL statement:CREATE VIEW sale_prodAS SELECT p.prod_id, cust_id, SUM(quantity_sold) ―Quantity‖, SUM(prod_list_price) ―Price‖FROM products p, sales sWHERE p.prod_id=s.prod_idGROUP BY p.prod_id, cust_id;Which statement is true regarding the execution of the above statement?A.The view will be created and you can perform DML operations on the view.B.The view will be created but no DML operations will be allowed on the view.C.The view will not be created because the join statements are not allowed for creating a view.D.The view will not be created because the GROUP BY clause is not allowed for creating a view. Answer: BWhich two statements are true regarding views? (Choose two.)A.A subquery that defines a view cannot include the GROUP BY clause.B.A view that is created with the subquery having the DISTINCT keyword can be updated.C.A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated.D.A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table.Answer: CDView the Exhibit to examine the description for the SALES tableWhich views can have all DML operations performed on it? (Choose all that apply.)A.CREATE VIEW v3AS SELECT * FROM SALESWHERE cust_id = 2034WITH CHECK OPTION;B.CREATE VIEW v1AS SELECT * FROM SALESWHERE time_id <= SYSDA TE – 2*365WITH CHECK OPTION;C.CREATE VIEW v2AS SELECT prod_id, cust_id, time_id FROM SALESWHERE time_id <= SYSDA TE – 2*365WITH CHECK OPTION;D.CREATE VIEW v4AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALESWHERE time_id <= SYSDA TE – 2*365GROUP BY prod_id, cust_idWITH CHECK OPTION;Answer: ABSEQUENCEEvaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXV ALUE 200CYCLENOCACHE;The SEQ1 sequence has generated numbers up to the maximum limit of 200. You issue the following SQL statement:SELECT seq1.nextval FROM dual;What is displayed by the SELECT statement?A.1B.10C.100D.an errorAnswer: AView the Exhibit and examine the structure of the ORD table.Evaluate the following SQL statements that are executed in a user session in the specified order:CREATE SEQUENCE ord_seq;SELECT ord_seq.nextvalFROM dual;INSERT INTO ordV ALUES (ord_seq.CURRV AL, ‗25-jan-2007′,101);UPDATE ordSET ord_no= ord_seq.NEXTV ALWHERE cust_id =101;What would be the outcome of the above statements?A.All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.B.The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.C.The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.D.All the statements would execute successfully and the ORD_NO column would have the value20 for the CUST_ID 101 because the default CACHE value is 20.Answer: AWhich two statements are true about sequences created in a single instance database? (Choose two.)A.The numbers generated by a sequence can be used only for one table.B.DELETE would remove a sequence from the database.C.CURRV AL is used to refer to the last sequence number that has been generated.D.When the MAXV ALUE limit for a sequence is reached, you can increase the MAXV ALUE limit by using the ALTER SEQUENCE statement.E.When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted.Answer: CDINDEXWhich two statements are true regarding indexes? (Choose two.)A.They can be created on tables and clusters.B.They can be created on tables and simple views.C.You can create only one index by using the same columns.D.You can create more than one index by using the same columns if you specify distinctly differentcombinations of the columns.Answer: ADWhile observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?A.V alidate the index structure using the ANAL YZE…INDEX command.B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.C.Change the block space utilization parameters using the ALTER INDEX command.D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.Answer: BYou created an ORDERS table with the following description:Name Null Type—————–————- ————–ORD_ID NOT NULL NUMBER(2)CUST_ID NOT NULL NUMBER(3)ORD_DATE NOT NULL DATEORD_AMOUNT NOT NULL NUMBER (10,2)You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column. Which statement is true in this scenario?A.You cannot have two constraints on one column.B.You cannot add a primary key constraint if data exists in the column.C.The primary key constraint can be created only at the time of table creation.。

填空问题1某网络中共包含S390设备10端，S360设备10端，S320设备100端，那么我们按照现有网优体系进行网络评估和优化时，认为该网络的E300网管服务器共管理了『____』端等效网元。

There are 10 sets of S390 equipment, 10 sets of S360 equipment and 100 sets of S320 equipment in a network center, we consider that the E300 NMS server of this network totally manages 『____』equivalent NEs if we perform network evaluation and optimization according to current network optimization system.2网络资源评估时，我们发现一S390站点配置的时分交叉板为TCS32Z，网管上读出其时分实际占用为模块一32*16，模块二8*16，那么我们认为该站点的时分资源利用率为『____』。

In the network resource evaluation, we find out that the lower-order cross-connect board configured in the S390 equipment on this station is TCS32Z board, however, the actual occupied lower-order which is read on the NMS is: the capacity of module 1 is 32x16, the capacity of module 2 is 8x16. Therefore, the lower-order resource utilization ratio on this station is 『____』。

Exam : 300-410Title : Implementing Cisco EnterpriseAdvanced Routing andServicesVendor : CiscoVersion : DEMONO.1 An engineer configured the wrong default gateway for the Cisco DNA Center enterprise interface during the install.Which command must the engineer run to correct the configuration?A.sudo maglev-config updateB.sudo maglev install config updateC.sudo maglev reinstallD.sudo update config installAnswer: ANO.2 Which command displays the IP routing table information that is associated with VRF-Lite?A.show ip protocols vrfB.show run vrfC.show ip route vrfD.show ip vrfAnswer: CNO.3 Which statement about IPv6 RA Guard is true?A.It does not offer protection in environments where IPv6 traffic is tunneled.B.It is not supported in hardware when TCAM is programmed.C.It cannot be configured on a switch port interface in the ingress direction.D.Packets that are dropped by IPv6 RA Guard cannot be spanned.Answer: ANO.4 While troubleshooting connectivity issues to a router, these details are noticed:*Standard pings to all router interfaces, including loopbacks, are successful.*Data traffic is unaffected.*SNMP connectivity is intermittent.*SSH is either slow or disconnects frequently.Which command must be configured first to troubleshoot this issue?A.show interface | inc dropB.show ip routeC.show policy-map control-planeD.show policy-mapAnswer: CNO.5 Refer to the exhibit.Why is the remote NetFlow server failing to receive the NetFlow data?A.The flow exporter is configured but is not used.B.The destination of the flow exporter is not reachable.C.The flow monitor is applied to the wrong interface.D.The flow monitor is applied in the wrong direction.Answer: BNO.6 A network engineer is investigating a flapping (up/down) interface issue on a core switch thatis synchronized to an NTP server. Log output currently does not show the time of the flap. Which command allows the logging on the switch to show the time of the flap according to the clock on the device?A.service timestamps log uptimeB.clock calendar-validC.clock summer-time mst recurring 2 Sunday mar 2:00 1 Sunday nov 2:00D.service timestamps log datetime localtime show-timezoneAnswer: D。