Free Oracle 1Z0-082 Exam Questions & Answer from Training Expert TestKingsIT
Top Oracle 1Z0-082 Courses Online
NEW QUESTION 51
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. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- C. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- D. Dynamic service registration cannot be used for this database instance
- E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Answer: B
NEW QUESTION 52
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 53
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- A. INTERSECT ignores NULLs
- B. The number of columns in each SELECT in the compound query can be different
- C. Column names in each SELECT in the compound query can be different
- D. Reversing the order of the intersected tables can sometimes affect the output
- E. INTERSECT returns rows common to both sides of the compound query
Answer: A,C
NEW QUESTION 54
Which three statements are true concerning logical and physical database structures? (Choose three.)
- A. A segment can span multiple data files in some tablespaces
- B. A smallfile tablespace might be bigger than a bigfile tablespace
- C. Segments can span multiple tablespsaces
- D. All tablespaces may have one or more data files
- E. The extents of a segment must always reside in the same datafile
- F. A segment might have only one extent
- G. A segment's blocks can be of different sizes
Answer: B,C,F
NEW QUESTION 55
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
- A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
- B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
- C. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
- D. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
"DUES AMOUNT" FROM transactions; - E. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
Answer: A,E
NEW QUESTION 56
Which three statements are true about single-row functions? (Choose three.)
- A. The argument can be a column name, variable, literal or an expression
- B. They can accept only one argument
- C. They return a single result row per table
- D. The data type returned can be different from the data type of the argument
- E. They can be used only in the WHERE clause of a SELECT statement
- F. They can be nested to any level
Answer: A,C,D
Explanation:
Explanation/Reference: https://www.folkstalk.com/2012/01/oracle-single-row-functions-examples.html
NEW QUESTION 57
Which three are types of segments in an Oracle Database? (Choose three.)
- A. stored procedures
- B. tables
- C. sequences
- D. clusters
- E. undo
- F. index
Answer: B,D,F
Explanation:
Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION 58
Which three statements are true about inner and outer joins? (Choose three.)
- A. Outer joins can only be used between two tables per query
- B. An inner join returns matched rows
- C. A full outer join must use Oracle syntax
- D. Outer joins can be used when there are multiple join conditions on two tables
- E. A full outer join returns matched and unmatched rows
- F. A left or right outer join returns only unmatched rows
Answer: B,E,F
Explanation:
Reference:
https://www.studytonight.com/dbms/joining-in-sql.php
NEW QUESTION 59
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 60
Which two statements are true about single row functions? (Choose two.)
- A. FLOOR : returns the smallest integer greater than or equal to a specified number
- B. CONCAT : can be used to combine any number of values
- C. TRUNC : can be used with NUMBER and DATE values
- D. MOD : returns the quotient of a division operation
- E. CEIL : can be used for positive and negative numbers
Answer: C,E
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 61
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. Drop other U1 objects in DATA
- B. Grant UNLIMITED TABLESPACE to U1
- C. Increase U1's quota sufficiently in DATA
- D. Set AUTOEXTEND ON for data files in DATA
- E. Set DEFERRED_SEGMENT_CREATION to TRUE
- F. Add a data file to DATA
Answer: C,D,E
NEW QUESTION 62
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 63
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
NEW QUESTION 64
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- B. Source Routing requires the use of a name server
- C. Load Balancing requires the use of a name server
- D. Connect Time Failover requires the use of Transparent Application Failover (TAF)
- E. Connect Time Failover requires the connect string to have two or more listener addresses configured
- F. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
Answer: B,E,F
NEW QUESTION 65
Which three statements are true about views in an Oracle database? (Choose three.)
- A. Tables in the defining query of a view must always exist in order to create the view
- B. Views can be updated without the need to re-grant privileges on the view
- C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
- D. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- E. The WITH CHECK clause prevents certain rows from being updated or inserted
- F. Data Manipulation Language (DML) can always be used on views
- G. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
Answer: B,D,G
NEW QUESTION 66
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_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;
- B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
- C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
- D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
- E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
Answer: C
NEW QUESTION 67
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- B. Source Routing requires the use of a name server
- C. Load Balancing requires the use of a name server
- D. Connect Time Failover requires the use of Transparent Application Failover (TAF)
- E. Connect Time Failover requires the connect string to have two or more listener addresses configured
- F. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
Answer: B,E,F
Explanation:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
NEW QUESTION 68
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 69
Which two statements are true about single row functions? (Choose two.)
- A. FLOOR : returns the smallest integer greater than or equal to a specified number
- B. CONCAT : can be used to combine any number of values
- C. TRUNC : can be used with NUMBER and DATE values
- D. MOD : returns the quotient of a division operation
- E. CEIL : can be used for positive and negative numbers
Answer: C,D
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C
NEW QUESTION 70
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. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- C. The LREG process registers services dynamically with the LISTENER_1 listener
- D. Dynamic service registration cannot be used for this database instance
- E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Answer: C
Explanation:
The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.
Reference:
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
NEW QUESTION 71
......
Benefits in Obtaining Oracle 1z0-082: Oracle Database Administration I Exam Certification Path
Oracle 1Z0-068 Certification will strengthen your knowledge and skills by introducing you to a wide variety of important database features, functions, and tasks. Oracle Database certification trains you on how to perform complex, hands-on activities through study, labs, and practice. This certification will help you gain a better understanding and experience with Oracle RAC and Grid Infrastructure. After gaining this certification you will be able to install, maintain, tune and recover RAC databases, Clusterware, and ASM environments.
Earning this certification gives you a competitive advantage by developing a skill set that’s in demand in the world. 80% of Oracle’s certified people reported that certification helped them in promotion, increase in wages, or other career improvements. You will also get a digital badge that you can display on your LinkedIn profiles.
New (2022) Oracle 1Z0-082 Exam Dumps: https://exampasspdf.testkingit.com/Oracle/latest-1Z0-082-exam-dumps.html