Online Access Free 1Z0-082 Exam Questions

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months.
Which where clause can be used?

• A.WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
• B.WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
• C.WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
• D.WHERE TO_XUMBER(start_date - SYSDATE) <= 25

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

• A.Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
• B.The WHERE clause can be used to exclude rows after dividing them into groups
• C.WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
• D.The WHERE clause can be used to exclude rows before dividing them into groups
• E.The HAVING clause can be used with aggregating functions in subqueries

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

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

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 nonstandard block size tablespaces.
• D.Create an additional listener.
• E.Create a template that can be used to clone the database.

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.Usernames of all users including database administrators are stored in the data dictionary
• B.The data dictionary is created and maintained by the database administrator
• C.It is owned by the SYSTEM user
• D.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• E.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• F.Base tables can be queried directly