What is the minimum number of instances you need to have in order to create a RAC?

What is the minimum number of instances you need to have in order to create a RAC?
by

1 Answer

Answer :

1. You can create a RAC with just one server.
by

Related questions

What RAC component is used for communication between instances?

Description : What RAC component is used for communication between instances?

Last Answer : Private Interconnect.

How many alert logs exist in a RAC environment?

Description : How many alert logs exist in a RAC environment?

Last Answer : One for each instance.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

What is the difference between normal views and RAC views?

Description : What is the difference between normal views and RAC views?

Last Answer : RAC views has the prefix ‘G’. For example, GV$SESSION instead of V$SESSION

What was RAC previous name before it was called RAC?

Description : What was RAC previous name before it was called RAC?

Last Answer : OPS: Oracle Parallel Server

Can you have many database versions in the same RAC?

Description : Can you have many database versions in the same RAC?

Last Answer : Yes, but Clusterware version must be greater than the greater database version.

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

What command would you use to check the availability of the RAC system?

Description : What command would you use to check the availability of the RAC system?

Last Answer : crs_stat -t -v (-t -v are optional)

What is the recommended method to make backups of a RAC environment?

Description : What is the recommended method to make backups of a RAC environment?

Last Answer : RMAN to make backups of the database, dd to backup your voting disk and hard copies of the OCR file.

Point out the wrong statement. a) AWS S3 essentially lets you create your own cloud storage b) AWS created “Availability Zones” within regions, which are sets of systems that are isolated from one another c) Amazon Web Services (AWS) adds redundancy to its IaaS systems by allowing EC2 virtual machine instances d) None of the mentioned

Description : Point out the wrong statement. a) AWS S3 essentially lets you create your own cloud storage b) AWS created Availability Zones within regions, which are sets of systems that are isolated from ... adds redundancy to its IaaS systems by allowing EC2 virtual machine instances d) None of the mentioned

Last Answer : None of the mentioned

Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Description : Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Last Answer : Amazon Relational Database Service

What are the minimum number of groups required for a matrix report

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

What is the full form of 'RAC' ? -How To ?

Description : What is the full form of 'RAC' ? -How To ?

Last Answer : The full form of 'RAC' is Reservation Against Cancellation

RAC stands for A. Reservation Against Cancellation B. Reservation Against Collection C. Reservation against cancel D. None of These

Description : RAC stands for A. Reservation Against Cancellation B. Reservation Against Collection C. Reservation against cancel D. None of These

Last Answer : A [Reservation Against Cancellation]

Horse power of I.C. engines can be expressed as RAC rating, SAE rating, or DIN rating. To which countries these standards belong ?

Description : Horse power of I.C. engines can be expressed as RAC rating, SAE rating, or DIN rating. To which countries these standards belong ?

Last Answer : U.K., USA and Germany respectively.

. A permanent DRDO exhibition known as Darpan is established at (a) VRDE (b) INMAS (c) DRDE (d) RAC

Description : . A permanent DRDO exhibition known as Darpan is established at (a) VRDE (b) INMAS (c) DRDE (d) RAC

Last Answer : (d) RAC

How does one create a standby database? (for DBA)

Description : How does one create a standby database? (for DBA)

Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

How does one create and drop database users?

Description : How does one create and drop database users?

Last Answer : Look at these examples: CREATE USER scott IDENTIFIED BY tiger -- Assign password DEFAULT TABLESACE tools -- Assign space for table and index segments TEMPORARY TABLESPACE temp; -- Assign sort space ... give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools;

What utility is used to create a physical backup?

Description : What utility is used to create a physical backup?

Last Answer : Either rman or alter tablespace begin backup will do..

The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

Description : The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

Last Answer : Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space. . Create an Oracle user who would own this repository. Assign ... would trigger the creation of the repository. From now on, Enterprise manager is ready to accept jobs.

