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 it.
Which constraints will remain enabled by default during this operation()
A.CHECK
B.UNIQUE
C.NOT NULL
D.PRIMARY KEY
E.FOREIGN KEY
您可能感兴趣的试卷
你可能感兴趣的试题
Observe the information in the columns:
1. The SGA a. Text and parsed forms of all SQL statements
2. The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved
3. User-session data c. Security and resource usage information
4. The stack space d. Local variables for the process
Which option has the correct match between the memory areas and their contents()
A.1-c, 2-b, 3-d, 4-a
B.1-b, 2-c, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
Identify the memory component from which memory may be allocated for:()
1. Session memory for the shared server
2. Buffers for I/O slaves
3. Oracle Database Recovery Manager (RMAN) backup and restore operations
A.Large Pool
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area (PGA)
In your database instance, the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users:
1. The user account must be locked after four unsuccessful login attempts.
2. The user must be prompted to change the password at regular intervals.
3. The user may not have more than three simultaneous sessions.
4. The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above()
A.By assigning profiles for the users
B.By implementing Fine-Grained Auditing (FGA)
C.By granting a secure application role to the users
D.By implementing the Database Resource Manager plan
Note the following points describing various utilities in Oracle Database 1g:1. It enables the high-speed transfer of data from one database to another.
2. It provides a complete solution for the backup, restoration, and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup()
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error()
A.The MTTR Advisor is disabled.
B.The database is in NOARCHIVELOG mode.
C.The tablespace is already in backup mode.
D.The Flash Recovery Area is not configured
The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the primary key.As part of the archival process, the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products, the company deals with many new products during every quarter.
Whichmethod is best suited for this quarterly data transfer()
A.Using the MERGE command
B.Using the SQL*Loader utility
C.Using the correlated UPDATE command
D.Using the INSERT command to perform bulk operation
A.It is possible to have multiple database writers in an Oracle instance.
B.It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
C.It writes dirty buffers, if any, to data files whenever a transaction commits.
D.It writes dirty buffers, if any, to data files before the log writer (LGWR) writes
To make audit information more productive, the DBA executes the following command before starting an auditoperation:
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase()
A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it
View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while
configuring the storage you find that the block size that you can provide is only 8 KB.
Which configuration couldhave enabled the block selection of 16 KB()
A.Choosing the extent allocation type to uniform
B.Choosing the Segment Space Management option to manual
C.Setting autoextension on for the data file mentioned for the tablespace
D.Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database:
1. SGA is allocated.
2. Control file is read.
3. Redo log files are read.
4. Instance recovery is started.
5. Background processes are started.
6. Data files are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur()
A.7, 1, 5, 2, 3, 6, 4
B.1, 2, 3,7, 5, 6, 4
C.7, 1, 4, 5, 2, 3, 6
D.1, 7, 5, 4, 2, 3, 6
最新试题
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command()
Which statement is true about loading data using the conventional path of SQL*Loader()
Which statements are true regarding a tablespace()
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error()
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements aretrue regarding the above command()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable:ERROR at line 1:ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario()