Olete.in – MCQs, Mock Tests & Government Job Prep | Oracle DB Oracle DB Mcq Question Set 2

A ____ is a set of tables physically stored together as one table that shares a common column

1. Index
2. Object
3. Datafiles
4. Cluster

✅ Correct Answer: 4

Where is data dictionary kept?

1. SYSTEM Tablespace
2. Stack Space
3. Data File
4. None of the mentioned

✅ Correct Answer: 1

The ORDER BY clause can only be used in _______

1. SELECT queries
2. INSERT queries
3. GROUP BY queries
4. HAVING queries

✅ Correct Answer: 1

Which of the following rule below are categories of index?

1. Column and Functional
2. Multiple Column and Functional
3. To create an index in another schema
4. none of the mentioned

✅ Correct Answer: 1

What is the purpose of SMON (System Monitor Process) background process?

1. Performs crash recovery when a failed instance starts up again
2. Performs recovery when a user process fails
3. Writes redo log entries to disk
4. All of the Mentioned

✅ Correct Answer: 1

Recycle bin can be turned on or off this. This parameter is stored in which of the below file?

1. PARAMETER FILE
2. PARFILE
3. DATAFILES
4. PFILE

✅ Correct Answer: 1

When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called

1. Undone Data
2. Archive Data
3. Redo Data
4. Undo Data

✅ Correct Answer: 3

What does DLL stand for ?

1. Dynamic Link Library
2. Dynamic Language Library
3. Dynamic Load Library
4. none of the mentioned

✅ Correct Answer: 1

POST-BLOCK trigger is also a ?

1. Navigational Trigger
2. Key Trigger
3. Transaction Trigger
4. All of the Mentioned

✅ Correct Answer: 1

The system variable that records the select statement that SQL * FORMS most recently used to populate a block is ____

1. SYSTEM.LAST_RECORD
2. SYSTEM.CURSOR_RECORD
3. SYSTEM.CURSOR_FIELD
4. SYSTEM.LAST_QUERY

✅ Correct Answer: 4

In Oracle, which of the following package procedure is UNRESTRICTED ?

1. CALL_INPUT
2. CLEAR_BLOCK
3. EXECUTE_QUERY
4. USER_EXIT

✅ Correct Answer: 4

What is SQL * FORMS ?

1. SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application
2. SQL * FORMS is a 3GL tool for connecting to a Database
3. SQL * FORMS is a reporting tool
4. None of the mentioned

✅ Correct Answer: 1

Which of the following statement is false ?

1. Any procedure can raise a error and return an user message and error number
2. Error number is ranging from 20000 to 20999 are reserved for user defined messages
3. Oracle checks Uniqueness of User defined errors
4. Raise_Application_error is used for raising an user defined error

✅ Correct Answer: 3

What is the result of the following ‘PAN’NULL’KAJ’?

1. Error
2. PAN KAJ
3. PANKAJ
4. NULL

✅ Correct Answer: 3

Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL 20000 A48 ABHYUDAY A83 KRISHNA 30000 Select count(SALARY) from EMP; will result in

1. 1
2. 0
3. 3
4. None of the mentioned

✅ Correct Answer: 3

What will be the value of svar after execution? Declare fvar number :=null; svar number :=5; Begin goto <<>> if fvar is null then <<>> svar:=svar+5; end-if; End;

1. Error
2. 10
3. 5
4. None of the mentioned

✅ Correct Answer: 1

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

1. select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;
2. select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;
3. select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;
4. select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

✅ Correct Answer: 2

What SYSTEM VARIABLE is used to refer DATABASE TIME ?

1. $$dbtime$$
2. $$time$$
3. $$datetime$$
4. none of the mentioned

✅ Correct Answer: 1

You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?

1. Increase the size of the redo log files
2. Decrease the number of redo log members
3. Set LOG_CHECKPOINT_TO_ALERT to TRUE
4. Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

✅ Correct Answer: 4

Which statement is correct regarding undo management?

1. The database can have more than one undo tablespaces
2. The undo data must be purged manually when the transaction is over
3. The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF
4. Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL

✅ Correct Answer: 1

Which operations can be performed using the Data Recovery Ad-visor?

1. Diagnosing data failure
2. It is a percentage of rows in which the statistics are collected incrementally for partitions
3. Presenting appropriate repair options
4. Generating reports for possible causes of failure

✅ Correct Answer: 1

A user receives the following error while executing a query: ORA-01555: snapshot too old Predict one way to avoid such errors in near future.

1. Increase the size of redo log files
2. Increase the size of the undo tablespace
3. Increase the size of the Database Buffer Cache
4. Increase the size of the default temporary tablespace

✅ Correct Answer: 2

You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.

1. Set the TRACE_ENABLED parameter to TRUE
2. Set the threshold for the Current Logons Count metric
3. Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
4. Set the SESSIONS_PER_USER limit in the profiles used by users

✅ Correct Answer: 2

You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario?

