Get ready to pass the 1Z0-082 Exam right now using our Oracle Database 19c Exam Package
A fully updated 2024 1Z0-082 Exam Dumps exam guide from training expert CramPDF
NEW QUESTION # 43
Your database instance is started with an SPFILE.
A PFILE is also available. You execute this command:
ALTER SYSTEM SET DB_CACHE_SIZE=100K;
Where Is the value changed?
- A. in the SPFILE, SPFILE, and memory
- B. in the SPFILE and SPFILEc
- C. in the SPFILE and in memory
- D. only In the SPFILE
- E. only in memory
Answer: B
NEW QUESTION # 44
Which two actions can you perform using DBCA for an existing database?
- A. Change the server mode from dedicated to shared, and vice versa.
- B. Change the character set.
- C. Create a template that can be used to clone the database.
- D. Create nonstandard block size tablespaces.
- E. Create an additional listener.
Answer: A,B
NEW QUESTION # 45
While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?
- A. DBA_DATA_FILES displays the new name for the data files.
- B. DBA_DATA_FILES displays the original name for the data files.
- C. V$DATAFILE displays the new names for the data files.
- D. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
- E. DBA_DATA _FILES displays both the new name and the old name for the data files.
Answer: B,E
NEW QUESTION # 46
Which three statements are true regarding indexes? (Choose three.)
- A. An update to a table can result in no updates to any of the table's indexes
- B. An update to a table can result in updates to any or all of the table's indexes
- C. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
- D. A SELECT statement can access one or more indices without accessing any tables
- E. A UNIQUE index can be altered to be non-unique
- F. A table belonging to one user can have an index that belongs to a different user
Answer: C,E,F
Explanation:
https://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/indexes.htm
https://docs.oracle.com/cd/B10501_01/server.920/a96521/indexes.htm
NEW QUESTION # 47
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?
- A. COLUMN STORE COMPRESS FOR QUERY LOW
- B. ROW STORE COMPRESS BASIC
- C. ROW STORE COMPRESS ADVANCED
- D. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
Answer: C
Explanation:
https://www.oracle.com/technetwork/database/options/compression/advanced-compression- wp-
12c-1896128.pdf
NEW QUESTION # 48
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
SELECT &&col1, &&col2
- A. FROM &table
WHERE '&&condition' = '&cond';
SELECT &&col1, &&col2 - B. FROM &table
WHERE &&condition; - C. FROM &table
WHERE &&condition = &&cond;
SELECT &col1, &col2 - D. FROM "&table"
WHERE &condition;
SELECT '&&col1', '&&col2' - E. FROM &&table
WHERE &condition;
SELECT &col1, &col2
Answer: E
NEW QUESTION # 49
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 cust_credit_level !=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 due_amount != NULL;
Answer: D
NEW QUESTION # 50
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
- A. The foreign key columns and parent table primary key columns must have the same names
- B. 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
- C. A table can have only one primary key and one foreign key
- D. Only the primary key can be defined at the column and table level
- E. Primary key and foreign key constraints can be defined at both the column and table level
- F. 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
- G. A table can have only one primary key but multiple foreign keys
Answer: A,E,F,G
NEW QUESTION # 51
Which three statements are true about a self join? (Choose three.)
- A. It must be an equijoin
- B. It can be an outer join
- C. The ON clause can be used
- D. It must be an inner join
- E. The ON clause must be used
- F. The query must use two different aliases for the table
Answer: B,C,F
NEW QUESTION # 52
Which three statements are true about single-row functions? (Choose three.)
- A. The data type returned can be different from the data type of the argument
- B. They can be used only in the WHERE clause of a SELECT statement
- C. The argument can be a column name, variable, literal or an expression
- D. They return a single result row per table
- E. They can be nested to any level
- F. They can accept only one argument
Answer: A,C,D
Explanation:
Explanation/Reference: https://www.folkstalk.com/2012/01/oracle-single-row-functions-examples.html
NEW QUESTION # 53
Which two statements are true about the DUAL table? (Choose two.)
- A. It can display multiple rows but only a single column
- B. It can be accessed by any user who has the SELECT privilege in any schema
- C. It can be accessed only by the SYS user
- D. It consists of a single row and single column of VARCHAR2 data type
- E. It can be used to display only constants or pseudo columns
- F. It can display multiple rows and columns
Answer: C,D
Explanation:
Explanation/Reference: https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION # 54
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. The WITH CHECK clause prevents certain rows from being updated or inserted
- C. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- D. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- E. Views can be updated without the need to re-grant privileges on the view
- F. The WITH CHECK clause prevents certain rows from being displayed when querying the view
- G. Data Manipulation Language (DML) can always be used on views
Answer: C,D,E
NEW QUESTION # 55
Which two statements are true about UNDO and REDO? (Choose two.)
- A. DML modifies Oracle database objects and only generates REDO
- B. DML modifies Oracle database objects and only generates UNDO
- C. The generation of UNDO generates REDO
- D. The generation of REDO generates UNDO
Answer: C,D
NEW QUESTION # 56
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
Answer: A
NEW QUESTION # 57
Which statement is true about the INTERSECT operator used in compound queries?
- A. It ignores NULLs
- B. INTERSECT is of lower precedence than UNION or UNION ALL
- C. Multiple INTERSECT operators are not possible in the same SQL statement
- D. It processes NULLs in the selected columns
Answer: D
NEW QUESTION # 58
You start your database instance in NOMOUNT state. Which two actions are performed?
- A. SYS can access the database.
- B. The consistency of the database is checked.
- C. All required background processes are started.
- D. The control files are opened.
- E. Memory is allocated for the SG1
Answer: C,E
NEW QUESTION # 59
......
Master 2024 Latest The Questions Oracle Database 19c and Pass 1Z0-082 Real Exam!: https://actualtests.crampdf.com/1Z0-082-exam-prep-dumps.html