Intellect Design Arena Database Developer Interview Questions and Answers

SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.

• SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.

• SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.

• SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...read more

Restoring a database using RMAN involves connecting to the target database, restoring the control file, and recovering the database.

• Connect to the target database using RMAN

• Restore the control file from a backup

• Restore the datafiles and tablespaces

• Recover the database to bring it to a consistent state

• Perform necessary checks and validations after restoration

You can change a column in a table using the ALTER TABLE statement in SQL.

• Use the ALTER TABLE statement followed by the MODIFY keyword to change the data type or size of a column.

• Use the ALTER TABLE statement followed by the ADD or DROP keyword to add or remove a column.

• Make sure to specify the table name, column name, and the new data type or size when making changes.

Different types of objects in a database include tables, views, indexes, sequences, and stored procedures.

• Tables: Used to store data in rows and columns.

• Views: Virtual tables created by a query.

• Indexes: Improve the performance of queries by allowing quick access to specific rows.

• Sequences: Generate unique numbers.

• Stored Procedures: Precompiled SQL code that can be executed with parameters.

Fundamentals of Oracle DB and Architecture

• Oracle Database is a relational database management system (RDBMS)

• It uses SQL (Structured Query Language) for querying and managing data

• Consists of physical and logical structures like data files, tablespaces, and schemas

• Architecture includes components like instance, memory structures, and background processes

A materialized view (mview) is a database object that contains the results of a query. Datapump is a tool for moving data between Oracle databases. Oracle GoldenGate is a real-time data integration and replication tool.

• Materialized views (mviews) store the results of a query for faster access.

• Datapump is a tool used for exporting and importing data between Oracle databases.

• Oracle GoldenGate is a real-time data integrat...read more

Configuring RAC involves setting up shared storage, network, and database components on multiple nodes.

• Configure shared storage using ASM or NFS

• Configure network components such as VIP, SCAN, and listener

• Install Oracle Grid Infrastructure and Oracle Database software on all nodes

• Create a RAC database using DBCA or manually

• Configure load balancing and failover using services

• Use shell scripting and SQL scripting to autom...read more