Free Oracle 1Z0-514 Exam Dumps Questions & Answers

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.primary key constraint on the STUDENT_ID columns
• C.unique key constraint on the STUDENT_ID column
• D.check constraint on the DATE_OF_BIRTH column
• E.not null constraint on the DATE_OF_BIRTH column
• F.foreign key constraint on the COURSE_ID column

Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)

• A.SQLTuning Advisor considers the impact of the indexes only queries.
• B.SQLTuning Advisor considers the impact of new indexes on both queries and DML operations.
• C.SQLTuning Advisor considers the impact of the newindexeson both queries and DML operations.
• D.SQLTuning Advisor considers the impact of the indexes on only data manipulation language(DML) operations.

Evaluate the following command: $sqlplus / noblog
In which scenario would the above command execute successfully?

• A.Either from a client or server only if the database instance is up but the command does not connect the session to the instance.
• B.Either from a client or server only if the database instance is up and the command connectsthe session to the instance.
• C.Only from the server if the database instance is not up.
• D.Eitherfrom the server or client even if the database instance is not up.

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

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

Which statement is true regarding the OracleUniversal Installer (OUI)?

• A.OUI supports the installation of several active Oracle homes on the same host.
• B.OUIenables configuring of listener as part of the installation process but not the creation of Net
• C.OUI can be usedto uninstall only the complete Oracle software and not specific products.
• D.Operating system environment variables need to be set before running the OUI.