databases Online Quiz - 119
Description: databases Online Quiz - 119 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Archived Redo Log is
Examine the syntax for creating a DEPARTMENT table: CREATE TABLE ABCD( A NUMBER(4), B VARCNAR2(30), C NUMBER(6), D NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE userdata; What is the size defined for the fifth extent?
The control file defines the current state of the physical database. Which dynamic performance views obtain information from the control file?
Control file contains information about
What is a Parallel Server
To re-create a database, all existing database files should be reused. The following SQL statement is issued: CREATE DATABASE ABC DATAFILE '/u01/oradata/abc/system0l.dbf' SIZE 100M REUSE LOGFILE GROUP 1 ('/u01/oradata/abc/logla.rdo', '/u02/oradata/abc/loglb.rdo') SIZE 50K REUSE, GROUP 2 ('/u01/oradata/abc/log2a.rdo', '/u02/oradata/abc/log2b.rdo') SIZE 50K REUSE MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10; Why does the CREATE DATABASE statement fail?
What represents the value of the ORACLE_HOME environment variable in Oracle 9i?
Which of the following tasks can be performed by using the TO_CHAR function?
Evaluate the following SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is the correct use of the Trunc command on a date?
How do I eliminate duplicate rows in an Oracle database?
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
Which command will delete all data from a table and will not write to the rollback segment?
Which character function can be used to return a specified portion of a character string?
Which of the following SQL functions can operate on any datatype?
Which of the following is an important consideration when tuning an SQL statement?
What best describes the relationship between indexes and SQL performance?
Which of the following SQL clauses is used to select data from 2 or more tables?
Which of the following commands cause a transaction to end?