Category Archives: Oracle Certification

Oracle Certification Question and Answers

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this

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 »

Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase

Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.Segment creation is not deferred.You execute this command:Which three statements must be true so that the SALES user can create tables in SALES_Q1?(Choose three.) A. The sales user must have been granted the CREATE SESSION privilege B. The sales user must have… Read More »

Given: (Exhibit) What is the expected result of javac?

Given:What is the expected result of javac? A. javac fails to compile the class and prints the error message, Error: Could not find or load main class Mycar.class B. javac fails to compile the class and prints the error message, C:\workspace4\Mycar.java:1:error: package java does not exist C. javac compiles Mycar.java without errors or warnings. D. javac fails to… Read More »

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »