Tag Archives: 1Z0082

Which four statements are true regarding primary and foreign key constraints and the effect they can

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.) A. Primary key and foreign key constraints can be defined at both the column and table level B. It is possible for child rows that have a foreign key to remain in the child table at… Read More »

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.) A. The HAVING clause can be used with aggregating functions in subqueries B. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query C. The WHERE clause can be used to exclude rows… Read More »

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.Which query can be used? A. SELECT… Read More »

Examine this command: (Exhibit) Which two statements are true? (Choose two.)

Examine this command:Which two statements are true? (Choose two.) A. The file is renamed and stored in the same location B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command. C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST. D. DML may be performed on tables with… Read More »

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row B. The CURRENT_TIMESTAMP function returns data without time zone information C. A… Read More »

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set C. It supports diagnostics for Automatic Storage Management (ASM) D. It supports diagnostics… Read More »