Oracle 1Z0-082 Deluxe Study Guide with Online Test Engine
1Z0-082 dumps review - Professional Quiz Study Materials
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.
NEW QUESTION 69
Examine this command and some partial output:
Why does the DB01.abc.com service show unknown status?
- A. The listener is not listening on the default port 1521
- B. The service DB01.abc.com is dynamically registered
- C. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- D. The service DB01.abc.com is statically registered
- E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
Answer: C
NEW QUESTION 70
Which statement is true about aggregate functions?
- A. The MAX and MIN functions can be used on columns with character data types
- B. Aggregate functions can be used in any clause of a SELECT statement
- C. Aggregate functions can be nested to any number of levels
- D. The AVG function implicitly converts NULLS to zero
Answer: C
NEW QUESTION 71
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- B. A synonym can be available to all users
- C. A synonym created by one user can refer to an object belonging to another user
- D. A SEQUENCE can have a synonym
- E. A synonym cannot be created for a PL/SQL package
Answer: B,C,D
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION 72
Which two statements are true about Enterprise Manager (EM) Express?
- A. You can shut down a database instance using EM Express.
- B. You cannot start up a database instance using EM Express.
- C. EM Express uses a separate repository database to store target database metadata.
- D. By default, EM express is available for a database after database creation using DBCA.
- E. You can use a single instance of EM Express to manage multiple database running on the same server.
Answer: B,D
NEW QUESTION 73
Which two statements are true regarding a SAVEPOINT? (Choose two.)
- A. Rolling back to a SAVEPOINT can undo a DELETE statement
- B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
- C. A SAVEPOINT does not issue a COMMIT
- D. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
- E. Only one SAVEPOINT may be issued in a transaction
Answer: A,C
NEW QUESTION 74
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Multiple row pieces from the same row may be stored in the same block
- B. Index block free space is always contiguous in the middle of the block
- C. A table row piece can be chained across several database blocks
- D. Data block headers contain their own Data Block Address (DBA)
- E. Data block free space is always contiguous in the middle of the block
- F. Multiple row pieces from the same row may be stored in different database blocks
Answer: C,D,F
Explanation:
Reference:
https://antognini.ch/2016/10/whats-the-difference-between-row-migration-and-row-chaining/
NEW QUESTION 75
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?
- A. SUBTRACT
- B. UNION
- C. UNION ALL
- D. MINUS
- E. INTERSECT
Answer: D
NEW QUESTION 76
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
- A. The number of columns selected in each SELECT statement must be identical
- B. The output is sorted by the UNION ALL operator
- C. Duplicates are eliminated automatically by the UNION ALL operator
- D. NULLS are not ignored during duplicate checking
- E. The names of columns selected in each SELECT statement must be identical
Answer: A,D
NEW QUESTION 77
Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED ? (Choose two.) RETENTION
- A. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
- C. Active UNDO is always retained.
- D. UNDO_RETENTION specifies how long all types of UNDO are retained.
- E. Unexpired UNDO is always retained.
Answer: D,E
NEW QUESTION 78
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 the minimum PROD_LIST_PRICE for each product status
- C. Display suppliers whose PROD_LIST_PRICE is less than 1000
- 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 79
Which two types of files are opened by a database instance in the NOMOUNT state?
- A. control files
- B. data files
- C. the alert log
- D. the initialization parameter file
- E. online redo logs
Answer: B,D
NEW QUESTION 80
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
- B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- C. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- D. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
- E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
Answer: B,E
NEW QUESTION 81
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. It supports diagnostics for Oracle Clusterware
- C. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
- D. It supports diagnostics for Automatic Storage Management (ASM)
- E. It is held inside an Oracle database schema
Answer: C,E
NEW QUESTION 82
Which three activities are recorded in the database alert log? (Choose three.)
- A. Data Definition Language (DDL) statements
- B. non-default database parameters
- C. session logins and logouts
- D. block corruption errors
- E. deadlock errors
Answer: B,D,E
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION 83
Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)
- A. V$TABLESPACE displays information about tablespaces contained in the data dictionary
- B. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
- C. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
- D. Tablespace free space can be viewed in V$TABLESPACE
- E. Tablespace free space can be viewed in DBA_TABLESPACES
Answer: B,C
NEW QUESTION 84
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- B. A synonym can be available to all users
- C. A synonym created by one user can refer to an object belonging to another user
- D. A SEQUENCE can have a synonym
- E. A synonym cannot be created for a PL/SQL package
Answer: B,C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION 85
Which two statements are true about single row functions? (Choose two.)
- A. TRUNC : can be used to combine any number of values
- B. FLOOR : returns the smallest integer greater than or equal to a specified number
- C. CONCAT : can be used to combine any number of values
- D. MOD : returns the quotient of a division operation
- E. CEIL : can be used for positive and negative numbers
Answer: A,D
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 86
You want to use table compression suitable for OLTP that will:
* Compress rows for all DML statements on that table
* Minimize the overheads associated with compression
Which compression option is best suited for this?
- A. COLUMN STORE COMPRESS FOR QUERY LOW
- B. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
- C. ROW STORE COMPRESS BASIC
- D. ROW STORE COMPRESS ADVANCED
- E. COLUMN STORE COMPRESS FOR ARCHIVE LOW
Answer: D
NEW QUESTION 87
Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)
- A. The second ROLLBACK command replays the delete
- B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
- C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
- D. The second ROLLBACK command undoes the insert
- E. The second ROLLBACK command does nothing
Answer: C,D
NEW QUESTION 88
A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?
- A. The command fails because the script must refer to the full path name
- B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
- C. The command fails and reports an error because @ is used twice
- D. The command succeeds and HR will be connected to the orcl and abc.sql databases
Answer: B
NEW QUESTION 89
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)
- A. analysis of all privileges used by all users but excluding administrative users in the database
- B. analysis of privileges that a user has on their own schema objects that they did not use
- C. analysis of privileges that a user has on their own schema objects that they did use
- D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
- E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
- F. analysis of all privileges used by all users including administrative users in the database
Answer: A,D,E
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/performing-privilege-analysis-find-privilege-use.html#GUID-AD683DDB-D345-4702-B1F4-37B79F276B66
NEW QUESTION 90
......
Exam Questions Answers Braindumps 1Z0-082 Exam Dumps PDF Questions: https://www.actual4dumps.com/1Z0-082-study-material.html
1Z0-082 Test Prep Training Practice Exam Questions Practice Tests: https://drive.google.com/open?id=1_kRI2mbjK6o2hsvtQBfgDhC3YYbIDoxL