DCL stands for
A. Data Control Language
B. Data Console Language
C. Data Console Level
D. Data Control Level
TCL stands for
A. Transaction control languages
B. Transaction command languages
C. Transaction connect languages
D. None of the Mentioned
What file is read by ODBC to load drivers ?
A. ODBC.INI
B. ODBC.DLL
C. ODBCDRV.INI
D. None of the above
_________commands in SQL allow controlling access to data within database.
A. Database
B. Database
C. Data
D. Data control
E. All of the Mentioned
In an SQL statement, which of the following parts states the conditions for row selection?
A. Where
B. From
C. Order By
D. Group By
A transaction completes its execution is said to be
A. Committed
B. Aborted
C. Rolled back
D. Failed
The status of the Rollback segment can be viewed through
A. DBA_SEGMENTS
B. DBA_ROLES
C. DBA_FREE_SPACES
D. DBA_ROLLBACK_SEG
Which of the following keyword is used with Data Control Language (DCL) statements?
A. SELECT
B. INSERT
C. DELETE
D. GRANT
It is very difficult to grant and manage common priveleges needed by different groups of database users using roles.
A. TRUE
B. FALSE
C.
D.
DCL Provides Commands To Perform Actions Like _____________
A. Change The Structure Of Tables
B. Insert, Update Or Delete Records And Data Values
C. Authorizing Access And Other Control Over Database
D. None of the Mentioned
Which of the following is TRUE. 1 Host variables are declared anywhere in the program 2 Host variables are declared in the DECLARE section
A. Only 1 is TRUE
B. Only 2 is TRUE
C. Both 1 & 2are TRUE
D. Both are FALSE
What is SQL * FORMS ?
A. SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application
B. SQL * FORMS is a 3GL tool for connecting to a Database
C. SQL * FORMS is a reporting tool
D. None of the Mentioned
What does DLL stand for ?
A. Dynamic Link Library
B. Dynamic Language Library
C. Dynamic Load Library
D. None of the Mentioned
What is a trigger
A. A piece of logic written in PL/SQL
B. Executed at the arrival of a SQL*FORMS event
C. Both A & B
D. None of the above
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. DML and DDL
D. None of the Mentioned
Which of the following is TRUE for a ERASE packaged procedure 1 ERASE removes an indicated Global variable & releases the memory associated with it 2 ERASE is used to remove a field from a page
A. Only 1 is TRUE
B. Only 2 is TRUE
C. Both 1 & 2 are TRUE
D. Both 1 & 2 are FALSE
The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________
A. SYSTEM.LAST_RECORD
B. SYSTEM.CURSOR_RECORD
C. SYSTEM.CURSOR_FIELD
D. SYSTEM.LAST_QUERY
Which of the following is TRUE for the ENFORCE KEY field a. ENFORCE KEY field characterstic indicates the source of the value that SQL*FORMS uses to populate the field b. A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off
A. Only 1 is TRUE
B. Only 2 is TRUE
C. Both 1 and 2 are TRUE
D. Both 1 and 2 are FALSE
POST-BLOCK trigger is also a ?
A. Navigational Trigger
B. Key Trigger
C. Transaction Trigger
D. All of the Mentioned
What is the maximum size of the page ?
A. Characters wide & 265 characters length
B. Characters wide & 265 characters length
C. Characters wide & 80 characters length
D. None of the above
In Oracle, which of the following package procedure is UNRESTRICTED ?
A. CALL_INPUT
B. CLEAR_BLOCK
C. EXECUTE_QUERY
D. USER_EXIT
LGWR process writes information into
A. Database files
B. Control files
C. Redolog files
D. All the above
What is the full form of SQL?
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of the Mentioned
A FORM is madeup of which of the following objects
A. block, fields only.
B. blocks, fields, pages only.
C. blocks, fields, pages, triggers and form level procedures.
D. Only blocks.
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the Mentioned
Which of the following is TRUE for the SYSTEM VARIABLE $$date$$
A. Can be assigned to a global variable
B. Can be assigned to any field only during design time
C. Can be assigned to any variable or field during run time
D. None of the above
Which of the following is/are the DDL statements?
A. Create
B. Drop
C. Alter
D. All of the Mentioned
What are the SQL clauses supported in the link property sheet ?
A. WHERE & START WITH
B. WHERE & HAVING
C. START WITH & HAVING
D. WHERE, START WITH & HAVING