[Nov 29, 2021] 1Z0-082 Exam Dumps, 1Z0-082 Practice Test Questions
Free 1Z0-082 Study Guides Exam Questions & Answer
Introduction to Oracle 1z0-082: Oracle Database Adminstration 1 Exam
Oracle Database 12c: RAC and Grid Infrastructure Administration Exam assess the abilities of the Database Administrators and System Administrators who have at least 1 year of experience in RAC and Grid Infrastructure. The candidates should have the ability to install, manage, tracking, tuning and restoring RAC databases, cluster, and Oracle Automatic Storage Management (ASM). They should have a good understanding of the architectures of the ASM, Clusterware, and Oracle RAC databases. They should also know how to install, setup, backup, and recovery monitoring and tuning of these components.
Oracle Real Application Clusters (RAC) in database computing is a choice for Oracle Database software developed by Oracle Corporation, it provides clustering software and high availability in Oracle database environments. With the Enterprise Version, Oracle Corporation includes RAC, provided the nodes are clustered using Oracle Clusterware. Oracle RAC allows several machines when accessing a single database, to run Oracle RDBMS software simultaneously, offering to cluster.
The Oracle Grid Infrastructure for an independent server is the Oracle software that offers system support for a database including the file system, volume management, and automation of the restart process. If you want to utilize the Oracle restart or Oracle Automatic Storage Management (ASM) services, you have to install Oracle grid infrastructure before installing Oracle Database.
Difficulty in Writing of Oracle 1z0-082: Oracle Database Administration I Exam
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator Certification is not the most difficult Oracle certification test but taking it without any preparation is likely to fail. Therefore, it is highly recommended that candidates should prepare well by taking 1Z0-068 practice exams. Any questions that are left unanswered will be treated as incorrect therefore you should answer all the questions after the examination of 1Z0-068 dumps even if you are unsure that which is the correct option, mark the most suitable option as your answer so that any question shouldn’t be left as unanswered in 1Z0-068 dumps pdf.
NEW QUESTION 39
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- A. It will always have a 32K blocksize
- B. AUTOEXTEND is possible for the datafile
- C. It must be bigger than the largest SMALLFILE tablespace
- D. It will be a dictionary-managed tablespace by default
- E. Additional data files may not be added
Answer: B,C
NEW QUESTION 40
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- B. The ADR base defaults to $ORACLE_HOME/rdbms/admin if
neither DIAGNOSTIC_DEST nor ORACLE_BASE is set - C. It is held inside an Oracle database schema
- D. It supports diagnostics for Oracle Clusterware
- E. It supports diagnostics for Automatic Storage Management (ASM)
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
NEW QUESTION 41
Examine the description of the CUSTOMERS table:
For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?
- A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_incoms_level IS NOT NULL
AND due_amount IS NOT NULL; - B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL; - C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL; - D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount !=NULL; - E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL;
Answer: B
NEW QUESTION 42
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
- A. A table can have only one primary key and foreign key
- B. Primary key and foreign key constraints can be defined at both the column and table level
- C. Only the primary key can be defined at the column and table level
- D. A table can have only one primary key but multiple foreign keys
- E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
- F. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
- G. The foreign key columns and parent table primary key columns must have the same names
Answer: B,D,E,G
NEW QUESTION 43
Which three are types of segments in an Oracle Database? (Choose three.)
- A. tables
- B. undo
- C. stored procedures
- D. clusters
- E. sequences
- F. index
Answer: A,D,F
Explanation:
http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION 44
Which two statements are true about the SET VERIFY ON command? (Choose two.)
- A. It can be used in SQL Developer and SQL*Plus
- B. It displays values for variables created by the DEFINE command
- C. It displays values for variables used only in the WHERE clause of a query
- D. It displays values for variables prefixed with &&
- E. It can be used only in SQL*Plus
Answer: B,E
NEW QUESTION 45
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
- A. They can be written by background processes
- B. They can be written by server processes
- C. Trace files are written to the Fast Recovery Area (FRA)
- D. All trace files contain error information that require contacting Oracle Support
- E. Trace file names are based on the database name concatenated with a sequential number
Answer: A,B
Explanation:
Reference:
https://gerardnico.com/db/oracle/trace_file
https://docs.oracle.com/html/E25494_01/monitoring001.htm
Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, and other information is for Oracle Support Services. Trace file information is also used to tune applications and instances.
NEW QUESTION 46
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Enable flashback database for an existing database
- C. Configure a nonstandard block size for a new database
- D. Register a new database with an available Enterprise Manager Management server
- E. Change the standard block size of an existing database
Answer: D,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 47
Which two statements are true about single row functions? (Choose two.)
- A. CEIL : can be used for positive and negative numbers
- B. CONCAT : can be used to combine any number of values
- C. FLOOR : returns the smallest integer greater than or equal to a specified number
- D. TRUNC : can be used to combine any number of values
- E. MOD : returns the quotient of a division operation
Answer: D,E
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C
NEW QUESTION 48
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
- A. Oracle Net Manager can be used to centrally configure listeners on any database server target
- B. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
- C. The Oracle Net Configuration Assistant is only used when running the Oracle installer
- D. The lsnrctl utility requires a listener.ora file to exist before it is started
- E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
- F. Oracle Net Manager can be used to locally configure naming methods on a database server
Answer: B,E,F
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/introducing-oracle-net-services.html#GUID-6B1F0584-887D-4D2A-B982-40ACF15DF985
* Oracle Enterprise Manager Cloud Control combines configuration functionality across multiple file systems, along with listener administrative control to provide an integrated environment for configuring and managing Oracle Net Services. * Oracle Net Manager provides configuration functionality for an Oracle home on a local client or server host.
NEW QUESTION 49
Which two statements are true about the PMON background process? (Choose two.)
- A. It kills sessions that exceed idle time
- B. It frees resources held by abnormally terminated processes
- C. It registers database services with all local and remote listeners known to the database instance
- D. It records checkpoint information in the control file
- E. It frees unused temporary segments
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
NEW QUESTION 50
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
- A. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
- B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- C. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- D. CURRENT_DATE returns the current date and time as per the session time zone
- E. SYSDATE can be queried only from the DUAL table
- F. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
Answer: D,E
NEW QUESTION 51
You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)
- A. SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;
- B. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;
- C. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
- D. SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
- E. SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
Answer: B,D
NEW QUESTION 52
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)
- A. Display the total number of products supplied by supplier 102 which have a product status of obsolete
- B. Display suppliers whose PROD_LIST_PRICE is less than 1000
- C. Display the minimum PROD_LIST_PRICE for each product status
- D. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
- E. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
Answer: D,E
NEW QUESTION 53
Which is true about security rules on a compute node?
- A. New security rules can be defined to use only the TCP protocol but multiple port numbers.
- B. A new database deployment on a compute node automatically enables a set of predefined security rules.
- C. A security rule can restrict IP addresses that can connect to a database instance on a compute node.
- D. The port used for HTTPS connections is enabled by default based on a predefined security rule.
- E. A compute node port can be enabled only if it is associated with an existing security rule.
Answer: B
NEW QUESTION 54
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
- A. The WHERE clause can be used to exclude rows after dividing them into groups
- B. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
- C. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
- D. The WHERE clause can be used to exclude rows before dividing them into groups
- E. The HAVING clause can be used with aggregating functions in subqueries
Answer: D,E
NEW QUESTION 55
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- B. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- C. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- F. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
Answer: A,B,E
NEW QUESTION 56
In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully?
(Choose two.)
- A. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- B. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
- C. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- D. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
- E. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
Answer: A,C
NEW QUESTION 57
......
1Z0-082 Exam Dumps, 1Z0-082 Practice Test Questions: https://www.dumps4pdf.com/1Z0-082-valid-braindumps.html
Attested 1Z0-082 Dumps PDF Resource [2021]: https://drive.google.com/open?id=1JF81dBxbmWPa6K-OGGUitbwOhGFeVT-Y