> > Oracle Database MCQs > Basic Oracle Database MCQs

Basic Oracle Database MCQ

1. Which of the follwing is NOT associated with an instance?

Trace files

Parameter files

Control files

Alert files

Answer

Correct Answer: Control files

Note: This Question is unanswered, help us to find answer for this one

2. To truncate table changes, use DATA_OBJECT_ID.

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

3. Users that can see any changed data are:

No one except the default user for the corresponding schema

DBAs and users in the same group

Only DBAs

Only the ones making the changes

Answer

Correct Answer: Only the ones making the changes

Note: This Question is unanswered, help us to find answer for this one

4. The default value of SHARED_POOL_SIZE is:

16000000 bytes

1024000 bytes

3500000 bytes

2048000 bytes

Answer

Correct Answer: 3500000 bytes

Note: This Question is unanswered, help us to find answer for this one

5. Which of these tasks is NOT performed during the database mounting process?

Allocating the SGA

Reading the control files to obtain the names and status of the data files

Locating and opening the control files

Associating the database with a previously started instance

Answer

Correct Answer: Allocating the SGA

Note: This Question is unanswered, help us to find answer for this one

6. Which of the following falsely sums up Oracle’s locking policy?

Oracle never locks data just to read it. There are no locks placed on rows of data by simple reads

Oracle locks data at the row level on modification. There is no lock escalation to a block or table level

A writer of data is blocked only when a reader of data has already locked the row it was going after.

A reader of data never blocks a writer of data

Answer

Correct Answer: A writer of data is blocked only when a reader of data has already locked the row it was going after.

Note: This Question is unanswered, help us to find answer for this one

7. Rowid on oracle stores:

Log stored position

Logical position of the data

Indexed position of data

Physical position of the data

Answer

Correct Answer: Physical position of the data

Note: This Question is unanswered, help us to find answer for this one

8. Does "Not in" use an index?

Yes

Answer

Correct Answer: No

Note: This Question is unanswered, help us to find answer for this one

9. In what value do these 3 statements differ from one another? select * from employees where department_id = 60; SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 60; select /* a_comment / from employees where department_id = 60;

Hash values

The last statement contains syntax error

All statements don't differ from one another

The execution result

Answer

Correct Answer: Hash values

Note: This Question is unanswered, help us to find answer for this one

10. What is the number of user defined triggers in Oracle?

Answer

Correct Answer: 12

Note: This Question is unanswered, help us to find answer for this one

11. Which of the following statements are true about deleting or updating a statement?

The data block is read, loading it into a memory structure called a buffer cache

No entry in the undo segment header block is created for this transaction

For a delete, the row will not be removed from the data block until the end user execute commit command

The undo log buffer will contain the corresponding delete or update statement

Answer

Correct Answer: The data block is read, loading it into a memory structure called a buffer cache

Note: This Question is unanswered, help us to find answer for this one

12. The only users recognized by the password file are:

SYSTEM and INTERNAL

SYS and INTERNAL

SYS and SYSTEM

SYSMAN and SYSTEM

Answer

Correct Answer: SYS and INTERNAL

Note: This Question is unanswered, help us to find answer for this one

13. In Forms, what keyboard shortcut will access the shortcut menu?

F11

Ctrl + S

Ctrl + K

Ctrl + M

Answer

Correct Answer: Ctrl + K

Note: This Question is unanswered, help us to find answer for this one

14. The basic units that make up a PL/SQL are called:

Logical blocks

Executable blocks

Nested blocks

Sub-routines

Answer

Correct Answer: Logical blocks

Note: This Question is unanswered, help us to find answer for this one

15. In an Oracle RAC environment, a physical standby database will be registered with the clusterware. When creating the clusterware resource for the standby database, which of the following commands do you use to perform this registration?

srvctl register database

srvctl add database

srvctl alter database

srvctl add database register

Answer

Correct Answer: srvctl add database

Note: This Question is unanswered, help us to find answer for this one

16. Which of the following parameters specifies whether Oracle checks for a password file?

None of these

LOGIN_PASSWORDFILE

REMOTE_LOGIN_PASSWORD_FILE

REMOTE_LOGIN_PASSWORDFILE

Answer

Correct Answer: REMOTE_LOGIN_PASSWORDFILE

Note: This Question is unanswered, help us to find answer for this one

17. There are 2 classifications of an index: by logical design and by physical implementation. From its logical design, indexes can have the following types, except:

B-Tree

Single column or concatenated

Function-based

Unique or non unique

Answer

Correct Answer: B-Tree

Note: This Question is unanswered, help us to find answer for this one

18. How do you switch from an init.ora file to a spfile?

ALTER DATABASE USE SPFILE;

update parameter USE_SPFILE to TRUE

ALTER SYSTEM USE SPFILE;

Delete init.ora file, 10g and greater automatically creates an SPFILE if init.ora is missing

CREATE SPFILE FROM PFILE;

Answer

Correct Answer: CREATE SPFILE FROM PFILE;

Note: This Question is unanswered, help us to find answer for this one

19. Which of the following best describes how to have requests serviced by an Oracle server (using either dedicated or shared server)?

For each open session, a new dedicated server will be created separately from the instance in a one-to-one mapping

The client process will be in direct communication with this shared server over some networking conduit such as TCP/IP socket.

A big difference between shared and dedicated server connections is that the client process connected to the database never talks directly to a dedicated server, as it would to a shared server

In dedicated server, Oracle uses a pool of shared processes for a large community of users

Answer

Correct Answer: For each open session, a new dedicated server will be created separately from the instance in a one-to-one mapping

Note: This Question is unanswered, help us to find answer for this one

20. This structure is not included in the Shared Pool contents.

Database buffer cache

Library cache

User Global Area

Data dictionary cache

Answer

Correct Answer: Database buffer cache

Note: This Question is unanswered, help us to find answer for this one

21. The Oracle server provides a number of standard data dictionary views to obtain information on database and instance. These views are:

V$DATAFILE, V$DATABASE, V$SESSIONS

V$SGA, V$BGPROCESS,V$USERS

V$DATATABLE, V$USERS, V$SESSIONS

V$SGA, V$INSTANCE, V$PROCESS

Answer

Correct Answer: V$SGA, V$INSTANCE, V$PROCESS

Note: This Question is unanswered, help us to find answer for this one

22. Which one of these statements is true about a concatenated index?

Columns in concatenated index need to be in the same order as the columns in the table

It is created on multiple columns in a table.

It is created when using functions or expressions that involve one or more columns in a table

There is no limit of how many columns can be included in a composite key

Answer

Correct Answer: It is created on multiple columns in a table.

Note: This Question is unanswered, help us to find answer for this one

23. When executing the command: "show parameter xxxx", ORA-00942: table or view does not exist appears. Which of the following best explains this error?

The parameter has been changed but the transaction is never committed

The statement is executed using "normal" user

The database is not started up

Parameter table does not exist

Answer

Correct Answer: The statement is executed using "normal" user

Note: This Question is unanswered, help us to find answer for this one

24. One of these datatypes is NOT a base scalar datatype?

NUMBER

INT

VARCHAR2

BOOLEAN

Answer

Correct Answer: INT

Note: This Question is unanswered, help us to find answer for this one

25. Before any SQL statement is parsed, Oracle will check the _______ to see if that same statement already exists there.

None of these

Dictionary cache

Library cache

Shared pool

Answer

Correct Answer: Library cache

Note: This Question is unanswered, help us to find answer for this one

26. Which of the following cannot be placed in the declaration part of PL/SQL?

SQL statements

Variables

User-defined exceptions

Constants

Answer

Correct Answer: SQL statements

Note: This Question is unanswered, help us to find answer for this one

27. What happens if the command ALTER TABLE <tablename> DEALLOCATE UNUSED is used without the KEEP clause?

Oracle will deallocate all unused space without any condition

Oracle will deallocate all unused space above the high water mark

Oracle will deallocate all unused space less than the high water mark

None of these

Answer

Correct Answer: Oracle will deallocate all unused space above the high water mark

Note: This Question is unanswered, help us to find answer for this one

28. The init.ora parameter that controls the location of the Alert log file is:

USER_DUMP_DEST

UTL_FILE_DIR

LOG_BUFFER

BACKGROUND_DUMP_DEST

Answer

Correct Answer: BACKGROUND_DUMP_DEST

Note: This Question is unanswered, help us to find answer for this one

29. How does PL/SQL allow programmers to use it on any host environment?

It improves process performance

It processes Oracle errors with exception-handling routines

It modularizes program development

It is portable

Answer

Correct Answer: It is portable

Note: This Question is unanswered, help us to find answer for this one

30. This type of error can be solved by increasing the undo retention of increasing the size of rollbacks.

ORA-03620

ORA-01155

ORA-02511

ORA-01555

Answer

Correct Answer: ORA-01555

Note: This Question is unanswered, help us to find answer for this one

31. The background process that checks for consistency of the database is called:

PMON

DBW0

SMON

LGWR

Answer

Correct Answer: SMON

Note: This Question is unanswered, help us to find answer for this one

32. The most effective way to re-order the columns in a table is:

Use ALTER TABLE MODIFY COLUMN command

By using CREATE TABLE AS SELECT

Write a stored procedure to manipulate the columns

Drop the table and re-create it

Answer

Correct Answer: By using CREATE TABLE AS SELECT

Note: This Question is unanswered, help us to find answer for this one

33. Oracle default optimization follows:

Rule based optimization

Cost based optimiztion

Both Cost and Rule

Answer

Correct Answer: Cost based optimiztion

Note: This Question is unanswered, help us to find answer for this one

34. Which of the following is a good suggestion for avoiding unnecessary extension of a rollback segment?

Always use INITIAL = NEXT for rollback segments

Avoid setting MAXEXTENT to UNLIMITED

Always place rollback segment in a separate exclusive tablespace

Set OPTIMAL value to minimize the allocation or deallocation of rollback segment extents

Answer

Correct Answer: Avoid setting MAXEXTENT to UNLIMITED

Note: This Question is unanswered, help us to find answer for this one

35. Which of these programs is the most popular choice to load data directly into Oracle E-Business Suite?

Forms Data Loader

Access

Excel

Cognos

DataLoad

Answer

Correct Answer: DataLoad

Note: This Question is unanswered, help us to find answer for this one

36. Given the following data in the emp table: ENAME SALARY : PING 5000 AILYN 4999 SAM 1000 LESLIE 3000 TOM 2500 RAVI 10000 What will the following select statement produce? SELECT ename FROM emp WHERE salary BETWEEN 3000 AND 5000;

an error

None of these

AILYN

PING AILYN LESLIE

Answer

Correct Answer: PING AILYN LESLIE

Note: This Question is unanswered, help us to find answer for this one

37. When you issue the command "ALTER DATABASE BACKUP CONTROLFILE TO TRACE", a text script version of backup control file will be created. Where is this file located?

In a folder pointed by SYSTEM_DUMP_DEST

In the same folder as the running command

In a folder pointed by USER_DUMP_DEST

In the ORACLE_HOME/backup folder

Answer

Correct Answer: In a folder pointed by USER_DUMP_DEST

Note: This Question is unanswered, help us to find answer for this one

38. Which function is not in DBMS_OUTPUT?

NEW_LINE

PUT_LINE

PUT

PREV_LINE

Answer

Correct Answer: PREV_LINE

Note: This Question is unanswered, help us to find answer for this one

39. A "virtual" table name to query the current time is:

DUAL

ALL_PARAMS

SYSDATE

V$PARAMETERS

Answer

Correct Answer: DUAL

Note: This Question is unanswered, help us to find answer for this one

40. This protects the library cache from becoming corrupted by concurrent modifications by two sessions or by one session trying to read information that is being modified by another one.

Cache

Power lock

Latch

Pitch

Answer

Correct Answer: Latch

Note: This Question is unanswered, help us to find answer for this one

41. What happends when you execute one transcaction and then truncate another table?

Transcation will commit automatically

No effect on transaction

Transaction will rollback

Truncate will not work

Answer

Correct Answer: Transcation will commit automatically

Note: This Question is unanswered, help us to find answer for this one

42. Implicit Cursor works when:

Executing a procedure

DML operation is done

User logs in

Executing a function

Answer

Correct Answer: DML operation is done

Note: This Question is unanswered, help us to find answer for this one

43. Which of these is NOT an Oracle "database option?"

Active Data Guard

Oracle Real Application Testing

Oracle Questions

Total Recall

Database Vault

Answer

Correct Answer: Oracle Questions

Note: This Question is unanswered, help us to find answer for this one

44. What will happen if PL/SQL variables occur in SQL statements and have the same name as a table column

None of these

Oracle will popup an execution error

Oracle will assume that it is the column that is being referenced

Oracle will ignore the column name

Answer

Correct Answer: Oracle will assume that it is the column that is being referenced

Note: This Question is unanswered, help us to find answer for this one

45. Which of the following actions are performed by the MINUS operator?

Returns all of the columns for the tables specified in the FROM clause minus those specified after the MINUS operator.

Returns the output of top query minus the output of the query below the MINUS operator.

Returns the result of one numeric value minus another.

Answer

Correct Answer: Returns the output of top query minus the output of the query below the MINUS operator.

Note: This Question is unanswered, help us to find answer for this one

46. The "materialized view" in Oracle stores:

No output only the definition

Output in logical space

No output

Output in different physical space

Answer

Correct Answer: Output in different physical space

Note: This Question is unanswered, help us to find answer for this one

47. The IN operator is used when you are using a subquery which returns more than one record. What is the operator used in a correlated subquery?

EXISTS

None of these

UNION

INTERSECT

Answer

Correct Answer: EXISTS

Note: This Question is unanswered, help us to find answer for this one

48. Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS

USER_COL_PRIVS

USER_COL_PRIVS_MADE

Answer

Correct Answer: USER_COL_PRIVS

Note: This Question is unanswered, help us to find answer for this one

49. Which of these statement is NOT true?

A datafile can be associated with one or more database

A database has at least one datafile

A tablespace is a logical unit of database storage formed by one or more data files

Control file is used to identify the data files and the redo log files

Answer

Correct Answer: A datafile can be associated with one or more database

Note: This Question is unanswered, help us to find answer for this one

50. Which /SQL*Plus feature can be used to replace values in the WHERE clause?

This feature cannot be implemented through /SQL*Plus.

Substitution variables

Replacementvariables

Instead-of variables

Answer

Correct Answer: Substitution variables

Note: This Question is unanswered, help us to find answer for this one

51. In Oracle "view" consists of:

The whole table

Indexed output of the table

The definition only

The output of the table

Answer

Correct Answer: The definition only

Note: This Question is unanswered, help us to find answer for this one

52. What operator would you choose to prevent this Oracle error message? ORA-01427:single -row subquery returns more than one row

Use the >= operator

Use the IN operator

Use the CAN EXIST operator

Use the <= operator

Use the = operator

Answer

Correct Answer: Use the IN operator

Note: This Question is unanswered, help us to find answer for this one

53. When a user process fails, this background process will clean up after it:

PMON

SQLMON

WRAP

SESSIONMON

Answer

Correct Answer: PMON

Note: This Question is unanswered, help us to find answer for this one

54. Order the following entities from the smallest to the largest:

Segments, extents, data blocks, tablespaces

Data blocks, extents, segments, table spaces

Extents, data blocks, segments, tablespaces

Table spaces, data blocks, extents, segments

Answer

Correct Answer: Data blocks, extents, segments, table spaces

Note: This Question is unanswered, help us to find answer for this one

55. What command is used to restore an "accidentally" dropped table?

flashback table <tablename> to before drop

rollback table <tablename> to before drop

rollback to segment

alter database cancel drop <tablename>

Answer

Correct Answer: flashback table <tablename> to before drop

Note: This Question is unanswered, help us to find answer for this one

56. "Select for Update" performs:

Lock the record on result set

Unlock the record on result set

Select the record and deelete

Update the record set

Answer

Correct Answer: Lock the record on result set

Note: This Question is unanswered, help us to find answer for this one

57. The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? select * from HR

You obtain the results retrieved from the HR table that belongs to your schema.

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

You obtain the results retrieved from the public synonym HR created by the database administrator

You get an error message because you cannot retrieve from a table that has the same name as a public synonym

Answer

Correct Answer: You obtain the results retrieved from the HR table that belongs to your schema.

Note: This Question is unanswered, help us to find answer for this one

58. What is the definition of data buffer cache?

An area that is used to allocate the I/O buffers from shared memory

An area in SGA that is used to store the most recently used data block

Circular buffer that holds information about changes made to the database

An area in SGA taht contains the database checkpoints

Answer

Correct Answer: An area in SGA that is used to store the most recently used data block

Note: This Question is unanswered, help us to find answer for this one

59. The Oracle Certification Program contains three levels. Which of these is not one of them?

Oracle Certified Developer (OCD)

Oracle Certified Master (OCM)

Oracle Certified Associate (OCA)

Oracle Certified Professional (OCP)

Answer

Correct Answer: Oracle Certified Developer (OCD)

Note: This Question is unanswered, help us to find answer for this one

60. Regarding Oracle, what does DES most commonly mean?

Digital Encryption System

Data Entry Sheet

Dynamic Energy Saver

Data Encryption Standard

Data Extraction Segment

Answer

Correct Answer: Data Encryption Standard

Note: This Question is unanswered, help us to find answer for this one

61. REPLACE ('CUCKOO AND CARLIE', 'C', 'CH') will return:

CUCKOO AND CARLIE

CHUCKOO AND CHARLIE

CHUCHKOO AND CARLIE

CHUCHKOO AND CHARLIE

Answer

Correct Answer: CHUCHKOO AND CHARLIE

Note: This Question is unanswered, help us to find answer for this one

62. Which one of the following is not a DDL (Data Definition Language) command?

Drop

Update

Alter

Create

Answer

Correct Answer: Update

Note: This Question is unanswered, help us to find answer for this one

63. A block is the smallest unit of logical storage that the Relational Database Management System (RDBMS) can manipulate. Block size is determined by which of the following database parameter?

DB_SYSTEM_CLUSTER_SIZE

DB_BLOCK_SIZE

DB_SYSTEM_BLOCK_SIZE

DB_CLUSTER_SIZE

Answer

Correct Answer: DB_BLOCK_SIZE

Note: This Question is unanswered, help us to find answer for this one

64. SQL stands for:

Standard Query Language

Sequential Query Language

Structured Query Language

Symmetric Query Language

Answer

Correct Answer: Structured Query Language

Note: This Question is unanswered, help us to find answer for this one

65. In business, what is the most common definition for ERP?

Electronic Resource Planning

Electronic Resource Pricing

Early Retirement Plan

Employee Referral Program

Enterprise Resource Planning

Answer

Correct Answer: Enterprise Resource Planning

Note: This Question is unanswered, help us to find answer for this one

66. Which operator will help to filter out all duplicate records?

distinct

join

order by

delete

Answer

Correct Answer: distinct

Note: This Question is unanswered, help us to find answer for this one

67. In terms of Oracle, what is the most common meaning of OEM?

Order Entry Module

Oracle Enterprise Manager

Oracle Equipment Model

Oracle Entry Manager

Original Equipment Manufacturer

Answer

Correct Answer: Oracle Enterprise Manager

Note: This Question is unanswered, help us to find answer for this one

68. What clause follows "group by" in SQL?

Having

When

Not in

Answer

Correct Answer: Having

Note: This Question is unanswered, help us to find answer for this one

69. You need to search for text data in a column, but you only remember part of the string. Which of the following SQL operations allows the use of wildcard comparisons?

BETWEEN

EXISTS

Answer

Correct Answer: LIKE

Note: This Question is unanswered, help us to find answer for this one

70. The DBA assigns permission to the user using this command:

Table

Lock

Role

Answer

Correct Answer: Role

Note: This Question is unanswered, help us to find answer for this one

71. True or False: "Select for Update" performs the function "Lock the record on result set."

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

72. Which of the following is(are) physical storage file(s) of Oracle?

Redo log files

Control files

All of these

Data files

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

73. Which of the following operators can be used to substitute the 'IN' operator in a SELECT statement?

AND

BETWEEN ... AND

Answer

Correct Answer: BETWEEN ... AND

Note: This Question is unanswered, help us to find answer for this one

74. Define Index:

Create another column

Random form of data

Create another table

Ordered form of data

Answer

Correct Answer: Ordered form of data

Note: This Question is unanswered, help us to find answer for this one

75. In business, what is the most common definition for CRM?

Contact Relationship Marketing

Customer Relationship Management

Client Relationship Management

Customer Relationship Marketing

Customer Resource Management

Answer

Correct Answer: Customer Relationship Management

Note: This Question is unanswered, help us to find answer for this one

76. SQL statement operator that tests whether a field value is unavailable, unassigned or unknown is:

IS NOTHING

IS NULL

= NULL

IS EMPTY

Answer

Correct Answer: IS NULL

Note: This Question is unanswered, help us to find answer for this one

77. Which of these is not a real Oracle suite option?

Oracle E-Business Suite

Oracle Enterprise Manager

Oracle Developer Suite

Oracle Customer Service Suite

Oracle Application Server

Answer

Correct Answer: Oracle Customer Service Suite

Note: This Question is unanswered, help us to find answer for this one

78. Which of the following are system privileges?

SELECT and DELETE

CREATE TABLE and DROP TABLE

DELETE and UPDATE

CREATE TABLE and SELECT

Answer

Correct Answer: CREATE TABLE and DROP TABLE

Note: This Question is unanswered, help us to find answer for this one

79. DBMS_SCHEDULER, along with the power of PL/SQL, provides a mechanism for automating some of the daily tasks. Which of the following is an advantage of using DBMS_SCHEDULER?

Makes your environment the same across the enterprise

Is relatively easy to grant or revoke access for each specific job to other user

Is capable of running a program, anonymous PL/SQL blocks, stored procedure, executables or even a chain of commands

All of these

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

80. A rollback segment can be specified as either PUBLIC or PRIVATE. The value of PCTINCREASE of a rollback segment is always set to:

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

81. How many columns are there in a Dual table?

Answer

Correct Answer: 1

Note: This Question is unanswered, help us to find answer for this one

82. Which of the following statements is true about rebuilding indexes?

They can be rebuilt online

Performed by issuing the command ALTER INDEX

All of these

Rebuilding indexes doesn't need a lock on the table

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

83. Which of the following statement correctly decribes how to rebuild an index?

ALTER INDEX index_name REBUILD

ALTER index_name REBUILD

ALTER INDEX REBUILD index_name

index_name REBUILD

Answer

Correct Answer: ALTER INDEX index_name REBUILD

Note: This Question is unanswered, help us to find answer for this one

84. What view would you use to look at the size of a data file?

DBA_FREE_SPACE

DBA_DATA_FILES

FILES_DBA_SPACE

FREE_DATA_FILES

Answer

Correct Answer: DBA_DATA_FILES

Note: This Question is unanswered, help us to find answer for this one

85. Remote access of database can be made by:

SGA

PMON

SQL star plus

Database Link

Answer

Correct Answer: Database Link

Note: This Question is unanswered, help us to find answer for this one

86. In a sequence, Curval returns:

Less then current value

More than current value

Present Value

Zero

Answer

Correct Answer: Present Value

Note: This Question is unanswered, help us to find answer for this one

87. The source code of procedure, function and package bodies can be queried from which data dictionary?

DBA_SOURCE

All of these

USER_SOURCE

ALL_SOURCE

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

88. Which naming rules are applied to tables?

Start with a letter

Can have the same name as any database object if that object is not owned by the same user

All of these

Can contain characters such as $, _ and #

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

89. What will the shortcut "Ctrl + F11" do?

Update Record

Enter Query

Clear Record

Execute Query

Exit

Answer

Correct Answer: Execute Query

Note: This Question is unanswered, help us to find answer for this one

90. Which statement about views are true?

A view must have aliases defined for the column names in the SELECT statement.

A view can be created as a join on two or more tables.

A view cannot have an ORDERBY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.

Answer

Correct Answer: A view can be created as a join on two or more tables.

Note: This Question is unanswered, help us to find answer for this one

91. The transaction control that prevents more than one user from updating data in a table is which of the following (choose one)?

lock

commit

savepoint

rollback

Answer

Correct Answer: lock

Note: This Question is unanswered, help us to find answer for this one

92. What are the parts of a Package?

Header, Body and Footer

Header and Footer

Main, Content and Footer

Spec and Body

Answer

Correct Answer: Spec and Body

Note: This Question is unanswered, help us to find answer for this one

93. What does the acronym RDBMS mean?

Relational Database Manager System

Rational Database Management System

Rational Database Manager System

Relational Database Management System

Ratio Database Management System

Answer

Correct Answer: Relational Database Management System

Note: This Question is unanswered, help us to find answer for this one

Oracle Database MCQs | Topic-wise

MCQ on Basic Oracle Database

General Oracle Database MCQs

Buy us a coffee

Oracle Database Subjects

More Resources

Oracle Database MCQ

Oracle Database Skill Assessment

Oracle Database PDF

Related MCQs

OS (Operating System) MCQs

Pay per click (PPC) MCQs

Paypal Web Integration MCQs

PayPal-Development MCQs

Perl MCQs

Basic Oracle Database MCQ

1. Which of the follwing is NOT associated with an instance?

2. To truncate table changes, use DATA_OBJECT_ID.

3. Users that can see any changed data are:

4. The default value of SHARED_POOL_SIZE is:

5. Which of these tasks is NOT performed during the database mounting process?

6. Which of the following falsely sums up Oracle’s locking policy?

7. Rowid on oracle stores:

8. Does "Not in" use an index?

9. In what value do these 3 statements differ from one another? select * from employees where department_id = 60; SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 60; select /* a_comment */ * from employees where department_id = 60;

