WorksheetsDBMS Lab-Model Exam-Viva
Total questions: 10
Worksheet time: 5mins
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?
IF-THEN-ELSIF statement
IF-THEN statement
All of the options
IF-THEN-ELSE statement
PL/SQL function must contain a
Return Statement
Follow Statement
GOTO Statement
NULL Statement
