多项选择题

A.It cannot be created without a package specification.……

Which two statements are true regarding a PL/SQL package body？（）

A.It cannot be created without a package specification.
B.It cannot invoke subprograms defined in other packages.
C.It can contain only the subprograms defined in the package specification.
D.It can be changed and recompiled without making the package specification invalid.

<上一题目录下一题>

热门试题

单项选择题Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcacheholdstheidealworkloadforanalysis.Youwanttoanalyzeonlyfewmostresource-intensivestatements.Whatwouldbeyoursuggestiontoreceiverecommendationsontheefficientuseofindexesandmaterializedviewstoimprovequeryperformance？（）

A.Run the SQL Access Advisor.
B.Run the SQL Tuning Advisor （STA）.
C.Run the Automatic Workload Repository （AWR） report.
D.Run the Automatic Database Diagnostic Monitor （ADDM）.

多项选择题WhichtwodatabaseoperationscanbeperformedattheMOUNTstageofdatabasestartup？（）

A.renaming of data files
B.dropping the database user
C.renaming of control files
D.multiplexing of control files
E.configuring the database in ARCHIVELOG mode

多项选择题YourdatabaseisinNOARCHIVELOGmode.Afterwhichtwooperationsyoushouldtakethebackupofcontrolfile？（）

A.adding a new user to the database
B.dropping a user from the database
C.dropping a table from the database
D.dropping a data file from a tablespace
E.adding a new tablespace to the database

多项选择题Auserwantstoconnecttothedatabaseinstancefromanapplicationthatisrunningonaremotemachine.WhichtoolsshouldtheDBAusetoestablishtherequiredconfigurationtoensurethattheuserisabletoconnecttothedatabaseinstance？（）

A.Data Pump
B.Oracle Net Manager
C.Oracle Enterprise Manager
D.Oracle Universal Installer （OUI）
E.Database Configuration Assistant （DBCA）

单项选择题YoudefineanalerttoberaisedwhentheUSERStablespaceusagehasreached80%ofthetotalspace.Whichareawouldyoureferto，inordertoconfirmthatthealerthasbeenraisedduetheevent？（）

A.the alert.log file
B.the DBA_ALERTS view
C.the Database Control Home page
D.the Database Control performance page
E.the Database Control Maintenance page