Tag Archives: command

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE

You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE `/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two statements are true about the SALES tablespace? (Choose two.) A. Any data files added to the tablespace must have a size of 5 gigabytes B. It uses the database default blocksize C. Free space is managed using freelists D. It must be smaller than the… Read More »

Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE `undotbs_01.dbf' SIZE 100M AUTOEXTEND

Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE `undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Add the ONLINE clause B. Set UNDO_TABLESPACE to UNDOTBS01 C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Make certain that the database operates in automatic… Read More »

Examine this command: (Exhibit) Which two statements are true? (Choose two.)

Examine this command:Which two statements are true? (Choose two.) A. The file is renamed and stored in the same location B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command. C. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command. D. If Oracle Managed Files (OMF) is used, then the file… Read More »

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.Examine this command:SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);Which segment or segments, if any, are created as a result of executing the command? A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment B. T1, an index segment for the primary key, and a… Read More »

Which three statements are true about the DESCRIBE command? (Choose three.)

Which three statements are true about the DESCRIBE command? (Choose three.) A. It can be used only from SQL*Plus B. It can be used to display the structure of an existing view C. It can be used from SQL Developer D. It displays all constraints that are defined for each column E. It displays the PRIMARY KEY constraint… Read More »

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION

In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »

You execute this command: (Exhibit) Sufficient storage is available in filesystem /u01. Which two statements

You execute this command:Sufficient storage is available in filesystem /u01.Which two statements are true about the BIG_TBS tablespace? (Choose two.) A. AUTOEXTEND is possible for the datafile B. It will be a dictionary-managed tablespace by default C. It must be bigger than the largest SMALLFILE tablespace D. It will always have a 32K blocksize E. Additional data files… Read More »

Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M AUTOEXTEND

Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Set UNDO_TABLESPACE to UNDOTBS01 B. Add the SEGMENT SPACE MANAGEMENT AUTO clause C. Add the ONLINE clause D. Add the NOLOGGING clause E. Make certain that the database operates in automatic… Read More »