FPSC - Database Administrator Model Papers -2026 — Test 5
Page 1 of 3
Question 1
What is a global temporary table?
FPSC - Database Administrator Model Papers -2026
Question 2
Which of the following is a valid Oracle table name?
FPSC - Database Administrator Model Papers -2026
Question 3
Which statement adds a new column to an existing table?
FPSC - Database Administrator Model Papers -2026
Question 4
Which statement changes the size of an existing column?
FPSC - Database Administrator Model Papers -2026
Question 5
Which statement removes a column from a table?
FPSC - Database Administrator Model Papers -2026
Question 6
Which statement renames a table?
FPSC - Database Administrator Model Papers -2026
Question 7
What does DROP TABLE emp CASCADE CONSTRAINTS do?
FPSC - Database Administrator Model Papers -2026
Question 8
How does TRUNCATE differ from DELETE?
FPSC - Database Administrator Model Papers -2026
Question 9
Which SQL*Plus command shows the column names and data types of a table?
FPSC - Database Administrator Model Papers -2026
Question 10
Which view lists the columns of the tables owned by the current user?
FPSC - Database Administrator Model Papers -2026