1. The user can not create tables
2. The user can create tables
3. The user cannot query any tables
4. None of the mentioned

✅ Correct Answer: 2

Examine the following settings for the initialization parameters: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M SGA_TARGET=300M PGA_AGGREGATE_TARGET=70M Which statement is true about the memory management for the newly started database instance?

1. MEMORY_TARGET defines the maximum limit for SGA_TARGET
2. SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M
3. The value for MEMORY_MAX_TARGET is the sum of SGA_TARGET and PGA_AGGREGATE_TARGET
4. SGA_TARGET and PGA_AGGREGATE_TARGET will keep growing till a maximum of 300M and 70M, respectively

✅ Correct Answer: 2

Database management systems are intended to ______

1. Eliminate data redundancy
2. Establish relationship among records in different files
3. Manage file access
4. All of the Mentioned

✅ Correct Answer: 4

One approach to standardization storing of data ?

1. MIS
2. Structured programming
3. CODASYL specification
4. None of the mentioned

✅ Correct Answer: 3

The language used application programs to request data from the DBMS is referred to as the

1. DML
2. DDL
3. Query language
4. All of the Mentioned

✅ Correct Answer: 1

Report generators are used to

1. Store data input by a user
2. Retrieve information from files
3. Answer queries
4. Retrieve information from files and Answer queries

✅ Correct Answer: 4

The management information system (MIS) structure with one main computer system is called a

1. Hierarchical MIS structure
2. Distributed MIS structure
3. Centralized MIS structure
4. Decentralized MIS structure

✅ Correct Answer: 3

Which of the following is not true of the traditional approach to information processing

1. There is common sharing of data among the various applications
2. It is file oriented
3. Programs are dependent on the file
4. All of the Mentioned

✅ Correct Answer: 1

Choose the RDBMS which supports full fledged client server application development

1. dBase V
2. Oracle 7.1
3. FoxPro 2.1
4. Ingress

✅ Correct Answer: 2

Which of the following situation requires the use of ID-dependent entities ?

1. Association relationships only
2. Multivalued attributes only
3. Instance relationships only
4. All of the Mentioned

✅ Correct Answer: 4

Which of the following statements concerning business rules is true?

1. It should be complex.
2. It should not be convertible to computer code.
3. It may include restrictions.
4. All of the Mentioned

✅ Correct Answer: 3

In order to use a record management system

1. you need to understand the low level details of how information is stored
2. you need to understand the model the record management system uses
3. you need to understand both information storage and the model of record management system
4. None of the mentioned

✅ Correct Answer: 2

A collection of data designed to be used by different people is called a/an

1. Organization
2. Database
3. Relationship
4. Schema

✅ Correct Answer: 2

Which of the following is the process of selecting the data storage and data access characteristics of the database?

1. Logical database design
2. Physical database design
3. Testing and performance tuning
4. Evaluation and selecting

✅ Correct Answer: 2

The relationship between DEPARTMENT and EMPLOYEE is a

1. One-to-one relationship
2. One-to-many relationship
3. Many-to-many relationship
4. Many-to-one relationship

✅ Correct Answer: 2

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

1. Consistent state
2. Inconsistent state
3. Durable state
4. Atomic state

✅ Correct Answer: 2

When an entity instance must be a member of only one sub-type, it is which of the following?

1. Disjoint with total specialization
2. Disjoint with partial specialization
3. Overlap with total specialization
4. Overlap with partial specialization

✅ Correct Answer: 1

A supertype/subtype hierarchy is which of the following?

1. Each subtype has only one attribute
2. Each supertype has only one attribute
3. Each subtype has only one supertype
4. Each supertype has only one subtype

✅ Correct Answer: 3

Use of a supertype/subtype relationship is necessary when which of the following exists?

1. An instance of a subtype participates in a relationship that is unique to that subtype
2. An instance of a subtype participates in a relationship that is the same as the other subtypes
3. Attributes apply to all of the instances of an entity type
4. No attributes apply to any of the instances of an entity type

✅ Correct Answer: 1

Which of the following is not one of the three ways to classify an action assertion?

1. Condition
2. Integrity Control
3. Authorization
4. Enabler

✅ Correct Answer: 4

A BI reporting system does not _______

1. Create meaningful information
2. Deliver information to users on a timely basis
3. Use statistical procedures to predict future events
4. Use disparate data sources

✅ Correct Answer: 3

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

1. Dirty data
2. Inconsistent data
3. Too much data
4. Non-integrated data

✅ Correct Answer: 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?

1. Push
2. Pull
3. RFM
4. OLAP

✅ Correct Answer: 2

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

1. Filter data
2. Group data
3. Modify data
4. Both filter and group data

✅ Correct Answer: 3

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

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

✅ Correct Answer: 4

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

1. Reduced training costs
2. Increased dependence on a single vendor
3. Applications are not needed
4. All of the Mentioned

✅ Correct Answer: 1

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

1. SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);
2. SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;
3. SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;
4. SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

✅ Correct Answer: 4