Once defined, how long will a variable remain so in SQL*Plus?

Which of the following options will allow you to drop the user david and all objects in the schema that are associated with that user?

identify the meaning of the following SQL statement CREATE USER PETRIE IDENTIFIED EXTERNALLY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMPS QUOTA 12M ON forms

You are setting up two multiplexed online redo log file groups with three members in each group, how many disks are necessary at minimum?

What can be said of the following SQL statement? CREATE GLOBAL TEMPORARY TABLE extra_area (startdate DATE, enddate DATE, class CHAR(15)) ON COMMIT DELETE ROWS

The database administrator is taking the cbgb tablespace offline, due to erroneous datafiles in the tablespace. Which offline tablespace option should be chosen?

Which of the following role properties would be beneficial if you want to grant privileges to a group of specified users to a certain role?

A database administrator needs to create a tablespace for an Oracle database. He formulates the following statement: CREATE TABLESPACE frgr DATAFILE ‘/g01/oracle/data/sasa01.dbf’ SIZE 100M EXTENT MANAGEMENT DICTIONARY AUTOALLOCATE DEFAULT STORAGE ( INITIAL 100K NEXT 100K MINEXTENTS 5 MAXEXTENTS 25 PCTINCREASE 0); LOGGING TEMPORARY

Provide a declaration for i that turns this loop into an infinite loop: while( i != i){ }

Is this a legal Java Program? If so, what does it print? \u0070\u0075\u0062\u006c\u0069\u0063\u0020\u0020\u0020\u0020 \u0063\u006c\u0061\u0073\u0073\u0020\u0055\u0067\u006c\u0079 \u007b\u0070\u0075\u0062\u006c\u0069\u0063\u0020\u0020\u0020 \u0020\u0020\u0020\u0020\u0073\u0074\u0061\u0074\u0069\u0063 \u0076\u006f\u0069\u0064\u0020\u006d\u0061\u0069\u006e\u0028 \u0053\u0074\u0072\u0069\u006e\u0067\u005b\u005d\u0020\u0020 \u0020\u0020\u0020\u0020\u0061\u0072\u0067\u0073\u0029\u007b \u0053\u0079\u0073\u0074\u0065\u006d\u002e\u006f\u0075\u0074 \u002e\u0070\u0072\u0069\u006e\u0074\u006c\u006e\u0028\u0020 \u0022\u0048\u0065\u006c\u006c\u006f\u0020\u0077\u0022\u002b \u0022\u006f\u0072\u006c\u0064\u0022\u0029\u003b\u007d\u007d

What does it print? public class Elementary { public static void main(String[] args) { System.out.println(12345 + 5432l); } }

What happens when the following code is compiled and run. Select the one correct answer. for(int i = 2; i < 4; i++) for(int j = 2; j < 4; j++) if(i < j) assert i!=j : i;