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()
Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? ()
After the /etc/tunables/nextboot file has been edited, which command can be used to validate changes to the IO performance tuning settings?()
Which file is NOT controlled by the alog command?()
Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
Which of the following is a secure method of remote access via command line?()
The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numtoyminterval(1,’month’)) (partition p0 values less than (to_date(’01-01-2005’,’dd-mm-yyyy’)), partition p1 values less than (to_date(’01-01-2006’,’dd-mm-yyyy’))); The following data has been inserted into the INV_HISTORY table : INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command: SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR(TO_DATE(’15-feb-2006’,’dd-mon-yyyy’)), FOR(TO_DATE(’15-apr-2006’)) INTO PARTITION sys_py; What would be the outcome of this command?()
Which statement is true regarding the effect of this command on the transaction in Scott’s session()
The following command was issued on Router 2: Given the above output shown above, which statement is true?()
Which CLI command shows whether an L2TP Tunnel Switch profile is applied?()