10. What is the number of user defined triggers in Oracle?

11. Which of the following statements are true about deleting or updating a statement?

12. The only users recognized by the password file are:

13. In Forms, what keyboard shortcut will access the shortcut menu?

14. The basic units that make up a PL/SQL are called:

15. In an Oracle RAC environment, a physical standby database will be registered with the clusterware. When creating the clusterware resource for the standby database, which of the following commands do you use to perform this registration?

16. Which of the following parameters specifies whether Oracle checks for a password file?

17. There are 2 classifications of an index: by logical design and by physical implementation. From its logical design, indexes can have the following types, except:

18. How do you switch from an init.ora file to a spfile?

19. Which of the following best describes how to have requests serviced by an Oracle server (using either dedicated or shared server)?

20. This structure is not included in the Shared Pool contents.

21. The Oracle server provides a number of standard data dictionary views to obtain information on database and instance. These views are:

22. Which one of these statements is true about a concatenated index?

23. When executing the command: "show parameter xxxx", ORA-00942: table or view does not exist appears. Which of the following best explains this error?

24. One of these datatypes is NOT a base scalar datatype?

25. Before any SQL statement is parsed, Oracle will check the _______ to see if that same statement already exists there.

26. Which of the following cannot be placed in the declaration part of PL/SQL?

