Oracle 12c Admin MCQs
Oracle 12c Admin MCQs
Our team has conducted extensive research to compile a set of Oracle 12c Admin MCQs. We encourage you to test your Oracle 12c Admin knowledge by answering these 70+ multiple-choice questions provided below.
Simply scroll down to begin!
1: Which of the following is/are the default index(es) provided by Oracle Database 12c?
A. Domain index
B. Bitmap index
C. B - tree index
D. Global and local
A.
System Global Area (SGA)
B.
Program Global Area (PGA)
C.
Neither a nor b
Which of the following statements are valid in Oracle Database 12c?
1.ANALYZE INDEX indx_pv VALIDATE STRUCTURE;
2.ANALYZE TABLE tbemployees VALIDATE STRUCTURE CASCADE;
3.ANALYZE TABLE tbemployees VALIDATE STRUCTURE ONLINE;
4.ANALYZE CLUSTER clpersonnel VALIDATE STRUCTURE CASCADE;
A.
Only statements 2 and 3 are valid
B.
All statements 1. 2. 3 and 4 are valid
C.
Only statements 2, 3 and 4 are valid
D.
Only statements 3 and 4 are valid
4: A table Employee is given with the following attributes:
A. Employeeld
B. EmployeeName
C. Salary
D. Department
A.
SELECT Employeeld, EmployeeName, Salary, Department FROM Employee e WHERE Salary > (SELECT AVG(Salary) FROM Employee WHERE Salary = e.Department);
B.
SELECT Employeeld, EmployeeName, Salary, Department FROM Employee WHERE Salary >
(SELECT AVERAGE(Salary) FROM Employee WHERE Department = Department);
C.
SELECT Employeeld, EmployeeName, Salary, Department FROM Employee WHERE Salary >
(SELECT AVG(Salary) FROM Employee WHERE Department = Department);
D.
SELECT Employeeld, EmployeeName, Salary, Department FROM Employee 9 WHERE Salary >(SELECT AVG(Salary) FROM Employee WHERE Department = e.Department);
6: A production house needs a report about the sale, where total sale of the day is more than $20,000.Which query should be used?
A. 0 select‘ from orders where sum(amount) > 20000;
B. 0 select orderdate. sum(amount) from orders where sum(amount) > 20000 order by OrderDate;
C. 0 select orderdate. sum(amount) from orders group by orderdate having sum(amount) > 20000;
D. 0 select orderdate. sum(amount) from orders group by OrderDate where sum(amount) > 20000;
7: Which of the following statements is/are correct about lightweightjobs in Oracle Database 12c?
A. They are schema objects like regular jobs
B. Average session creation time for lightweight jobs is lower than regularjobs
C. Regularjobs have significantly better create and drop times than lightweightjobs
D. Both options b and c are correct
8: For which of the following platforms in Oracle Database 12c, remote operating system authentication over a secure connection is supported?
A. Linux platform
B. Unix platform
C. Mac OS platform
D. Windows platform
9: While encrypting a tablespace in Oracle Database 12c, which of the following segments are supported for encryption? 1.Tables 2.Clusters 3.lndexes 4.LOBs
A. Only1 and 3 are supported
B. Only 1, 2 and 3 are supported
C. Only 1, 3 and 4 are supported
D. All 1, 2, 3 and 4 are supported
While using DBMS_STATS.SET_'_PREFS procedures for setting statistics preferences, which of the following options is the correct order of precedence?
A.
1.Table preference
2.Global preference
3.Default preference
B.
1.Globa| preference
2.Table preference
3.Default preference
C.
1.Default preference
2.Global preference
3.Table preference
D.
1.Default preference
2.Table preference
3.Global preference
Which of the given SQL statements will be used to create a table Student having the following attributes, such that the table has a PRIMARY KEY constraint on the column StudentID and also has UNIQUE and NOT NULL constraints on both the columns Phone and City?
StudentlD int
StudentName nvarchar(60
City nvarchar(15)
Region nvarchar(15)
Country nvarchar(15)
Phone nvarchar(20)
A.
CREATE TABLE Student (StudentlD int IDENTITY "PRIMARY KEY", StudentName nvarchar(60) NULL. City nvarchar (15) NOT NULL "UNIQUE". Region nvarchar (15) NULL. Country nvarchar (15) NULL.
Phone nvarchar (20) NOT NULL “UNIQUE");
B.
CREATE TABLE Student (StudentlD int IDENTITY (PRIMARY KEY), StudentName nvarchar (60) NULL. City nvarchar (15) (NOT NULL) (UNIQUE). Region nvarchar (15) NULL. Country nvarchar (15)
NULL, Phone nvarchar (20) (NOT NULL) (UNIQUE));
C.
CREATE TABLE Student (StudentlD int Add Key(PRlMARY), StudentName nvarchar (60)NULL, City nvarchar (15) NOT NULL UNIQUE, Region nvarchar (15) NULL, Country nvarchar(15) NULL, Phone
nvarchar (20) NOT NULL UNIQUE);
D.
CREATE TABLE Student (StudentlD int IDENTITY PRIMARY KEY, StudentName nvarchar(60) NULL, City nvarchar (15) NOT NULL UNIQUE. Region nvarchar (15) NULL, Country nvarchar (15) NULL,
Phone nvarchar (20) NOT NULL UNIQUE);
12: In Oracle Database 12c, which of the following statements is NOT valid?
A. TRUNCATE TABLE emp DROP ALL STORAGE;
B. TRUNCATE CLUSTER emp_desg DROP ALL STORAGE;
C. TRUNCATE CLUSTER emp_dept REUSE STORAGE;
D. TRUNCATE TABLE emp REUSE STORAGE;
E. All of the above statements are valid
In a multitenant environment, which of the following techniques can be used to create a pluggable database (PDB)?
1.Using the files of a seed
2.C|oning an existing PDB or non—CDB
3.Using an XML metadata file that describes the PDB and the files associated with the PDB
4.Moving a non—CDB into a PDB
A.
All 1, 2, 3 and 4 can be used
B.
0 Only1 and 2 can be used
C.
0 Only 1, 2 and 3 can be used
D.
0 Only 1, 2 and 4 can be used
14: What is the relative file number of a data file to identify a bigfile tablespace on the 0s/390 platform?
A. 1024
B. 2048
C. 4096
D. 1022
15: Which of the given SQL statements is equivalent to the following SQL statement?
A. SELECT c.customer_id, d.order_id, c.customer_name, d.order_price FROM customer c, orders (IWHERE c.order_id = d.order_id;
B. SELECT customer_id. order_id. customer_name. order_price FROM customer WHERE order_id IN (SELECT order_id FROM orders);
C. SELECT customer_id, order_id, customer_name. order_price FROM customer NATURAL JOIN orders;
D. SELECT c.customer_id. d.order_id, c.customer_name, d.order_price FROM customer c JOIN orders d ON c.order_id = d.order_id;
E. SELECT c.customer_id, d.order_id, c.customer_name, d.order_price FROM customer JOIN orders USING (c.order_id = d.order_id;);
16: We can create database objects in an undo tablespace.
A. True
B. False
17: While allocating memory for dynamic components in the System Global Area (SGA), what will be the granule size, if the requested SGA memory is greater than 16 GB and less than or equal to 32 GB?
A. 32 MB
B. 64 MB
C. 128 MB
D. 512 MB
18: We can use the following SQL command to disable remote jobs on a database: DROP USER REMOTE_SCHEDULER_AGENT CASCADE;
A. True
B. False
19: In Oracle Database 12c, how many files, with up to 4M block each, can be contained by a smallfile tablespace?
A. 64
B. 128
C. 512
D. 1022
20: While managing diagnostic data in Oracle Database 12c. which of the following files contain a memory dump, in an all- binary and port - specific format?
A. Trace files
B. Dumps
C. Core files
D. None of the above
21: Which of the following DBMS_STATS procedures for gathering optimizer statistics is used to collect statistics for all system schemas?
A. GATHER_TABLE_STATS
B. GATHER_DICTIONARY_STATS
C. GATHER_SCHEMA_STATS
D. GATHER_INDEX_STATS
22: In Oracle Database 12c, which of the following tablespace data dictionary views is used to display the total used and free space in all temporary tablespaces?
A. V$TEMPSEG_USAGE
B. V$TEMP_SPACE_HEADER
C. DBA_TEMP_FILES
D. DBA_TEMP_FREE_SPACE
23: Which of the following SQL commands disables the force full database caching?
A. ALTER DATABASE DISABLE FORCE FULL CACI-IING;
B. ALTER DATABASE DISABLE FORCE FULL DATABASE CACHING;
C. ALTER DATABASE NO FORCE FULL CACHING;
D. ALTER DATABASE NO FORCE FULL DATABASE CACHING;
24: In Oracle Database 12c, which of the following statements is NOT correct about Temporary tablespaces?
A. Temporary tablespaces can be used to store temporary Lobs
B. Temporary tablespaces can be used to store temporary B—trees
C. We can explicitly create objects in a temporary tablespace
D. Multiple users can share a single temporary tablespace
25: In Oracle Database 12c, what is the minimum size permitted for a redo log file?
A. 128 KB
B. 512 MB
C. 4 MB
D. 12 MB
26: Which of the following statements can be used to change the open mode of a current PDB to mounted?
A. ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
B. ALTER PLUGGABLE DATABASE OPEN READ ONLY;
C. ALTER PLUGGABLE DATABASE OPEN FORCE:
D. ALTER PLUGGABLE DATABASE OPEN UPGRADE;
27: In Oracle Database 12c, which of the following statements can be used to drop redo log group number 3?
A. DROP LOGFILE GROUP 3;
B. ALTER DATABASE DROP LOGFILE GROUP 3;
C. ALTER DATABASE CLEAR LOGFILE GROUP 3;
D. ALTER DATABASE REMOVE LOGFILE GROUP 3;
28: Which of the following statements can be used to change the open mode of a current PDB. from mounted to migrate?
A. ALTER PLUGGABLE DATABASE OPEN FORCE:
B. ALTER PLUGGABLE DATABASE OPEN UPGRADE;
C. ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE:
D. ALTER PLUGGABLE DATABASE OPEN READ ONLY;
29: Which of the following scripts is used to run all the scripts that are required for or used with PL/SQL?
A. catalogsql
B. catprocsql
C. pupbld.sql
D. None of the above
30: In Oracle 12c database, the user session becomes public when you connect with the database as:
A. SYSDBA administrative privilege
B. SYSOPER administrative privilege
C. SYSBACKUP administrative privilege
D. SYSKM administrative privilege
31: In Oracle Database 12c, which of the following types of operations are NOT permissible in distributed transactions?
A. Data Manipulation Language (DML) transactions
B. Data Control Language (DCL) transactions
C. Data Definition Language (DDL) transactions
D. Transaction Control Statements
32: A table named PurchaseDetails has the following table structure:
A. Table: PurchaseDetails
B. Attributes
C. Purchaser_ld
D. ltem_Name
E. Quantity
F. Pnce
33: Which of the following queries, when run for PurchaseDetails table, will return the names of items and their maximum and minimum prices. such that the maximum price for the items is greater than 600?
A. SELECT ltem_Name, max(Price), min(Price) FROM PurchaseDetails GROUP BY ltem_Name HAVING max(Price) > 600;
B. SELECT ltem_Name, max(Price), min(Price) FROM PurchaseDetails IN (max(Price) > 600);
C. SELECT ltem_Name, maximum(Price), minimum(Price) FROM PurchaseDetails GROUP BY ltem_Name HAVING maximum(Price) > 600;
D. SELECT ltem_Name, maximum(Price), minimum(Price) FROM PurchaseDetails GROUP BY ltem_Name IN (maximum(Price) > 600);
34: In Oracle Database 12c. which of the following statements is/are correct about managing Temporary Undo?
A. It can reduce the size of the redlog
B. It can be enabled for a specific session
C. It cannot be enabled for the whole system
D. Only a and b are correct
35: In Oracle Database 12c, which of the following statements is/are correct about ADMINISTER_RESOURCE_MANAGER system privilege?
A. It can be granted or revoked using DBMS_RESOURCE_MANAGER_PRIVS package
B. It can be granted or revoked using SQL GRANT or REVOKE statements
C. Both a and b are correct
D. Neither a nor b is correct
36: For a multitenant environment, which of the following options is the correct command-line tool that can be used tcreate, manage and monitor pluggable and multitenant container databases?
A. DBCA
B. Oracle Enterprise Manager Cloud Control
C. Oracle SQL Developer
D. SQL’PIus
37: Which of the following components of a container database, is a template that can be used tcreate a new pluggable database while working with a multitenant environment?
A. Root
B. Seed
C. PDB
D. None of the above
38: Choose the appropriate query for the Products table where data should be displayed. firstly. In ascending order of the ProductGroup column and then. sorting should be in descending order of the CurrentStock column.
A. Select * from Products order by CurrentStock,ProductGroup
B. Select * from Products order by CurrentStock DESC,ProductGroup
C. Select " from Products order by ProductGroup,CurrentStock
D. Select * from Products order by ProductGroup,CurrentStock DESC
On the basis of following statement. answer the given question.
CREATE VIEW dept_hq
AS SELECT dept_id. dept_name, |ocation_id
FROM hr.departments
WHERE |ocation_id = 1400
WITH CHECK OPTION CONSTRAINT dept_hq_cnst;
Which of the following clauses/statements cannot be included in a CREATE VIEW statement?
A.
AS SELECT
B.
FROM
C.
WHERE
D.
WITH CHECK OPTION CONSTRAINT
E.
All of the above can be included in a CREATE VIEW statement
40: In Oracle Database 12c. which of the following indexes are specific tan application/cartridge?
A. B-tree cluster indexes
B. Global and local indexes
C. Hash cluster indexes
D. Domain indexes
In Oracle Database 12c, which of the following statements can be included in an operation using the CREATE SCHEMA statement?
1.CREATE TABLE statement
2.CREATE VIEW statement
3.GRANT statement
A.
Only statements‘l and 2 can be included
B.
Only statementsl and 3 can be included
C.
All statements 1, 2 and 3 can be included
D.
Only statementI can be included
42: While managing jobs, the value of which of the following additional attributes must be set, if you want tcreate an event—based job in Oracle Database 12C?
A. queue_spec
B. event_condition
C. Both a and b must be set
D. Neither a nor b is required tbe set
43: Which of the following statements are correct about Global database link?
A. Database link management is simple and centralized
B. Only a single user's data is associated with a global database link definition
C. It is mandatory for a global database link toperate as a connected user database link
D. All of the above statements are correct
E. Only statements a and c are correct
Which of the given options is correct about the following twSQL statements?
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
A.
Both the statements produce identical results
B.
The second statement returns an error
C.
There is nneed tspecify DESC because the results are sorted in descending order by default
What will be the output of the following command?
SOL> SELECT NAME FROM V$CONTROLFILE;
A.
It will display the database information from the control file
B.
It will display the list of control files
C.
It will display the information about control file record sections
D.
It will display the names of the control files specified in the CONTROL_FILES initialization parameter
46: In Oracle Database 12c. which of the following options is the correct statement for backing up the control file ta binary file?
A. ALTER DATABASE BACKUP CONTROLFILE TTRACE:
B. CREATE BACKUP CONTROLFILE TTRACE;
C. CREATE BACKUP CONTROLFILE T'loracle/backup/control.bkp';
D. ALTER DATABASE BACKUP CONTROLFILE T‘loracIe/backup/control.bkp';
47: If you want tdrop an external destination using DROP_AGENT_DESTINATION procedure in Oracle Database 12C, then which of the following privileges is required tcarry out the task?
A. CREATE JOB
B. ALTER
C. MANAGE SCHEDULER
D. CREATE ANY JOB
Which of the following types of links can be used by a user taccess a remote database?
1.Connected user link
2.Current user link
3.Fixed user link
A.
Only1 and 3 can be used
B.
Only1 and 2 can be used
C.
All 1, 2 and 3 can be used
D.
Only 2 and 3 can be used
E.
Only1 can be used
49: In Oracle Database 12c. multiple buffer pools are available for which of the following block size caches?
A. Standard block size caches
B. Non-standard block size caches
C. Multiple buffer pools are available for both of the given caches
D. Multiple buffer pools are not available for either of the given caches
50: What is the permissible range of values for DDL_LOCK_TIMEOUT parameter tenable blocking DDL statements twait for locks?
A. t1.000 seconds
B. t10.000 seconds
C. t100;000 seconds
D. t1,000,000 seconds
List of Oracle 12c Admin MCQs ...
Available in:
Oracle 12c Admin MCQs
