1Z0-514 | The Up to date Guide To 1Z0-514 braindumps


Q1. Your database instance in running.db01 is a net service name. You issue a connection request

using the following command:

SQL> CONNECT scott/tiger@db01

Which component receives the request and establishes the appropriate connection?

A. listener

B. user process

C. service name

D. server process

Answer: A

Q2. Which two statements are true regarding views? (Choose two)

A. Views contain no data

B. Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table

C. Views can be created only on tables in the same schema.

D. Views on one or more tables can be used to update the columns specified in the views.

Answer: A,B

Q3. Your test database is currently running in the ARCHIVELOG mode and you plan to switch to the NOARCHIVELOG mode temporarily.

Which type of backup should you perform before switching the mode to ensure database recovery

is possible?

A. whole backup

B. level o incremental backup of data files

C. full backup of data files using only backup sets

D. full backup of data files using only image copies

Answer: A

Q4. Which three statements about the Automatic Database Diagnostic Monitor (ADDM) are true? (Choose three)

A. requires the database to be open

B. analyses the performance of specified objects

C. implements all recommendations automatically

D. recommends solutions and quantifies expected benefits

E. retains snapshots in the SYSAUX tablespace until the database is restarted

F. analyzes the snapshots stored in the Automatic Workload Repository (AWR)

Answer: D,E,F

Q5. Which three options correctly map SQL commands with their categories? (Choose thee)

A. SELECT: transaction control

B. DROP: data control language

C. ROLLBACK: transition control

D. REVOKE:Data control language

E. ALTER: Data manipulation language

F. MERGE: Data manipulation language

Answer: C,D,F

Q6. You create an index, EMP_IDX, on the ENAME column in the EMP table.

Identify the three operations in which FMP_IDX would be used? (Choose three.)

A. addition of new data to the EMP table

B. deletion of existing row from the EMP table

C. modification of data in any column in the EMP table

D. all queries that display data from the ENAME column

E. queries that search for data based on a condition on the ENAME column

Answer: A,B,E

Q7. You have some operatingsystem scripts on one server that need to run in response to certain changes in data in your Oracle Database.The mostefficient way to implement this with Oracle Database 11g would be:

A. Write a PL/SQL routine that connects to the remote server and calls the script.

B. Create a script on the database server to perform the remote action and thatscript from adatabase trigger.

C. Modify the script on the remote server to periodically chock for these data change in your Oracle database.

D. Install an Oracle Scheduler Agent on the remote server and create job to be called from Oracle scheduler in response to a database server event.

Answer: D

Q8. Which two statements are true regarding the usage of integrity constraints? (Choose two.)

A. l EM h column can have only one constraint.

B. Primary key constrain) can consist of multiple columns from the same table.

C. Foreign key column can reference e a primary key column in the same of or different tables.

D. More than one row in a table cannot contain null value In a column with unique constraint.

E. A chock constraint can enforce conditions that refer to the values in other columns in the table.

Answer: B,C

Q9. Which two statements are true regarding Oracle Net? (Choose two.)

A. It must reside only on the client for traditional client/server applications.

B. It must reside only on the database server for web-based applications.

C. It must reside on both the web server and database server for web-based applications.

D. It must reside on both the client and database server for traditional client/server applications.

Answer: C,D

Q10. Whit h two of the following tasks must you perform in order to benefit from the SQL. Query Result Cache?

A. Use a SQL_QUERY_RESULT_CACHEhint in your SQL statement.

B. Set RESULT_CACHE_MODE to FORCE

C. Make sure the RESULT_CACHE_MAX_SIZE is greater than 0.

D. Have SQL statements that are executed repeatedly.

E. Use temporary tables.

F. Not use bind variables in your query.

Answer: A,C