Technical Evaluation - 102 - 2024

Which of the following statement is true?

• DELETE does not free the space containing the table and TRUNCATE free the space containing the table
• Both DELETE and TRUNCATE free the space containing the table
• Both DELETE and TRUNCATE does not free the space containing the table
• DELETE free the space containing the table and TRUNCATE does not free the space containing the table

What is the purpose of the SQL AS clause?

• The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column
• The AS clause is used with the JOIN clause only
• The AS clause defines a search condition
• All of the mentioned

What does the ALTER TABLE clause do?

• The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
• The SQL ALTER TABLE clause is used to insert data into database table
• THE SQL ALTER TABLE deletes data from database table
• The SQL ALTER TABLE clause is used to delete a database table

_______ allow us to identify uniquely a tuple in the relation.

• schema
• superkey
• domain
• attribute

Logical design of database is called

• all of the options
• database schema
• database instance
• database snapshot

Which of the following is correct regarding Aggregate functions?

• it takes a single value and returns a single value as result
• it takes a list of values and return a single values as result
• it takes a list of values and return a list of values as result
• it takes a single value and returns a list of values as result

The attribute that can be divided into other attributes is called

• composite attribute
• derived attribute
• simple attribute
• multi-valued attribute

What is ACID properties of Transactions?

• atomicity, consistency, isolation, database
• automatically, concurrency, isolation, durability
• atomicity, consistency, isolation, durability
• atomicity, consistency, inconsistent, durability

If every non-key attribute is functionally dependent on the primary key, the relation will be in

• fourth formal form
• third normal form
• first normal form
• second normal form

Database locking concept is used to solve the problem of

• inconsistent data
• lost update
• uncommitted dependency
• all of the options