DBMS Lab-Model Exam-Viva

Which SQL function is used to count the number of rows in a SQL query?

• SUM()

• NUMBER()

• COUNT()

• COUNT(*)

Which of the following is not a DDL command?

• None of the Mentioned

• ALTER

• TRUNCATE

• UPDATE

Which of the following statement is true?

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

• Both DELETE and TRUNCATE free the space containing the table

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

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

Which of the following is not true about the ALTER TABLE statement?

• It can add a new column.

• It can modify existing columns.

• It can define a default value for the new column.

• It can add a new row.

Which of the following is not a valid aggregate function?

• COUNT

• SUM

• MAX

• COMPUTE

Which of the following is not a database object?

• TABLE

• INDEX

• RELATIONSHIP

• SEQUENCE

Which of the following database object is ideal to view, change, and analyze data in different ways ?

• TABLE

• REPORT

• FORM

• QUERY

Is it possible to create a view without the existence of the base table?

• YES

• NO

Which of the following is correct syntax of IF statement?

• 1. IF-THEN-ELSIF statement

• 1. IF-THEN statement

• 1. All of the options

• 1. IF-THEN-ELSE statement

PL/SQL function must contain a

• 1. Return Statement

• 1. Follow Statement

• 1. GOTO Statement

• 1. NULL Statement