Oracle and SQL

Question 1 Multiple Choice (Single Answer)

Which of the following functions in oracle converts a string into unicode in the database unicode character set?

Translate()
Unistr()
Substr()
Upper()
Ascii()

Question 2 Multiple Choice (Single Answer)

Which of the following components of SQL tells the database how a user wants the data to be sorted?

Select
From
Where
Order by
Group by

Question 3 Multiple Choice (Single Answer)

Which of the following keys in database is a combination of all attributes inside a relation that can serve as primary key?

Alternate key
Candidate key
Foreign key
Tertiary key
Secondary key

Question 4 Multiple Choice (Single Answer)

Which of the following roles of distributed database main task is to initiate a commit or roll back operation as instructed by the global coordinator?

Client
Global coordinator
Database server
Local coordinator
Commit point site

Question 5 Multiple Choice (Single Answer)

The 'delete' command in SQL is a part of _______________.

DDL
DSL
DML
TCL
DDD

Question 6 Multiple Choice (Single Answer)

Which of the following operations in relation algebra produces all combinations of tuples from two relations that satisfy a join condition with only equality comparisons?

Theta join
Natural join
Project
Equi join
Union

Question 7 Multiple Choice (Single Answer)

Which of the following terms in a relation describes the mapping of associated entity instances in the relationship?

Degree
Connectivity
Cardinality
Attributes
Entities

Question 8 Multiple Choice (Single Answer)

Which of the following statements refers to the data independence property of a database?

Primary key and foreign key of a database are not the same.
Structure of the database is not defined during the database construct.
Users are not affected by changes to the structure of the database.
Structure of the database can be altered by anyone.
Changes made to the physical structure is affected to the logical structure of the database.

Question 9 Multiple Choice (Single Answer)

Which of the following is not the restriction applied to the table names and column of a database?

The name should not contain more than 16 characters.
The name must start with a letter.
The name can contain letters, numbers and underscores.
The name should not contain spaces.
The table name may contain any special character other than underscore.

Question 10 Multiple Choice (Single Answer)

Which of the following parts in stored function of PL/SQL block consisting of statements that assign values, control execution, and manipulate oracle data?

Declarative part
Executable part
Exception handling part
Main function part
Procedure part

Question 11 Multiple Choice (Single Answer)

Which of the following terms in a relation is a form of abstraction that specifies that two or more entities that share common attributes can be generalized into a higher level entity type called a supertype or generic entity?

Existence
Direction
Generalization hierarchy
Cardinality
Degree

Question 12 Multiple Choice (Single Answer)

Which of the following object privileges is used with SQL command revoke to allow a grantee to add records to the table?

Alter
Delete
Insert
Select
Update

Question 13 Multiple Choice (Single Answer)

Which of the following arguments in stored procedure of PL/SQL block specifies that the procedure passes a value for this argument back to its calling environment after execution?

IN
Schema
OUT
REPLACE
BEGIN

Question 14 Multiple Choice (Single Answer)

Which of the following modes in lock table command of SQL allows queries but prohibits updates to a table?

Exclusive
Nowait
Share
Row Share
Row Exclusive

Question 15 Multiple Choice (Single Answer)

Which of the following statements in PL/SQL block allows a user to change the flow of control within the block?

commit
rollback
savepoint
goto
declare

Questions