Oracle Database MCQs
Oracle Database MCQs
Answer these 100+ Oracle Database MCQs and see how sharp is your knowledge of Oracle Database.
Scroll down and let's start!
1: What does the acronym RDBMS mean?
A. Relational Database Manager System
B. Rational Database Management System
C. Rational Database Manager System
D. Relational Database Management System
E. Ratio Database Management System
2: What are the parts of a Package?
A. Header, Body and Footer
B. Header and Footer
C. Main, Content and Footer
D. Spec and Body
3: The transaction control that prevents more than one user from updating data in a table is which of the following (choose one)?
A. lock
B. commit
C. savepoint
D. rollback
4: Which statement about views are true?
A. A view must have aliases defined for the column names in the SELECT statement.
B. A view can be created as a join on two or more tables.
C. A view cannot have an ORDERBY clause in the SELECT statement.
D. A view cannot be created with a GROUP BY clause in the SELECT statement.
5: What will the shortcut "Ctrl + F11" do?
A. Update Record
B. Enter Query
C. Clear Record
D. Execute Query
E. Exit
6: Which naming rules are applied to tables?
A. Start with a letter
B. Can have the same name as any database object if that object is not owned by the same user
C. All of these
D. Can contain characters such as $, _ and #
7: Which syntax turns an existing constraint on?
A. LTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;
B. ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
C. ALTER TABLE table_name ENABLE constraint_name;
D. ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;
8: The source code of procedure, function and package bodies can be queried from which data dictionary?
A. DBA_SOURCE
B. All of these
C. USER_SOURCE
D. ALL_SOURCE
9: In a sequence, Curval returns:
A. Less then current value
B. More than current value
C. Present Value
D. Zero
10: Remote access of database can be made by:
A. SGA
B. PMON
C. SQL star plus
D. Database Link
11: What view would you use to look at the size of a data file?
A. DBA_FREE_SPACE
B. DBA_DATA_FILES
C. FILES_DBA_SPACE
D. FREE_DATA_FILES
12: Which of the following statement correctly decribes how to rebuild an index?
A. ALTER INDEX index_name REBUILD
B. ALTER index_name REBUILD
C. ALTER INDEX REBUILD index_name
D. index_name REBUILD
13: Which of the following statements is true about rebuilding indexes?
A. They can be rebuilt online
B. Performed by issuing the command ALTER INDEX
C. All of these
D. Rebuilding indexes doesn't need a lock on the table
14: How many columns are there in a Dual table?
A. 7
B. 1
C. 8
D. 9
15: A rollback segment can be specified as either PUBLIC or PRIVATE. The value of PCTINCREASE of a rollback segment is always set to:
A. 0
B. 6
C. 4
D. 2
16: Which of these is not a language element of SQL?
A. Queries
B. Clauses
C. Expressions
D. None. All are language elements of SQL.
E. Statements
17: 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?
A. Makes your environment the same across the enterprise
B. Is relatively easy to grant or revoke access for each specific job to other user
C. Is capable of running a program, anonymous PL/SQL blocks, stored procedure, executables or even a chain of commands
D. All of these
18: Which of the following are system privileges?
A. SELECT and DELETE
B. CREATE TABLE and DROP TABLE
C. DELETE and UPDATE
D. CREATE TABLE and SELECT
19: Which of these is not a real Oracle suite option?
A. Oracle E-Business Suite
B. Oracle Enterprise Manager
C. Oracle Developer Suite
D. Oracle Customer Service Suite
E. Oracle Application Server
20: SQL statement operator that tests whether a field value is unavailable, unassigned or unknown is:
A. IS NOTHING
B. IS NULL
C. = NULL
D. IS EMPTY
21: In business, what is the most common definition for CRM?
A. Contact Relationship Marketing
B. Customer Relationship Management
C. Client Relationship Management
D. Customer Relationship Marketing
E. Customer Resource Management
22: Define Index:
A. Create another column
B. Random form of data
C. Create another table
D. Ordered form of data
23: What is the purpose of the Rollback command?
A. Undo the last uncommitted transactions
B. Save the last uncommitted transactions
C. Maintains Log of the last uncommitted transactions
D. Redo the last uncommitted transactions
24: Which of the following operators can be used to substitute the 'IN' operator in a SELECT statement?
A. >=
B. AND
C. BETWEEN ... AND
D. <=
25: Which of the following is(are) physical storage file(s) of Oracle?
A. Redo log files
B. Control files
C. All of these
D. Data files
26: Which of the following is not DML (Data Manipulation Language)?
A. Rename
B. Delete
C. Insert
D. Update
27: True or False: "Select for Update" performs the function "Lock the record on result set."
A. True
B. False
28: The DBA assigns permission to the user using this command:
A. Table
B. Lock
C. Role
29: 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?
A. IN
B. BETWEEN
C. LIKE
D. EXISTS
30: What clause follows "group by" in SQL?
A. Having
B. When
C. Not in
D. In
31: In terms of Oracle, what is the most common meaning of OEM?
A. Order Entry Module
B. Oracle Enterprise Manager
C. Oracle Equipment Model
D. Oracle Entry Manager
E. Original Equipment Manufacturer
32: Which operator will help to filter out all duplicate records?
A. distinct
B. join
C. order by
D. delete
33: In business, what is the most common definition for ERP?
A. Electronic Resource Planning
B. Electronic Resource Pricing
C. Early Retirement Plan
D. Employee Referral Program
E. Enterprise Resource Planning
34: SQL stands for:
A. Standard Query Language
B. Sequential Query Language
C. Structured Query Language
D. Symmetric Query Language
35: 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?
A. DB_SYSTEM_CLUSTER_SIZE
B. DB_BLOCK_SIZE
C. DB_SYSTEM_BLOCK_SIZE
D. DB_CLUSTER_SIZE
36: Which one of the following is not a DDL (Data Definition Language) command?
A. Drop
B. Update
C. Alter
D. Create
37: REPLACE ('CUCKOO AND CARLIE', 'C', 'CH') will return:
A. CUCKOO AND CARLIE
B. CHUCKOO AND CHARLIE
C. CHUCHKOO AND CARLIE
D. CHUCHKOO AND CHARLIE
38: Regarding Oracle, what does DES most commonly mean?
A. Digital Encryption System
B. Data Entry Sheet
C. Dynamic Energy Saver
D. Data Encryption Standard
E. Data Extraction Segment
39: The Oracle Certification Program contains three levels. Which of these is not one of them?
A. Oracle Certified Developer (OCD)
B. Oracle Certified Master (OCM)
C. Oracle Certified Associate (OCA)
D. Oracle Certified Professional (OCP)
40: What is the definition of data buffer cache?
A. An area that is used to allocate the I/O buffers from shared memory
B. An area in SGA that is used to store the most recently used data block
C. Circular buffer that holds information about changes made to the database
D. An area in SGA taht contains the database checkpoints
41: 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
A. You obtain the results retrieved from the HR table that belongs to your schema.
B. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
C. You obtain the results retrieved from the public synonym HR created by the database administrator
D. You get an error message because you cannot retrieve from a table that has the same name as a public synonym
42: "Select for Update" performs:
A. Lock the record on result set
B. Unlock the record on result set
C. Select the record and deelete
D. Update the record set
43: What command is used to restore an "accidentally" dropped table?
A. flashback table <tablename> to before drop
B. rollback table <tablename> to before drop
C. rollback to segment
D. alter database cancel drop <tablename>
44: Order the following entities from the smallest to the largest:
A. Segments, extents, data blocks, tablespaces
B. Data blocks, extents, segments, table spaces
C. Extents, data blocks, segments, tablespaces
D. Table spaces, data blocks, extents, segments
45: When a user process fails, this background process will clean up after it:
A. PMON
B. SQLMON
C. WRAP
D. SESSIONMON
46: What operator would you choose to prevent this Oracle error message? ORA-01427:single -row subquery returns more than one row
A. Use the >= operator
B. Use the IN operator
C. Use the CAN EXIST operator
D. Use the <= operator
E. Use the = operator
47: What is true about this set of statements? CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT;
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
C. The DESCRIBE DEPT statement returns an error ORA-04043:object DEPT does not exist
D. The ROLLBACK statement frees the storage space occupied by the DEPT table.
48: In Oracle "view" consists of:
A. The whole table
B. Indexed output of the table
C. The definition only
D. The output of the table
49: You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?
A. GRANTselect,insert,modify ON student_grades TO manager WITH GRANT OPTION;
B. .GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
C. GRANT select, insert, update ON student_grades TO manager;
D. GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
50: Which /SQL*Plus feature can be used to replace values in the WHERE clause?
A. This feature cannot be implemented through /SQL*Plus.
B. Substitution variables
C. Replacementvariables
D. Instead-of variables
List of Oracle Database MCQs M...
Available in:
Oracle Database MCQs
Вопросы по База данных Oracle на русском языке
Вопросы по База данных Oracle на русском языке
日本語でのオラクルデータベースの質問
Domande su Banca dati Oracle in lingua italiana
Questions Oracle Database en langues françaises
Questões do Oracle Database em português
Fragen zur Oracle-Datenbank in deutscher Sprache
中文（简体）语言的 Oracle 数据库问题
أسئلة Oracle Database باللغات العربية
Soal Oracle Database dalam bahasa Indonesia
Türkçe dillerde Oracle Veritabanı soruları
