Oracle Database Multiple Choice Questions and Answers on Data Entry, Query and Reporting for Freshers

1. A BI reporting system does not _____________

a) Create meaningful information
b) Deliver information to users on a timely basis
c) Use statistical procedures to predict future events
d) Use disparate data sources

Answer: c

Explanation: Business intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information.

2. The “curse of dimensionality” relates to which problem of using operational data for BI reporting?

a) Dirty data
b) Inconsistent data
c) Too much data
d) Non-integrated data

Answer: c

Explanation: The curse of dimensionality refers to various phenomena that arise when analyzing and organizing data in high-dimensional spaces.

3. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

a) Push
b) Pull
c) RFM
d) OLAP

Answer: b

Explanation: The push-pull model to not allow mixed port type combinations for a connection, such as connecting a push output port to a pull input port, and a pull output port to a push input port.

4. Business Intelligence (BI) reporting systems cannot do which of the following operations?

a) Filter data
b) Group data
c) Modify data
d) Both filter and group data

Answer: c

Explanation: Business intelligence (BI) is a technology-driven process for filter data and group information.

5. Which of the following is not a component of a data warehouse?

a) Data extraction/cleaning/preparation programs
b) Data warehouse data
c) Data metadata
d) None of the Mentioned

Answer: c

Explanation: Data warehouse is not deal with the Data metadata.

6. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?

a) Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row
b) Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column
c) Three rows have the values Brown, NULL, and Blue in the same column
d) One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column

Answer: d

Explanation: Option d fullfill the condition of column.

7. The wildcard in a WHERE clause is useful when?

a) An exact match is necessary in a SELECT statement
b) An exact match is not possible in a SELECT statement
c) An exact match is necessary in a CREATE statement
d) An exact match is not possible in a CREATE statement

Answer: b

Explanation: Wildcard useful only when an exact match is not possible in a SELECT statement.

8. The benefits of a standard relational language include which of the following ?

a) Reduced training costs
b) Increased dependence on a single vendor
c) Applications are not needed
d) All of the Mentioned

Answer: a

Explanation:Standard relational language gives the benefits of reducing the training costs.

9. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;

a) SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);
b) SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;
c) SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;
d) SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

Answer: d

Explanation: Query d satisfy the condition mention in above.

10. There are two sessions currently connected to your database instance. In the first session, the following UPDATE statement is executed:

SQL> UPDATE dept SET deptno=80 WHERE dname='SALES';

The UPDATE statement above waits to complete the execution. Investigations reveal the following facts:
– The UPDATE statement is waiting to acquire a lock
– There is referential integrity constraint between the DEPT and EMP table
– Department number 30 represents the SALES department
– The EMP table is updated in the second session as follows:

SQL> UPDATE emp SET sal=sal*0.17 WHERE deptno=30;

Which action would you perform to avoid waiting in the first session ?

a) Drop any existing index on the EMP table
b) Drop any existing index on the DEPT table
c) Create an index on the deptno column of the EMP table
d) Create an index on the deptno column of the DEPT table

Answer: c

Explanation: Creation index on the column will may increase the disk space requirements of your database and slow down dml (i.e. inserts, updates and deletes)also increase the maintenance requirements of your Oracle database,index may make your queries slower instead of faster.