Oracle

Suppose you decide to backup a database at 10 PM on a day. When you return next morning, you see that the backup has happened successfully. However, the data files and control files are check-pointed with different SCN. What does this scenario indicate?

Suppose you have a production database which must continue to run 24 hours a day and 7 days a week. Which of the following is used for a consistent backup?

In Oracle, while using RMAN RESTORE command to restore data files from backup sets or image copies, is it mandatory to restore also the archived log files?

In Oracle, which of the following commands is used to increase the product_type column which is declared as varchar2(10), to varchar2(15) in the SALES table?

Which of the following statements about associated columns and datatypes is not true in Oracle?

In Oracle, you have created a stored procedure DELETE_TEST_TABLE that uses dynamic SQL to remove a table in your schema. You have granted the EXECUTE privilege to user ANN on this procedure. When the user XYZ executes the DELETE_TEST_TABLE procedure, under whose privileges are the operations performed by default?

In Oracle, there is an employee table in a schema which has a public synonym EMP and you are granted all object privileges on it. The employee information which is in the public synonym EMP table is been processed by your procedure proc_emp. You have just created a new table called employee within your schema. Which of the following statements is correct?

In Oracle, what is the appropriate table used to perform arithmetic calculations using MATH functions, on values defined within the SELECT statement?

Which of the following is a valid SQL statement?

In Oracle, which of the following scripts is used in an Enterprise Manager (EM) to schedule a backup of your database?