A Learning Portal from Recruitment India
Which of the following is a collection of one or more replicated objects (typically tables) that are administrated together.
Replication group
Replica
Replication
Replica group
Answer with explanation
Answer: Option AExplanation
Workspace
A _____________ is a set of tables physically stored together as one table that shares a common column.
Cluster
Datafiles
Object
Index
Answer with explanation
Answer: Option AExplanation
Workspace
When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?
Undo Data
Undone Data
Redo Data
Archive Data
Answer with explanation
Answer: Option AExplanation
The correct answer is Before the transaction happen the Oracle kept the files in Undo Data to overcome form any failure.
Workspace
Which is the smallest unit of storage in an Oracle database?
Data File
Extent
Data Block
Segment
Answer with explanation
Answer: Option CExplanation
Oracle data blocks are the smallest units of storage that Oracle can use or allocate. See Also: Your Oracle operating system-specific documentation for more information about data block sizes.
Workspace
Which clause is used to remove the duplicate records from the result set?
Distinct
Like
Group by
Where
Answer with explanation
Answer: Option AExplanation
Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with the SELECT statement.
Workspace
Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Using the SQL CREATE DATABASE command
Using the Oracle-supplied database creation procedures
Using the Oracle Database Configuration Assistant
None of the above is correct
Answer with explanation
Answer: Option CExplanation
The correct answer is Using the Oracle Database Configuration Assistant
Workspace
After a table has been created, its structure can be modified using the SQL command:
CHANGE TABLE [TableName].
ALTER TABLE [TableName].
MODIFY TABLE [TableName]
UPDATE TABLE [TableName]
Answer with explanation
Answer: Option BExplanation
The correct answer is ALTER TABLE [TableName]
Workspace
Which of the following is not true of SQL views?
The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Oracle views can be queried.
Oracle views are created using the standard SQL-92 CREATE VIEW command
Oracle views cannot use the ORDER BY clause in view definitions.
Answer with explanation
Answer: Option DExplanation
The correct answer is Oracle views cannot use the ORDER BY clause in view definitions.
Workspace
What is the Oracle database used for?
Store and retrieve relevant data
Accessing database servers
Creating backup for data
Both a & c
Answer with explanation
Answer: Option AExplanation
The correct answer is to Store and retrieve relevant data
An Oracle database is a collection of data that is viewed as if it were a single entity. A database’s main goal is to store and retrieve relevant data. The key to tackling information management issues is a database server.
Workspace
Which of the following database was designed first for enterprise grid computing?
Google database
MongoDB
SQL
Oracle database
Answer with explanation
Answer: Option DExplanation
Oracle was the first database to be created specifically for enterprise grid computing and data warehousing. The most versatile and cost-effective way to handle information and applications is through enterprise grid computing.
Workspace
Oracle database’s design is also called as –
Database Schema
Database Abstraction
Database Instance
none of these
Answer with explanation
Answer: Option AExplanation
The correct answer is Oracle database’s design is also called a Database Schema.
Workspace
What is COALESCE function?
COALESCE function result sets for VARCHAR2
COALESCE function is used to return the value which is set to be is null in the list
COALESCE function is used to return the value which is set to be not null in the list
None of the above
Answer with explanation
Answer: Option CExplanation
The correct answer is COALESCE function is used to return the value which is set to be not null in the list
Workspace
What is the use of Library cache?
Log of changes made to the database
Used to do Oracle background processes
Used to store shared SQL
None of the above
Answer with explanation
Answer: Option CExplanation
The correct answer is Used to store shared SQL
Workspace
Maximum Number Of Column A Table Can Have In Oracle?
2000
1000
500
500
Answer with explanation
Answer: Option BExplanation
The correct answer is there’s a hard limit of 1,000 columns per table in the Oracle Database. So you have to split it into many tables. But if you split it into many tables each with <= 255 columns, you’ll have more joins.
Workspace
Select the best answer.
PACKAGE foo_foo IS
PROCEDURE foo
( p_foo_text IN VARCHAR2 );
PROCEDURE foo
(p_foo_number IN NUMBER);
END;
The package specification is invalid. We can only have one procedure named foo in the package.
The package specification is valid. This is an example of overloading.
The package specification is valid. We can have an unlimited number of procedures name foo
The package specification is invalid. The first procedure should be called foo_1, the second procedure should be called foo_2
Answer with explanation
Answer: Option BExplanation
The correct answer is Package specification is valid. This is an example of overloading.
Workspace
Select incorrect variable declarations
Foo_text varchar2(10) := ‘hello world’;
Foo_time date;
Foo_char char(1) := ‘Y’;
Foo_text number(10);
Answer with explanation
Answer: Option AExplanation
The correct answer is Foo_text varchar2(10) := ‘hello world’;
Workspace