In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

In SQL, the CREATE TABLESPACE isused
A.
to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace
B.
to createa database trigger
C.
to add/rename data files, to change storage
D.
All of theabove
E.
None of the above
by

1 Answer

Answer :

to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace
by

Related questions

Which of the following technique isused for encapsulation? A. a technique used inbest-effort delivery systems toavoid endlessly loopingpackets. B. a technique used by protocols in which a lower level protocol accepts a message from ahigher level protocol and places it in the data portion of the low level frame. C. One of the pieces that results when an IP gateway divides an IP datagram into smallerpieces for transmission acrossa network that cannothandle the originaldatagram size D. All of theabove E. None of the above

Description : Which of the following technique isused for encapsulation? A. a technique used inbest-effort delivery systems toavoid endlessly loopingpackets. B. a technique used by protocols in which a lower level ... network that cannothandle the originaldatagram size D. All of theabove E. None of the above

Last Answer : a technique used by protocols in which a lower level protocol accepts a message from ahigher level protocol and places it in the data portion of the low level frame

Which of the following technique isused for fragment? A. a technique used inbest-effort delivery systems toavoid endlessly loopingpackets B. a technique used by protocols in which a lower level protocol accepts a message from ahigher level protocol and places it in the data portion of the low level frame C. one of the pieces that results when an IP gateway divides an IP datagram into smallerpieces for transmission acrossa network that cannothandle the originaldatagram size D. All of theabove E. None of the above

Description : Which of the following technique isused for fragment? A. a technique used inbest-effort delivery systems toavoid endlessly loopingpackets B. a technique used by protocols in which a lower level protocol ... network that cannothandle the originaldatagram size D. All of theabove E. None of the above

Last Answer : one of the pieces that results when an IP gateway divides an IP datagram into smallerpieces for transmission acrossa network that cannothandle the originaldatagram size

In SQL, which command(s) is(are) used to change atable's storage characteristics? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of theabove E. None of the abov

Description : In SQL, which command(s) is(are) used to change atable's storage characteristics? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of theabove E. None of the abov

Last Answer : ALTER TABLE

How will you create multiple rollback segments in a database ?

Description : How will you create multiple rollback segments in a database ?

Last Answer : Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment ... ) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments.

In SQL, the command(s) is (are)used tocreate an index for atable or cluster A. CREATE INDEX B. MODIFY INDEX C. SET INDEX TO FILE D. All of theabove E. None of the above

Description : In SQL, the command(s) is (are)used tocreate an index for atable or cluster A. CREATE INDEX B. MODIFY INDEX C. SET INDEX TO FILE D. All of theabove E. None of the above

Last Answer : CREATE INDEX

Database management systems are intended to: A. eliminatedata redundancy B. establishrelationships among records in different files C. manage file access D. maintaindata integrity E. All of theabove

Description : Database management systems are intended to: A. eliminatedata redundancy B. establishrelationships among records in different files C. manage file access D. maintaindata integrity E. All of theabove

Last Answer : All of theabove

