Tag Archives: commands

Evaluate these commands which execute successfully: (Exhibit) Which two statements are true about the

Evaluate these commands which execute successfully:Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.) A. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ C. Sequence ORD_SEQ is guaranteed not… Read More »

Evaluate these commands which execute successfully: (Exhibit) Which two statements are true about the

Evaluate these commands which execute successfully:Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?(Choose two.) A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row… Read More »

Evaluate these commands which execute successfully: (Exhibit) Which two statements are true about the

Evaluate these commands which execute successfully:Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.) A. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ C. Sequence ORD_SEQ is guaranteed not… Read More »

Examine these commands: (Exhibit) Which two statements are true about the sqlldr execution? (Choose two.)

Examine these commands:Which two statements are true about the sqlldr execution? (Choose two.) A. It uses the database buffer cache to load data B. It overwrites data in EMP with data in EMP.DAT C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations D. It appends data from EMP.DAT to… Read More »