1. Which of the follwing is NOT associated with an instance?
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.
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:
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:
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?
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?
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:
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?
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;
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?
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:
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?
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:
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?
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?
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:
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?
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)?
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.
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:
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?
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?
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?
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.
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?
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?
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:
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?
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.
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:
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:
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:
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?
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?
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;
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?
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?
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:
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.
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?
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:
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?"
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
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?
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:
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?
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?
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?
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?
Answer
Correct Answer:
Substitution variables
Note: This Question is unanswered, help us to find answer for this one
51. In Oracle "view" consists of:
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
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:
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:
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?
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:
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
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?
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?
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?
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:
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?
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?
Answer
Correct Answer:
DB_BLOCK_SIZE
Note: This Question is unanswered, help us to find answer for this one
64. SQL stands for:
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?
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?
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?
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?
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?
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:
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."
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?
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?
Answer
Correct Answer:
BETWEEN ... AND
Note: This Question is unanswered, help us to find answer for this one
74. Define Index:
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?
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:
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?
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?
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?
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?
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?
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?
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:
Answer
Correct Answer:
Database Link
Note: This Question is unanswered, help us to find answer for this one
86. In a sequence, Curval returns:
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?
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?
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?
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?
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)?
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?
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?
Answer
Correct Answer:
Relational Database Management System
Note: This Question is unanswered, help us to find answer for this one