Free Oracle 1Z0-082 Study Guides Exam Questions and Answer
1Z0-082 Exam Dumps, 1Z0-082 Practice Test Questions
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.
Oracle 1Z0-082 certification exam is designed to test an individual's skills and knowledge in administering Oracle databases. 1Z0-082 exam is a fundamental requirement for individuals who wish to become Oracle Database Administrators. It focuses on the core concepts of database administration, including database architecture, installation, configuration, backup, recovery, and performance tuning.
NEW QUESTION # 43
Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)
- A. ORDER BY 2, 1
- B. ORDER BY "CUST_NO"
- C. ORDER BY CUST_NO
- D. ORDER BY 2, cust_id
- E. ORDER BY "Last Name"
Answer: A,C,D
NEW QUESTION # 44
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Data block headers contain their own Data Block Address (DBA)
- B. Data 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. Index block free space is always contiguous in the middle of the block
- E. Multiple row pieces from the same row may be stored in different database blocks
- F. Multiple row pieces from the same row may be stored in the same block
Answer: B,C,E
Explanation:
Explanation/Reference: https://books.google.com.pk/books?id=lNtVjrmbzckC&pg=PA267&lpg=PA267&dq=Multiple+row
+pieces+from+the+same+row+may+be+stored+in+different+database
+blocks&source=bl&ots=lEIhFe2Q52&sig=ACfU3U1TETJPy194pARxfIJ5ROaQdySCMQ&hl=en&sa=X&ved=2 ahUKEwivveLa97_mAhWOzaQKHahYAVEQ6AEwAnoECAoQAQ#v=onepage&q=Multiple%20row%20pieces
%20from%20the%20same%20row%20may%20be%20stored%20in%20different%20database%
20blocks&f=false
NEW QUESTION # 45
Which three statements are true about single-row functions? (Choose three.)
- A. They can be nested to any level
- B. The data type returned can be different from the data type of the argument
- C. The argument can be a column name, variable, literal or an expression
- D. They can accept only one argument
- E. They can be used only in the WHERE clause of a SELECT statement
- F. They return a single result row per table
Answer: A,B,C
Explanation:
https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm
NEW QUESTION # 46
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
- A. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
- B. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
- C. A DROP COLUMN command can be rolled back
- D. Partition key columns cannot be dropped.
- E. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
- F. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
Answer: B,D,E
NEW QUESTION # 47
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)
- A. one instance on one server associated with one database
- B. two or more instances on separate servers all associated with one database
- C. one instance on one server associated with two or more databases on the same server
- D. one instance on one server associated with two or more databases on separate servers
- E. one instance on one server not associated with any database
Answer: C,D,E
NEW QUESTION # 48
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:
Which statement is true?
- A. The LREG process registers services dynamically with the LISTENER_1 listener
- B. Dynamic service registration cannot be used for this database instance
- C. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances - D. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
Answer: E
Explanation:
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
NEW QUESTION # 49
Which two are true about the roles? (Choose two.)
- A. All privileges and roles granted to a user are enabled by default when the user logs in.
- B. The SET ROLE statement enables as well as disables roles in a session.
- C. The SET ROLE statement can be used once per session.
- D. A role must be disabled before it can be revoked from a user.
- E. The ALTER USER statement must be used to set specific default roles for a user.
Answer: A,B
NEW QUESTION # 50
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)
- A. Display the minimum PROD_LIST_PRICE for each product status
- B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
- C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
- D. Display the total number of products supplied by supplier 102 which have a product status of obsolete
- E. Display suppliers whose PROD_LIST_PRICE is less than 1000
Answer: B,C
NEW QUESTION # 51
Which three statements are true about using SQL*Plus?
- A. It can run scripts passed to it by a shell script.
- B. It must be downloaded from the Oracle Technology Network (OTN).
- C. It can run scripts entered at the SQL prompt.
- D. It has its own commands that are separate from any SQL statements.
- E. It has both command-line and graphical user interfaces (GUI).
- F. It can run Recovery Manager (RMAN) commands.
Answer: B,C,D
NEW QUESTION # 52
Which three activities are recorded in the database alert log? (Choose three.)
- A. non-default database parameters
- B. session logins and logouts
- C. block corruption errors
- D. deadlock errors
- E. Data Definition Language (DDL) statements
Answer: A,C,D
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION # 53
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. It supports diagnostics for Automatic Storage Management (ASM)
- B. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
- C. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- D. It supports diagnostics for Oracle Clusterware
- E. It is held inside an Oracle database schema
Answer: B,E
Explanation:
https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
NEW QUESTION # 54
Which two functions are performed by a listener?
- A. creating a user session in the System Global Area (SGA)
- B. verifying a user's authentication credentials
- C. maintaining the connection to a client's user process until the user request is completed
- D. verifying the service name in an incoming user request
- E. returning the results of processing from the server process to the user process
- F. connecting a user process to a server process
Answer: E,F
NEW QUESTION # 55
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_income_level != NULL AND due_amount != NULL;
- B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount 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 IS NOT NULL AND cust_credit_limit IS NOT 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: D
NEW QUESTION # 56
What is true about non-equijoin statement performance? (Choose two.)
- A. The join syntax used makes no difference to performance
- B. The BETWEEN condition always performs less well than using the >= and <= conditions
- C. Table aliases can improve performance
- D. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
- E. The BETWEEN condition always performs better than using the >= and <= conditions
Answer: C,D
NEW QUESTION # 57
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 names of columns selected in each SELECT statement must be identical
- C. The output is sorted by the UNION ALL operator
- D. NULLS are not ignored during duplicate checking
- E. Duplicates are eliminated automatically by the UNION ALL operator
Answer: A,D
NEW QUESTION # 58
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE `/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
- A. It is a locally managed tablespace
- B. Free space is managed using freelists
- C. Any data files added to the tablespace must have a size of 5 gigabytes
- D. It must be smaller than the smallest BIGFILE tablespace
- E. It uses the database default blocksize
Answer: A,E
NEW QUESTION # 59
Which two can you use to recover a dropped table? (Choose two.)
- A. FLASHBACK TRANSACTION
- B. FLASHBACK DROP
- C. FLASHBACK DATABASE
- D. FLASHBACK TABLE TO SCN
- E. FLASHBACK QUERY
Answer: B,D
NEW QUESTION # 60
The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?
- A. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
- B. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
- C. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
- D. WHERE TO_XUMBER(start_date - SYSDATE) <= 25
Answer: A
NEW QUESTION # 61
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
- A. checking for outbound shared server responses on the common outbound response queue
- B. writing inbound request to the common request queue from all shared server connections
- C. sending each connection input request to the appropriate shared server input queue
- D. sending shared server session responses back to requesters on the appropriate connection
- E. broadcasting shared server session responses back to requesters on all connections
- F. receiving inbound requests from processes using shared server connections
Answer: B,C,F
NEW QUESTION # 62
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
- A. Only the primary key can be defined at the column and table level
- B. A table can have only one primary key but multiple foreign keys
- C. The foreign key columns and parent table primary key columns must have the same names
- D. A table can have only one primary key and foreign key
- E. 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
- F. Primary key and foreign key constraints can be defined at both the column and table level
- G. 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
Answer: B,C,F,G
NEW QUESTION # 63
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 be a dictionary-managed tablespace by default
- B. Additional data files may not be added
- C. AUTOEXTEND is possible for the datafile
- D. It must be bigger than the largest SMALLFILE tablespace
- E. It will always have a 32K blocksize
Answer: B,C
NEW QUESTION # 64
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
- A. Set DEFERRED_SEGMENT_CREATION to TRUE
- B. Grant UNLIMITED TABLESPACE to U1
- C. Add a data file to DATA
- D. Drop other U1 objects in DATA
- E. Set AUTOEXTEND ON for data files in DATA
- F. Increase U1's quota sufficiently in DATA
Answer: A,E,F
NEW QUESTION # 65
Which two statements are true about the rules of precedence for operators? (Choose two.)
- A. Multiple parentheses can be used to override the default precedence of operators in an expression
- B. The concatenation operator | | is always evaluated before addition and subtraction in an expression
- C. The + binary operator has the highest precedence in an expression in a SQL statement
- D. NULLS influence the precedence of operators in an expression
- E. Arithmetic operators with equal precedence are evaluated from left to right within an expression
Answer: A,E
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.
NEW QUESTION # 66
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?
- A. It succeeds and the generated undo is stored in SYSTEM.
- B. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1' ". - C. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- D. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- E. It succeeds and the generated undo is stored in SYSAUX.
Answer: D
Explanation:
Explanation
NEW QUESTION # 67
Which two statements are true about the rules of precedence for operators? (Choose two.)
- A. Multiple parentheses can be used to override the default precedence of operators in an expression
- B. Arithmetic operators with equal precedence are evaluated from left to right within an expression
- C. The concatenation operator | | is always evaluated before addition and subtraction in an expression
- D. The + binary operator has the highest precedence in an expression in a SQL statement
- E. NULLS influence the precedence of operators in an expression
Answer: A,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
NEW QUESTION # 68
......
Latest 1Z0-082 Actual Free Exam Questions Updated 145 Questions: https://getfreedumps.passreview.com/1Z0-082-exam-questions.html