Database [3i Infotech Placement]: Sample Questions 69 - 70 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 69

Database

Question

MCQ▾

A FORM is made up of which of the following objects … .

Choices

Choice (4)

a.

Only blocks.

b.

block, fields only,

c.

blocks, fields, pages only,

d.

blocks, fields, pages, triggers and form level procedures,

Answer

d.

Explanation

  • Form is made up of blocks, fields, pages, triggers and form level procedures.
  • To access a database object user interface can be created- generates form՚s HTML and validate user՚s input.
  • Form is easy for visitors to use.
  • Form object is designed to get a specific type of information.
  • For example, for a list of categories- to select more than one category, check box form object can be used however to only select one category, use the radio button form object instead.

Question 70

Database
Edit

Describe in Detail

Essay▾

To retrieve information using SQL, what is the 1st word is your query?

Explanation

Explanation of SELECT Statement
  • To retrieve information using SQL, SELECT is the 1st word is in query

SQL SELECT statement:

  • Starts with the SELECT keyword
  • Used to retrieve information from MySQL database tables.
  • Made of several different keywords known as clauses.
  • Query may retrieve information from specified columns or from all of the columns in the table.
  • To specify the column name and the table name, to create a simple SQL SELECT statement
  • The whole query is called SQL SELECT Statement.

Syntax of SQL SELECT Statement:

SELECT “column1”

[, “column2” , etc]

From “tablename”

[where “condition” ] ;

[] = optional

Conditional selections used in the where clause:

= Equal

> Greater

< Less than

>= Greater than or equal

<= Less than or equal

<> Not equal to

Ex .

SELECT first_name + ‘’ +

Last_name As emp_name FROM

Employee;

O/P

emp_name

Developed by: