1. Which of the following is/are the default index(es) provided by Oracle Database 12c?
2. 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?
3. 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;
4. A table Employee is given with the following attributes:
5. 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?
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?
7. Which of the following statements is/are correct about lightweightjobs in Oracle Database 12c?
8. For which of the following platforms in Oracle Database 12c, remote operating system authentication over a secure connection is supported?
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
10. While using DBMS_STATS.SET_'_PREFS procedures for setting statistics preferences, which of the following options is the correct order of precedence?
11. 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?
12. In Oracle Database 12c, which of the following statements is NOT valid?
13. 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
14. What is the relative file number of a data file to identify a bigfile tablespace on the 0s/390 platform?
15. Which of the given SQL statements is equivalent to the following SQL statement?
16. We can create database objects in an undo tablespace.
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?
18. We can use the following SQL command to disable remote jobs on a database: DROP USER REMOTE_SCHEDULER_AGENT CASCADE;
19. In Oracle Database 12c, how many files, with up to 4M block each, can be contained by a smallfile tablespace?
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?
21. Which of the following DBMS_STATS procedures for gathering optimizer statistics is used to collect statistics for all system schemas?
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?
23. Which of the following SQL commands disables the force full database caching?
24. In Oracle Database 12c, which of the following statements is NOT correct about Temporary tablespaces?
25. In Oracle Database 12c, what is the minimum size permitted for a redo log file?
26. Which of the following statements can be used to change the open mode of a current PDB to mounted?
27. In Oracle Database 12c, which of the following statements can be used to drop redo log group number 3?
28. Which of the following statements can be used to change the open mode of a current PDB. from mounted to migrate?
29. Which of the following scripts is used to run all the scripts that are required for or used with PL/SQL?
30. In Oracle 12c database, the user session becomes public when you connect with the database as:
31. In Oracle Database 12c, which of the following types of operations are NOT permissible in distributed transactions?
32. A table named PurchaseDetails has the following table structure:
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?
34. In Oracle Database 12c. which of the following statements is/are correct about managing Temporary Undo?
35. In Oracle Database 12c, which of the following statements is/are correct about ADMINISTER_RESOURCE_MANAGER system privilege?
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. 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?
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.
39. 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?
40. In Oracle Database 12c. which of the following indexes are specific tan application/cartridge?
41. 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
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?
43. Which of the following statements are correct about Global database link?
44. 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
45. Output of command? SOL> SELECT NAME FROM V$CONTROLFILE;
46. In Oracle Database 12c. which of the following options is the correct statement for backing up the control file ta binary file?
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?
48. 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
49. In Oracle Database 12c. multiple buffer pools are available for which of the following block size caches?
50. What is the permissible range of values for DDL_LOCK_TIMEOUT parameter tenable blocking DDL statements twait for locks?
51. In Oracle 12c Database. which of the following administrative privileges allow(s) you tdrop the database?
52. While cloning a PDB, which of the following requirements are valid?
53. Which of the following statements are correct about tablespaces in Oracle Database 12c?
54. 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?
55. 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?
56. In Oracle Database 12c. which of the following table types CANNOT have invisible columns?
57. Which of the following are included in the control file of Oracle Database 12c?
58. Which of the following statements are correct about DBMS_REPAIR procedures?
59. In Oracle Database 12c, which of the following resource consumer groups are the special groups that cannot be modified or deleted and are always present in the data dictionary?
60. Which of the following statements can be used tenable or disable triggers in Oracle Database 12C?
61. In Oracle Database 12c, which of the following options is/are the correct scheduling method(s) used for job execution?
62. Which of the following Subqueries will work?
63. While working with Oracle Database 12c. which of the following transaction control statements are supported in distributed transaction?
64. Which of the following statements is/are correct about pluggable and container databases in a multitenant environment?
65. Which of the following are DML statements?
66. Which of the following are DCL statements?
67. While deferring constraint checks in Oracle Database 12c, which of the following statements hold true?
68. Find the error in the following query. if the Students table contains several records.
69. Which of the following are the new features in Oracle Database 12c?
70. 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?
71. In Oracle Database 12c, the RENAME statement is used trename which of the following schema objects?