Primary Key
Forign Key
Composite Key
Alternate Key
Change The Structure Of Tables
Insert, Update Or Delete Records And Data Values
Authorizing Access And Other Control Over Database
None Of Above
Unique
Not Null
A and B Both
None of These
Foreign Key
Both A and B
None of these
Validation rule
Default value
Input mask
None of above
Sophisticated Question List
Structured Question List
Structured Query Language
Small Query Length
Simple Query Language
System Query Language
Sequential Query Language
FETCH
SELECT
GET
READ
To specify the columns to be retrieved
To filter the rows based on a condition
To order the result set
To perform mathematical operations
ASC
DESC
ORDER BY
SORT
To filter rows based on a condition
To join tables
To group rows based on a column's values
To perform arithmetic operations
INT
DATE
VARCHAR
FLOAT
Deletes the table structure
Deletes all records from the table
Deletes a specific record based on a condition
Deletes a specific column from the table
ALTER TABLE
UPDATE TABLE
MODIFY TABLE
ADD COLUMN
To concatenate strings
To combine rows from two or more tables based on a related column
To create a temporary table
TOTAL()
COUNT()
SUM()
AVG()
B. To filter out duplicate values from the result set
C. To retrieve records in a distinct order
D. To select distinct columns from a table
Answer: B. To filter out duplicate values from the result set
B. MODIFY
C. ALTER
D. CHANGE
Answer: A. UPDATE
B. To insert a new record into a table
C. To update an existing record in a table
D. To delete records from a table
Answer: B. To insert a new record into a table
B. LIKE
C. IN
D. EXISTS
Answer: A. BETWEEN