Database Administration Questions

Alter database backup control file to trace

The More You Have the Darkness, The Less You See i.e, visible less.

They watch no movie during the working days, but in holidays they watch one movie.

is correctly written among the given options.

France national football team has won the FIFA 2018 - an international football tournament contested by the men's national teams of the member associations of FIFA once every four years. It took place in Russia from 14 June to 15 July 2018.

Given word is TRANSFORMER.

Number of letters in the given word = 11 (3 R's)

Required, number of ways the letters of the word 'TRANSFORMER' can be arranged such that 'N' and 'S' always come together is

10! x 2!/3!

= 3628800 x 2/6

= 1209600

A Telephone or an Alarm...

SQL statements are broadly classified into three. They are

1. DDL – Data Definition Language

DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.

2. DML – Data Manipulation Language

DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.

3. DCL – Data Control Language

DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

In computers, generally Font size is measured in points (pt).