Identify the correct order of consolidation density.

Correct Answer for the following Question is given below Identify the correct order of consolidation density. Question: Identify the correct order of consolidation density. Options: multitenant< schema consolidation< dedicated database< VMs schema consolidation< VMs< dedicated databases< multitenant dedicated databases< VMs< schema consolidation< multitenant VMs< dedicated databases< schema consolidation< multitenant Correct Answer The Correct Answer for ... Read more

Which command do you use to check for block corruption by validating the database?

Correct Answer for the following Question is given below Which command do you use to check for block corruption by validating the database? since 11g the syntax got changed to RMAN> validate [check logical] database;Example:DGMGRL> validate database verbose d1 output include: Block Corruptions found NO NO Question: Which command do you use to check for … Read more

Which three operations would allow you to insert data without getting the error message?

Correct Answer for the following Question is given below Examine the statements:SQL> CREATE TABLESPACE MYTBS DATAFILE ‘/disk1/mytbs_l.dbf ‘ SIZE 10M;SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )PARTITION BY RANGE(id) ( partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m));When inserting data, you … Read more

Which two statements represent where Oracle Net must reside?

Correct Answer for the following Question is given below Which two statements represent where Oracle Net must reside? Question: Which two statements represent where Oracle Net must reside? Options: Only on the client for traditional client/server applications Only on the database server for web-based applications On both the web server and database server for web-based … Read more

Which component receives the request and establishes the appropriate connection?

Correct Answer for the following Question is given below Your database instance is running. db01 is a net service name. You issue a connection request by using the command:SQL> CONNECT scott/[email protected] component receives the request and establishes the appropriate connection?References: Question: Which component receives the request and establishes the appropriate connection? Options: listener user process … Read more

What would be the outcome?

Correct Answer for the following Question is given below There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, onlyLISIENER1 is started. You issue the command: lsnrctl start listener2What would be the outcome?References: Question: What would be the outcome? Options: It starts the … Read more

Which two statements are true regarding SQL*Plus?

Correct Answer for the following Question is given below Which two statements are true regarding SQL*Plus?References: Question: Which two statements are true regarding SQL*Plus? Options: It has commands for performing database administration operations. It can be used in interactive but not batch mode for SQL commands. It has to be installed separately after the Oracle … Read more

Which scenario would this command execute successfully?

Correct Answer for the following Question is given below Examine the command: sqlplus /nologIn which scenario would this command execute successfully? Question: Which scenario would this command execute successfully? Options: only from the server, if the database instance is not up from either a client or server, even if the database instance is not up … Read more

What happens to the installation in this situation?

Correct Answer for the following Question is given below You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the productspecific prerequisite checks has failed:Checking available swap space requirements…Expected result: 1512MBActual Result: 1018MBCheck complete. The overall result of this check is: … Read more

Which statement about a server parameter file (SPFILE) is false?

Correct Answer for the following Question is given below Which statement about a server parameter file (SPFILE) is false? http://docs.oracle.com/database/121/ADMIN/start.htm#ADMIN12825 Question: Which statement about a server parameter file (SPFILE) is false? Options: An SPFILE is a binary file that cannot be edited by using a text editor. You can create an SPFILE from an existing … Read more