ITI COPA Database Management System: MS Access MCQ

It is a customized presentation of the data from one or more tables from a database

This clause lets you eliminate duplicate rows from the query result

The function returns all the characters in the input string in uppercase

This function returns an input string with the first character of each word in upper case.

it is a small box or bar that when clicked, selects an entire row in a table

This operator returns TRUE if at least one of the operands evaluate to true

It is a copy of either a full table or a subset of a table

A field name can have maximum upto _______ characters

All data in a relational database is stored in

It is helpful when you simply want to know if the value is present in a table or not

_______ is the programming language that defines and manipulates the database

This operator returns TRUE if at least one of the operands evaluate to true

It is a Stored Procedure that is fired when a table is modified

It is used for lengthy text and numbers

This operator returns TRUE if at least one of the operands evaluate to true

This category of commands contains only one command: SELECT

The char data type allows the maximum size of up to _____ characters.