Consider the under mentioned syntax, which creates a DEPARTMENT table:

CREATE TABLE department

(DeptnoNUMBER(4),

DnameVARCNAR2(30),

mgr NUMBER(6),

LocNUMBER(4))

STORAGE(INITIAL 200K NEXT 200K

PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5)

TABLESPACE userdata;

What is the size defined for the fifth extent?

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?

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 externally. 2. Make sure that the user has CONNECT and RESOURCE privileges. 3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges. 4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary tablespace. 5. Assign the user to the DATA_TS default tablespace Which of the following statements would you use to create the User Account for Smith?

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 running a business critical Data Manipulation Language (DML) statement, and it must complete prior to shutting down the database. Which of the following shutdown statements prevents the new user connections, logs off the remaining user, and shuts down the database after the DML statement completes?

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 does not provide access to the database. 3)The OPEN command enables users to access the database. 4)The STARTUP command starts an instance. Which of these statements are correct?

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 GROUP 1 ('/u01/oradata/Sales/logla.rdo', '/u02/oradata/Sales/loglb.rdo') SIZE 50K REUSE, GROUP 2 ('/u01/oradata/Sales/log2a.rdo', '/u02/oradata/Sales/log2b.rdo') SIZE 50K REUSE MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10; The CREATE DATABASE statement fails. Why?

Examine the following TRUNCATE TABLE command: TRUNCATE TABLE departments; Which of the following statements are correct with regard to this command?

You issue the following command: STARTUP MOUNT Which of the following events occur when the instance is started and database is mounted?

Which of the following helps a DBA examine the performance of the database?

Which of the following methods enforce resource limits?

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?