27. What happens if the command ALTER TABLE <tablename> DEALLOCATE UNUSED is used without the KEEP clause?

28. The init.ora parameter that controls the location of the Alert log file is:

29. How does PL/SQL allow programmers to use it on any host environment?

30. This type of error can be solved by increasing the undo retention of increasing the size of rollbacks.

31. The background process that checks for consistency of the database is called:

32. The most effective way to re-order the columns in a table is:

33. Oracle default optimization follows:

34. Which of the following is a good suggestion for avoiding unnecessary extension of a rollback segment?

35. Which of these programs is the most popular choice to load data directly into Oracle E-Business Suite?

36. Given the following data in the emp table: ENAME SALARY : PING 5000 AILYN 4999 SAM 1000 LESLIE 3000 TOM 2500 RAVI 10000 What will the following select statement produce? SELECT ename FROM emp WHERE salary BETWEEN 3000 AND 5000;

37. When you issue the command "ALTER DATABASE BACKUP CONTROLFILE TO TRACE", a text script version of backup control file will be created. Where is this file located?

38. Which function is not in DBMS_OUTPUT?

39. A "virtual" table name to query the current time is:

40. This protects the library cache from becoming corrupted by concurrent modifications by two sessions or by one session trying to read information that is being modified by another one.

41. What happends when you execute one transcaction and then truncate another table?

