当前分类: 1Z0-052
问题:单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN INSERT INTO...
查看答案
问题:多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file...
问题:单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine()A host naming methodB local naming methodC external naming methodD directory naming meth...
问题:You notice that the performance of the database has degraded...
问题:多选题You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space ...
问题:Examine the commands executed in the following sequence: 1:...
问题:多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on ...
问题:多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays, to tape. Which two statements are true about differential incremental backups()AThe backup performed on Sundays contains all the blo...
问题:多选题Which statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn...
问题:单选题The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$...
问题:多选题Which two statements are true regarding Oracle Data Pump()AEXPDP and IMPDP are the client components of Oracle Data Pump.BDBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.COracle Data Pump export and import operations ca...
问题:多选题Identify the situations in which you use the alert log file in your database to check the detail.()ARunning a query on a table returns ORA-600: Internal Error.BInserting a value in a table returns ORA-01722: invalid number.CCreating a table returns ORA...
问题:单选题In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()A Optimizer statistics are collected automatically.B Only timed operating system (OS) statistics and plan execution statistics...
问题:单选题These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definit...
问题:单选题Examine the commands executed in the following sequence: 1:SQL CREATE ROLE mgrrole; 2:SQL GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL GRANT select,update ON sh.sales TO mgrrole; 4:SQL CREATE ROLE ceo IDENTIFIED BY boss; 5...
问题:单选题in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting()A Optimizer statistics are collected automatically.B Only timed operating system (OS) statistics and plan execution statistics...
问题:单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FI...
问题:单选题Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressedmode for an installation()A Run the root.sh script.B Create the oraInst.loc file.C Create the tnsnames.ora file.D Run the oraintRoot.sh script....
问题:多选题Which operations require undo data()ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE...
问题:All the database users are presently connected to the databa...