What is the maximum number of profiles that can be assigned to a user? - A user can have only one profile assigned. The profile assigned to a user can be queried from the DBA_USERS view.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What is the maximum number of profiles that can be assigned to a user?

Answer: A user can have only one profile assigned. The profile assigned to a user can be queried from the DBA_USERS view.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9519 users
Added on	7/7/2010
Views	69252
Rate it!

Question: What is the maximum number of profiles that can be assigned to a user?

Answer:

A user can have only one profile assigned. The profile assigned to a user can be queried from the DBA_USERS view. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	4. Choose the option that is not true. a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially has a value of 5.	View Answer
	3. Which resource is not used to calculate the COMPOSITE_LIMIT? a. PRIVATE_SGA b. CPU_PER_SESSION c. CONNECT_TIME d. LOGICAL_READS_PER_CALL	View Answer
	2. Which command is used to assign a profile to an existing use? a. ALTER PROFILE b. ALTER USER c. SET PROFILE d. The profile should be specified when creating the user; it cannot be changed.	View Answer
	1. Profiles cannot be used to restrict. a. CPU time used b. Total time connected to the database c. Maximum time a session can be inactive d. Time spent reading blocks	View Answer
	What is the difference between a unique constraint and a primary key constraint?	View Answer
	Which script creates the CHAINED_ROWS table? A. catproc.sql B. catchain.sql C. utlchain.sql D. No script is necessary: ANALYZE TABLE LIST CHAINED ROWS creates the table.	View Answer
	A constraint is created with the DEFERRABLE INITIALLY IMMEDIATE CLAUSE. What does this mean?	View Answer
	Which data dictionary view shows statistical information from the ANALYZE INDEX VALIDATE STRUCTURE command?	View Answer
	15. Which keyword should be used in the CREATE INDEX command to create a function –based index? A. CREATE FUNCTION INDEX… B. CREATE INDEX … ORGANIZATION INDEX C. CREATE INDEX… FUNCTION BASED … D. None of the above	View Answer
	14 Which component is not part of the ROWID? A. Tablespace B. Data file number C. Object ID D. Block ID	View Answer
	13. Which line in the following code has an error? 1. ALTER TABEL MY_TABLE 2. STORAGE ( 3. MINEXTENTS 4 4. NEXT 512K) 5. NOLOGGING;	View Answer
	What clause is in the ALTER TABLE command is used to reorganize a table?	View Answer
	Which keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause?	View Answer
	When validating a constraint, why would you specify the EXCEPTIONS clause?	View Answer
	A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?	View Answer
	Fill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ___________________.	View Answer
	How does Oracle determine the extent sizes for a temporary segment? A. From the initialization parameters B. From the tables involved in the sort operation C. Using the default storage parameters for the tablespace D. The database block size	View Answer
	Which of the following statements may require a temporary segment? a. CREATE TABLE b. CREATE INDEX c. UPDATE d. CREATE TABLESPACE	View Answer
	Which two initialization parameters are used by ORACLE to determine the number of rollback segments required for an instance? a. ROLLBACK_SEGMENTS b. TRANSACTIONS c. TRANSACTIONS_PER_ROLLBACK_SEGMENT d. PROCESSES	View Answer
	What can cause the Snapshot too old error?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode