20th
Oct
Oracle MCQ

Oracle MCQ

  • Admin
  • 20th Oct, 2020
  • 418 Followers

Oracle MCQ Quiz

1) What does DLL stands for ?

  • A. Dynamic Language Library
  • B. Dynamic Link Library
  • C. Dynamic Load Library
  • D. None of the above

2) What is the extension of Oracle SQL*Plus file?

  • A. .pls
  • B. .ora
  • C. .txt
  • D. .sql

3) The System Global Area (SGA) is a group of ____, known as SGA components, that contain data and control information for one Oracle Database instance.

  • A. shared memory structures
  • B. partial memory structures
  • C. database
  • D. None of the above

4) Which one is the new feature of Oracle Database 12c?

  • A. Online migration of an active data file
  • B. sql
  • C. stored procedure
  • D. None of the above

5) All of the following can only be used with numeric data types except:

  • A. AVG
  • B. STDDEV
  • C. SUM
  • D. COUNT
Download Free : Oracle MCQ PDF

6) What is the use of an index?

  • A. Retrieve data more quickly and efficiently
  • B. Related data requires much less I/O overhead if accessed simultaneously
  • C. Simplify the user’s perception of data access
  • D. All of the Mentioned

7) The redo log buffer and Shared pool are elements of ___.

  • A. PGA
  • B. SGA
  • C. PGA and Buffer cache
  • D. Buffer cache

8) A Stored Procedure is a ____.

  • A. Sequence of SQL or PL/SQL statements to perform specific function
  • B. Stored in compiled form in the database
  • C. Can be called from all client environmets
  • D. All are Correct

9) Oracle allows you to define procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the associated table. These procedures are called ____.

  • A. database triggers
  • B. table
  • C. row
  • D. language

10) What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

  • A. Application failure
  • B. Rollback failure
  • C. Instance Failure
  • D. Media Failure

11) Which one is the advange of oracle over other RDBMS?

  • A. SQL
  • B. oracle database improves the performance and speed of consideration with transaction control and locking.
  • C. oracle databaseslows the performance and speed of consideration with transaction control and locking.
  • D. None of the above

12) Which of the following statements contains an error?

  • A. SELECT empid FROM emp;
  • B. SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;
  • C. SELECT * FROM emp WHERE empid = 493945;
  • D. SELECT empid FROM emp WHERE empid= 493945;

13) What do you mean by tuple is a RDBMS?

  • A. Row of a table.
  • B. Two dimensional table
  • C. Key of a table.
  • D. Column of a table.

14) Select statement is used to insert records in a database table.

  • A. False
  • B. True

15) Money is defined in Oracle with the Currency data type.

  • A. True
  • B. False

16) Constraints cannot be exported through EXPORT command.

  • A. True
  • B. False

17) ____ is the latest innovations in Oracle.

  • A. Oracle Database 19c
  • B. Oracle Database 29c
  • C. Oracle Database 10
  • D. None of the above

18) Which one of the following SQL phrase is not supported by Oracle?

  • A. ON UPDATE CASCADE
  • B. DROP SEQUENCE [SequenceName]
  • C. ON DELETE CASCADE
  • D. CREATE SEQUENCE [SequenceName]

19) What is the use of Library cache?

  • A. Contains User information, such as user privileges
  • B. Used to store shared SQL
  • C. Log of changes made to the database
  • D. All of the Mentioned

20) When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

  • A. are case insensitive.
  • B. must always be in upper case.
  • C. are case sensitive.
  • D. must always be in lower case.

21) Which prefixes are available to Oracle triggers?

  • A. :new only
  • B. :old only
  • C. Both :new and :old
  • D. Neither :new nor :old

22) The primary key is selected from the:

  • A. Composite keys.
  • B. Foreign keys.
  • C. Determinants.
  • D. Candidate keys.

23) Which of the following is not true of SQL views?

  • A. Oracle views can by queried.
  • B. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
  • C. Oracle views cannot use the ORDER BY clause in view definitions.
  • D. Oracle views are created using the standard SQL-92 CREATE VIEW command.

24) Insert and Update is a ____.

  • A. DDL
  • B. DML
  • C. HTML
  • D. None of the above

25) The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

  • A. PGA
  • B. Library cache
  • C. SGA
  • D. Data dictionary

26) Create, alter and drop are a _____.

  • A. DDL
  • B. DML
  • C. DQL
  • D. DCL

27) SQL is a set-based _____ language that provides an interface to an RDBMS such as Oracle Database.

  • A. declarative
  • B. optionl
  • C. programming
  • D. scripting

28) Which task of the Database Administrator is available for cloning on Oracle home and on a database?

  • A. Download and Install Patches d.
  • B. Roll Out to Additional Hosts
  • C. Back Up the Fully Functional Database
  • D. Tune Database Performance

29) In Oracle, view is a virtual table that does not physically exist. view is created by a ____ one or more tables.

  • A. query joining
  • B. DDL
  • C. DML
  • D. None of the above.

30) Which of the following is the fastest query method for a table?

  • A. Fetch by columnid
  • B. Fetch by indexid
  • C. Fetch by rowid
  • D. Fetch by tableid

31) Where is the data dictionary kept?

  • A. Stack Space
  • B. SYSTEM tablespace
  • C. Data file
  • D. None of the above

32) Which process is an instance made of oracle?

  • A. Memory processes
  • B. Data processes
  • C. Oracle background processes
  • D. All are Correct

33) SQL is a computer language for ______ data stored in a relational database.

  • A. storing, manipulating and retrieving
  • B. creating webpage
  • C. programming code
  • D. None of the above

34) What is SQL*FORMS ?

  • A. SQL*FORMS is a 4GL tool for developing & executing Oracle based interactive applications.
  • B. SQL*FORMS is a 3GL tool for connecting to the Database.
  • C. SQL*FORMS is a reporting tool
  • D. None of the above.

35) In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

  • A. SQL*Plus will automatically show the errors to you.
  • B. The line numbers reported match the line numbers you see in your text editor.
  • C. To see the errors, enter SHOW ERRORS in SQL*Plus.
  • D. If there are no syntax errors, you will receive the message "NO ERRORS."

36) SQL stands for ______.

  • A. Structureral query language
  • B. Structured query language
  • C. Structureral query language
  • D. Script query language

37) How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?

  • A. SELECT [all] FROM EMP WHERE Last_Name LIKE 'KING'
  • B. SELECT [all] FROM EMP WHERE Last_Name ='KING'
  • C. SELECT * FROM EMP WHERE Last_Name LIKE 'KING'
  • D. SELECT * FROM EMP WHERE Last_Name ='KING'

38) A disadvantage of using Oracle is its cost.

  • A. Yes
  • B. No

39) Oracle database design is also called ____.

  • A. Database Instance
  • B. Database Schema
  • C. Database Abstraction
  • D. None of the above

40) Oracle Database is an ___.

  • A. RDBMS
  • B. Query
  • C. laguage
  • D. sql

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Dec
Laravel MCQ
01st
Dec
React JS MCQ
01st
Jan
AngularJs MCQ
01st
Jul
Node js MCQ
01st
Jul
Angular 2 MCQ
01st
Jul
JSON MCQ