Oracle 12c Admin MCQ Questions Answers

1. In Oracle Database 12c, the RENAME statement is used trename which of the following schema objects?

2. While creating a database password file in Oracle Database 12c, which of the given administrative privileges are supported. if we set the FORMAT argument tvalue. legacy?

3. Which of the following are the new features in Oracle Database 12c?

4. Find the error in the following query. if the Students table contains several records.

5. While deferring constraint checks in Oracle Database 12c, which of the following statements hold true?

6. Which of the following are DCL statements?

7. Which of the following are DML statements?

8. Which of the following statements is/are correct about pluggable and container databases in a multitenant environment?

9. While working with Oracle Database 12c. which of the following transaction control statements are supported in distributed transaction?

10. Which of the following Subqueries will work?

11. In Oracle Database 12c, which of the following options is/are the correct scheduling method(s) used for job execution?

12. Which of the following statements can be used tenable or disable triggers in Oracle Database 12C?

13. In Oracle Database 12c, which of the following resource consumer groups are the special groups that cannot be modif‌ied or deleted and are always present in the data dictionary?

14. Which of the following statements are correct about DBMS_REPAIR procedures?

15. Which of the following are included in the control f‌ile of Oracle Database 12c?

16. In Oracle Database 12c. which of the following table types CANNOT have invisible columns?

17. The given image contains three tables and their attributes. Which of the following queries will determine the names of the Authors whhave written more than one book?

18. While managing optimizer statistics using cloud control in Oracle Database 12c, which of the following operations will you find on the Manage Optimizer Statistics page?

19. Which of the following statements are correct about tablespaces in Oracle Database 12c?

20. While cloning a PDB, which of the following requirements are valid?

21. In Oracle 12c Database. which of the following administrative privileges allow(s) you tdrop the database?

22. What is the permissible range of values for DDL_LOCK_TIMEOUT parameter tenable blocking DDL statements twait for locks?

23. In Oracle Database 12c. multiple buffer pools are available for which of the following block size caches?

24. Which 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

25. 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?

26. In Oracle Database 12c. which of the following options is the correct statement for backing up the control f‌ile ta binary file?

27. Output of command? SOL> SELECT NAME FROM V$CONTROLFILE;

28. Which options is correct about 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

29. Which of the following statements are correct about Global database link?

30. 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?

31. In Oracle Database 12c, which statements can be included in an operation using the CREATE SCHEMA statement? 1.CREATE TABLE statement 2.CREATE VIEW statement 3.GRANT statement

32. In Oracle Database 12c. which of the following indexes are specific tan application/cartridge?

33. 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?

34. 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.

35. 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?

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?

37. In Oracle Database 12c, which of the following statements is/are correct about ADMINISTER_RESOURCE_MANAGER system privilege?

38. In Oracle Database 12c. which of the following statements is/are correct about managing Temporary Undo?

39. 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?

40. A table named PurchaseDetails has the following table structure:

41. In Oracle Database 12c, which of the following types of operations are NOT permissible in distributed transactions?

42. In Oracle 12c database, the user session becomes public when you connect with the database as:

43. Which of the following scripts is used to run all the scripts that are required for or used with PL/SQL?

44. Which of the following statements can be used to change the open mode of a current PDB. from mounted to migrate?

45. In Oracle Database 12c, which of the following statements can be used to drop redo log group number 3?

46. Which of the following statements can be used to change the open mode of a current PDB to mounted?

47. In Oracle Database 12c, what is the minimum size permitted for a redo log file?

48. In Oracle Database 12c, which of the following statements is NOT correct about Temporary tablespaces?

49. Which of the following SQL commands disables the force full database caching?

50. 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?

51. Which of the following DBMS_STATS procedures for gathering optimizer statistics is used to collect statistics for all system schemas?

52. 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?

53. In Oracle Database 12c, how many f‌iles, with up to 4M block each, can be contained by a smallf‌ile tablespace?

54. We can use the following SQL command to disable remote jobs on a database: DROP USER REMOTE_SCHEDULER_AGENT CASCADE;

55. 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?

56. We can create database objects in an undo tablespace.

57. Which of the given SQL statements is equivalent to the following SQL statement?

58. What is the relative f‌ile number of a data f‌ile to identify a bigf‌ile tablespace on the 0s/390 platform?

59. 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 f‌ile that describes the PDB and the f‌iles associated with the PDB 4.Moving a non—CDB into a PDB

60. In Oracle Database 12c, which of the following statements is NOT valid?

61. Which 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?

62. While using DBMS_STATS.SET_'_PREFS procedures for setting statistics preferences, which of the following options is the correct order of precedence?

63. 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

64. For which of the following platforms in Oracle Database 12c, remote operating system authentication over a secure connection is supported?

65. Which of the following statements is/are correct about lightweightjobs in Oracle Database 12c?

66. 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?

67. Which of the following co—related SQL queries will return Employeeld, EmployeeName, Salary and Department of all those employees whose salary is more than the average salary of employees in that employee's department?

68. A table Employee is given with the following attributes:

69. 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;

70. when a server process is started, Oracle Database creates a non-shareMemory that contains data and control information. Which of the following options represents this memory?

71. Which of the following is/are the default index(es) provided by Oracle Database 12c?