quiz Oracle MCQ Practice

corporate_fare Computing and Information Technology
school B.Sc. Computer Science
30 Questions
0 Completed
0 Correct
0 of 30 completed
visibility You're studying as a guest — progress isn't saved. Sign in to track progress
help Question 1
radio_button_unchecked

What is Oracle?

help Question 2
radio_button_unchecked

Which of the following is correct about Oracle?

help Question 3
radio_button_unchecked

Which of the following database was designed first for enterprise grid computing?

help Question 4
radio_button_unchecked

Which of the following is not a Oracle Database feature?

help Question 5
radio_button_unchecked

Which of the following is an advantage of Oracle database?

help Question 6
radio_button_unchecked

Which of the following is a disadvantage of Oracle database?

help Question 7
radio_button_unchecked

What is Oracle database used for?

help Question 8
radio_button_unchecked

Which of the following components comprise an Oracle architecture?

help Question 9
radio_button_unchecked

Which of the following area of PGA stores binding variables and run-time buffers information?

help Question 10
radio_button_unchecked

Which of the following is the smallest unit of storage in an Oracle database?

help Question 11
radio_button_unchecked

Which of the following is another name of Oracle database’s design?

help Question 12
radio_button_unchecked

Which of the following is used to logically group data together?

help Question 13
radio_button_unchecked

Which of the following package procedure is UNRESTRICTED in Oracle?

help Question 14
radio_button_unchecked

Oracle server configuration is dedicated for

help Question 15
radio_button_unchecked

Which schema object instructs Oracle to connect to remotely access an object of a database?

help Question 16
radio_button_unchecked

When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?

help Question 17
radio_button_unchecked

A new user on the database is created by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is correct in this scenario?

help Question 18
radio_button_unchecked

Which of the following is referred to as the language used application programs to request data from the DBMS?

help Question 19
radio_button_unchecked

Which of the following RDBMS supports full fledged client server application development?

help Question 20
radio_button_unchecked

Which of the following is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

help Question 21
radio_button_unchecked

Which of the following is not included in DML (Data Manipulation Language)?

help Question 22
radio_button_unchecked

Which of the following keyword is used with Data Control Language (DCL) statements?

help Question 23
radio_button_unchecked

Which of the following command is used to obtain the structure of an Oracle table?

help Question 24
radio_button_unchecked

Which of the following is not a type of SQL statement?

help Question 25
radio_button_unchecked

command to use iscommand is used for removing a table and all its data from the database?

help Question 26
radio_button_unchecked

Which of the following is/are the DDL statements?

help Question 27
radio_button_unchecked

The SQL statement

help Question 28
radio_button_unchecked

Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?

help Question 29
radio_button_unchecked

Which of the following is record based logical model?

help Question 30
radio_button_unchecked

Which of the following is not a Key in SQL Server?