- #ROWWISE GRANDTOTAL IN ORACLE11G PDF#
- #ROWWISE GRANDTOTAL IN ORACLE11G UPDATE#
- #ROWWISE GRANDTOTAL IN ORACLE11G PASSWORD#
Configure Java Pool to cache the java objects.ī. Which action would you consider to overcome the performance degradation?Ī. You suspect the shared pool fragmentation to be the reason. The database instance is currently using 60% of total operating system memory. The PROD database is running in shared server mode. You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?ġ1. Each data block in the database always corresponds to one OS block.ġ0. It is possible to have tablespaces of different block sizes in a database.Į. A data block is the smallest unit of I/O for data files.ĭ. Multiple tablespaces can share single data file.Ĭ. Each segment contains one or more extents.ī. Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)Ī. Which file is used by the Oracle database server to authenticate APP_DBA?ĩ. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. You want the user APP_DBA to administer the Oracle database from a remote machine. The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.Ĩ. The primary key constraint can be imposed by combining more than one column.Į. The primary key constraint can be referred by only one foreign key constraint.ĭ. It is possible to have more than one primary key constraint in a single table.Ĭ. It is not possible to disable the primary key constraint.ī. Which two statements are true about the primary key constraint in a table? (Choose two.)Ī. The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.ħ. The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.ĭ. If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.Ĭ. This clause is not valid for a temporary or undo tablespace.ī. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba role to the user.Ħ. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.ĭ.
#ROWWISE GRANDTOTAL IN ORACLE11G PASSWORD#
The user must be listed in the password file for the authentication.Ĭ. The user must be granted the database administrator (DBA) privilege.ī. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?Ī. The command fails with an error because no absolute path is specified for log file and dumpfile.ĥ. The command fails with an error because DATA_PUMP_DIR directory have higher precedence over the per-file directory.ĭ. But log file would not be created as DATA_PUMP_DIR directory is only accessible to user with SYSDBA privilege.Ĭ. The command would execute successfully and the export dump file would be created in the destination of the directory object MY_DIR.ī. $ EXPDP would be the outcome of this command?Ī. You executed the following command to export the EMPLOYEES table from a remote machine: Which type of script does the backup scheduler generate?Ĥ. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. On startup, all the files will be synchronized and you get both committed and uncommitted data.ģ. On startup, perform media recovery and then instance recovery.į. Uncommitted changes will be rolled back after the database is opened.Į. On startup, use RMAN to perform instance recovery.ĭ. On startup, CKPT coordinates instance recovery.Ĭ. On startup, SMON coordinates instance recovery.ī. Which two statements are true? (Choose two.)Ī. Because of a hardware failure, the instance has shut down before synchronizing all the database files. You are in the middle of a transaction and very crucial data has been modified. Which three pieces of information would you check to confirm that the statistics have been collected? (Choose three.)Į.
#ROWWISE GRANDTOTAL IN ORACLE11G UPDATE#
In your Oracle 10g database, you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. Oracle Objective type Questions and Answers Listġ.
#ROWWISE GRANDTOTAL IN ORACLE11G PDF#
140 top Oracle multiple choice questions and answers PDF for freshers and experienced
0 kommentar(er)
