Free Oracle 1Z0-514 Exam Dumps Questions & Answers

Which three statements are true regarding an Oracle instance? (Choose three)

• A.One instance can be associated with multiple databases.
• B.A database instance is created based on the information in the SPFILE file.
• C.A database instance is created based on the information in the control file.
• D.One instance is associated with only one database.
• E.Multiple database instances can run on one computer.
• F.Only one database instance can run on one computer.

You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
Which three constraints must be explicitly enforced on the table? (Choose three)

• A.check constraint on the COURSE_ID column
• B.check constraint on the DATE_OF_BIRTH column
• C.foreign key constraint on the COURSE_ID column
• D.primary key constraint on the STUDENT_ID columns
• E.unique key constraint on the STUDENT_ID column
• F.not null constraint on the DATE_OF_BIRTH column

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

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

Whi.li statement is true regarding the management of tablespaces?

• A.Locally managed temporary tablespaces can be converted to permanent tablespaces.
• B.AUTOEXTEND can be enabled only for new data files.
• C.Dictionary-managed tablespaces can be converted to locally managed tablespaces.
• D.Space usage alert thresholds can be modified only if the tablespace contains no data.

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

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