ITI COPA Database Management System: MS Access MCQ

This clause lets you eliminate duplicate rows from the query result

A field name can have maximum upto _______ characters

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

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

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

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

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 category of commands contains only one command: SELECT

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

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

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

It is used for lengthy text and numbers

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