Oracle Database Administration I - 1Z1-082 FREE EXAM DUMPS QUESTIONS & ANSWERS

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

A. Dynamic service registration cannot be used for this database instance B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances C. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration D. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration E. The LREG process registers services dynamically with the LISTENER_1 listener

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

A. A sequence can only be dropped by a DBA. B. A sequence number that was allocated can be rolled back if a transaction fails. C. Sequences can always have gaps. D. A sequence's unallocated cached values are lost if the instance shuts down. E. A sequence can Issue duplicate values. F. Two or more tables cannot have keys generated from the same sequence.

A. Undo segments must be stored in a BIGFILE tablespace B. Undo segments have a minimum of three extents C. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment D. An undo segment may be used by multiple transactions simultaneously E. Undo segments must be stored in a SMALLFILE tablespace F. Undo segments can extend when a transaction fills the last extent of the undo segment G. A single transaction may use multiple undo segments simultaneously

A. You can no longer monitor it B. It terminates C. It is paused and can be resumed D. You can reattach to it and monitor it E. It continues to run in the background

A. external tables B. temporary tables C. heap organized tables D. index organized tables E. partitioned tables F. clustered tables

A. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees; B. SELECT join_date I I ' ' II salary FROM employees; C. SELECT join_date FROM employees WHERE join_date > '10-02-2018'; D. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;

A. The control files are opened. B. All required background processes are started. C. Memory is allocated for the SG1 D. The consistency of the database is checked. E. SYS can access the database.

A. tables B. clusters C. sequences D. stored procedures E. undo F. index

A. It always eliminates all migrated rows if any exist in the table B. To shrink a table it must have a UNIQUE KEY constraint C. To shrink a table it must have a PRIMARY KEY constraint D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) E. To shrink a table it must have row movement enabled F. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

A. An undo tablespace may be owned by only one instance. B. undo segments are owned by SYSTEM. C. There can be only one undo tablespace created in a database. D. An instance will crash if the active undo tablespace is lost. E. undo segments are owned by SYSBACKUP.

A. 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; B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL; C. 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; D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL; E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;