Quality 1Z0-082 PDF Dumps - 1Z0-082 Exam Questions
Most UptoDate Oracle 1Z0-082 Exam Dumps PDF 2023
Oracle 1z0-082: Oracle Database Administration 1 Exam Certification Path
The Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator certification is for Database Development Systems Managers and Database Administrators with at least 1 year of RAC and Grid Infrastructure experience. It is also recommended to understand high availability concepts and clustering. To earn this certificate, you should have the ability to install, manage, monitor, and recover RAC databases, Clusterware, and ASM environments. You will get a complete understanding of the architecture of the Clusterware, ASM, and RAC databases while preparing for the exam. After earning this certification, you will gain the skills of installing, setup, backup and recovering, tuning, and monitoring these components. Self-study courses are great sources for the preparation of the Exam, but they do not meet the requirement of the training. To meet the requirement of the training course must be offered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner, or Oracle Workforce Development Program. Courses can be a live virtual class, training on demand, learning subscription, or instructor-led in-class.
NEW QUESTION 33
Which three activities are recorded in the database alert log? (Choose three.)
- A. session logins and logouts
- B. Data Definition Language (DDL) statements
- C. deadlock errors
- D. non-default database parameters
- E. block corruption errors
Answer: C,D,E
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION 34
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Enable flashback database for an existing database
- B. Register a new database with an available Enterprise Manager Management server
- C. Configure a nonstandard block size for a new database
- D. Configure incremental backups for a new database
- E. Change the standard block size of an existing database
Answer: B,E
NEW QUESTION 35
Which is true about roles?
- A. All roles belong to the SYSTEM schema.
- B. A role can be granted to other roles.
- C. Roles containing object privileges can be created only by the object owner.
- D. Roles can be created only by SYS or SYSTEM.
- E. A role can be password-protected only if it has been granted system privileges.
Answer: E
NEW QUESTION 36
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. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- C. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
- 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,B
NEW QUESTION 37
Which two statements are true about Enterprise Manager (EM) Express?
- A. You can use a single instance of EM Express to manage multiple database running on the same server.
- B. EM Express uses a separate repository database to store target database metadata.
- C. You cannot start up a database instance using EM Express.
- D. You can shut down a database instance using EM Express.
- E. By default, EM express is available for a database after database creation using DBCA.
Answer: C,E
NEW QUESTION 38
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 privileges granted indirectly to a role that are then used by a user who has been granted that role
- B. analysis of all privileges used by all users but excluding administrative users in the database
- C. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
- D. analysis of privileges that a user has on their own schema objects that they did not use
- E. analysis of all privileges used by all users including administrative users in the database
- F. analysis of privileges that a user has on their own schema objects that they did use
Answer: A,D,E
NEW QUESTION 39
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:
What must you do so that KING is authenticated by the OS when connecting to the database instance?
- A. Unset REMOTE_LOGIN_PASSWORDFILE
- B. Set OS_AUTHENT_PREFIX to OPS$
- C. Grant DBA to KING
- D. Have the OS administrator add KING to the OSDBA group
- E. Alter user KING to be IDENTIFIED EXTERNALLY
Answer: A
NEW QUESTION 40
You must create a tablespace of non-standard block size in a new file system and plan to use this command:
The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?
- A. The /u02 file system must have at least lOOg space for the datafile.
- B. db_32k_cache_size must be set to a value that can be accommodated in the SGA.
- C. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.
- D. d3_32k_cache_size should be set to a value greater than db_cache_size.
- E. db_32r_cache_si2e must be less than db_ca=he_size.
- F. The operating system must use a 32k block size.
Answer: C,E
NEW QUESTION 41
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
- A. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
- B. The Oracle Net Configuration Assistant is only used when running the Oracle installer
- C. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
- D. Oracle Net Manager can be used to centrally configure listeners on any database server target
- E. Oracle Net Manager can be used to locally configure naming methods on a database server
- F. The lsnrctl utility requires a listener.ora file to exist before it is started
Answer: A,D,E
NEW QUESTION 42
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 undoes the insert
- 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 does nothing
- E. The second ROLLBACK command replays the delete
Answer: A,B
Explanation:
Explanation/Reference:
NEW QUESTION 43
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?
- A. It returns the date for the last Monday of the current month
- B. It generates an error
- C. It executes successfully but does not return any result
- D. It returns the date for the first Monday of the next month
Answer: D
NEW QUESTION 44
Which two are true about the roles? (Choose two.)
- A. The ALTER USER statement must be used to set specific default roles for a user.
- B. The SET ROLE statement can be used once per session.
- C. All privileges and roles granted to a user are enabled by default when the user logs in.
- D. A role must be disabled before it can be revoked from a user.
- E. The SET ROLE statement enables as well as disables roles in a session.
Answer: C,E
NEW QUESTION 45
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- A. AUTOEXTEND is possible for the datafile
- B. It must be bigger than the largest SMALLFILE tablespace
- C. It will be a dictionary-managed tablespace by default
- D. It will always have a 32K blocksize
- E. Additional data files may not be added
Answer: A,E
NEW QUESTION 46
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100
- A. "DUES" FROM transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 - B. transactions;
SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 - C. DUES FROM transactions;
SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + - D. 'DUES AMOUNT' FROM transactions;
- E. 100 "DUES AMOUNT" FROM transactions;
SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
Answer: B,C
NEW QUESTION 47
Which three statements are true about single-row functions? (Choose three.)
- A. They can be nested to any level
- B. They return a single result row per table
- C. They can accept only one argument
- D. They can be used only in the WHERE clause of a SELECT statement
- E. The argument can be a column name, variable, literal or an expression
- F. The data type returned can be different from the data type of the argument
Answer: A,E,F
Explanation:
https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm
NEW QUESTION 48
View the Exhibit and examine the description of the tables.
You execute this SQL statement:
Which three statements are true?
- A. The statement will fail because a subquery may not be contained in a values clause.
- B. The statement will fall if a row already exists in the sales table for product 23.
- C. The sales table has five foreign keys.
- D. A customer can exist in many countries.
- E. The statement will execute successfully and a new row will be inserted into the sales table.
- F. A product can have a different unit price at different times.
Answer: C,E,F
NEW QUESTION 49
Which two statements are true about interval data types?
- A. The year field in an interval year to month column must be a positive value.
- B. INTERVAL year TO month columns support yearly intervals.
- C. The value in an interval day to SECOND column can be copied into an interval year to month column.
- D. INTERVAL year to month columns only support monthly Intervals within a single year.
- E. INTERVAL day to second columns support fractions of seconds.
- F. INTERVAL year to month columns only support monthly intervals within a range of years.
Answer: B,E
NEW QUESTION 50
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:
Exhibit 1.
Exhibit 2.
What will be the result?
- A. It executes successfully and gives the required result
- B. It gives an error because the ALL keyword is not valid
- C. It executes successfully but does not give the required result
- D. It gives an error because the GROUP BY clause is not valid
Answer: A
NEW QUESTION 51
Which statement is true about smallfile tablespaces?
- A. Segments can span multiple tablespaces.
- B. Segments can span multiple data files.
- C. Extent location metadata is stored in the data dictionary by default.
- D. The number of data files is constrained only by the size of the storage array.
- E. Maximum file size can be set to unlimited only if the logical volume manager supports striping.
Answer: B
NEW QUESTION 52
Which three statements are true about the DESCRIBE command? (Choose three.)
- A. It can be used from SQL Developer
- B. It can be used only from SQL *Plus
- C. It can be used to display the structure of an existing view
- D. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
- E. It displays the NOT NULL constraint for any columns that have that constraint
- F. It displays all constraints that are defined for each column
Answer: B,C,E
NEW QUESTION 53
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Load Balancing requires the use of a name server
- B. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- C. Connect Time Failover requires the connect string to have two or more listener addresses configured
- D. Source Routing requires the use of a name server
- E. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- F. Connect Time Failover requires the use of Transparent Application Failover (TAF)
Answer: C,D,E
Explanation:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
NEW QUESTION 54
Which three statements are true about inner and outer joins? (Choose three.)
- A. A full outer join returns matched and unmatched rows
- B. An inner join returns matched rows
- C. Outer joins can only be used between two tables per query
- D. Outer joins can be used when there are multiple join conditions on two tables
- E. A left or right outer join returns only unmatched rows
- F. A full outer join must use Oracle syntax
Answer: A,B,E
Explanation:
Reference:
https://www.studytonight.com/dbms/joining-in-sql.php
NEW QUESTION 55
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
- A. the maximum amount of CPU time allowed for a user's sessions before their account is locked
- B. the number of days for which an account may be inactive before it is locked
- C. the number of days for which an account is locked after the configured number of login attempts has been reached
- D. the ability to prevent a password from ever being reused
- E. the number of hours for which an account is locked after the configured number of login attempts has been reached
- F. the number of password changes required within a period of time before a password can be reused
- G. the maximum number of sessions permitted for a user before the account is locked
Answer: C,D,F,G
NEW QUESTION 56
......
100% Free Oracle Database 19c 1Z0-082 Dumps PDF Demo Cert Guide Cover: https://vcetorrent.passreview.com/1Z0-082-exam-questions.html