Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 141:

  Which two tasks can be performed in the NOMOUNT state? (Choose two.)

  A. renaming data files
  B. full database recovery
  C. re-creating control files
  D. creating a database
  E. enabling online redo log archiving
  C. re-creating control files
  D. creating a database

• Question 142:

  Which two statements are true about the Oracle Data Dictionary?

  A. It is owned by the SYS user.
  B. Data dictionary base tables can be queried directly.
  C. It is owned by the SYSTEM user.
  D. Data dictionary views are always created with queries that join two or more base tables.
  E. All data dictionary view join base tables to dynamic performance views.
  A. It is owned by the SYS user.
  B. Data dictionary base tables can be queried directly.

  ---

  Explanation/Reference:

• Question 143:

  View the Exhibit and examine the structure of the PRODUCTS table.

  Which two tasks require subqueries? (Choose two.)

  

  A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
  B. Display suppliers whose PROD_LIST_PRICE is less than 1000
  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 the minimum PROD_LIST_PRICE for each product status
  A. 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

• Question 144:

  Which two statements are true about UNDO and REDO? (Choose two.)

  A. The generation of UNDO generates REDO
  B. DML modifies Oracle database objects and only generates UNDO
  C. The generation of REDO generates UNDO
  D. DML modifies Oracle database objects and only generates REDO
  E. DML modifies Oracle database objects and generates UNDO and REDO
  A. The generation of UNDO generates REDO
  E. DML modifies Oracle database objects and generates UNDO and REDO

  ---

  Explanation/Reference:

  ... undo is stored in redo logs also. During roll forward phase of instance/media recovery, as changes (redo in redo logs) are applied to datafiles, undo stored in redo logs is used to generate undo segments. These segments are subsequently used to rollback uncommitted changes during rollback phase of instance/media recovery.

  https://www.experts-exchange.com/articles/13880/UNDO-AND-REDO-IN-ORACLE.html

• Question 145:

  Which three statements are true about single-row functions? (Choose three.)

  A. They can be used only in the WHERE clause of a SELECT statement
  B. The argument can be a column name, variable, literal or an expression
  C. The data type returned can be different from the data type of the argument
  D. They can be nested to any level
  E. They can accept only one argument
  F. They return a single result row per table
  B. The argument can be a column name, variable, literal or an expression
  C. The data type returned can be different from the data type of the argument
  D. They can be nested to any level

  ---

  Explanation/Reference:

  https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm

• Question 146:

  Which three statements are true about an SPFILE? (Choose three.)

  A. It must exist for a database instance to start.
  B. It can be used to create a pfile.
  C. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.
  D. It can be created by SYS from an idle instance.
  E. It contains only static initialization parameters.
  B. It can be used to create a pfile.
  C. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.
  D. It can be created by SYS from an idle instance.

• Question 147:

  Which two statements are true about a self join? (Choose two.)

  A. It can be an inner join.
  B. It can be a left outer join.
  C. It must be an equijoin.
  D. The join key column must have an index.
  E. It must be a full outer join.
  A. It can be an inner join.
  B. It can be a left outer join.

  ---

  Explanation/Reference:

• Question 148:

  An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table. Which three situations does the transaction complete thereby committing the updates?

  A. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
  B. when a CREATE INDEX statement is executed successfully in the same session
  C. when a COMMIT statement is issued by the same user from another session in the same database instance
  D. when the session logs out successfully
  E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
  F. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session
  A. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
  B. when a CREATE INDEX statement is executed successfully in the same session
  D. when the session logs out successfully

• Question 149:

  Examine the description of the BOOKS_TRANSACTIONS table:

  

  Examine this partial SQL statement:

  SELECT * FROM books_transactions

  Which two WHERE conditions give the same result? (Choose two.)

  A. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
  B. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
  C. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'))
  D. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR menber_id IN ('A101', 'A102'));
  E. WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');
  B. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
  E. WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');

  ---

  Explanation/Reference:

• Question 150:

  Which three statements are true concerning logical and physical database structures? (Choose three.)

  A. All tablespaces may have one or more data files
  B. The extents of a segment must always reside in the same datafile
  C. A smallfile tablespace might be bigger than a bigfile tablespace
  D. A segment can span multiple data files in some tablespaces
  E. A segment's blocks can be of different sizes
  F. A segment might have only one extent
  G. Segments can span multiple tablespaces
  C. A smallfile tablespace might be bigger than a bigfile tablespace
  D. A segment can span multiple data files in some tablespaces
  F. A segment might have only one extent

  ---

  Explanation/Reference: