logo

MCQ Problems / Explanations



A subject S is not allowed to write an object O unless Class(S) <= Class(O) . It is

Last updated: Sat, 8 Feb

______ allows one to express access control policies that take the protection object content into account.

Last updated: Sat, 8 Feb

Authorizing the identity and managing the schema of these identities is called

Last updated: Sat, 8 Feb

The characteristics of Hierarchic diagrams of RBAC are

Last updated: Sat, 8 Feb

Types of mutual exclusion of roles are

Last updated: Sat, 8 Feb

If two roles in RBAC cannot be used simultaneously by the user is termed as____

Last updated: Sat, 8 Feb

When a tuple value at some security level can be filtered (derived) from a higher-classified tuple, then it is suff...

Last updated: Sat, 8 Feb

When all attributes that are members of the apparent key must not be null and must have the same security classific...

Last updated: Sat, 8 Feb

When several tuples can have the same apparent key value but have different attribute values for users at different...

Last updated: Sat, 8 Feb

The process of storing a single tuple in the relation at a higher classification level and produce the correspondin...

Last updated: Sat, 8 Feb

The _____ key of multilevel relation is the set of attributes that would have formed the primary key in a regular (...

Last updated: Sat, 8 Feb

Simple Security property is defined as

Last updated: Sat, 8 Feb

A subject S is not allowed read access to an object O unless

Last updated: Sat, 8 Feb

To limit the depth of the granting of privileges is

Last updated: Sat, 8 Feb

When an account B, given the GRANT OPTION, can grant the privilege to at most i other accounts is termed as

Last updated: Sat, 8 Feb

The owner A of a relation R grants a privilege on R to another account B, the privilege can be given to B

Last updated: Sat, 8 Feb

Taking away the privileges once the assigned task is completed is called ____

Last updated: Sat, 8 Feb

When an account has been given the capability to reference a relation R when specifying integrity constraints is kn...

Last updated: Sat, 8 Feb

The DBA can control the privilege to access each individual relation or view in the database. It is known as

Last updated: Sat, 8 Feb

A database log that is used mainly for security purposes is sometimes called

Last updated: Sat, 8 Feb

The actions performed by the DBA

Last updated: Sat, 8 Feb

The pathways for information to flow implicitly in ways that violate the security policy of an organization are cal...

Last updated: Sat, 8 Feb

Handling the creation of user accounts and passwords to control the login process by the DBMS is known as

Last updated: Sat, 8 Feb

Preventing information from flowing un such a way that it reaches unauthorized users is called

Last updated: Sat, 8 Feb

In ________ encryption, a pair of keys is used.

Last updated: Sat, 8 Feb

In a_________ encryption, the same key is used by both the sender and the receiver.

Last updated: Sat, 8 Feb

The_______ is the message after transformation.

Last updated: Sat, 8 Feb

Which is the disadvantage of the symmetric Encryption?

Last updated: Sat, 8 Feb

Authentication refers to

Last updated: Sat, 8 Feb

Data integrity means

Last updated: Sat, 8 Feb

Prevention of access to the database by unauthorized user is referred to as

Last updated: Sat, 8 Feb

Data security threats include

Last updated: Sat, 8 Feb

What is used for database security?

Last updated: Sat, 8 Feb

For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is rai...

Last updated: Sat, 8 Feb

Which collection exception is raised when a subscript exceeds the number of elements in a collection?

Last updated: Sat, 8 Feb

Which collection exception is raised when a subscript designates an element that was deleted, or a nonexistent elem...

Last updated: Sat, 8 Feb

To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege,...

Last updated: Sat, 8 Feb

In which mode parameter lets you pass values to the subprogram being called? It cannot be assigned a value.

Last updated: Sat, 8 Feb

Which internal exception is raised when a program references a nested table or array element using an index number ...

Last updated: Sat, 8 Feb

True dependencies generated in reflexive rule are classified as

Last updated: Sat, 8 Feb

The grant privileges on SQL authorization mechanism does not have

Last updated: Sat, 8 Feb

Which statement is used to revoke an authorization

Last updated: Sat, 8 Feb

Implicitly to all current and future privileges that are granted users are called as

Last updated: Sat, 8 Feb

Grant privileges on SQL authorization mechanism_____________

Last updated: Sat, 8 Feb

When we update any tuple in the relation which authorization on a relation allows a user to

Last updated: Sat, 8 Feb

Which of the following is not true about the PL/SQL functions?

Last updated: Sat, 8 Feb

Which of the following is true about the execution section of a PL/SQL block?

Last updated: Sat, 8 Feb

What is the maximum number of else clauses that can be included in an if clause that is not nested?

Last updated: Sat, 8 Feb

The structure of a PL/SQL package closely resembles the basic Pascal program structure or a _____ unit.

Last updated: Sat, 8 Feb

PL/SQL functions analogously to the embedded procedural languages associated with other______

Last updated: Sat, 8 Feb

PL/SQL is ________'s procedural extension language for SQL and oracle relational database.

Last updated: Sat, 8 Feb

As a procedural language by definition, PL/SQL provides several iteration constructs, including basic loop statemen...

Last updated: Sat, 8 Feb

Functions in PL/SQL are a collection of ______ and PL/SQL statements that perform a task and should return a value ...

Last updated: Sat, 8 Feb

Which one of the following statements about formal and actual parameters is true?

Last updated: Sat, 8 Feb

What are the three parameter modes for the procedure?

Last updated: Sat, 8 Feb

When modifying procedure code, the procedure must be re-executed to validate and store it in the database.

Last updated: Sat, 8 Feb

Which kind of parameters can not have a default value?

Last updated: Sat, 8 Feb

A nested subprogram can be called from the main procedure or from the calling environment.

Last updated: Sat, 8 Feb

If you do not specify mode for a parameter, what is the default mode?

Last updated: Sat, 8 Feb

Subprograms and anonymous blocks can be called by other applications.

Last updated: Sat, 8 Feb

Which of the following can be used as an argument for procedure parameter?

Last updated: Sat, 8 Feb

PL/SQL subprograms, unlike anonymous blocks, are compiled each time they are exceuted.

Last updated: Sat, 8 Feb

For which trigger timing can you reference the NEW and OLD qualifiers?

Last updated: Sat, 8 Feb

What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occur?

Last updated: Sat, 8 Feb

What happens when rows are found using a fetch statement?

Last updated: Sat, 8 Feb

The command used to open a cursor for loop is

Last updated: Sat, 8 Feb

Which line in the following statement will produce an error?

Last updated: Sat, 8 Feb

If left out, which of the following would cause an infinite loop to occur in a simple loop?

Last updated: Sat, 8 Feb

Which of the following is not implicit cursor attributes?

Last updated: Sat, 8 Feb

Which of the following is not a feature of cursor for loop?

Last updated: Sat, 8 Feb

Which of the following statements is true about implicit cursors?

Last updated: Sat, 8 Feb

A top to bottom relationships among the items in a database is established by a

Last updated: Sat, 8 Feb

A view of database that appears to an application program is known as

Last updated: Sat, 8 Feb

In an object oriented model, one object can access data of another object by passing

Last updated: Sat, 8 Feb

One of the following is a valid record based data model

Last updated: Sat, 8 Feb

Which one is an example for network database?

Last updated: Sat, 8 Feb

The Scheme for hierarchical database is

Last updated: Sat, 8 Feb

Data about data is normally termed as

Last updated: Sat, 8 Feb

The data model which describes how the data is actually stored is

Last updated: Sat, 8 Feb

The language used application programs to request data from the DBMS is referred to as the

Last updated: Sat, 8 Feb

The mapping between the external and logical levels provides various views to the users.

Last updated: Sat, 8 Feb

An autonomous homogenous environment is which of the following?

Last updated: Sat, 8 Feb

The layout of the data within the disk file system is found at the logical/conceptual level.

Last updated: Sat, 8 Feb

The constructs of a procedure, function or a package are ________

Last updated: Sat, 8 Feb

The recovery scheme must also provide

Last updated: Sat, 8 Feb

____________ is preferred method for enforcing data integrity

Last updated: Sat, 8 Feb

Drop Table cannot be used to drop a table referenced by a _________ constraint.

Last updated: Sat, 8 Feb

Which one of the following uniquely identifies the elements in the relation?

Last updated: Sat, 8 Feb

______ is a special type of integrity constraint that relates two relations & maintains consistency across the rela...

Last updated: Sat, 8 Feb

Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can b...

Last updated: Sat, 8 Feb

Data integrity constraints are used to

Last updated: Sat, 8 Feb

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any numb...

Last updated: Sat, 8 Feb

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity...

Last updated: Sat, 8 Feb

_____________, express the number of entities to which another entity can be associated via a relationship set.

Last updated: Sat, 8 Feb

A special redo-only log record is written to the log, where V1 is the value being restored to data item Xj during t...

Last updated: Sat, 8 Feb

The actions which are played in the order while recording it is called ______________ history.

Last updated: Sat, 8 Feb

In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last c...

Last updated: Sat, 8 Feb

____________ using a log record sets the data item specified in the log record to the old value.

Last updated: Sat, 8 Feb

If database modifications occur while the transaction is still active, the transaction is said to use the _________...

Last updated: Sat, 8 Feb

If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.

Last updated: Sat, 8 Feb