42. Implicit Cursor works when:

43. Which of these is NOT an Oracle "database option?"

44. What will happen if PL/SQL variables occur in SQL statements and have the same name as a table column

45. Which of the following actions are performed by the MINUS operator?

46. The "materialized view" in Oracle stores:

47. The IN operator is used when you are using a subquery which returns more than one record. What is the operator used in a correlated subquery?

48. Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

49. Which of these statement is NOT true?

50. Which /SQL*Plus feature can be used to replace values in the WHERE clause?

51. In Oracle "view" consists of:

52. What operator would you choose to prevent this Oracle error message? ORA-01427:single -row subquery returns more than one row

53. When a user process fails, this background process will clean up after it:

54. Order the following entities from the smallest to the largest:

55. What command is used to restore an "accidentally" dropped table?

56. "Select for Update" performs:

58. What is the definition of data buffer cache?

59. The Oracle Certification Program contains three levels. Which of these is not one of them?

60. Regarding Oracle, what does DES most commonly mean?

61. REPLACE ('CUCKOO AND CARLIE', 'C', 'CH') will return:

62. Which one of the following is not a DDL (Data Definition Language) command?

63. A block is the smallest unit of logical storage that the Relational Database Management System (RDBMS) can manipulate. Block size is determined by which of the following database parameter?

64. SQL stands for:

65. In business, what is the most common definition for ERP?

66. Which operator will help to filter out all duplicate records?

67. In terms of Oracle, what is the most common meaning of OEM?

68. What clause follows "group by" in SQL?

69. You need to search for text data in a column, but you only remember part of the string. Which of the following SQL operations allows the use of wildcard comparisons?

70. The DBA assigns permission to the user using this command:

71. True or False: "Select for Update" performs the function "Lock the record on result set."

72. Which of the following is(are) physical storage file(s) of Oracle?

73. Which of the following operators can be used to substitute the 'IN' operator in a SELECT statement?

74. Define Index:

75. In business, what is the most common definition for CRM?

76. SQL statement operator that tests whether a field value is unavailable, unassigned or unknown is:

77. Which of these is not a real Oracle suite option?

78. Which of the following are system privileges?

79. DBMS_SCHEDULER, along with the power of PL/SQL, provides a mechanism for automating some of the daily tasks. Which of the following is an advantage of using DBMS_SCHEDULER?

80. A rollback segment can be specified as either PUBLIC or PRIVATE. The value of PCTINCREASE of a rollback segment is always set to:

9. In what value do these 3 statements differ from one another? select * from employees where department_id = 60; SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 60; select /* a_comment / from employees where department_id = 60;