Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:ALTER DATABASE MOUNT;Which two actions are performed? (Choose two.) A. The online redo logs are opened B. The online data files are opened C. The alert log records the execution details D. The Oracle background processes are started E. The initialization… Read More »
In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »
Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.)SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 A. ‘DUES AMOUNT’ FROM transactions; B. 100 “DUES AMOUNT” FROM transactions;SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM C. “DUES” FROM transactions;SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 D. transactions;SELECT… Read More »
You execute this query:SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”fmMonth rrrr’)What is the result? A. It executes successfully but does not return any result B. It returns the date for the last Monday of the current month C. It generates an error D. It returns the date for the first Monday of the next month Correct Answer: D
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 »
You execute this command:During the export operation, you detach from the job by using CTRL+C and then execute this command:Export> STOP_JOB=immediateAre you sure you wish to stop the job ([yes]/no): yesWhich two statements are true about the job? (Choose two.) A. You can no longer monitor it B. You can reattach to it and monitor it C. It… Read More »
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 »
You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE ‘/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. It must be smaller than the smallest BIGFILE tablespace B. Free space is managed using freelists C. Any data files added to the tablespace must have a size… Read More »
Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.)SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 A. DUES FROM transactions;SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + B. 100 “DUES AMOUNT” FROM transactions;SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM C. transactions;SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE,… Read More »
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 »