61 - 80

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command: CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING `dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?. as SCOTT in DALLAS_DB. as SCOTT in BOSTON_DB. as SCOTT in BOSTON_DB and SYS in DALLAS_DB. as SYS in both the databases. as SCOTT in both the databases.

Which three statements are true about views in an Oracle database? (Choose three.). Views can be updated without the need to re-grant privileges on the view. Tables in the defining query of a view must always exist in order to create the view. The WITH CHECK clause prevents certain rows from being displayed when querying the view. Data Manipulation Language (DML) can always be used on views. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error. The WITH CHECK clause prevents certain rows from being updated or inserted.

In which three situations does a new transaction always start? (Choose three.). when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session. when issuing a DML statement after a DML statement failed in the same session.

Which three statements are true about Oracle synonyms? (Choose three.). A synonym cannot be created for a PL/SQL package. A synonym can be available to all users. A SEQUENCE can have a synonym. A synonym created by one user can refer to an object belonging to another user. Any user can drop a PUBLIC synonym.

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.). The online redo logs are opened. The online data files are opened. The alert log records the execution details. The Oracle background processes are started. The initialization parameter file is read. The control file is read.

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?. the first column in the first select of the compound query. the first varchab2 column in the first select of the compound query. the first number column in the first select of the compound query. the first number or varchar2 column in the last select of the compound query. the first column in the last select of the compound query.

Which three statements are true about sequences in a single instance Oracle database?. Sequences can always have gaps. A sequence can Issue duplicate values. A sequence's unallocated cached values are lost if the instance shuts down. Two or more tables cannot have keys generated from the same sequence. A sequence can only be dropped by a DBA. A sequence number that was allocated can be rolled back if a transaction fails.

Which two statements are true about Database Instances and Real Application Clusters (RAC)?. A RAC database can have one Instance. A RAC database can have instances on separate servers. Two RAC databases can share their instances. A RAC database must have three or more Instances. A RAC database must have two or more instances.

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.). Column names in each SELECT in the compound query can be different. The number of columns in each SELECT in the compound query can be different. Reversing the order of the intersected tables can sometimes affect the output. INTERSECT returns rows common to both sides of the compound query. INTERSECT ignores NULLs.

Examine the description of the customers table: You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000. Examine this partial query: SELECT cust_last_name, cust_credit_limit FROM customers Which two where conditions give the required result?. Option A. Option B. Option C. Option D. Option E.

Which two actions can you perform using DBCA for an existing database?. Create a template that can be used to clone the database. Change the server mode from dedicated to shared, and vice versa. Change the character set. Create an additional listener. Create nonstandard block size tablespaces.

Which two statements are true about the PMON background process? (Choose two.). It registers database services with all local and remote listeners known to the database instance. It rolls back transactions when a process fails. It records checkpoint information in the control file. It frees unused temporary segments. It frees resources held by abnormally terminated processes.

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.). Employee 100 will have SALARY set to the same value as the SALARY of employee. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100. Employee 200 will have SALARY set to the same value as the SALARY of employee. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200. Employees 100 and 200 will have the same JOB_ID as before the update command. Employees 100 and 200 will have the same SALARY as before the update command.

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command: SQL> CREATE TABLE t1 AS (SELECT object_name, sharing, created FROM dba_objects); U1 complains that the command is taking too long to execute. In the alert log, the database administrator (DBA) finds this: 2017-03-06T12:15:17.183438+05:30 statement in resumable session `User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace `DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.). Add a data file to DATA. Drop other U1 objects in DATA. Increase U1's quota sufficiently in DATA. Set DEFERRED_SEGMENT_CREATION to TRUE. Grant UNLIMITED TABLESPACE to U1. Set AUTOEXTEND ON for data files in DATA.

Which three statements are true about data block storage in an Oracle Database?. A block header contains a row directory pointing to all rows in the block. An index block can contain row data. Row data is stored starting at the end of the block. A data block header is of a fixed length. A table block must always contain row data.

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?. in the undo tablespace. in the SYSAUX tablespace. in the SGA. in the PGA. in the temporary tablespace.

Which three statements are true about roles?. All roles granted to a user are set on by default when the user logs in,. Object privileges may not be granted to roles. The SET ROLE statement can disable one or more roles for a session. Roles must be password protected. Roles may be granted to roles. The SET ROLE statement can enable one or more roles for a session.

Examine the description of the PRODUCT_STATUS table: The status column contains the values 'in stock' or 'out of stock' for each row. Which two queries will execute successfully?. SELECT prod_id Il q" 's not available" FROM product_status where status = 'OUT OF STOCK';. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id "CURRENT AVAILABILITY" II q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id I I q' ('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id I I q' ('s not available)' ' CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK';.

Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE `undotbs_01.dbf' SIZE 100M AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.). Add the SEGMENT SPACE MANAGEMENT AUTO clause. Set UNDO_TABLESPACE to UNDOTBS01. Add the NOLOGGING clause. Make certain that the database operates in automatic undo management mode. Add the ONLINE clause.

You execute this command: During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate Are you sure you wish to stop the job ([yes]/no): yes Which two statements are true about the job? (Choose two.). You can no longer monitor it. You can reattach to it and monitor it. It is paused and can be resumed. It continues to run in the background. It terminates.