DataBase,Oracle,Test 2

Enter your search terms Submit search form

Web examineonline.googlepages.com

Online Exam >> DataBase >> Oracle >> Test 2

Test 2

1 .
You intend to use only password authentication and have used the password file utility to create
a password file as follows:

$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5

The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE. You created a user and
granted only the SYSDBA privilege to that user as follows:

CREATE USER dba_user
IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;

The user attempts to connect to the database as follows:

connect dba_user/dba_pass as sysdba;

Why does the connection fail?

A.The DBA privilege was not granted to dba_user

B.REMOTE_LOGIN_PASSWORDFILE is not set to EXCLUSIVE

C.The password file has been created in the wrong directory

D.The user did not specify the password orapass to connect as SYSDBA

2 . A User named ABC has created a procedure named SALARY_CALC. Which SQL query allows him to view the text of the procedure?

A.SELECT text FROM user_source WHERE name ='SALARY_CALC';

B.SELECT * FROM user_source WHERE source_name ='salary_calc';

C.SELECT * FROM user_objects WHERE object_name = 'SALARY_CALC';

D.SELECT * FROM user procedures WHERE object_name ='SALARY_CALC';

E.SELECT text FROM user_source WHERE name='SALARY_CALC' AND owner ='ABC';

3 .
You issue the following queries to obtain information about the redo log files: SQL> SELECT
group#, type, member FROM v$logfile;

GROUP# TYPE MEMBER

1 ONLINE /databases/DB01/ORADATA/u02/log1a.rdo
1 ONLINE /databases/DB01/ORADATA/u03/log1b.rdo
2 ONLINE /databases/DB01/ORADATA/u02/log2a.rdo
2 ONLINE /databases/DB01/ORADATA/u03/log2b.rdo
3 ONLINE /databases/DB01/ORADATA/u02/log3a.rdo
3 ONLINE /databases/DB01/ORADATA/u03/log3b.rdo

SQL> SELECT group#, sequence#, status FROM v$log;

GROUP# SEQUENCE# STATUS
1 250 INACTIVE
2 251 CURRENT
3 249 INACTIVE

You immediately issue this command:

ALTER DATABASE DROP LOGFILE MEMBER '/databases/DB01/ORADATA/u03/log2b.rdo';

Why does the command fail?

A.Each online redo log file group must have two members

B.You cannot delete any members of online redo log file groups

C.You cannot delete any members of the current online redo log file group

D.You must delete the online redo log file in the operating system before issuing the ALTER DATABASE command.

4 . You are in the process of dropping the BUILDING_LOCATION column from the HR.EMPLOYEES table. The table has been marked INVALID until the operation completes. Suddenly the instance fails. Upon startup, the table remains INVALID. Which step(s) should you follow to complete the operation?

A.Continue with the drop column command: ALTER TABLE hr. employees DROP COLUMNS CONTINUE;

B.Truncate the INVALID column to delete remaining rows in the column and release unused space immediately.

C.Use the Export and Import utilities to remove the remainder of the column from the table and release unused space.

D.Mark the column as UNUSED and drop the column:
ALTER TABLE hr.employees
SET UNUSED COLUMN building location;
ALTER TABLE hr.employees
DPOP UNUSED COLUMN building_location
CASCADE CONSTRAINTS;

5 . What determines the initial size of a table space?

A.The INITIAL clause of the CREATE TABLESPACE statement

B.The MINEXTENTS clause of the CREATE TABLESPACE statement

C.The MINIMUM EXTENT clause of the CREATE TABLESPACE statement

D.The sum of the INITIAL and NEXT clauses of the CREATE TABLESPACE statement

E.The sum of the sizes of all data files specified in the CREATE TABLESPACE statement

6 . Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?

A.LGWR

B.SMON

C.DBWn

D.CKPT

E.PMON

7 . Which two methods enforce resource limits?

A.ALTER SYSTEM SET RESOURCE_LIMIT= TRUE

B.Set the RESOURCE_LIMIT parameter to TRUE

C.CREATE PROFILE sessions LIMIT SESSIONS_PER_USER 2 CPU_PER_SESSION 10000 IDLE_TIME 60 CONNECT_TIME 480;

D.ALTER PROFILE sessions LIMIT SESSIONS_PER_USER 2 CPU_PER_SESSION 10000 IDLE_TIME 60 CONNECT_TIME 480;

8 . Which data dictionary view would you use to get a list of all database users and their default settings?

