A. /lib/svc/method/net-physical B. /etc/rcS.d/S30network C. svc:/network/rpc/bind:default D. /lib/svc/method/rpc-bind
A.LOGICAL_READS_PER_SESSION B.CONNECT_TIME C.COMPOSITE_LIMIT D.CPU_PER_SESSION E.PRIVATE_SGA
A. Export the tablespaces using data pump. B. Determine if the transportable set is self-contained. C. Convert the datafiles using RMAN. D. Copy the datafiles from source to destination.
A.selection, projection, join B.difference, projection, join C.selection, intersection, join D.intersection, projection, join E.difference, projection, product
A.The command would return an error because LOG_BUFFER is a static parameter. B.The parameter value would be changed and it would come into effect immediately. C.You need to restart the database so that parameter changes can come into effect. D.The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
A.SUM(start_date) B.AVG(start_date) C.COUNT(start_date) D.AVG(start_date, end_date) E.MIN(start_date) F.MAXIMUM(start_date)
A. It updates the existing SQL profiles with current statistics. B. It makes the statistics information available to GATHER_STATS_JOB C. It initiates the statistics collection process by running GATHER_STATS_JOB D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
A.Wallet Manager B.Radius C.Oracle Internet Directory D.None of the above
A. The control file will be multiplexed. B. The control file will be recreated. C.The script containing the CREATE CONTROLFILE statement will be created. D. The binary backup of the control file will be created.
A. selection of SQL plan baselines B. partitioning of tables and indexes C. creation of index-organized tables D. creation of bitmap, function-based, and B-tree indexes E. optimization of materialized views for maximum query usage and fast refresh