A Company shifts all its branches to one office building, so the very large EMPLOYEES table no longer requires the BUILDING_LOCATION column. The DBA decides to drop that column using the syntax giv...
Mark the column as UNUSED. Remove the column at a later stage when less activity is on the system 0.0%
Drop all indexes and constraints associated with the column prior to dropping the column 0.0%
Mark the column INVALID prior to beginning the drop to bypass undo. Remove the column using DROP UNUSED COLUMNS command 0.0%
Add a checkpoint to the DROP UNUSED COLUMNS command to minimize undo space. 100.0%
A DBA has issued the following SQL statement: SELECT max_blocks FROM dba_ts_quotas WHERE tablespace_name='USER_TBS' AND username='MARRY'; User Marry has unlimited quota on the USER_TBS tablespace...
0 0.0%
1 0.0%
-1 100.0%
NULL 0.0%
A new user, Smith, has just joined the organization. You need to create a User Account for him in the database. The points given below are to be kept in mind: 1. Create a user who is authenticated...
CREATE USER smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 100M ON data_ts QUOTA 500K ON temp_ts TEMPORARY TABLESPACE temp_ts; REVOKE DROP_TABLE, CREATE_USER from smith; 0%
CREATE USER smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 500K ON temp_ts QUOTA 100M ON data_ts TEMPORARY TABLESPACE temp_ts; GRANT connect, resource TO smith 0%
CREATE USER smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 100M ON data_ts QUOTA 500K ON temp_ts TEMPORARY TABLESPACE temp_ts; GRANT connect TO smith 0%
CREATE USER smith INDENTIFIED GLOBALLY AS '' DEFAULT TABLESPACE data_ts QUOTA 500K ON temp_ts QUOTA 100M ON data_ts TEMPORARY TABLESPACE temp_ts; GRANT connect, resource TO smith; REVOKE DROP_TABLE, CREATE_USER from smith; 0%
Consider the under mentioned syntax, which creates a DEPARTMENT table: CREATE TABLE department (Deptno NUMBER(4), Dname VARCNAR2(30), mgr NUMBER(6), Loc NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PC...
200 K 0.0%
300 K 0.0%
450 K 0.0%
675 K 100.0%
Examine the following SQL statement: CREATE TABLESPACE user_data DATAFILE '/u01/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part o...
Extent 100.0%
Segment 0.0%
Oracle block 0.0%
Operating system block 0.0%
Examine the following statements: 1)MOUNT mounts the database for certain DBA activities, but does not provide user access to the database. 2)The NOMOUNT command creates only the Data Buffer, but d...
2 and 3 0%
1 and 3 0%
Only 4 0%
None of the above 0%
Examine the following syntax: CREATE INDEX emp_last_name_idx ON emp(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx; What type of Index does this ...
Bitmap 0%
B-Tree 0%
Partitioned 0%
Reverse key 0%
Examine the following TRUNCATE TABLE command: TRUNCATE TABLE departments; Which of the following statements are correct with regard to this command?
All extents are released 0%
All rows of the table are deleted 0%
Any associated indexes are truncated 0%
No undo data is generated for the table's rows 0%
Extents are logical collection of contiguous _________________.
Segments 0%
Database blocks 0%
Table spaces 0%
operating system blocks 0%
Miller is an Administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile (as illustrated below), he receives an error message (shown below): SQL> drop profile SYS.DEFAU...
The DEFAULT profile cannot be dropped 0%
MILLER requires the DROP PROFILE privilege 0%
Profiles created by SYS cannot be dropped 0%
None of the above 0%
The constraints for which Indexes are created by default are:
Check 0%
Unique 0%
Not null 0%
Primary key 0%
Foreign key 0%
The current password file allows five entries. New DBAs have been hired and five more entries need to be added to the file. How can you increase the allowed number of entries in the password file?
Manually edit the password file and add the new entries 0%
Add the new entries; the password file will automatically grow 0%
Drop the current password file, recreate it with the appropriate number of entries, and add everyone again 0%
All of the above 0%
The database needs to be shut down for hardware maintenance. All the user sessions except one have either voluntarily logged off or have been forcibly killed. The remaining one user session is runn...
SHUTDOWN 0%
SHUTDOWN ABORT 0%
SHUTDOWN NORMAL 0%
SHUTDOWN IMMEDIATE 0%
SHUTDOWN TRANSACTIONAL 0%
The information for a dynamic performance view is gathered from the control file.
What provides for recovery of data that has not been written to the data files prior to a failure?
Redo log 0%
Undo segment 0%
Rollback segment 0%
System tablespace 0%
When does the Log Writer (LGWR) process write the redo entries from the redo log buffer to the current online redo log group?
When a transaction commits 0%
When a rollback is executed 0%
When the redo log buffer is about to be completely full (90%) 0%
Before the DBWn writes modified blocks in the database buffer cache 0%
When is SGA created in an Oracle database environment?
When the database is created 0%
When the instance is started 0%
When the database is mounted 0%
When a user process is started 0%
Where is free space managed for a tablespace created with automatic segment-space management?
In the extent 0%
In the control file 0%
In the data dictionary 0%
In the undo tablespace 0%
Which of the following background processes performs a checkpoint in the database by writing modified blocks from the database buffer cache in SGA to the data files?
LGWR 0%
SMON 0%
DBWN 0%
CKPT 0%
PMON 0%
Which of the following becomes available when an Oracle instance is started?
User Process 0%
Server Process 0%
Datafile 0%
Background Processes 0%
Which of the following causes a log switch?
Completion of a transaction 0%
Initiation of an instance 0%
Filling-up of the current online redo log group 0%
Issuing of the ALTER SYSTEM SWITCH LOGFILE command 0%
Which of the following constitute the advantages that the server parameter file (SPFILE) provides while managing initialization parameters?
The Oracle server maintains the server parameter file 0%
The server parameter file is created automatically when the instance is started 0%
Changes can be made in memory and/or in the SPFILE with the ALTER SYSTEM command 0%
The use of SPFILE provides the ability to make changes persistent across shut down and start up 0%
The Oracle server keeps the server parameter file and the text initialization parameter file synchronized 0%
Which of the following constitute the logical components of the Oracle database?
Tablespaces, segments, extents, and data files 0%
Tablespaces, segments, extents, and Oracle blocks 0%
Tablespaces, database, segments, extents, and data files 0%
Tablespaces, database, segments, extents, and Oracle blocks 0%
Which of the following constraint states prevents new data (that violates the constraint) from entering into the table, but allows invalid data to exist in the table?
ENABLE VALIDATE 0%
DISABLE VALIDATE 0%
ENABLE NOVALIDATE 0%
DISABLE NOVALIDATE 0%
Which of the following helps a DBA examine the performance of the database?
Recovery Manager 0%
Oracle Enterprise Manager 0%
Oracle Universal Installer 0%
Oracle Database Configuration Assistant 0%
Which of the following helps determine the initial size of a Tablespace?
The INITIAL clause of the CREATE TABLESPACE statement 0%
The MINEXTENTS clause of the CREATE TABLESPACE statement 0%
The MINIMUM EXTENT clause of the CREATE TABLESPACE statement 0%
The sum of the sizes of all data files specified in the CREATE TABLESPACE statement 0%
Which of the following memory areas is not part of SGA?
Database Buffer Cache 0%
Redo log Buffer 0%
PGA 0%
Shared Pool 0%
Which of the following memory areas is used to cache the Data Dictionary Information?
Database Buffer Cache 0%
PGA 0%
Redo Log Buffer 0%
Shared Pool 0%
Which of the following methods enforce resource limits?
ALTER SYSTEM SET RESOURCE_LIMIT= TRUE 0%
Set the RESOURCE_LIMIT parameter to TRUE 0%
CREATE PROFILE sessions LIMIT SESSIONS_PER_USER 2 CPU_PER_SESSION 10000 IDLE_TIME 60 CONNECT_TIME 480; 0%
ALTER PROFILE sessions LIMIT SESSIONS_PER_USER 2 CPU_PER_SESSION 10000 IDLE_TIME 60 CONNECT_TIME 480 0%
Which of the following methods is correct for starting an instance to create a database?
STARTUP 0%
STARTUP OPEN 0%
STARTUP MOUNT 0%
STARTUP NOMOUNT 0%
Which of the following options enables you to increase the size of online redo log groups?
Use the ALTER DATABASE RESIZE LOGFILE GROUP command for each group to be resized 0%
Use the ALTER DATABASE RESIZE LOGFILE MEMBER command for each member within the group being resized 0%
Add new redo log groups using the ALTER DATABASE ADD LOGFILE GROUP command with the new size. Drop the old redo log files using the ALTER DATABASE DROP LOGFILE GROUP command 0%
Use the ALTER DATBASE RESIZE LOGFILE GROUP command for each group to be resized. Use the ALTER DATABASE RESIZE LOGFILE MEMBER command for each member within the group 0%
Which of the following statements is correct with regard to an Oracle instance?
The redo log buffer is NOT a part of the shared memory area of an Oracle instance 0%
Multiple instances can execute on the same computer, each accessing its own physical database 0%
An Oracle instance is a combination of memory structures, background processes, and user processes 0%
In a shared server environment, the memory structure component of an instance consists of a single SGA and a single PGA 0%
Which of the following statements should you use to obtain information about the names, status of the control files?
SELECT name, status FROM v$parameter; 0%
SELECT name, status FROM v$controlfile; 0%
SELECT name, status FROM v$control_files; 0%
SELECT name, status FROM v$parameter WHERE parameter=control_files; 0%
Which of the following storage structures provides a way to manually store the rows (from more than one table) in the same data block?
Cluster table 0%
Partitioned table 0%
Index-organized table 0%
None of the above 0%
Which of the following tables help build scalable applications and also proves to be useful for large tables that can be queried or manipulated using several processes concurrently?
Regular table 0%
Clustered table 0%
Partitioned table 0%
Index-organized table 0%
Which of the following types of files is a part of the Oracle database?
Control file 0%
Password file 0%
Parameter files 0%
Archived log files 0%
While preparing to create a database, you must ensure that there is sufficient disk space for the database files. When you calculate the space requirements, you may need to multiplex some of the fi...
Data files 0%
Control file 0%
Password file 0%
Online redo log files 0%
With the help of the Database Configuration Assistant, you can create a template using an existing database structure. Which of the following will be included in this template?
Data files 0%
Tablespaces 0%
User defined schemas 0%
User defined schema data 0%
Initialization parameters 0%
You are creating a new database. You do NOT want users to use the SYSTEM tablespace for sorting operations. What should you do while issuing the CREATE DATABASE statement?
Create an undo tablespace 0%
Create a default temporary tablespace 0%
Create a tablespace with UNDO as a keyword 0%
None of the above 0%
You check the alert log for your database and discover that there are many lines that say "Checkpoint Not Complete." Which of the following options help solve this problem?
Delete archived log files 0%
Add more online redo log groups 0%
Increase the size of archived log files 0%
increase the size of online redo log files 0%
You have a database with DB_NAME set to STUD and ORACLE_SID set to STUD. These files are in default location for the initialization files: -init.ora -initSTUD.ora -spfile.ora -spfileSTUD.ora The da...
Init.ora, initSTUD.ora, spfileSTUD.ora 0%
Spfile.ora, spfileSTUD.ora, initSTUD.ora 0%
SpfileSTUD.ora, spfile.ora, initSTUD.ora 0%
InitSTUD.ora, spfileSTUD.ora, spfile.ora 0%
You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are...
New transactions are assigned to UNDO_TBS2 0%
Current transactions are switched to the UNDO_TBS2 tablespace 0%
The switch to UNDO_TBS2 fails, and an error message is returned 0%
The UNDO_TBS1 undo tablespace enters into a PENDING OFFLINE mode (status) 0%
You issue the following command: STARTUP MOUNT Which of the following events occur when the instance is started and database is mounted?
The SGA is allocated 0%
The background process is started 0%
The existence of the datafile is verified 0%
The existence of the online redo log file is verified 0%
You issue the following SQL statement to re-create your database and reuse all the existing database files: CREATE DATABASE Sales DATAFILE '/u01/oradata/Sales/system0l.dbf' SIZE 100M REUSE LOGFILE...
You have set MAXLOGFILES too low 0%
You omitted the CONTROLFILE REUSE clause 0%
You cannot reuse the online redo log files 0%
You cannot reuse the data file belonging to the SYSTEM tablespace 0%
You just issued the STARTUP command. Which of the following files is checked to determine the state of the database?
The control file 0%
The first member of redo log file group 1 0%
The data file belonging to the SYSTEM tablespace 0%
The most recently created archived redo log file 0%
You need to create an index on the ITEM table, which is 10 GB in size. You want your index to be spread across many tablespaces, decrease contention for index lookup, and increase scalability and m...
Bitmap 0%
Unique 0%
Partitioned 0%
Reverse key 0%
Single column 0%
You need to drop two columns from a table. Which of the following sequence of SQL statements is used to drop the columns and limit the number of times the rows are updated?
ALTER TABLE emp DROP COLUMN comments DROP COLUMN email; 0%
ALTER TABLE emp DROP COLUMN comments; ALTER TABLE emp DROP COLUMN email; 0%
ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp DROP UNUSED COLUMNS; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS; 0%
ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS; 0%
You started your database with the following command: STARTUP PFILE=initSAMPLE.ora One of the values in the initSAMPLE.ora parameter file is: LOG_ARCHIVE_START=false While your database is open, ...
When you take a backup the Archiver process is disabled 0%
The Archiver can only be started by issuing the ALTER DATABASE ARCHIVELOG command 0%
LOG_ARCHIVE_START is still set to FALSE because the PFILE is not updated when you issue the ALTER SYSTEM command 0%
The Archiver can only be started by issuing the ALTER SYSTEM ARCHIVE LOG START command each time you open the database 0%
Your company hires a DBA named Allen. He will be starting the database remotely, as he is going to work from home. You created a password file for your database and set REMOTE_LOGIN_PASSWORDFILE = ...
GRANT DBA TO ALLEN; 0%
GRANT SYSDBA TO ALLEN; 0%
GRANT RESOURCE TO ALLEN; 0%
orapwd file=orapwdSTUD user=ALLEN password=DBA 0%
Your database is in ARCHIVELOG mode. Which of the following must be true before the Log Writer (LGWR) can reuse a filled online redo log file?
The redo log file must be archived 0%
All the data files must be backed up 0%
All transactions with entries in the redo log file must complete 0%
The changes recorded in the redo log file must be written to the data files 0%