Online Access Free 1Z0-514 Exam Questions

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

• A.It must reside on both the client and database server for traditional client/server applications.
• B.It must reside on both the web server and database server for web-based applications.
• C.It must reside only on the client for traditional client/server applications.
• D.It must reside only on the database server for web-based applications.

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 start the listener?

• A.Oracle Net configuration Assistant
• B.Database Configuration Assistant
• C.Oracle Not Manager
• D.listener Control utility

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 result of choosing this option?

• A.The data files are automatically spread across all available storage devices to optimize performance and resource utilization.
• B.The database files would be managed by the operating system's file system.
• C.DBCA would not save the database files by using Optimal File Architecture (OFA).
• D.Disk mirroring and striping would be done automatically.

Which mode of database shutdown requires an instance recovery at the time of the database startup?

• A.IMMEDIATE
• B.NORMAL
• C.TRANSACTIONAL
• D.ABORT

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

• A.Large pool
• B.Program Global Area
• C.Buffer Cache
• D.Shared pool