Identify the physical component of the database, which stores the information about the database layout
Datafile
Controlfile
Redolog Group
Archivelogs
Password File
Identify the logical components of the database. Choose all that apply.
Database
Table
Schema
which of the following represent the "not equal to" condition?
!=
^=
<>
!==
which of the following is not a comparison condition?
NOT LIKE
IN (set)
==
which of the following are wildcard characters?
%
$
_
*
RDBMS stands for
Relational Database Management System
Rational Database Management System
Real Database Management System
Rapid Database Management System
Identify SQL statement which is used for Data Retrieval
Insert
Create
Delete
Select
Grant
Commit
Identify SQL statement which is used for Data Manipulation. Choose all that apply.
Merge
Update
Identify SQL statement which is used as Transaction Control Language command. Choose all that apply.
Alter
Rollback
Rename
Savepoint
Identify SQL statement which is used as Data Control Language command. Choose all that apply.
Revoke