1Z0-514 Exam Questions

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 di...

Your database instance is running. A user, SCOTT, starts a SQL*Plus session, and issues the following query; SQL>SELECT * FROM sales: Which process would retrieve the result from t...

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

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 Or...

View the exhibit. You are creating a database by using Database Configuration Assistant (DHCIA). You have chosen the File System option as the storage mechanism. What would be the...

View the exhibit. You plan to load the customer information that has been brought from a non Oracle database in the CUSTOMERS table in your database using the "Enterprise Manager L...

Which two statements are true regarding the use of SQL in Oracle database? (Choose two)

You issue the following command as a DBA: SQL> SHUTDOWN What would be the outcome of the above command?

Enterprise Manager beacons are a feature of which 11g management pack?

What is needed to establish monitoring of SSL-encrypted HTTP traffic?

Which could be used to identify the top pages in a Web application?

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

Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to...

The RECYCLEBIN parameter is set to onfor your database. You drop a table, PRODUCTS, from the SCOTTschema. Which two statements are true regarding the outcome of this action? (Choos...

Choose three areas for which Oracle Database 11g Release 2 and Enterprise Manager offer tools that can recommended solutions on optimal implementation.

Which two statements are true regarding undo data records? (Choose two.)

You want to change your database by adding some new columns to a particular tale. These new columns represent new data that is not accessed by the current application. Which approa...

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

Which three statements are true regarding database recovery operations? (Choose three.)

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

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: - Each...

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

Which two statements ore true regarding the- Database Configuration Assistant (DIKIA)? (Choose two.)

You added the Following code in the tnsnames.ora file in the client PC: Sales= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=salesdatA. (PORT=1521)) (SRVICE_NAME = sales.acme)) Whic...

Your application has a need to allow managers to see all sales records owned by sales reps in their entire territory, and for the sales reps to see only the sales records they own....

There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You i...

Which two statements are true regarding the database control file? (Choose two.)

View the exhibit below and examine the details entered. User HR has made some modifications to the data in the HR.EMPLOYEES table. You need to now restore the data in the table to...

Which statement describes the function of the Segment Advisor?

Which two statements are true regarding the usage of tools in administering an Oracle database? (Choose two.)

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

You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid this potential outco...

You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?

A customer recently had a security audit, when they were told that their test and developmentenvironment contained test data, which was the copy of production data, yet was not pro...

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

Which two statements are true regarding indexes? (Choose two.)

Which two statements are true regarding the segment shrink operation? (Choose two.)

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

Which two statements are true regarding point-in-time recovery? (Choose two.)

Which three statements are true regarding inconsistent backup? (Choose three)

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

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

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

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

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

Which two statements correctly differentiate undo and redo data? (Choose two.)

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...

A customer is looking to upgrade to Oracle Database 11g Release 2 when they bring in a new database server. Which two features of the release can the customer use to ensure that th...

You started up your database In the NOARCHIVELOG mode. Which are the two implications of this setting? (Choose two.)

Which two statements are true regarding the structure of the redo logs? (Choose two.)