Tag Archives: create

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: 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 actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. It must be smaller than the smallest BIGFILE tablespace B. Free space is managed using freelists C. Any data files added to the tablespace must have a size… Read More »

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 »

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 »

You have been tasked to create a table for a banking application. One of the columns must meet three

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be stored in a format supporting date arithmetic without using conversion functions2. Store a loan period of up to 10 years3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should… Read More »

You have been tasked to create a table for a banking application. One of the columns must meet three

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be stored in a format supporting date arithmetic without usingconversion functions2. Store a loan period of up to 10 years3. Be used for calculating interest for the number of days the loanremains unpaidWhich data type should you use? A.… 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 »

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 »

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. Make certain that the database operates in automatic undo management mode C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Add… Read More »