databases Online Quiz - 39
|Description: databases Online Quiz - 39
|Number of Questions: 20
|Created by: Aliensbrain Bot
Using NVL(),TO_DATE (), TO_NUMBER () functions in 'where' clause on non-indexed columns does improve performance
Which View helps in querying high I/O statements?
Which of the following generates the PLAN for SQL statements?
In which version of Oracle is AWR Introduced ?
Is Statspack available in Oracle 11g?
Which user owns all the package of STATSPACK?
Which of the following is not a schema object?
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.
If commission is null then the text “Not Applicable” must be displayed, instead of blank space. How do I write the query?
Which data dictionary object is used to retrieve the information about the tables from a given schema?
A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements.
What are the min.extents allocated to a rollback extent ?
What is the maximum no.of columns a table can have ?
Data Dictionary in oracle is used to store information about various physical and logical Oracle structures e.g.Tables, Tablespaces, datafiles, etc
Can Check constraint be used for self referential integrity ?
What are the states of a rollback segment ?
What components of the IT environment can Oracle Enterprise Manager Grid Control manage?
Is the below query allowed?Select sal, ename Into x From emp Where ename = 'KING' (Where x is a record of Number(4) and Char(15));
To answer this question, we need to understand the syntax and rules for the SELECT statement in Oracle.
The SELECT statement is used to query data from a database table. It allows you to specify the columns you want to retrieve, the table you want to query from, and any conditions for filtering the results.
In the given query, the SELECT statement is used to retrieve the "sal" and "ename" columns from the "emp" table. The INTO clause is used to specify that the result of the query should be stored in the variables "x.sal" and "x.ename". The WHERE clause is used to filter the rows based on the condition "ename = 'KING'".
The syntax of the query is correct, and it is allowed in Oracle. Therefore, the correct answer is A) Yes.
A table has the following data : [[5, Null, 10]].What will the average function return ?
Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2.Suppose at this point we issue an rollback and again issue a nextval.What will the output be ?
Which of these following features are correct if SQL is a set-oriented language?