单选题
What is a requirement for creating a remote database scheduler job?
A、 The remote database job must run as a user that is valid on target remote database
B、 A private database link must be created from the originating database to the target remote database
C、 The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later
D、 The target remote database must be on a different host from the originating scheduler database host
单选题
Examine the parameters for a databaseYour database has three undo tablespaces and the default undo tablespace is notAutoextensible. Resumable space allocation is not enabled for any sessions in the databaseInstance. What is the effect on new transactions when all undo space in the default undoTablespace is in use by active transaction?
A、Transactions write their undo in a temporary tablespace.
B、Transactions fail.
C、Transactions write their undo in the SYSTEM undo segment.
D、Transactions wait until space becomes available in UNDOTBS1.
单选题 When is the UNDO_RETENTION parameter value ignored by a transaction?
A、 when the undo tablespace is of a fixed size and retention guarantee is not enabled
B、 when the data file of the undo tablespace is autoextensible
C、 when there are multiple undo tablespaces available in a database
D、 when Flashback Database is enabled
单选题
Your database instance is started by using a sever parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter. ALTER SYSTEM SET LOG_BUFFER=32M;
What is the outcome of this command?
A、 It returns an error because SCOPE should be set to MEMORY.
B、 It returns an error because the value of this parameter cannot be changed dynamically.
C、 The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.
D、 The parameter value is changed and it comes into effect at the next instance startup.
单选题
One of your databases has archive logging enabled and RMAN backups are taken at regular
Intervals. The data file for the USERS tablespace is corrupt. Which command must you execute
Before starting the recovery of this tablespace?
A、 SWITCH DATAFILE ALL;
B、 STARTUP FORCE
C、 ALTER TABLESPACE users OFFLINE TEMPORARY;
D、 ALTER TABLESPACE users OFELINE NORMAL;
E、 ALTER TABLESPACE users OFFLINE IMMEDIATE;
单选题
In your Oracle12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?
A、 It creates a locally managed tablespace with manual segment space management enabled.
B、 It creates a dictionary-managed tablespace with manual segment space management enabled.
C、 It raises an error because extent management is not specified.
D、 It creates a locally managed tablespace with automatic segment space management enabled.
单选题
Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace?
A、 SWITCH DATAFILE ALL
B、 STARTUP FORCE
C、 STARTUP FORCE NOMOUNT
D、 ALTER TABLESPACE users OFFLINE
单选题
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEE.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE
CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction delete a primary
Key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table. Which statement is true?
A、 Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transaction on the DEPARTMENTS table is complete.
B、 The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the
DEPARTMENTS table is complete.
C、 The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the
DEPARTMENTS table is complete.
D、 The transaction acquired a table lock only on the DEPARTMENTS table until the transaction is complete.
2021-01-03
共372道
