实行建筑高度控制区内建筑高度，应按建筑物室外地面至建筑物和构筑物（)计算。A．平均高度B．高度差C．

stimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）

A.DB_RECOVERY_FILE_DESTonly

B.DB_FLASHBACK_RETENTION_TARGETonly

C.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonly

D.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonly

E.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTand

F.DB_FLASHBACK_RETENTION_TARGET

A. ABORT

B. NORMAL

C. IMMEDIATE

D. TRANSACTIONAL

A.Nomoredatafilescanbeaddedtothetablespace.

B.Segmentspaceismanagedbyfreelistsinthetablespace.

C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.

D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit.

A.whenyouwanttorestoreatablethathasbeendroppedfromtheRecycleBin

B.whenyouwanttoidentifythetransactionIDofthetransactionthatdeletedsomeimportantrecordsfromatable

C.whenyouwanttorecovertheschemaofadroppeduser

D.whenyouwanttorestoreadroppedtablespace

A. To find the tax percentage for each of the employees.

B. To list the name, job id, and manager name for all the employees.

C. To find the name, salary, and department name of employees who are not working with Smith.

D. To find the number of employees working for the Administrative department and earning less then 4000.

E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

ecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）

A.V$FLASHBACK_DATABASE_LOG

B.V$FLASHBACK_DATABASE_STAT

C.V$DATABASE

D.V$UNDOSTAT

EPARTMENT_ID NUMBERMANAGER_ID NUMBERLAST_NAME VARCHAR2(25)DEPARTMENTSDEPARTMENT_ID NUMBERMANAGER_ID NUMBERDEPARTMENT_NAME VARCHAR2(35)LOCATION_ID NUMBERYou want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?（）

A. SELECT last_name, department_name, location_id FROM employees , department ;

B. SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;

C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;

D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;

tabaseAdministrator.TheSecurityAdministratorinyourorganizationhaskepthumanerrors，suchaserroneouslydroppingusers，tables，andimportantdata，toaminimumbycarefullygrantingonlythenecessaryprivilegestoeachuser.Asaresultofseveralongoingtransactionswithinyourdatabase，youdiscoverthattheflashbacklogsarerapidlyincreasingintheflashrecoveryarea.Toavoidout-of-spaceerrors，youdecidetodeletetheflashbacklogsfromtheflashrecoveryarea.Howcanyoudeletetheflashbacklogsfromthedatabaseifyourdatabaseisupandrunning？（）

A. The transparent encryption of backups uses the encryption wallet

B. The database uses the same encryption key for every encrypted backup

C. The password encryption of backups only uses the password while creating and restoring backup

D. If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.

A. MANAGER must be a role.

B. It allows the MANAGER to pass the specified privileges on to other users.

C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.