There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey called? A. Data storage system B. Database management system (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Description : There arecertain packages that allow people to define data items, place these items in particular records, combine therecords into designated files and then manipulate and retrieve the storeddata. What arethey ... (DBMS) C. Batch processingsystem D. Data communication package E. None of the above

Last Answer : Database management system (DBMS)

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.

In SQL, which of the following is not adata definitionlanguagecommands? A. RENAME B. REVOKE C. GRANT D. UPDATE E. None of the above

Description : In SQL, which of the following is not adata definitionlanguagecommands? A. RENAME B. REVOKE C. GRANT D. UPDATE E. None of the above

Last Answer : UPDATE

In SQL, which commandis used to select only onecopy of each setof duplicablerows A. SELECT DISTINCT B. SELECT UNIQUE C. SELECT DIFFERENT D. All of theabove E. None of the above

Description : In SQL, which commandis used to select only onecopy of each setof duplicablerows A. SELECT DISTINCT B. SELECT UNIQUE C. SELECT DIFFERENT D. All of theabove E. None of the above

Last Answer : SELECT DISTINCT

. In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Description : . In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Last Answer : ALTER FUNCTION

A logical schema A. is the entire database B. is a standard wayof organizing information into accessible parts C. describes how data is actually stored on disk D. All of theabove E. None of the above

Description : A logical schema A. is the entire database B. is a standard wayof organizing information into accessible parts C. describes how data is actually stored on disk D. All of theabove E. None of the above

Last Answer : is a standard wayof organizing information into accessible parts

Data integrity control A. is used to set upper and lower limits on numeric data B. requires the use of passwords toprohibit unauthorized access tothe file C. has the data dictionary keep thedate and time of lastaccess last back-up,and most recent modificationfor all files D. All of theabove E. None of the above

Description : Data integrity control A. is used to set upper and lower limits on numeric data B. requires the use of passwords toprohibit unauthorized access tothe file C. has the data dictionary keep thedate and time ... back-up,and most recent modificationfor all files D. All of theabove E. None of the above

Last Answer : has the data dictionary keep thedate and time of lastaccess last back-up,and most recent modificationfor all files

How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to the existing tablespace C. Enable compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

Description : How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to ... compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

Last Answer : B. Add a new data file to the existing tablespace

The database administration function includes A. application programming B. computer operations management C. databaseaccessplanning D. All of theabove E. None of the above

Description : The database administration function includes A. application programming B. computer operations management C. databaseaccessplanning D. All of theabove E. None of the above

Last Answer : databaseaccessplanning

Queries to a database A. are written in English B. can use aggregatefunctions like SUM and COUNT C. both (a)and (b) D. All of theabove E. None of the above

Description : Queries to a database A. are written in English B. can use aggregatefunctions like SUM and COUNT C. both (a)and (b) D. All of theabove E. None of the above

Last Answer : can use aggregatefunctions like SUM and COUNT

Can one rename a tablespace? (for DBA)

Description : Can one rename a tablespace? (for DBA)

Last Answer : No, this is listed as Enhancement Request 148742. Workaround: Export all of the objects from the tablespace Drop the tablespace including contents Recreate the tablespace Import the objects

Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud c) Enables support for outbound sockets using the language – specific, built in libraries. d) Lets developers factor large applications into logical components that can be share stateful services and communicate in secure fashion.

Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.

Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud

Devices interconnected by the LAN should include A. Computers and terminals B. mass storage device, printers and plotters C. bridges and gateways D. All of theabove E. None of the above

Description : Devices interconnected by the LAN should include A. Computers and terminals B. mass storage device, printers and plotters C. bridges and gateways D. All of theabove E. None of the above

Last Answer : All of theabove

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

Subschema can be used to A. create very different, personalized views of the samedata B. present information in different formats C. hide sensitive informationby omitting fields from thesub¬schema's description D. All of theabove E. None of the above

Description : Subschema can be used to A. create very different, personalized views of the samedata B. present information in different formats C. hide sensitive informationby omitting fields from thesub¬schema's description D. All of theabove E. None of the above

Last Answer : All of theabove

A SONET system can use _________. A) STS multiplexers B) regenerators C) add/drop multiplexers D) all of theabove

Description : A SONET system can use _________. A) STS multiplexers B) regenerators C) add/drop multiplexers D) all of theabove

Last Answer : add/drop multiplexers

Theprotocol that isused for signaling in the telephone network is called ______. A) POP B) SSS C) SS7 D) none of the above

Description : Theprotocol that isused for signaling in the telephone network is called ______. A) POP B) SSS C) SS7 D) none of the above

Last Answer : SS7

. A technique called______ isused tocreate a subnetting effect. A) ARP B) RARP C) proxy ARP D) noneof the above

Description : . A technique called______ isused tocreate a subnetting effect. A) ARP B) RARP C) proxy ARP D) noneof the above

Last Answer : proxy ARP

In SQL, which commandis used to remove a stored function from the database? . REMOVE FUNCTION B. DELETE FUNCTION C. DROP FUNCTION D. ERASE FUNCTION E. None of the above

Description : In SQL, which commandis used to remove a stored function from the database? . REMOVE FUNCTION B. DELETE FUNCTION C. DROP FUNCTION D. ERASE FUNCTION E. None of the above

Last Answer : DROP FUNCTION

I've lost some Rollback Segments, how can I get my DB back? (for DBA

Description : I've lost some Rollback Segments, how can I get my DB back? (for DBA

Last Answer : Re-start your database with the following INIT.ORA parameter if one of your rollback segments is corrupted. You can then drop the corrupted rollback segments and create it from scratch. ... Please contact Oracle Support before using it. _Corrupted_rollback_segments = (rbs01, rbs01, rbs03, rbs04)

What are the various types of RollBack Segments ?

Description : What are the various types of RollBack Segments ?

