Pebble Interview Questions and Answers

Normal types of SQL views include simple views, complex views, and materialized views.

• Simple views are based on a single table or multiple tables with a simple join.

• Complex views involve more complex queries, such as subqueries or aggregations.

• Materialized views store the result of a view as a physical table for improved performance.

A database is a structured collection of data, while data refers to the raw facts and statistics that are stored in a database.

• A database is a software system that organizes and stores data in a structured manner.

• Data refers to the raw facts and statistics that are stored in a database.

• Databases are used to store, retrieve, and manage large amounts of data efficiently.

• Examples of databases include MySQL, Oracle, MongoDB, and SQLite.

• Data can be in various forms such as text, n...read more

Subqueries in SQL are queries nested within another query. They can be used to retrieve data for further analysis or filtering.

• Subqueries are enclosed within parentheses and can be used in SELECT, FROM, WHERE, and HAVING clauses.

• They can be used to retrieve a single value, a list of values, or a table of values.

• Subqueries can be correlated or non-correlated, depending on whether they reference the outer query.

• Examples of subqueries include finding the maximum value, filtering...read more

Operating systems are software that manage computer hardware and software resources.

• Operating systems provide an interface between users and computer hardware.

• They manage computer memory, processes, and file systems.

• Examples include Windows, macOS, Linux, and Android.

PL/SQL types are data types used in PL/SQL programming language.

• PL/SQL types include scalar, composite, reference, and lob types.

• Scalar types include number, varchar2, date, boolean, etc.

• Composite types include record and table types.

• Reference types include cursor and object types.

• LOB types include BLOB, CLOB, NCLOB, and BFILE.

• PL/SQL types are used to define variables, parameters, and functions in PL/SQL programs.

Manual testing is a process of verifying software manually to find defects and ensure its functionality.

• Manual testing involves executing test cases manually without the use of automation tools.

• It requires human intervention to perform various testing activities.

• Testers follow predefined test scripts and scenarios to validate software functionality.

• It helps in identifying bugs, usability issues, and ensuring the software meets user requirements.

• Examples of manual testing incl...read more