Free Oracle 1Z0-514 Exam Dumps Questions & Answers

Which three statements are true regarding the Database Configuration Assistant (DBCA. templates? (Choose three)

• A.  A new template can be created using only an existing database.
• B.  A new template can be created using either an existing database or template.
• C.  Seed templates contain both the logical structure and physical files of an existing database.
• D.  Seed templates contain only the logical strut tuna of .in existing database.
• E.  Templates are stored as HTML files.
• F.  Templates are stored as XML files.

Which statement is true regarding accessing the Enterprise Manager Database Control?

• A.  It can be accessed only it the Net service names have been configured in the server tnsnames.ora file.
• B.  It can be accessed Irrespective of whether the database instance shut down or running.
• C.  It can beaccessed only it thedefault preset port number1158 is available.
• D.  It can be accessed through a Web browser or command line.

Which two statements are true regarding consistent backups? (Chooser two)

• A.  Consistent backup are taken before the changes in the online redo log files haw been applied to the data files.
• B.  Database can be opened immediately after the restore operation.
• C.  Database can be opened only after the restore and recovery operations.
• D.  Consistent backups can be taken only when the instance is running and the database is closed.
• E.  Consistent backups can be taken only when the instance is shut clown and the database is closed.

View the exhibit

and examine the structure of the PRODUCTS table.
The PRODUCTS table contains 20 rows.
In the data that has been entered, the PROD_ID column contains only single digit values, PROD_NAMKhas a maximum of 5 characters, and RATE has 4 digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table? (Choose two.)

• A.  Now columns can be added only if they have NOT NULL constraint.
• B.  PROD_IP can be changed from CHAR to NUMBER data type.
• C.  PROD_NAME size can be reduced from 10 to 5 characters.
• D.  PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2).
• E.  None of the existing columns can be dropped because they contain data.

The DBA of your database informs you that the Oracle instance has started.
What does this imply?

• A.  Memory areas have been allocated and background processes have been started.
• B.  Only the background and user processes are running.
• C.  Only the SGA has been allocated for the database.
• D.  Users can access the data in the database.