Tag: databases

Questions Related to databases

  1. V$SQLSTATS.DISK_READS

  2. V$DISK_READS

  3. V$SQL_STATS

  4. V$SYS_STAT


Correct Option: A

Which of the following generates the PLAN for SQL statements?

  1. PLAN

  2. EXPLAIN PLAN

  3. TKPROF

  4. V$PLAN


Correct Option: B

Which of the following is not a schema object?

  1. Indexes

  2. Tables

  3. Public Synonyms

  4. Triggers and Packages


Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of schema objects in a database.

A schema object is a logical database structure that is created and owned by a specific user or schema in a database. These objects are used to store, manage, and manipulate data within the database.

Let's go through each option to understand why it is correct or incorrect:

Option A) Indexes - This option is a schema object. Indexes are database objects that improve the speed of data retrieval operations on database tables.

Option B) Tables - This option is a schema object. Tables are used to store data in a structured manner and are one of the fundamental objects in a database.

Option C) Public Synonyms - This option is not a schema object. Public synonyms are used to provide a consistent and simplified naming convention for database objects across multiple schemas. However, they are not considered as schema objects themselves.

Option D) Triggers and Packages - This option is a schema object. Triggers and packages are database objects used to automate actions and encapsulate related procedures, functions, and variables.

The correct answer is C) Public Synonyms. This option is not a schema object because public synonyms are not considered as schema objects in a database.

  1. select nvl(to_char(comm),'NA') from emp;

  2. select nvl(comm,'NA') from emp;

  3. select nvl(comm,NA) from emp;

  4. None of the above


Correct Option: A