Treasure of MCQS

In SQL, which of the following is not a data definition language command?

RENAME

REVOKE

GRANT

UPDATE

Which command is used to select distinct subject (SUB. from the table (BOOK)?

SELECT ALL FROM BOOK

SELECT DISTINCT SUB FROM BOOK

SELECT SUB FROM BOOK

All of the above

Which of the following is a valid SQL type?

CHARACTER

NUMERIC

FLOAT

All of the above

Which of the following is a legal expression in SQL?

SELECT NULL FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE WHERE SALARY=NULL;

None of the above

Which of the following operation is used if we are interested in only certain columns of a table?

PROJECTION

SELECTION

UNION

JOIN

Which of the following is correct?

A SQL query automatically eliminates duplicates

SQL permits attribute names to be repeated in the same relation

A SQL query will not work if there are no indexes on the relations

None of the above

The statement in SQL which allows to change the definition of a table is

Alter

Update

Create

Select

Count function in SQL returns the number of

Values

Distinct values

groups

Columns

'AS' clause is used in SQL for

Selection operation

Rename operation

Join operation

Projection operation

DML is provided for

Description of logical structure of database

Addition of new structure in the database system

Manipulation & processing of database

Definition of physical structure of database system

You can show the shortcut menu during the slide show by

Clicking the shortcut button on the formatting toolbar

Right clicking the current slide

Clicking an icon on the current slide

Option a and b

To select all of the boxes of an organization chart

Clicking and edit and select all

Right click the chart background and then click select all

Press and hold the SHIFT key and click each box

All of above

Which of the following can you use to add time to the slides in a presentation?

Slide show menu

Rehearse timings button

Slide transition button

All of the above

How can you quickly reinstate a deleted footer placeholder in master view?

Create a new slide master

Re-apply the slide layout

Re-apply the footer placeholder

All of the above

In normal view, how can you quickly change to the handout master view?

Click the outline tab and select handout master view

Press the shift key and click the handout master view button

On the view menu, click slide sorter, and click handouts

All of the above

Which command brings you to the first slide in your presentation?

Next slide button

Page up

Ctrl + Home

Ctrl + End

Which of the following provides a means of printing out feature notes with a miniature slide on a printed page?

Slide with animation

Outline view

Notes page

Audience handout

Objects on the slide that hold text are called

Placeholders

Object holders

Auto layouts

Text holders

What is total area of the earth?

510.94 million km²

492.102 million km²

392.023 million km²

692.192 million km²

Which of the following views is the best view to use when setting transition effects for all slides in a presentation?

Slide sorter view

Notes pages view

Slide view

Outline view

For Viewers

I am working hard on daily basis to add correct and important multiple question answer (Mcqs) but still mistake can happen because no one is 100% perfect. Also, I am getting these info from both online and offline sources So, It will be nice to fix me if I did any mistake in answering or Asking a question. Your explanation will be review by author and will be added to post. Contributors will be rewarded by mentioning their name and with social profile link if some one willing to. You can also submit Mcqs by clicking Here but before submitting make sure that question isn't available on our blog. For that do a quick search to confirm it. Thanks