The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLEA、Only the EMPLOYEES table.B、Only the EMPLOYEES table and its corresponding primary key index.C、The EMPLOYEES table and partition P1.D、The EMPLOYEES table， IPK_EMP index， and the SALES table.
The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLE
- A、Only the EMPLOYEES table.
- B、Only the EMPLOYEES table and its corresponding primary key index.
- C、The EMPLOYEES table and partition P1.
- D、The EMPLOYEES table， IPK_EMP index， and the SALES table.
相关考题：
Which statement is correct about the forwarding table?() A. The forwarding table is stored only on the PFEB. The forwarding table contains all known routesC. The forwarding table is stored on both the RE and PFED. The forwarding table is stored only on the RE
Which type of EIGRP route entry describes a feasible successor?() A. a primary route,stored in the routing tableB. a backup route,stored in the routing tableC. a backup route,stored in the topology tableD. a primary route,stored in the topology table
Which type of EIGRP route entry describes a feasible successor?（）A、a primary route,stored in the routing tableB、a backup route,stored in the routing tableC、a backup route,stored in the topology tableD、a primary route,stored in the topology table
Which statement is true about the forwarding table?（）A、The forwarding table is stored in the control plane only.B、The forwarding table is stored in the control plane and in the forwarding plane.C、The forwarding table contains both active and inactive routes.D、The forwarding table can contain only a single next hop per destination.
Which statement is correct about the forwarding table?（）A、The forwarding table is stored only on the PFEB、The forwarding table contains all known routesC、The forwarding table is stored on both the RE and PFED、The forwarding table is stored only on the RE
Which two statements are true of the forwarding table?（）A、The forwarding table is stored in the control plane only.B、The forwarding table contains both active and inactive routes.C、The forwarding table is stored in the control plane and the forwarding plane.D、The forwarding table uses a longest match lookup for forwarding decisions.
Which statement is true about the forwarding table?（）A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination
Which two operations can be flashed back using the Flashback technology？（）A、DROP USER SMITH；B、DROP TABLE EMPLOYEES；C、DROP TABLESPACE USERS；D、ALTER TABLE SALES_REP DROP PARTITION P1；E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp； Table dropped. What happens in this scenario？ （）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）A、 the RMAN LIST commandB、 the DBNEWID utilityC、 the RMAN REPORT commandD、 the RMAN BLOCKRECOVER commandE、 the RMAN CROSSCHECK commandF、 the ANALYZE command
Examine these two statements:Which three are true about the MRKT tablespace?（）A、The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.B、The MRKT tablespace may be dropped if it has no contents.C、Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.D、No more data files can be added to the tablespace.E、The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？ （）A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table （IOT）D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQLDROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）A、 PCTFREEB、 MAXTRANSC、 PCTINCREASED、 INITIALE、 NOLOGGINGF、 PARALLEL
单选题Which statement is true about the forwarding table?（）AThe forwarding table is stored in the control plane only.BThe forwarding table is stored in the control plane and in the forwarding plane.CThe forwarding table contains both active and inactive routes.DThe forwarding table can contain only a single next hop per destination.
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）AOracle Data Pump.BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.DOnline Table Redefinition.EEdition-Based Table Redefinition.
单选题You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？ （）AThe table is partitionedBThe table name is wrong.CIt is an index-Organized table （IOT）DThe table is stored in locally managedtablespace.EThe table is stored in atablespacewhere segment space is managed manually.
多选题Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
多选题Which two operations can be flashed back using the Flashback technology？（）ADROP USER SMITH；BDROP TABLE EMPLOYEES；CDROP TABLESPACE USERS；DALTER TABLE SALES_REP DROP PARTITION P1；EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）AThe table is moved to the SYSAUX tablespace.BThe table is moved to the SYSTEM tablespace.CThe table is removed from the database permanently.DThe table is renamed and remains in the TBSFD tablespace.
单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）AThe data in the segment will be compacted but the high water mark will not be adjusted BThe EMPLOYEES table will be changed to read-only mode during the shrink operation CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overDThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
单选题The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLEAOnly the EMPLOYEES table.BOnly the EMPLOYEES table and its corresponding primary key index.CThe EMPLOYEES table and partition P1.DThe EMPLOYEES table， IPK_EMP index， and the SALES table.
单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）Athe DBNEWID utilityBthe ANALYZE commandCthe RMAN LIST commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe RMAN BLOCKRECOVER command