0
Q:

# Copying the logs on the standby/backup server is an operation of Log Shipping

 A) TRUE B) FALSE

Explanation:

It is one of the operation of Log Shipping

Q:

The SQL keyword BETWEEN is used:

 A) for ranges B) as a wildcard C) to limit the columns displayed D) All the above

Explanation:

In SQL, BETWEEN Keyword is used for ranges like Number Ranges, Date Ranges, etc...

0 41
Q:

Candidate Key in DBMS?

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.

70
Q:

Foreign key in DBMS is

Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.

In detail : A Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.

64
Q:

A Transparent DBMS

 A) Keep its logical structure hidden from users B) Can access control C) Keeps its physical structure hidden from users D) Can not hide sensitive information from users

Answer & Explanation Answer: C) Keeps its physical structure hidden from users

Explanation:

DBMS :: Database Managemet System.

A DBMS which keeps its physical structure hidden from the user is known as a transparent DBMS.

2 108
Q:

What is Primary Key in DBMS?

A primary key is a special relational database table column or combination of columns designated to uniquely identify all table records. That is, A primary key is a column or set of columns in a table that uniquely identifies tuples (rows) in that table.

A primary key, also called a Primary Keyword.

Main Features Primary key are ::

It must contain a unique value for each row of data.

It cannot contain null values.

133
Q:

what will be the output of the following code?

class Value
{
public int i = 15;
}
public class Test
{
public static void main(String argv[])
{
Test t = new Test();
t.first();
}
public void first()
{
int i = 5;
Value v = new Value();
v.i = 25;
second(v, i);
System.out.println(v.i);
}
public void second(Value v, int i)
{
i = 0;
v.i = 20;
Value val = new Value();
v =  val;
System.out.println(v.i + " " + i);
}
}

 A) 15 0 2 B) 15 0 0 C) 15 20 0 D) 15 0 20

Explanation:

3 111
Q:

Difference between Candidate key and Primary key?

Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key.

Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.

• One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization. For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain.

189
Q:

Which dml command is used in conjunction with @@identity?

 A) INSERT and UPDATE B) UPDATE and DELETE C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback