Clover Infotech Interview Questions, Process, and Tips

Q1. How to recover control file if it is deleted in 8pm and how u recover that file after 8pm What is rac how u reate in rac ? About primary and standby And what command to used ? What is smon Library cacher.
Ans. 
To recover a deleted control file in Oracle Database, you can use a backup control file or create a new control file.
• If a backup control file is available, you can restore it using the RMAN utility.

• If a backup control file is not available, you can create a new control file using the CREATE CONTROLFILE statement.

• To create a new control file, you need to provide the necessary information about the database, such as data...read more
Answered by AI
Add your answer

Questions were there from reasoning

Q1. Questions were there from SQL language
Add your answer

Q1. Talk about all the things that you have done in your previous projects.
Add your answer

There was 10 question

Q1. What is array and strings
Ans. 
Arrays are a collection of elements of the same data type, while strings are a sequence of characters.
• Arrays can store multiple values in a single variable, accessed by index.

• Strings are a special type of array that store sequences of characters.

• Example: Array - [1, 2, 3], String - 'hello world'
Answered by AI
Add your answer
Q2. Write a code of prime number
Ans. 
Code to check if a number is prime or not
• Use a loop to check if the number is divisible by any number other than 1 and itself

• If the number is only divisible by 1 and itself, it is a prime number

• Example: Check if 7 is prime - loop from 2 to 6, no number divides 7 evenly
Answered by AI
Add your answer

Q1. Abstract class means
Add your answer

Q1. Joins,subquery,
Add your answer
Q2. Linux commands and uses
Ans. 
Linux commands are used to interact with the operating system, perform tasks, manage files, and more.
• ls - list directory contents

• cd - change directory

• pwd - print working directory

• cp - copy files

• mv - move files

• rm - remove files

• grep - search for specific text in files

• chmod - change file permissions

• sudo - execute a command as the superuser

• top - display system processes and resource usage
Answered by AI
Add your answer

Q1. SQL coding on different types of examples
Ans. 
SQL coding involves writing queries to retrieve, manipulate, and manage data in a database.
• Use SELECT statement to retrieve data from a database

• Use INSERT statement to add new data to a database

• Use UPDATE statement to modify existing data in a database

• Use DELETE statement to remove data from a database

• Use JOIN statement to combine data from multiple tables
Answered by AI
Add your answer