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

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)?

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?

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?

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?

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?

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

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

Count function in SQL returns the number of

  • Values
  • Distinct values
  • groups
  • Columns

'AS' clause is used in SQL for

'AS' clause is used in SQL for

  • Selection operation
  • Rename operation
  • Join operation
  • Projection operation

DML is provided for

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

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

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?

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?

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?

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?

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?

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

Objects on the slide that hold text are called

  • Placeholders
  • Object holders
  • Auto layouts
  • Text holders

What is total area of the earth?

What is total area of the earth?

  • 510.94 million km2
  • 492.102 million km2
  • 392.023 million km2
  • 692.192 million km2

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

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