Page: 1
/ 11
Total 155 questions
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
- A. Duplicates are eliminated automatically by the UNION ALL operator
- B. The number of columns selected in each SELECT statement must be identical
- C. The names of columns selected in each SELECT statement must be identical
- D. The output is sorted by the UNION ALL operator
- E. NULLS are not ignored during duplicate checking
Answer : BE
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither 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 for Oracle Clusterware
- E. It is held inside an Oracle database schema
Answer : AE
Reference:
https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)
- A. analysis of all privileges used by all users including administrative users in the database
- B. analysis of all privileges used by all users but excluding administrative users in the database
- C. analysis of privileges that a user has on their own schema objects that they did not use
- D. analysis of privileges that a user has on their own schema objects that they did use
- E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
- F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
Answer : ACF
Reference:
https://docs.oracle.com/database/121/ARPLS/d_priv_prof.htm#ARPLS74328
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
- A. An undo segment may be used by multiple transactions simultaneously
- B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
- C. Undo segments have a minimum of three extents
- D. Undo segments can extend when a transaction fills the last extent of the undo segment
- E. A single transaction may use multiple undo segments simultaneously
- F. Undo segments must be stored in a BIGFILE tablespace
- G. Undo segments must be stored in a SMALLFILE tablespace
Answer : ADG
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. It is available only when the database is open
- B. It can be used to perform database recovery
- C. The same port number can be used for Database Express configurations for databases on different hosts
- D. It can be used to switch a database into ARCHIVELOGMODE
- E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
Answer : AC
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:
Which two statements are true? (Choose two.)
- A. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
- B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
- D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- E. Employees 100 and 200 will have the same JOB_ID as before the update command
- F. Employees 100 and 200 will have the same SALARY as before the update command
Answer : AB
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
- A. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
- B. The number, but not names, of columns must be identical for all SELECT statements in the query.
- C. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
- D. The names and number of columns must be identical for all SELECT statements in the query.
- E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
Answer : AC
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
- A. The CURRENT_TIMESTAMP function returns data without time zone information
- B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
- C. A TIMESTAMP data type column contains information about year, month, and day
- D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
Answer : ADE
Which three statements are true about inner and outer joins? (Choose three.)
- A. A full outer join returns matched and unmatched rows
- B. An inner join returns matched rows
- C. Outer joins can only be used between two tables per query
- D. A full outer join must use Oracle syntax
- E. Outer joins can be used when there are multiple join conditions on two tables
- F. A left or right outer join returns only unmatched rows
Answer : ABE
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 TRANS_DATE, amount + 100 ג€DUES AMOUNTג€ FROM transactions;
- D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
- E. SELECT customer_id AS ג€˜CUSTOMER-IDג€™, transaction_date AS DATE, amount + 100 ג€˜DUES AMOUNTג€™ FROM transactions;
Answer : BD
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL(cust_credit_limit * .15, ג€˜Not Availableג€™) FROM customers;
- B. SELECT NVL2(cust_credit_limit * .15, ג€˜Not Availableג€™) FROM customers;
- C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), ג€˜Not Availableג€™) FROM customers;
- D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, ג€˜Not Availableג€™)) FROM customers;
- E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ג€˜Not Availableג€™) FROM customers;
Answer : CE
Which statement is true about aggregate functions?
- A. Aggregate functions can be nested to any number of levels
- B. The AVG function implicitly converts NULLS to zero
- C. Aggregate functions can be used in any clause of a SELECT statement
- D. The MAX and MIN functions can be used on columns with character data types
Answer : A
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)
- A. The online redo logs are opened
- B. The online data files are opened
- C. The alert log records the execution details
- D. The Oracle background processes are started
- E. The initialization parameter file is read
- F. The control file is read
Answer : DF
Which two are true about shrinking a segment online? (Choose two.)
- A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- B. It always eliminates all migrated rows if any exist in the table
- C. To shrink a table it must have a PRIMARY KEY constraint
- D. To shrink a table it must have a UNIQUE KEY constraint
- E. To shrink a table it must have row movement enabled
- F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
Answer : CE
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
Examine these commands:
Which two statements are true about the sqlldr execution? (Choose two.)
- A. It overwrites data in EMP with data in EMP.DAT
- B. It uses the database buffer cache to load data
- C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- D. It generates a sql script that it uses to load data from EMP.DAT to EMP
- E. It appends data from EMP.DAT to EMP
Answer : BD
30 days access 