A.ALL_USERS

B.USERS_USERS

C.DBA_USERS

D.V$SESSION

9 . Which statement about an Oracle instance is true?

A.The redo log buffer is NOT part of the shared memory area of an Oracle instance

B.Multiple instances can execute on the same computer, each accessing its own physical database.

C.An Oracle instance is a combination of memory structures, background processes, and user processes

D.In a shared server environment, the memory structure component of an instance consists of a single SGA and a single PGA.

10 . Which three statements are true about the use of online redo log files?

A.Redo log files are used only for recovery

B.Each redo log within a group is called a member.

C.Redo log files are organized into a minimum of three groups.

D.Redo log files provide the database with a read consistency method.

E.Redo log files provide the means to redo transactions in the event of an instance failure.

11 . Your database contains a locally managed uniform sized table space with automatic segmentspace management, which contains only tables. Currently, the uniform size for the table space is 512 K. Because the tables have become so large, your configuration must change to improve performance. Now the tables must reside in a table space that is locally managed, with uniform size of 5 MB and automatic segment-space management. What must you do to meet the new requirements?

A.The new requirements cannot be met.

B.Re-create the control file with the correct settings

C.Use the ALTER TABLESPACE command to increase the uniform size

D.Create a new table space with correct settings then move the tables into the new table space

12 . Which statement about the shared pool is true?

A.The shared pool CANNOT be dynamically resized

B.The shared pool contains only fixed structures

C.The shared pool consists of the library cache and buffer cache

D.The shared pool stores the most recently executed SQL statements and the most recently accessed data definitions.

13 . Which two actions cause a log switch?

A.A transaction completes.

B.The instance is started.

C.The instance is shut dowN

D.The current online redo log group is filled

E.The ALTER SYSTEM SWITCH LOGFILE command is issued

14 . Which data dictionary view would you use to get a list of object privileges for all database users?

A.DBA_TAB_PRIVS

B.ALL_TAB_PRIVS

C.USER_TAB_PRIVS

D.ALL_TAB_PRIVS_MADE

15 . Which type of file is part of the Oracle database?

A.Control file

B.Password file

C.Parameter files

D.Archived log files

16 . Extents are a logical collection of contiguous ...................

A.Segments

B.Database blocks

C.Table spaces

D.Operating system blocks

17 . For a table space created with automatic segment-space management, where is free space managed?

A.In the extent

B.In the control file

C.In the data dictionary

D.In the undo table space

18 . For which two constraints are indexes created when the constraint is added?

A.Check

B.Unique

C.Not null

D.Primary key

E.Foreign key

19 . An INSERT statement failed and is rolled back. What does this demonstrate?

A.Insert recovery

B.Read consistency

C.Transaction recovery

D.Transaction rollback

20 . Which constraint state prevents new data that violates the constraint from being entered, but allows invalid data to exist in the table?

A.ENABLE VALIDATE

B.DISABLE VALIDATE

C.ENABLE NOVALIDATE

D.DISABLE NOVALIDATE

21 . Which is a complete list of the logical components of the Oracle database?

A.Table spaces, segments, extents, and data files

B.Table spaces, segments, extents, and Oracle blocks

C.Table spaces, database, segments, extents, and data files

D.Table spaces, database, segments, extents, and Oracle blocks

E.Table spaces, segments, extents, data files, and Oracle blocks

22 . A table is stored in a data dictionary managed table space. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?

A.BLOCKS

B.PCT_FREE

C.NEXT_EXTENT

D.PCT_INCREASE

E.INITIAL_EXTENT

23 . Which three statements about the Oracle database storage structure are true?

A.A data block is a logical structure

B.A single data file can belong to multiple table spaces

C.When a segment is created, it consists of at least one extent.

D.A table space can consist of multiple data files, each from a separate disk

E.Within a table space, a segment cannot include extents from more than one file

24 . When is the SGA created in an Oracle database environment?

A.When the database is created

B.When the instance is started

C.When the database is mounted

D.When a user process is started

E.When a server process is started

25 . Which type of table is usually created to enable the building of scalable applications, and is useful for large tables that can be queried or manipulated using several processes concurrently?

A.Regular table

B.Clustered table

C.Partitioned table

D.Index-organized table

Test Name :	Test 2
Category :	Oracle
Number of Question :	25
Pass Score :	80

Test Result

Your Score :
Passing Score :	80

Result :

Menu

Test 2