최신Oracle Database Administration I - 1Z0-082무료샘플문제

A. The LREG process registers services dynamically with the LISTENER_1 listener

B. Dynamic service registration cannot be used for this database instance

C. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances

D. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

B. Add the AUTOEXTEND ON clause with NEXT set to 100M.

C. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

D. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

E. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

B. 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;

C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

D. 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;

E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;

A. It must resolve to a valid connect descriptor in the client's tnsnames.ora file

B. It must be the name of the database to whose instance HR wishes to connect

C. It must be the value of the SERVICE_NAMES parameter on the client side

D. It must be the name of the server running the database to whose instance HR wishes to connect

E. It must resolve to a valid connect descriptor in the server's tnsnames.ora file

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. A sequence can Issue duplicate values.

D. Two or more tables cannot have keys generated from the same sequence.

E. Sequences can always have gaps.

F. A sequence's unallocated cached values are lost if the instance shuts down.

A. ORDER BY "CUST_NO"

B. ORDER BY "Last Name"

C. ORDER BY CUST_NO

D. ORDER BY 2, 1

E. ORDER BY 2, cust_id

A. It overwrites the data for Alan and adds data for Curl and Bob

B. It appends data from EMP.DAT TO EMP.

C. It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

D. It overwrites all data in emp with data from emp.dat.

E. It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

A. SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond;

B. SELECT `&&col1', `&&col2'
FROM &table
WHERE `&&condition' = `&cond';

C. SELECT &col1, &col2
FROM &&table
WHERE &condition;

D. SELECT &col1, &col2
FROM "&table"
WHERE &condition;

E. SELECT &&col1, &&col2
FROM &table
WHERE &&condition;

A. You can use a single instance of EM Express to manage multiple database running on the same server.

B. You cannot start up a database instance using EM Express.

C. You can shut down a database instance using EM Express.

D. EM Express uses a separate repository database to store target database metadata.

E. By default, EM express is available for a database after database creation using DBCA.

A. The consistency of the database is checked.

B. The control files are opened.

C. All required background processes are started.

D. Memory is allocated for the SG1

E. SYS can access the database.

A. Reversing the order of the intersected tables can sometimes affect the output

B. Column names in each SELECT in the compound query can be different

C. The number of columns in each SELECT in the compound query can be different

D. INTERSECT ignores NULLs

E. INTERSECT returns rows common to both sides of the compound query

A. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

B. SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

C. SELECT prod_id I I q' ('s not available) ?'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

D. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

E. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

F. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

A. Only RMAN backupsets can be used to restore a database as part of it.

B. The database must have FLASHBACK enabled in order to perform it.

C. Incremental backups can be used to roll forward the database while performing it.

D. Uncommitted transactions will be rolled back after it completes.

E. It is possible only when the database is in MOUNT state

A. The control file is read

B. The online data files are opened

C. The Oracle background processes are started

D. The alert log records the execution details

E. The initialization parameter file is read

F. The online redo logs are opened