How does one create a repository? (for DBA

Description : How does one create a repository? (for DBA

Last Answer : For OEM v2 and above, start the Oracle Enterprise Manager Configuration Assistant (emca on Unix) to create and configure the management server and repository. Remember to setup a backup for the repository database after creating it.

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Can we create two blocks with the same name in form 3.0 ?

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

How will you create multiple rollback segments in a database ?

Description : How will you create multiple rollback segments in a database ?

Last Answer : Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment ... ) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments.

How does one create a RMAN recovery catalog? (for DBA

Description : How does one create a RMAN recovery catalog? (for DBA

Last Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user ... . Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;

Why is it preferable to create a fewer no. of queries in the data model?

Description : Why is it preferable to create a fewer no. of queries in the data model?

Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

How does one create a password file? (for DBA

Description : How does one create a password file? (for DBA

Last Answer : The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be ... visible in the process table of many systems. Administrators needs to be aware of this!

How do you create a new session while open a new form?

Description : How do you create a new session while open a new form?

Last Answer : Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

How does one create a new database? (for DBA)

Description : How does one create a new database? (for DBA)

Last Answer : One can create and modify Oracle databases using the Oracle "dbca" (Database Configuration Assistant) utility. The dbca utility is located in the $ORACLE_HOME/bin directory. The Oracle Universal ... ='/u02/oradata/'; ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2='/u03/oradata/'; CREATE DATABASE;

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

A table is having few rows, should you create indexes on this table

Description : A table is having few rows, should you create indexes on this table

Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.

On which columns you should create Indexes?

Description : On which columns you should create Indexes?

Last Answer : In general, you should create an index on a column in any of the following situations: ▪ The column is queried frequently ▪ A referential integrity constraint exists on the column ▪ A UNIQUE key ... ORDER BY clauses ▪ On columns that have few of the same values or unique values in the table

Which default Database roles are created when you create a Database?

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

How many minimum groups are required for a matrix report

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

What are the minimum parameters should exist in the parameter file (init.ora) ?

Description : What are the minimum parameters should exist in the parameter file (init.ora) ?

Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

Which statement is true about the maintenance of a cloud computing environment? A. In a Software as a Service (SaaS) environment, patches are not automatically installed on the clients. B. In a SaaS environment, customers do not need to worry about installing patches in the virtual instances. C. In an Infrastructure as a Service (IaaS) environment, patches are automatically installed on the clients. D. In an IaaS environment, customers do not need to worry about installing patches in the virtual instances.

Description : Which statement is true about the maintenance of a cloud computing environment? A. In a Software as a Service (SaaS) environment, patches are not automatically installed on the clients. B ... an IaaS environment, customers do not need to worry about installing patches in the virtual instances.

Last Answer : In a SaaS environment, customers do not need to worry about installing patches in the virtual

Suppose there are four processes in execution with 12 instances of a Resource R in a system. The maximum need of each process and current allocation are given below: Image With reference to current allocation, is system safe? If so, what is the safe sequence? (A) No (B) Yes, P1 P2 P3 P4 (C) Yes, P4 P3 P1 P2 (D) Yes, P2 P1 P3 P4

Description : Suppose there are four processes in execution with 12 instances of a Resource R in a system. The maximum need of each process and current allocation are given below: With reference to current allocation, is system safe? If so, ... B) Yes, P1 P2 P3 P4 (C) Yes, P4 P3 P1 P2 (D) Yes, P2 P1 P3 P4

Last Answer : (C) Yes, P4 P3 P1 P2

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Write the order of precedence for validation of a column in a table ?

Description : Write the order of precedence for validation of a column in a table ?

Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?

State the order in which these triggers are executed ?

Description : State the order in which these triggers are executed ?

Last Answer : POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

If a break order is set on a column would it affect columns which are under the column?

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

What is the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

What is the most important requirement in order to use RMAN to make consistent hot backups

Description : What is the most important requirement in order to use RMAN to make consistent hot backups

Last Answer : Your database has to be in ARCHIVELOG mode.

PHP echo number of instances if specific word?

Description : PHP echo number of instances if specific word?

Last Answer : make a while loop that goes through the contents of the array. prior to the array define a counting variable and give it the value 0. during each loop, increase the value by 1 if the word “and” is encountered