Last Answer : Public Available to all instances Private Available to specific instance

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Explain the relationship among Database, Tablespace and Data file.?

Description : Explain the relationship among Database, Tablespace and Data file.?

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

Explain the relationship among database, tablespace and data file.

Description : Explain the relationship among database, tablespace and data file.

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

Explain the relationship among Database, Tablespace and Data file.?

Description : Explain the relationship among Database, Tablespace and Data file.?

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

Data encryption techniquesare particularly useful for A. reducingstorage space requirements B. improving data integrity C. protecting data indata communication systems D. All of theabove E. None of the above

Description : Data encryption techniquesare particularly useful for A. reducingstorage space requirements B. improving data integrity C. protecting data indata communication systems D. All of theabove E. None of the above

Last Answer : protecting data indata communication systems

Goals for the design of thelogical schema include A. avoiding data inconsistency B. being ableto construct queries easily C. being ableto access data efficiently D. All of theabove E. None of the above

Description : Goals for the design of thelogical schema include A. avoiding data inconsistency B. being ableto construct queries easily C. being ableto access data efficiently D. All of theabove E. None of the above

Last Answer : All of theabove

‘AS’ clause is used in SQL for (A) Selection operation. (B) Rename operation. (C) Join operation. (D) Projection operation.

Description : ‘AS’ clause is used in SQL for (A) Selection operation. (B) Rename operation. (C) Join operation. (D) Projection operation.

Last Answer : (B) Rename operation.

A repeater is a connecting devicethat operates in the _______ layer of theInternet model. A) physical B) data link C) network D) all of theabove

Description : A repeater is a connecting devicethat operates in the _______ layer of theInternet model. A) physical B) data link C) network D) all of theabove

Last Answer : physical

Data flow between two devices canoccur in a _______ way. A) simplex B) half-duplex C) full-duplex D) all of theabove

Description : Data flow between two devices canoccur in a _______ way. A) simplex B) half-duplex C) full-duplex D) all of theabove

Last Answer : all of theabove

_____ refers tothe structure or format of the data, meaning the order in which they are presented. A) Semantics B) Syntax C) Timing D) All of theabove

Description : _____ refers tothe structure or format of the data, meaning the order in which they are presented. A) Semantics B) Syntax C) Timing D) All of theabove

Last Answer : Syntax

Data aresent over pin _____ of the EIA-232 interface. A. 2 B. 3 C. 4 D. All of theabove

Description : Data aresent over pin _____ of the EIA-232 interface. A. 2 B. 3 C. 4 D. All of theabove

Last Answer : 2

Which of the following is not a disadvantage of wireless LAN? A. Slower data transmission B. higher error rate C. interference of transmissions from different computers D. All of theabove

Description : Which of the following is not a disadvantage of wireless LAN? A. Slower data transmission B. higher error rate C. interference of transmissions from different computers D. All of theabove

Last Answer : All of theabove

To locate a data item for storage is a. Field b. Feed c. Database d. Fetch

Description : To locate a data item for storage is a. Field b. Feed c. Database d. Fetch

Last Answer : Fetch

To locate a data item for storage is a. Field b. Feed c. Database d. Fetch

Description : To locate a data item for storage is a. Field b. Feed c. Database d. Fetch

Last Answer : Fetch

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMAC.CREATE CLUSTERD.All of theaboveE.None of the above;

Description : In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMA C. CREATE CLUSTER D. All of theabove E. None of the above;

Last Answer : CREATE SCHEMA

How do you add a data file to a tablespace

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

What's the simplest way to create a web form that will populate a SQL database?

Description : What's the simplest way to create a web form that will populate a SQL database?

Last Answer : Give Forms To Go a try.

How will you force database to use particular rollback segment ?

Description : How will you force database to use particular rollback segment ?

Last Answer : SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.

Can a Tablespace hold objects from different Schemes ?

Description : Can a Tablespace hold objects from different Schemes ?

Last Answer : Yes.

Can a tablespace hold objects from different schemes?

Description : Can a tablespace hold objects from different schemes?

Last Answer : Yes.

Can a Tablespace hold objects from different Schemes?

Description : Can a Tablespace hold objects from different Schemes?

Last Answer : Yes.

A command that lets youchange one or more fields in a record is A. Insert B. Modify C. Look-up D. All of theabove E. None of the above

Description : A command that lets youchange one or more fields in a record is A. Insert B. Modify C. Look-up D. All of theabove E. None of the above

Last Answer : Modify