Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?（）1.shutdown immediate from RMAN2.Log into RMAN3.startup mount from RMAN4.backup database5.alter database open6.backup database plus

题目

Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?（）1.shutdown immediate from RMAN2.Log into RMAN3.startup mount from RMAN4.backup database5.alter database open6.backup database plus archivelog delete input

A.2，3，1，4，5

B.2，1，3，6，5

C.1，3，5，4

D.2，1，3，5，6

E.2，1，3，4，5

相似考题

1.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

2.Which statement accomplish this? ()A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

3.Evaluate the following statements:What are the two consequences of the above statements?()A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

4.Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?()A.V$BACKUPB.V$BACKUP_STATUSC.V$BACKUP_DATAFILED.V$DATAFILE_BACKUPE.V$TABLESPCE_BACKUP

参考答案和解析
参考答案：E
更多“Given the following steps, which would be the correct order to create a backup of an Oracl ”相关问题

  • 第1题：

    The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

    A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

    B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

    C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

    D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

    E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;


    参考答案：C, E

  • 第2题：

    You have table ‘apps‘,‘userdata‘ on server that uses MyISAM storage engine.You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands:Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p appsShell＞ mysql –u root –p –h server –e ‘ALTER TABLE ‘apps‘,‘userdata‘ ENGINE=InnoDB;‘Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p appsWhat effect does the – order-by-primary argument have on the mysqldump command?（）

    A.It exports tables with the most indexes first to assist with import speeds

    B.It ensures that unique indexes have no conflicts when the data is dumped

    C.It orders by primary key to assist in speeding up importing to InnoDB tables

    D.It must be specified so index data is dumped correctly when –on-create-info is used


    参考答案：C

  • 第3题：

    Whichtwodesignconcernsmustbeaddressedwhendesigningamulticastimplementation?()

    A.onlythelow-order23bitsoftheMACaddressareusedtomapIPaddresses

    B.onlythelow-order24bitsoftheMACaddressareusedtomapIPaddresses

    C.onlythehigh-order23bitsoftheMACaddressareusedtomapIPaddresses

    D.onlythelow-order23bitsoftheIPaddressareusedtomapMACaddresses

    E.the0x01004fMACaddressprefixisusedformappingIPaddressestoMACaddresses

    F.the0x01005eMACaddressprefixisusedformappingIPaddressestoMACaddresses


    参考答案：A, F

  • 第4题：

    Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0backuponSundays,totape.Whichtwostatementsaretrueaboutdifferentialincrementalbackups()

    A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.

    B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.

    C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.

    D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup，and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup


    参考答案：A, D

  • 第5题：

    An administrator wants to restore the /etc/resolv.conf file from a mksysb backup onto server1. After the mksysb is mounted in /mnt/backup/ from the local nim server.Which command should be run to restore the file?（）

    A.tar -xvf /mnt/backup/server1.mksysb ./etc/resolv.conf

    B.restore -Tvf /mnt/backup/server1.mksysb ./etc/resolv.conf

    C.listvgbackup -f /mnt/backup/server1.mksysb -r ./etc/resolv.conf

    D.restorevgfiles -xrm /mnt/backup/server1.mksysb ./etc/resolv.conf


    参考答案：C

  • 第6题：

    在本节中，测试类里创建了Person类的对象p，使用该对象调用order（)方法正确的是（）。

    A．p.order(new Car());

    B．p.order(new Truck());

    C．p.order(Car myCar);

    D．p.order(Truck myTruck);


    p.order(new Car());;p.order(new Truck());

相关内容